VIEW: APPS.PO_ECX_DISTRBN_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.DISTRIBUTION_NUM DISTRIBUTION_NUM, MRP_GET_PROJECT.PROJECT(PDAA.PROJECT_ID), PA.PROJECT_TYPE, PT.TASK_NUMBER, PDAA.QUANTITY_ORDERED, PDAA.RATE, PDAA.RATE_DATE, PDAA.DESTINATION_TYPE_CODE, PAPF.FULL_NAME, 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 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

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.DISTRIBUTION_NUM DISTRIBUTION_NUM
, MRP_GET_PROJECT.PROJECT(PDAA.PROJECT_ID)
, PA.PROJECT_TYPE
, PT.TASK_NUMBER
, PDAA.QUANTITY_ORDERED
, PDAA.RATE
, PDAA.RATE_DATE
, PDAA.DESTINATION_TYPE_CODE
, PAPF.FULL_NAME
, 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
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