Oracle Purchasing Important Queries

--Purchase Order, Requisition and Receipt Details Query

SELECT prh.segment1 requisition_number,

       prl.line_num requisition_line_num,

       ph.segment1 po_num,

       pl.line_num po_line_num,

       rsh.receipt_num receipt_num,

       rsl.line_num receipt_line_num,

       pll.line_location_id,

Important Oracle Purchasing related queries/scripts

---Used to list all Internal Requisitions that do not have an  associated Internal Sales order

  SELECT RQH.SEGMENT1 REQ_NUM,

         RQL.LINE_NUM,

         RQL.REQUISITION_HEADER_ID,

         RQL.REQUISITION_LINE_ID,

         RQL.ITEM_ID,

         RQL.UNIT_MEAS_LOOKUP_CODE,

         RQL.UNIT_PRICE,

         RQL.QUANTITY,

         RQL.QUANTITY_CANCELLED,