View: ECE_PO_DISTRIBUTIONS_V

Product:	EC - e-Commerce Gateway
Description:	/*#* This view extracts distribution information* for the outbound Purchase Order (850/ORDERS) and* outbound Purchase Order Change (860/ORDCHG) transactions.* @rep:scope private* @rep:product PO* @rep:lifecycle active* @rep:displayname Purc
Implementation/DBA Data:	APPS.ECE_PO_DISTRIBUTIONS_V

View Text

SELECT POD.PO_HEADER_ID PO_HEADER_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
, 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
, POD.ATTRIBUTE_CATEGORY DS_ATTRIBUTE_CATEGORY
, POD.ATTRIBUTE1 DS_ATTRIBUTE1
, POD.ATTRIBUTE2 DS_ATTRIBUTE2
, POD.ATTRIBUTE3 DS_ATTRIBUTE3
, POD.ATTRIBUTE4 DS_ATTRIBUTE4
, POD.ATTRIBUTE5 DS_ATTRIBUTE5
, POD.ATTRIBUTE6 DS_ATTRIBUTE6
, POD.ATTRIBUTE7 DS_ATTRIBUTE7
, POD.ATTRIBUTE8 DS_ATTRIBUTE8
, POD.ATTRIBUTE9 DS_ATTRIBUTE9
, POD.ATTRIBUTE10 DS_ATTRIBUTE10
, POD.ATTRIBUTE11 DS_ATTRIBUTE11
, POD.ATTRIBUTE12 DS_ATTRIBUTE12
, POD.ATTRIBUTE13 DS_ATTRIBUTE13
, POD.ATTRIBUTE14 DS_ATTRIBUTE14
, POD.ATTRIBUTE15 DS_ATTRIBUTE15
, HRL.LOCATION_CODE DELIVER_TO_LOCATION_CODE
, PPF.LAST_NAME DELIVER_TO_CONTACT_LAST_NAME
, PPF.FIRST_NAME DELIVER_TO_CONTACT_FIRST_NAME
, HRL.ADDRESS_LINE_1 DELIVER_TO_ADDRESS_LINE_1
, HRL.ADDRESS_LINE_2 DELIVER_TO_ADDRESS_LINE_2
, HRL.ADDRESS_LINE_3 DELIVER_TO_ADDRESS_LINE_3
, HRL.TOWN_OR_CITY DELIVER_TO_CITY
, HRL.POSTAL_CODE DELIVER_TO_POSTAL_CODE
, HRL.COUNTRY DELIVER_TO_COUNTRY
, HRL.REGION_1 DELIVER_TO_REGION_1
, HRL.REGION_2 DELIVER_TO_REGION_2
, HRL.REGION_3 DELIVER_TO_REGION_3
, HRL.TELEPHONE_NUMBER_1 DELIVER_TO_PHONE1
, HRL.TELEPHONE_NUMBER_2 DELIVER_TO_PHONE2
, HRL.TELEPHONE_NUMBER_3 DELIVER_TO_PHONE3
, POD.DELIVER_TO_LOCATION_ID DELIVER_TO_LOCATION_ID
, POD.DELIVER_TO_PERSON_ID DELIVER_TO_PERSON_ID
, 0 POR_RELEASE_NUM
, POLL.SHIPMENT_NUM SHIPMENT_NUMBER
, HRL.ECE_TP_LOCATION_CODE DELIVER_TO_EDI_LOCATION_CODE
FROM PO_LINE_LOCATIONS POLL
, PO_DISTRIBUTIONS POD
, PER_ALL_PEOPLE_F PPF
, HR_LOCATIONS_ALL HRL
WHERE POD.LINE_LOCATION_ID = POLL.LINE_LOCATION_ID
AND POD.DELIVER_TO_LOCATION_ID = HRL.LOCATION_ID (+)
AND PPF.PERSON_ID(+) = POD.DELIVER_TO_PERSON_ID
AND POD.PO_RELEASE_ID IS NULL
AND TRUNC(SYSDATE)<=PPF.EFFECTIVE_END_DATE(+)
AND TRUNC(SYSDATE)>=PPF.EFFECTIVE_START_DATE(+) UNION ALL SELECT POD.PO_HEADER_ID PO_HEADER_ID
, POD.PO_RELEASE_ID 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
, 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
, POD.ATTRIBUTE_CATEGORY DS_ATTRIBUTE_CATEGORY
, POD.ATTRIBUTE1 DS_ATTRIBUTE1
, POD.ATTRIBUTE2 DS_ATTRIBUTE2
, POD.ATTRIBUTE3 DS_ATTRIBUTE3
, POD.ATTRIBUTE4 DS_ATTRIBUTE4
, POD.ATTRIBUTE5 DS_ATTRIBUTE5
, POD.ATTRIBUTE6 DS_ATTRIBUTE6
, POD.ATTRIBUTE7 DS_ATTRIBUTE7
, POD.ATTRIBUTE8 DS_ATTRIBUTE8
, POD.ATTRIBUTE9 DS_ATTRIBUTE9
, POD.ATTRIBUTE10 DS_ATTRIBUTE10
, POD.ATTRIBUTE11 DS_ATTRIBUTE11
, POD.ATTRIBUTE12 DS_ATTRIBUTE12
, POD.ATTRIBUTE13 DS_ATTRIBUTE13
, POD.ATTRIBUTE14 DS_ATTRIBUTE14
, POD.ATTRIBUTE15 DS_ATTRIBUTE15
, HRL.LOCATION_CODE DELIVER_TO_LOCATION_CODE
, PPF.LAST_NAME DELIVER_TO_CONTACT_LAST_NAME
, PPF.FIRST_NAME DELIVER_TO_CONTACT_FIRST_NAME
, HRL.ADDRESS_LINE_1 DELIVER_TO_ADDRESS_LINE_1
, HRL.ADDRESS_LINE_2 DELIVER_TO_ADDRESS_LINE_2
, HRL.ADDRESS_LINE_3 DELIVER_TO_ADDRESS_LINE_3
, HRL.TOWN_OR_CITY DELIVER_TO_CITY
, HRL.POSTAL_CODE DELIVER_TO_POSTAL_CODE
, HRL.COUNTRY DELIVER_TO_COUNTRY
, HRL.REGION_1 DELIVER_TO_REGION_1
, HRL.REGION_2 DELIVER_TO_REGION_2
, HRL.REGION_3 DELIVER_TO_REGION_3
, HRL.TELEPHONE_NUMBER_1 DELIVER_TO_PHONE1
, HRL.TELEPHONE_NUMBER_2 DELIVER_TO_PHONE2
, HRL.TELEPHONE_NUMBER_3 DELIVER_TO_PHONE3
, POD.DELIVER_TO_LOCATION_ID DELIVER_TO_LOCATION_ID
, POD.DELIVER_TO_PERSON_ID DELIVER_TO_PERSON_ID
, POR.RELEASE_NUM POR_RELEASE_NUM
, POLL.SHIPMENT_NUM SHIPMENT_NUMBER
, HRL.ECE_TP_LOCATION_CODE DELIVER_TO_EDI_LOCATION_CODE
FROM PO_LINE_LOCATIONS POLL
, PO_RELEASES POR
, PO_DISTRIBUTIONS POD
, PER_ALL_PEOPLE_F PPF
, HR_LOCATIONS_ALL HRL
WHERE POD.LINE_LOCATION_ID = POLL.LINE_LOCATION_ID
AND POD.DELIVER_TO_LOCATION_ID = HRL.LOCATION_ID (+)
AND PPF.PERSON_ID(+) = POD.DELIVER_TO_PERSON_ID
AND POD.PO_RELEASE_ID = POR.PO_RELEASE_ID
AND TRUNC(SYSDATE)<=PPF.EFFECTIVE_END_DATE(+)
AND TRUNC(SYSDATE)>=PPF.EFFECTIVE_START_DATE(+)

Columns