View: PO_CXML_DELIVERTO_ARCH_V

Product:	PO - Purchasing
Description:
Implementation/DBA Data:	APPS.PO_CXML_DELIVERTO_ARCH_V

View Text

SELECT PDAA.REVISION_NUM REVISION_NUM
, PDAA.PO_RELEASE_ID PO_RELEASE_ID
, PDAA.PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID
, PDAA.PO_HEADER_ID PO_HEADER_ID
, PDAA.PO_LINE_ID PO_LINE_ID
, PDAA.LINE_LOCATION_ID PO_LINE_LOC_ID
, PDAA.DELIVER_TO_LOCATION_ID DELIVER_TO_LOCATION_ID
, PDAA.DISTRIBUTION_NUM DISTRIBUTION_NUM
, PDAA.QUANTITY_ORDERED - QUANTITY_CANCELLED QUANTITY
, PAPF.FULL_NAME REQUESTOR
, PDAA.DESTINATION_TYPE_CODE DESTINATION_TYPE
, HLA.LOCATION_CODE LOCATION_CODE
, HLA.ADDRESS_LINE_1 || HLA.ADDRESS_LINE_2 || HLA.ADDRESS_LINE_3 ADDRESS_LINE
, HLA.COUNTRY COUNTRY
, HLA.POSTAL_CODE POSTAL_CODE
, HLA.TOWN_OR_CITY TOWN_OR_CITY
, HLA.REGION_2 STATE
FROM PO_DISTRIBUTIONS_ARCHIVE_ALL PDAA
, PER_ALL_PEOPLE_F PAPF
, HR_LOCATIONS_ALL HLA
WHERE PDAA.DELIVER_TO_LOCATION_ID = HLA.LOCATION_ID
AND PDAA.DELIVER_TO_PERSON_ID = PAPF.PERSON_ID(+)
AND NVL(PAPF.EFFECTIVE_END_DATE
, SYSDATE) > = SYSDATE

Columns