eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.ECE_PO_DISTRIBUTIONS_V

Source

View Text - Preformatted


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(+)

View Text - HTML Formatted

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(+)