VIEW: APPS.ITG_PO_DISTRBN_ARCH_V

Source

View Text - Preformatted

SELECT PDAA.REVISION_NUM REVISION_NUM, NVL(PDAA.PO_RELEASE_ID, -9999) 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.DISTRIBUTION_NUM DISTRIBUTION_NUM, MRP_GET_PROJECT.PROJECT(PDAA.PROJECT_ID) PROJECT_NUM, PA.PROJECT_TYPE PROJECT_TYPE, PT.TASK_NUMBER TASK_NUM, PDAA.QUANTITY_ORDERED QTY_ORDERED, PDAA.RATE CONVERSION_RATE, PDAA.RATE_DATE CONV_RATE_DATE, PDAA.DESTINATION_TYPE_CODE DESTINATION_TYPE, PAPF.FULL_NAME REQUESTOR, PAPF.EMAIL_ADDRESS, PAPF.WORK_TELEPHONE, PDAA.ATTRIBUTE_CATEGORY DFF_DIST_ATTR1, PDAA.ATTRIBUTE1 DFF_DIST_ATTR2, PDAA.ATTRIBUTE2 DFF_DIST_ATTR3, PDAA.ATTRIBUTE3 DFF_DIST_ATTR4, PDAA.ATTRIBUTE4 DFF_DIST_ATTR5, PDAA.ATTRIBUTE5 DFF_DIST_ATTR6, PDAA.ATTRIBUTE6 DFF_DIST_ATTR7, PDAA.ATTRIBUTE7 DFF_DIST_ATTR8, PDAA.ATTRIBUTE8 DFF_DIST_ATTR9, PDAA.ATTRIBUTE9 DFF_DIST_ATTR10, PDAA.ATTRIBUTE10 DFF_DIST_ATTR11, PDAA.ATTRIBUTE11 DFF_DIST_ATTR12, PDAA.ATTRIBUTE12 DFF_DIST_ATTR13, PDAA.ATTRIBUTE13 DFF_DIST_ATTR14, PDAA.ATTRIBUTE14 DFF_DIST_ATTR15, PDAA.ATTRIBUTE15 DFF_DIST_ATTR16 FROM PO_DISTRIBUTIONS_ARCHIVE_ALL PDAA, PA_TASKS PT, PA_PROJECTS_ALL PA, PER_ALL_PEOPLE_F PAPF, PER_PHONES PHN WHERE PDAA.PROJECT_ID = PA.PROJECT_ID (+) and PDAA.PROJECT_ID = PT.PROJECT_ID (+) and PDAA.TASK_ID = PT.TASK_ID (+) and PDAA.DELIVER_TO_PERSON_ID = PAPF.PERSON_ID (+) and NVL(PAPF.EFFECTIVE_END_DATE,SYSDATE) >= sysdate and PDAA.DELIVER_TO_PERSON_ID = PHN.PARENT_ID (+) and PHN.PHONE_TYPE (+) = 'W1' and PHN.PARENT_TABLE (+) = 'PER_ALL_PEOPLE_F' and NVL(PHN.DATE_TO,SYSDATE) >= sysdate AND NVL(pdaa.distribution_type,'xx') <> 'PREPAYMENT'

View Text - HTML Formatted

SELECT PDAA.REVISION_NUM REVISION_NUM
, NVL(PDAA.PO_RELEASE_ID
, -9999) 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.DISTRIBUTION_NUM DISTRIBUTION_NUM
, MRP_GET_PROJECT.PROJECT(PDAA.PROJECT_ID) PROJECT_NUM
, PA.PROJECT_TYPE PROJECT_TYPE
, PT.TASK_NUMBER TASK_NUM
, PDAA.QUANTITY_ORDERED QTY_ORDERED
, PDAA.RATE CONVERSION_RATE
, PDAA.RATE_DATE CONV_RATE_DATE
, PDAA.DESTINATION_TYPE_CODE DESTINATION_TYPE
, PAPF.FULL_NAME REQUESTOR
, PAPF.EMAIL_ADDRESS
, PAPF.WORK_TELEPHONE
, PDAA.ATTRIBUTE_CATEGORY DFF_DIST_ATTR1
, PDAA.ATTRIBUTE1 DFF_DIST_ATTR2
, PDAA.ATTRIBUTE2 DFF_DIST_ATTR3
, PDAA.ATTRIBUTE3 DFF_DIST_ATTR4
, PDAA.ATTRIBUTE4 DFF_DIST_ATTR5
, PDAA.ATTRIBUTE5 DFF_DIST_ATTR6
, PDAA.ATTRIBUTE6 DFF_DIST_ATTR7
, PDAA.ATTRIBUTE7 DFF_DIST_ATTR8
, PDAA.ATTRIBUTE8 DFF_DIST_ATTR9
, PDAA.ATTRIBUTE9 DFF_DIST_ATTR10
, PDAA.ATTRIBUTE10 DFF_DIST_ATTR11
, PDAA.ATTRIBUTE11 DFF_DIST_ATTR12
, PDAA.ATTRIBUTE12 DFF_DIST_ATTR13
, PDAA.ATTRIBUTE13 DFF_DIST_ATTR14
, PDAA.ATTRIBUTE14 DFF_DIST_ATTR15
, PDAA.ATTRIBUTE15 DFF_DIST_ATTR16
FROM PO_DISTRIBUTIONS_ARCHIVE_ALL PDAA
, PA_TASKS PT
, PA_PROJECTS_ALL PA
, PER_ALL_PEOPLE_F PAPF
, PER_PHONES PHN
WHERE PDAA.PROJECT_ID = PA.PROJECT_ID (+)
AND PDAA.PROJECT_ID = PT.PROJECT_ID (+)
AND PDAA.TASK_ID = PT.TASK_ID (+)
AND PDAA.DELIVER_TO_PERSON_ID = PAPF.PERSON_ID (+)
AND NVL(PAPF.EFFECTIVE_END_DATE
, SYSDATE) >= SYSDATE
AND PDAA.DELIVER_TO_PERSON_ID = PHN.PARENT_ID (+)
AND PHN.PHONE_TYPE (+) = 'W1'
AND PHN.PARENT_TABLE (+) = 'PER_ALL_PEOPLE_F'
AND NVL(PHN.DATE_TO
, SYSDATE) >= SYSDATE
AND NVL(PDAA.DISTRIBUTION_TYPE
, 'XX') <> 'PREPAYMENT'