PO_LINE_LOCATIONS 2 HRMS

PO_LINE_LOCATIONS_ALL

SELECT
     PLLA.LINE_LOCATION_ID,
     PLLA.SHIPMENT_NUM                   "SHIPMENT NUM",
     OOD.ORGANIZATION_CODE                  "SHIP TO ORG CODE",
     HL.LOCATION_CODE                       "SHIP TO LOCATION CODE",
     PLLA.UNIT_MEAS_LOOKUP_CODE              "UOM",
     PLLA.QUANTITY                        "QUANTITY",
     PLLA.PROMISED_DATE                    "PROMISED DATE",
     PLLA.NEED_BY_DATE                        "NEED BY DATE"
FROM
     PO_LINES_ALL PLA,
     PO_LINE_LOCATIONS_ALL PLLA,
     ORG_ORGANIZATION_DEFINITIONS OOD,
     HR_LOCATIONS HL
WHERE
     PLA.PO_LINE_ID = '37703'                       AND
     PLA.PO_LINE_ID = PLLA.PO_LINE_ID                    AND
     PLLA.SHIP_TO_ORGANIZATION_ID = OOD.ORGANIZATION_ID AND
     PLLA.SHIP_TO_LOCATION_ID = HL.LOCATION_ID