View: PO_ECX_DISTRBN_ARCH_V

Product:	PO - Purchasing
Description:	Used for XML mapping in the distribution level
Implementation/DBA Data:	APPS.PO_ECX_DISTRBN_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.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

Columns