Oracle PO Shipments Query

Oracle PO Shipments Query

Hi Friends, We are going to discuss about Oracle PO Shipments Query. We will share the PO shipment query which helps to extract the Purchase Order details with PO shipment details in Oracle. We can refer this query to extract information about PO shipments in oracle. This is one of the most important and frequently used SQL query in Oracle which we can use to fetch the PO shipment details. Here below is the detail about Oracle PO Shipments Query.

Oracle PO Shipments Query

Important Tables used by PO Shipments Query in Oracle

1.PO_LINE_LOCATIONS_ALL
2.PO_LINES_ALL
3.PO_HEADERS_ALL

Detail Oracle PO Shipments Query

Here below is the detail sql Query which we can uses to extract the PO shipment details in oracle apps. This sql query is developed using the important PO tables. Please refer this sql query for extracting the PO shipment details.

SELECT PHA.SEGMENT1 PO_NUM,
       PLA.LINE_NUM PO_LINE_NUM,
       PLLA.SHIPMENT_NUM,
       PLA.ITEM_DESCRIPTION,   
       PLA.QUANTITY PO_LINE_QUANTITY,
       PHA.AUTHORIZATION_STATUS HEADER_APPROVAL_STATUS, PHA.APPROVED_FLAG HEADER_APPROVED_FLAG, PHA.APPROVED_DATE HEADER_APPROVED_DATE,
       , PHA.ORG_ID, PHA.PO_HEADER_ID,PLLA.*     
  FROM PO.PO_LINE_LOCATIONS_ALL PLLA,
       PO.PO_LINES_ALL PLA,
       PO.PO_HEADERS_ALL PHA   
 WHERE PLA.PO_LINE_ID = PLLA.PO_LINE_ID
   AND PLA.PO_HEADER_ID = PLLA.PO_HEADER_ID
AND PHA.PO_HEADER_ID = PLA.PO_HEADER_ID
   AND PHA.SEGMENT1=:P_PO_NUMBER
ORDER BY PHA.SEGMENT1,PLA.LINE_NUM，PLLA.SHIPMENT_NUM;

Oracle PO Shipments Query

Oracle PO Shipments Query