Drop Ship Query Query to retrieve Drop Ship Sales Order, Purchase Order , Requisition

Drop Ship Query

OE_DROP_SHIP_SOURCES.REQUISITION_HEADER_ID=PO-REQUISITION_HEADERS_ALL.REQUISITION_HEADER_ID 
OE_DROP_SHIP_SOURCES.PO_HEADER_ID=PO_HEADERS_ALL.PO_HEADER_ID




OE_DROP_SHIP_SOURCES
OE_ORDER_HEADERS_ALL
OE_ORDER_LINES_ALL
PO_REQUISITION_HEADERS_ALL
PO_HEADERS_ALL

SELECT OH.ORDER_NUMBER SALESORDERNO,
PH.SEGMENT1 PURCHASEORDERNO,
PRH.SEGMENT1 REQUISITIONNO,
OL.ORDERED_QUANTITY SALESORDERQUANTITY,
PL.QUANTITY PURCHASEORDERQUANTITY,
PRL.QUANTITY REQUISITIONQUANTITY,
HA.NAME
FROM OE_ORDER_HEADERS_ALL OH,
OE_ORDER_LINES_ALL OL,
OE_DROP_SHIP_SOURCES OS,
PO_REQUISITION_HEADERS_ALL PRH,
PO_HEADERS_ALL PH,
PO_LINES_ALL PL,
PO_REQUISITION_LINES_ALL PRL,
HR_ALL_ORGANIZATION_UNITS HA
WHERE OH.HEADER_ID=OL.HEADER_ID
AND OH.HEADER_ID=OS.HEADER_ID
AND OS.REQUISITION_HEADER_ID=PRH.REQUISITION_HEADER_ID 
AND OS.PO_HEADER_ID=PH.PO_HEADER_ID
AND PH.PO_HEADER_ID=PL.PO_HEADER_ID
AND PRH.REQUISITION_HEADER_ID=PRL.REQUISITION_HEADER_I D
AND OH.SHIP_FROM_ORG_ID=HA.ORGANIZATION_ID
AND OH.ORDER_NUMBER=:p1