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: EC.ECE_PO_DISTRIBUTIONS#

Source

View Text - Preformatted


select RUN_ID RUN_ID, PO_HEADER_ID PO_HEADER_ID, PO_RELEASE_ID PO_RELEASE_ID, PO_LINE_ID PO_LINE_ID, LINE_LOCATION_ID LINE_LOCATION_ID, PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, DISTRIBUTION_NUM DISTRIBUTION_NUM, PROJECT_NUMBER PROJECT_NUMBER, PROJECT_TYPE PROJECT_TYPE, TASK_NUMBER TASK_NUMBER, QUANTITY_ORDERED QUANTITY_ORDERED, QUANTITY_DELIVERED QUANTITY_DELIVERED, QUANTITY_BILLED QUANTITY_BILLED, QUANTITY_CANCELLED QUANTITY_CANCELLED, AMOUNT_BILLED AMOUNT_BILLED, CONVERSION_RATE CONVERSION_RATE, CONVERSION_DATE CONVERSION_DATE, DESTINATION_TYPE_CODE DESTINATION_TYPE_CODE, DS_ATTRIBUTE_CATEGORY DS_ATTRIBUTE_CATEGORY, DS_ATTRIBUTE1 DS_ATTRIBUTE1, DS_ATTRIBUTE2 DS_ATTRIBUTE2, DS_ATTRIBUTE3 DS_ATTRIBUTE3, DS_ATTRIBUTE4 DS_ATTRIBUTE4, DS_ATTRIBUTE5 DS_ATTRIBUTE5, DS_ATTRIBUTE6 DS_ATTRIBUTE6, DS_ATTRIBUTE7 DS_ATTRIBUTE7, DS_ATTRIBUTE8 DS_ATTRIBUTE8, DS_ATTRIBUTE9 DS_ATTRIBUTE9, DS_ATTRIBUTE10 DS_ATTRIBUTE10, DS_ATTRIBUTE11 DS_ATTRIBUTE11, DS_ATTRIBUTE12 DS_ATTRIBUTE12, DS_ATTRIBUTE13 DS_ATTRIBUTE13, DS_ATTRIBUTE14 DS_ATTRIBUTE14, DS_ATTRIBUTE15 DS_ATTRIBUTE15, DELIVER_TO_LOCATION_CODE DELIVER_TO_LOCATION_CODE, DELIVER_TO_LOCATION_CODE_INT DELIVER_TO_LOCATION_CODE_INT, DELIVER_TO_LOCATION_CODE_EXT1 DELIVER_TO_LOCATION_CODE_EXT1, DELIVER_TO_LOCATION_CODE_EXT2 DELIVER_TO_LOCATION_CODE_EXT2, DELIVER_TO_LOCATION_CODE_EXT3 DELIVER_TO_LOCATION_CODE_EXT3, DELIVER_TO_LOCATION_CODE_EXT4 DELIVER_TO_LOCATION_CODE_EXT4, DELIVER_TO_LOCATION_CODE_EXT5 DELIVER_TO_LOCATION_CODE_EXT5, DELIVER_TO_SITE_NAME DELIVER_TO_SITE_NAME, DELIVER_TO_CONTACT_LAST_NAME DELIVER_TO_CONTACT_LAST_NAME, DELIVER_TO_CONTACT_FIRST_NAME DELIVER_TO_CONTACT_FIRST_NAME, DELIVER_TO_ADDRESS_LINE_1 DELIVER_TO_ADDRESS_LINE_1, DELIVER_TO_ADDRESS_LINE_2 DELIVER_TO_ADDRESS_LINE_2, DELIVER_TO_ADDRESS_LINE_3 DELIVER_TO_ADDRESS_LINE_3, DELIVER_TO_CITY DELIVER_TO_CITY, DELIVER_TO_POSTAL_CODE DELIVER_TO_POSTAL_CODE, DELIVER_TO_COUNTRY DELIVER_TO_COUNTRY, DELIVER_TO_REGION_1 DELIVER_TO_REGION_1, DELIVER_TO_REGION_2 DELIVER_TO_REGION_2, DELIVER_TO_REGION_3 DELIVER_TO_REGION_3, DELIVER_TO_CONTACT_JOB_TITLE DELIVER_TO_CONTACT_JOB_TITLE, DELIVER_TO_PHONE1_AREA_CODE DELIVER_TO_PHONE1_AREA_CODE, DELIVER_TO_PHONE1 DELIVER_TO_PHONE1, DELIVER_TO_PHONE2_AREA_CODE DELIVER_TO_PHONE2_AREA_CODE, DELIVER_TO_PHONE2 DELIVER_TO_PHONE2, DELIVER_TO_PHONE3_AREA_CODE DELIVER_TO_PHONE3_AREA_CODE, DELIVER_TO_PHONE3 DELIVER_TO_PHONE3, DELIVER_TO_LOCATION_ID DELIVER_TO_LOCATION_ID, DELIVER_TO_PERSON_ID DELIVER_TO_PERSON_ID, RELEASE_NUMBER RELEASE_NUMBER, SHIPMENT_NUMBER SHIPMENT_NUMBER, DELIVER_TO_COUNTRY_EXT1 DELIVER_TO_COUNTRY_EXT1, DELIVER_TO_COUNTRY_EXT2 DELIVER_TO_COUNTRY_EXT2, DELIVER_TO_COUNTRY_EXT3 DELIVER_TO_COUNTRY_EXT3, DELIVER_TO_COUNTRY_EXT4 DELIVER_TO_COUNTRY_EXT4, DELIVER_TO_COUNTRY_EXT5 DELIVER_TO_COUNTRY_EXT5, DELIVER_TO_REGION_1_EXT1 DELIVER_TO_REGION_1_EXT1, DELIVER_TO_REGION_1_EXT2 DELIVER_TO_REGION_1_EXT2, DELIVER_TO_REGION_1_EXT3 DELIVER_TO_REGION_1_EXT3, DELIVER_TO_REGION_1_EXT4 DELIVER_TO_REGION_1_EXT4, DELIVER_TO_REGION_1_EXT5 DELIVER_TO_REGION_1_EXT5, DELIVER_TO_REGION_2_EXT1 DELIVER_TO_REGION_2_EXT1, DELIVER_TO_REGION_2_EXT2 DELIVER_TO_REGION_2_EXT2, DELIVER_TO_REGION_2_EXT3 DELIVER_TO_REGION_2_EXT3, DELIVER_TO_REGION_2_EXT4 DELIVER_TO_REGION_2_EXT4, DELIVER_TO_REGION_2_EXT5 DELIVER_TO_REGION_2_EXT5, DELIVER_TO_REGION_3_EXT1 DELIVER_TO_REGION_3_EXT1, DELIVER_TO_REGION_3_EXT2 DELIVER_TO_REGION_3_EXT2, DELIVER_TO_REGION_3_EXT3 DELIVER_TO_REGION_3_EXT3, DELIVER_TO_REGION_3_EXT4 DELIVER_TO_REGION_3_EXT4, DELIVER_TO_REGION_3_EXT5 DELIVER_TO_REGION_3_EXT5, TRANSACTION_RECORD_ID TRANSACTION_RECORD_ID, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, DELIVER_TO_ADDRESS_LINE_4 DELIVER_TO_ADDRESS_LINE_4 from "EC"."ECE_PO_DISTRIBUTIONS"

View Text - HTML Formatted

SELECT RUN_ID RUN_ID
, PO_HEADER_ID PO_HEADER_ID
, PO_RELEASE_ID PO_RELEASE_ID
, PO_LINE_ID PO_LINE_ID
, LINE_LOCATION_ID LINE_LOCATION_ID
, PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, DISTRIBUTION_NUM DISTRIBUTION_NUM
, PROJECT_NUMBER PROJECT_NUMBER
, PROJECT_TYPE PROJECT_TYPE
, TASK_NUMBER TASK_NUMBER
, QUANTITY_ORDERED QUANTITY_ORDERED
, QUANTITY_DELIVERED QUANTITY_DELIVERED
, QUANTITY_BILLED QUANTITY_BILLED
, QUANTITY_CANCELLED QUANTITY_CANCELLED
, AMOUNT_BILLED AMOUNT_BILLED
, CONVERSION_RATE CONVERSION_RATE
, CONVERSION_DATE CONVERSION_DATE
, DESTINATION_TYPE_CODE DESTINATION_TYPE_CODE
, DS_ATTRIBUTE_CATEGORY DS_ATTRIBUTE_CATEGORY
, DS_ATTRIBUTE1 DS_ATTRIBUTE1
, DS_ATTRIBUTE2 DS_ATTRIBUTE2
, DS_ATTRIBUTE3 DS_ATTRIBUTE3
, DS_ATTRIBUTE4 DS_ATTRIBUTE4
, DS_ATTRIBUTE5 DS_ATTRIBUTE5
, DS_ATTRIBUTE6 DS_ATTRIBUTE6
, DS_ATTRIBUTE7 DS_ATTRIBUTE7
, DS_ATTRIBUTE8 DS_ATTRIBUTE8
, DS_ATTRIBUTE9 DS_ATTRIBUTE9
, DS_ATTRIBUTE10 DS_ATTRIBUTE10
, DS_ATTRIBUTE11 DS_ATTRIBUTE11
, DS_ATTRIBUTE12 DS_ATTRIBUTE12
, DS_ATTRIBUTE13 DS_ATTRIBUTE13
, DS_ATTRIBUTE14 DS_ATTRIBUTE14
, DS_ATTRIBUTE15 DS_ATTRIBUTE15
, DELIVER_TO_LOCATION_CODE DELIVER_TO_LOCATION_CODE
, DELIVER_TO_LOCATION_CODE_INT DELIVER_TO_LOCATION_CODE_INT
, DELIVER_TO_LOCATION_CODE_EXT1 DELIVER_TO_LOCATION_CODE_EXT1
, DELIVER_TO_LOCATION_CODE_EXT2 DELIVER_TO_LOCATION_CODE_EXT2
, DELIVER_TO_LOCATION_CODE_EXT3 DELIVER_TO_LOCATION_CODE_EXT3
, DELIVER_TO_LOCATION_CODE_EXT4 DELIVER_TO_LOCATION_CODE_EXT4
, DELIVER_TO_LOCATION_CODE_EXT5 DELIVER_TO_LOCATION_CODE_EXT5
, DELIVER_TO_SITE_NAME DELIVER_TO_SITE_NAME
, DELIVER_TO_CONTACT_LAST_NAME DELIVER_TO_CONTACT_LAST_NAME
, DELIVER_TO_CONTACT_FIRST_NAME DELIVER_TO_CONTACT_FIRST_NAME
, DELIVER_TO_ADDRESS_LINE_1 DELIVER_TO_ADDRESS_LINE_1
, DELIVER_TO_ADDRESS_LINE_2 DELIVER_TO_ADDRESS_LINE_2
, DELIVER_TO_ADDRESS_LINE_3 DELIVER_TO_ADDRESS_LINE_3
, DELIVER_TO_CITY DELIVER_TO_CITY
, DELIVER_TO_POSTAL_CODE DELIVER_TO_POSTAL_CODE
, DELIVER_TO_COUNTRY DELIVER_TO_COUNTRY
, DELIVER_TO_REGION_1 DELIVER_TO_REGION_1
, DELIVER_TO_REGION_2 DELIVER_TO_REGION_2
, DELIVER_TO_REGION_3 DELIVER_TO_REGION_3
, DELIVER_TO_CONTACT_JOB_TITLE DELIVER_TO_CONTACT_JOB_TITLE
, DELIVER_TO_PHONE1_AREA_CODE DELIVER_TO_PHONE1_AREA_CODE
, DELIVER_TO_PHONE1 DELIVER_TO_PHONE1
, DELIVER_TO_PHONE2_AREA_CODE DELIVER_TO_PHONE2_AREA_CODE
, DELIVER_TO_PHONE2 DELIVER_TO_PHONE2
, DELIVER_TO_PHONE3_AREA_CODE DELIVER_TO_PHONE3_AREA_CODE
, DELIVER_TO_PHONE3 DELIVER_TO_PHONE3
, DELIVER_TO_LOCATION_ID DELIVER_TO_LOCATION_ID
, DELIVER_TO_PERSON_ID DELIVER_TO_PERSON_ID
, RELEASE_NUMBER RELEASE_NUMBER
, SHIPMENT_NUMBER SHIPMENT_NUMBER
, DELIVER_TO_COUNTRY_EXT1 DELIVER_TO_COUNTRY_EXT1
, DELIVER_TO_COUNTRY_EXT2 DELIVER_TO_COUNTRY_EXT2
, DELIVER_TO_COUNTRY_EXT3 DELIVER_TO_COUNTRY_EXT3
, DELIVER_TO_COUNTRY_EXT4 DELIVER_TO_COUNTRY_EXT4
, DELIVER_TO_COUNTRY_EXT5 DELIVER_TO_COUNTRY_EXT5
, DELIVER_TO_REGION_1_EXT1 DELIVER_TO_REGION_1_EXT1
, DELIVER_TO_REGION_1_EXT2 DELIVER_TO_REGION_1_EXT2
, DELIVER_TO_REGION_1_EXT3 DELIVER_TO_REGION_1_EXT3
, DELIVER_TO_REGION_1_EXT4 DELIVER_TO_REGION_1_EXT4
, DELIVER_TO_REGION_1_EXT5 DELIVER_TO_REGION_1_EXT5
, DELIVER_TO_REGION_2_EXT1 DELIVER_TO_REGION_2_EXT1
, DELIVER_TO_REGION_2_EXT2 DELIVER_TO_REGION_2_EXT2
, DELIVER_TO_REGION_2_EXT3 DELIVER_TO_REGION_2_EXT3
, DELIVER_TO_REGION_2_EXT4 DELIVER_TO_REGION_2_EXT4
, DELIVER_TO_REGION_2_EXT5 DELIVER_TO_REGION_2_EXT5
, DELIVER_TO_REGION_3_EXT1 DELIVER_TO_REGION_3_EXT1
, DELIVER_TO_REGION_3_EXT2 DELIVER_TO_REGION_3_EXT2
, DELIVER_TO_REGION_3_EXT3 DELIVER_TO_REGION_3_EXT3
, DELIVER_TO_REGION_3_EXT4 DELIVER_TO_REGION_3_EXT4
, DELIVER_TO_REGION_3_EXT5 DELIVER_TO_REGION_3_EXT5
, TRANSACTION_RECORD_ID TRANSACTION_RECORD_ID
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, DELIVER_TO_ADDRESS_LINE_4 DELIVER_TO_ADDRESS_LINE_4
FROM "EC"."ECE_PO_DISTRIBUTIONS"