开发者

Count Number of invoices in oracle APPS

开发者 https://www.devze.com 2023-04-01 13:25 出处:网络
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开发者_S

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

精彩评论

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

关注公众号