PO_DISTRIBUTIONS 2 HRMS AND GL

 


PO_DISTRIBUTIONS_ALL

SELECT
PDA.PO_DISTRIBUTION_ID,
PDA.DISTRIBUTION_NUM             "DISTRIBUTION NUM",
PDA.DESTINATION_TYPE_CODE      "DESTINATION TYPE",
PAPF.FULL_NAME              "DELIVER TO PERSON OR REQUESTOR",
HL.LOCATION_CODE              "DELIVER TO LOCATION",
PDA.DESTINATION_SUBINVENTORY        "DESTINATION SUBINVENTORY",
PDA.QUANTITY_ORDERED          "QUANTITY_ORDERED",
GCC.SEGMENT1||'-'||GCC.SEGMENT2||'-'||GCC.SEGMENT3||'-'||GCC.SEGMENT4||'-'||GCC.SEGMENT5             "CHARGE_ACCOUNT"
FROM
PO_LINE_LOCATIONS_ALL PLLA,
PO_DISTRIBUTIONS_ALL PDA,
PER_ALL_PEOPLE_F PAPF,
HR_LOCATIONS HL,
GL_CODE_COMBINATIONS GCC
WHERE
PDA.LINE_LOCATION_ID = '72079'                 AND
PLLA.LINE_LOCATION_ID = PDA.LINE_LOCATION_ID         AND
PAPF.PERSON_ID = PDA.DELIVER_TO_PERSON_ID         AND
HL.LOCATION_ID =PDA.DELIVER_TO_LOCATION_ID         AND