VIEW: APPS.PO_CXML_DELIVERTO_ARCH_V

Source

View Text - Preformatted

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, PAPF.EMAIL_ADDRESS REQUESTOR_EMAIL, 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

View Text - HTML Formatted

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
, PAPF.EMAIL_ADDRESS REQUESTOR_EMAIL
, 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