SQl queries related to purchase order po in oracle apps r12 ;Debugging where po is struck in oracle apps r12 po flow

1)The relation between Requisition and PO tables in oracle apps 12

2)query to list out all Internal Requisitions that do not have an associated Internal Sales order in oracle apps 12

3)Relation with Requisition and PO in oracle apps 12

4)query to list My cancel Requisition in oracle apps 12

5)query to list all Purchase Requisition without a Purchase Order in oracle apps 12

6)query to data entry from PR till PO in oracle apps 12

7)query to Identifying all PO's which does not have any PR in oracle apps 12

8)query to find all the PO's with there approval, invoice and Payment Details in oracle apps 12

9)query to find all open po in oracle apps 12 

10)query Purchase Requisition details in oracle apps 12

11)query to find Internal Requisition details in oracle apps 12

12)query to find all Purchase Orders for noninventory items like service in oracle apps 12

13)query to find Receiving transactions with PO and requisition information in oracle apps 12 

14)PO gets stuck somewhere, so what you have to do is to analyze which stage it stucked.

15)Get po_header_id first and run each query and then analyze the data

For better understanding, this is split into 5 major stages.

16)Debugging where po is struck in oracle apps r12 

17)query to the link between GL and PO

18)query to find the link between gl_import_references and po_header_id

 https://www.oracleapps2fusion.com/2015/11/purchasing-useful-scripts.html