开发者

Count Number of invoices in oracle APPS

i want a query to display how many invoices are created using a particular interface for the last one month in AR module. we are not using any other module except ar,ap ,gl.All our invoices ar开发者_StackOverflow社区e generated through interface only.Please tell me the table which i can find all the invoices created in AR module using a particular Interface.


This sounds simple to me but I don't have a lot of AR experience.
select count(*) from AP_INVOICES_ALL where CREATION_DATE > SYSDATE - 30 and SOURCE = '&source' ;

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜