Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Need Query in oracle apps 11i version, from AR to Subledger

Hello Everyone,

Can anyone share query to retrieve data from AR to subledger. (Oracle apps 11i)

I need details of a transaction as

transaction number,

transaction type,

customer,

transaction source,

gl date,

accounting entries of that transaction (i.e. accounting date, accounting segments,entered and accounted amount values ).

frontend : from front end in 11i , if you open , any transaction and go to tools ==> view accounting , we can see the accounting details.

The query will help me a lot.

Thanks & Regards
Bhanu Prakash Kadavakollu

Comments
Post Details
Added on Feb 5 2026
2 comments
83 views