View: ECE_PO_PROJECT_INFO_V

Product:	EC - e-Commerce Gateway
Description:	Contains the project level data for the the Purchase Order (850/ORDERS) and the Purchase Order Changes (860/ORDCHG) transactions.
Implementation/DBA Data:	APPS.ECE_PO_PROJECT_INFO_V

View Text

SELECT POD.PO_HEADER_ID PO_HEADER_ID
, NVL(POD.PO_RELEASE_ID
, 0) PO_RELEASE_ID
, POD.PO_LINE_ID PO_LINE_ID
, POD.LINE_LOCATION_ID LINE_LOCATION_ID
, POD.PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID
, POD.PROJECT_ID PROJECT_ID
, POD.TASK_ID TASK_ID
, POD.DISTRIBUTION_NUM DISTRIBUTION_NUM
, PPE.PROJECT_NUMBER PROJECT_NUMBER
, PPE.PROJECT_TYPE PROJECT_TYPE
, PAT.TASK_NUMBER TASK_NUMBER
, POD.QUANTITY_ORDERED QUANTITY_ORDERED
, POD.QUANTITY_DELIVERED QUANTITY_DELIVERED
, POD.QUANTITY_BILLED QUANTITY_BILLED
, POD.QUANTITY_CANCELLED QUANTITY_CANCELLED
, POD.AMOUNT_BILLED AMOUNT_BILLED
, POD.RATE CONVERSION_RATE
, POD.RATE_DATE CONVERSION_DATE
, POD.DESTINATION_TYPE_CODE DESTINATION_TYPE_CODE_INT
, POD.ATTRIBUTE_CATEGORY DISTRIBUTION_ATTRIB_CATEGORY
, POD.ATTRIBUTE1 DISTRIBUTION_ATTRIBUTE1
, POD.ATTRIBUTE2 DISTRIBUTION_ATTRIBUTE2
, POD.ATTRIBUTE3 DISTRIBUTION_ATTRIBUTE3
, POD.ATTRIBUTE4 DISTRIBUTION_ATTRIBUTE4
, POD.ATTRIBUTE5 DISTRIBUTION_ATTRIBUTE5
, POD.ATTRIBUTE6 DISTRIBUTION_ATTRIBUTE6
, POD.ATTRIBUTE7 DISTRIBUTION_ATTRIBUTE7
, POD.ATTRIBUTE8 DISTRIBUTION_ATTRIBUTE8
, POD.ATTRIBUTE9 DISTRIBUTION_ATTRIBUTE9
, POD.ATTRIBUTE10 DISTRIBUTION_ATTRIBUTE10
, POD.ATTRIBUTE11 DISTRIBUTION_ATTRIBUTE11
, POD.ATTRIBUTE12 DISTRIBUTION_ATTRIBUTE12
, POD.ATTRIBUTE13 DISTRIBUTION_ATTRIBUTE13
, POD.ATTRIBUTE14 DISTRIBUTION_ATTRIBUTE14
, POD.ATTRIBUTE15 DISTRIBUTION_ATTRIBUTE15
FROM PA_PROJECTS_EXPEND_V PPE
, PA_TASKS PAT
, PO_DISTRIBUTIONS POD
WHERE POD.TASK_ID = PAT.TASK_ID (+)
AND POD.PROJECT_ID = PAT.PROJECT_ID (+)
AND POD.PROJECT_ID = PPE.PROJECT_ID (+)

Columns