R12 : GL,AP,Purchasing ; Accounting information?

Hi Gurus,

I was wondering whether a report exists for finding all accounting information of a Requisition and its associated PO and Its Associated Invoice or invoice and its associated PO and its Associated Requisition.

I can gather information going individually through the Sublegder Inquiry for each Transaction or gathereing from subledger Accounting Program Report, it is cumbercome and time consuming and it will be great to get all the accounting information in one attempt.

I am also happy to have the required information by running a sql query , Appreciate if you can share the query.

Thanks and regards

Sudhir