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.

[Home] [Help]

VIEW: EC.ECE_PO_INTERFACE_SHIPMENTS#

Source

View Text - Preformatted


select SHIPMENT_NUMBER SHIPMENT_NUMBER, QUANTITY_ORIGINAL QUANTITY_ORIGINAL, UOM_CODE UOM_CODE, UOM_CODE_EXT1 UOM_CODE_EXT1, SHIPMENT_NEED_BY_DATE SHIPMENT_NEED_BY_DATE, SHIPMENT_PROMISED_DATE SHIPMENT_PROMISED_DATE, SHIPMENT_LAST_ACCEPTABLE_DATE SHIPMENT_LAST_ACCEPTABLE_DATE, QUANTITY QUANTITY, QUANTITY_CANCELLED QUANTITY_CANCELLED, QUANTITY_DELIVERED QUANTITY_DELIVERED, PRICE_OVERRIDE PRICE_OVERRIDE, CANCELLED_FLAG CANCELLED_FLAG, CANCELLED_DATE CANCELLED_DATE, SHIP_VIA SHIP_VIA, SHIP_VIA_EXT1 SHIP_VIA_EXT1, SHIP_VIA_EXT2 SHIP_VIA_EXT2, SHIP_VIA_EXT3 SHIP_VIA_EXT3, FOB_CODE FOB_CODE, FOB_CODE_EXT1 FOB_CODE_EXT1, FREIGHT_TERMS FREIGHT_TERMS, FREIGHT_TERMS_EXT1 FREIGHT_TERMS_EXT1, TAXABLE_FLAG TAXABLE_FLAG, SHIPMENT_ATTRIBUTE_CATEGORY SHIPMENT_ATTRIBUTE_CATEGORY, SHIPMENT_ATTRIBUTE1 SHIPMENT_ATTRIBUTE1, SHIPMENT_ATTRIBUTE2 SHIPMENT_ATTRIBUTE2, SHIPMENT_ATTRIBUTE3 SHIPMENT_ATTRIBUTE3, SHIPMENT_ATTRIBUTE4 SHIPMENT_ATTRIBUTE4, SHIPMENT_ATTRIBUTE5 SHIPMENT_ATTRIBUTE5, SHIPMENT_ATTRIBUTE6 SHIPMENT_ATTRIBUTE6, SHIPMENT_ATTRIBUTE7 SHIPMENT_ATTRIBUTE7, SHIPMENT_ATTRIBUTE8 SHIPMENT_ATTRIBUTE8, SHIPMENT_ATTRIBUTE9 SHIPMENT_ATTRIBUTE9, SHIPMENT_ATTRIBUTE10 SHIPMENT_ATTRIBUTE10, SHIPMENT_ATTRIBUTE11 SHIPMENT_ATTRIBUTE11, SHIPMENT_ATTRIBUTE12 SHIPMENT_ATTRIBUTE12, SHIPMENT_ATTRIBUTE13 SHIPMENT_ATTRIBUTE13, SHIPMENT_ATTRIBUTE14 SHIPMENT_ATTRIBUTE14, SHIPMENT_ATTRIBUTE15 SHIPMENT_ATTRIBUTE15, SHIP_TO_LOCATION_CODE SHIP_TO_LOCATION_CODE, SHIP_TO_ENTITY_EXT1 SHIP_TO_ENTITY_EXT1, SHIP_TO_SITE_NAME SHIP_TO_SITE_NAME, SHIP_TO_ADDRESS_LINE_1 SHIP_TO_ADDRESS_LINE_1, SHIP_TO_ADDRESS_LINE_2 SHIP_TO_ADDRESS_LINE_2, SHIP_TO_ADDRESS_LINE_3 SHIP_TO_ADDRESS_LINE_3, SHIP_TO_ADDRESS_LINE_4 SHIP_TO_ADDRESS_LINE_4, SHIP_TO_CITY SHIP_TO_CITY, SHIP_TO_POSTAL_CODE SHIP_TO_POSTAL_CODE, SHIP_TO_COUNTRY SHIP_TO_COUNTRY, SHIP_TO_COUNTRY_EXT1 SHIP_TO_COUNTRY_EXT1, SHIP_TO_REGION1 SHIP_TO_REGION1, SHIP_TO_REGION1_EXT1 SHIP_TO_REGION1_EXT1, SHIP_TO_REGION2 SHIP_TO_REGION2, SHIP_TO_REGION2_EXT1 SHIP_TO_REGION2_EXT1, SHIP_TO_REGION3 SHIP_TO_REGION3, SHIP_TO_REGION3_EXT1 SHIP_TO_REGION3_EXT1, SHIP_TO_CONTACT_LAST_NAME SHIP_TO_CONTACT_LAST_NAME, SHIP_TO_CONTACT_FIRST_NAME SHIP_TO_CONTACT_FIRST_NAME, SHIP_TO_CONTACT_JOB_TITLE SHIP_TO_CONTACT_JOB_TITLE, SHIP_TO_PHONE1_AREA_CODE SHIP_TO_PHONE1_AREA_CODE, SHIP_TO_PHONE1 SHIP_TO_PHONE1, SHIP_TO_PHONE2_AREA_CODE SHIP_TO_PHONE2_AREA_CODE, SHIP_TO_PHONE2 SHIP_TO_PHONE2, SHIP_TO_PHONE3_AREA_CODE SHIP_TO_PHONE3_AREA_CODE, SHIP_TO_PHONE3 SHIP_TO_PHONE3, PO_HEADER_ID PO_HEADER_ID, PO_RELEASE_ID PO_RELEASE_ID, PO_LINE_ID PO_LINE_ID, LINE_LOCATION_ID LINE_LOCATION_ID, RUN_ID RUN_ID, TRANSACTION_RECORD_ID TRANSACTION_RECORD_ID, CURRENCY_EXCHANGE_RATE CURRENCY_EXCHANGE_RATE, TERM_DUE_PERCENT TERM_DUE_PERCENT, TERM_DUE_DATE TERM_DUE_DATE, TERM_DUE_DAYS TERM_DUE_DAYS, TERM_DUE_DAY_OF_MONTH TERM_DUE_DAY_OF_MONTH, TERM_DUE_CUTOFF_DAY TERM_DUE_CUTOFF_DAY, TERM_DUE_MONTHS_FORWARD TERM_DUE_MONTHS_FORWARD, DISCOUNT_PERCENT1 DISCOUNT_PERCENT1, DISCOUNT_DAYS1 DISCOUNT_DAYS1, DISCOUNT_DATE1 DISCOUNT_DATE1, DISCOUNT_DAY_OF_MONTH1 DISCOUNT_DAY_OF_MONTH1, DISCOUNT_MONTHS_FORWARD1 DISCOUNT_MONTHS_FORWARD1, DISCOUNT_PERCENT2 DISCOUNT_PERCENT2, DISCOUNT_DAYS2 DISCOUNT_DAYS2, DISCOUNT_DATE2 DISCOUNT_DATE2, DISCOUNT_DAY_OF_MONTH2 DISCOUNT_DAY_OF_MONTH2, DISCOUNT_MONTHS_FORWARD2 DISCOUNT_MONTHS_FORWARD2, PAYMENT_TERMS PAYMENT_TERMS, DELIVER_TO_CONTACT_LAST_NAME DELIVER_TO_CONTACT_LAST_NAME, DELIVER_TO_CONTACT_FIRST_NAME DELIVER_TO_CONTACT_FIRST_NAME, DELIVER_TO_CONTACT_MIDDLE_NAME DELIVER_TO_CONTACT_MIDDLE_NAME, DELIVER_TO_CONTACT_TITLE DELIVER_TO_CONTACT_TITLE, UOM_CODE_EXT2 UOM_CODE_EXT2, UOM_CODE_EXT3 UOM_CODE_EXT3, UOM_CODE_EXT4 UOM_CODE_EXT4, UOM_CODE_EXT5 UOM_CODE_EXT5, SHIP_VIA_EXT4 SHIP_VIA_EXT4, SHIP_VIA_EXT5 SHIP_VIA_EXT5, FOB_CODE_EXT2 FOB_CODE_EXT2, FOB_CODE_EXT3 FOB_CODE_EXT3, FOB_CODE_EXT4 FOB_CODE_EXT4, FOB_CODE_EXT5 FOB_CODE_EXT5, FREIGHT_TERMS_EXT2 FREIGHT_TERMS_EXT2, FREIGHT_TERMS_EXT3 FREIGHT_TERMS_EXT3, FREIGHT_TERMS_EXT4 FREIGHT_TERMS_EXT4, FREIGHT_TERMS_EXT5 FREIGHT_TERMS_EXT5, SHIP_TO_COUNTRY_EXT2 SHIP_TO_COUNTRY_EXT2, SHIP_TO_COUNTRY_EXT3 SHIP_TO_COUNTRY_EXT3, SHIP_TO_COUNTRY_EXT4 SHIP_TO_COUNTRY_EXT4, SHIP_TO_COUNTRY_EXT5 SHIP_TO_COUNTRY_EXT5, SHIP_TO_REGION1_EXT2 SHIP_TO_REGION1_EXT2, SHIP_TO_REGION1_EXT3 SHIP_TO_REGION1_EXT3, SHIP_TO_REGION1_EXT4 SHIP_TO_REGION1_EXT4, SHIP_TO_REGION1_EXT5 SHIP_TO_REGION1_EXT5, SHIP_TO_REGION2_EXT2 SHIP_TO_REGION2_EXT2, SHIP_TO_REGION2_EXT3 SHIP_TO_REGION2_EXT3, SHIP_TO_REGION2_EXT4 SHIP_TO_REGION2_EXT4, SHIP_TO_REGION2_EXT5 SHIP_TO_REGION2_EXT5, SHIP_TO_REGION3_EXT2 SHIP_TO_REGION3_EXT2, SHIP_TO_REGION3_EXT3 SHIP_TO_REGION3_EXT3, SHIP_TO_REGION3_EXT4 SHIP_TO_REGION3_EXT4, SHIP_TO_REGION3_EXT5 SHIP_TO_REGION3_EXT5, DISCOUNT_PERCENT3 DISCOUNT_PERCENT3, DISCOUNT_DAYS3 DISCOUNT_DAYS3, DISCOUNT_DATE3 DISCOUNT_DATE3, DISCOUNT_DAY_OF_MONTH3 DISCOUNT_DAY_OF_MONTH3, DISCOUNT_MONTHS_FORWARD3 DISCOUNT_MONTHS_FORWARD3, PO_NUMBER PO_NUMBER, LINE_NUMBER LINE_NUMBER, DISTRIBUTION_NUMBER DISTRIBUTION_NUMBER, RELEASE_NUMBER RELEASE_NUMBER, PO_TYPE PO_TYPE, TRANSACTION_TYPE TRANSACTION_TYPE, COMMUNICATION_METHOD COMMUNICATION_METHOD, 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, QUANTITY_PENDING QUANTITY_PENDING, POR_RELEASE_ID POR_RELEASE_ID, SHIP_TO_LOCATION_CODE_INT SHIP_TO_LOCATION_CODE_INT, SHIP_TO_LOCATION_CODE_EXT1 SHIP_TO_LOCATION_CODE_EXT1, SHIP_TO_LOCATION_CODE_EXT2 SHIP_TO_LOCATION_CODE_EXT2, SHIP_TO_LOCATION_CODE_EXT3 SHIP_TO_LOCATION_CODE_EXT3, SHIP_TO_LOCATION_CODE_EXT4 SHIP_TO_LOCATION_CODE_EXT4, SHIP_TO_LOCATION_CODE_EXT5 SHIP_TO_LOCATION_CODE_EXT5, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID, START_DATE START_DATE, END_DATE END_DATE, CONSIGNED_FLAG CONSIGNED_FLAG, CONSIGNED_FLAG_EXT1 CONSIGNED_FLAG_EXT1, CONSIGNED_FLAG_EXT2 CONSIGNED_FLAG_EXT2, CONSIGNED_FLAG_EXT3 CONSIGNED_FLAG_EXT3, CONSIGNED_FLAG_EXT4 CONSIGNED_FLAG_EXT4, CONSIGNED_FLAG_EXT5 CONSIGNED_FLAG_EXT5, SHIP_TO_ORGANIZATION_NAME SHIP_TO_ORGANIZATION_NAME, SHIP_TO_CUSTOMER_NAME SHIP_TO_CUSTOMER_NAME, SHIP_TO_CONTACT_NAME SHIP_TO_CONTACT_NAME, SHIP_TO_CONTACT_PHONE SHIP_TO_CONTACT_PHONE, SHIP_TO_CONTACT_FAX SHIP_TO_CONTACT_FAX, SHIP_TO_CONTACT_EMAIL SHIP_TO_CONTACT_EMAIL, SHIPPING_INSTRUCTIONS SHIPPING_INSTRUCTIONS, PACKING_INSTRUCTIONS PACKING_INSTRUCTIONS, SHIPPING_METHOD SHIPPING_METHOD, CUSTOMER_PO_NUMBER CUSTOMER_PO_NUMBER, CUSTOMER_PO_LINE_NUM CUSTOMER_PO_LINE_NUM, CUSTOMER_PO_SHIPMENT_NUM CUSTOMER_PO_SHIPMENT_NUM, CUSTOMER_ITEM_DESCRIPTION CUSTOMER_ITEM_DESCRIPTION, DELIVER_TO_LOCATION DELIVER_TO_LOCATION, DELIVER_TO_CUSTOMER_NAME DELIVER_TO_CUSTOMER_NAME, DELIVER_TO_CONTACT_NAME DELIVER_TO_CONTACT_NAME, DELIVER_TO_CONTACT_PHONE DELIVER_TO_CONTACT_PHONE, DELIVER_TO_CONTACT_FAX DELIVER_TO_CONTACT_FAX, DELIVER_TO_CUSTOMER_ADDRESS DELIVER_TO_CUSTOMER_ADDRESS, DELIVER_TO_CONTACT_EMAIL DELIVER_TO_CONTACT_EMAIL from "EC"."ECE_PO_INTERFACE_SHIPMENTS"

View Text - HTML Formatted

SELECT SHIPMENT_NUMBER SHIPMENT_NUMBER
, QUANTITY_ORIGINAL QUANTITY_ORIGINAL
, UOM_CODE UOM_CODE
, UOM_CODE_EXT1 UOM_CODE_EXT1
, SHIPMENT_NEED_BY_DATE SHIPMENT_NEED_BY_DATE
, SHIPMENT_PROMISED_DATE SHIPMENT_PROMISED_DATE
, SHIPMENT_LAST_ACCEPTABLE_DATE SHIPMENT_LAST_ACCEPTABLE_DATE
, QUANTITY QUANTITY
, QUANTITY_CANCELLED QUANTITY_CANCELLED
, QUANTITY_DELIVERED QUANTITY_DELIVERED
, PRICE_OVERRIDE PRICE_OVERRIDE
, CANCELLED_FLAG CANCELLED_FLAG
, CANCELLED_DATE CANCELLED_DATE
, SHIP_VIA SHIP_VIA
, SHIP_VIA_EXT1 SHIP_VIA_EXT1
, SHIP_VIA_EXT2 SHIP_VIA_EXT2
, SHIP_VIA_EXT3 SHIP_VIA_EXT3
, FOB_CODE FOB_CODE
, FOB_CODE_EXT1 FOB_CODE_EXT1
, FREIGHT_TERMS FREIGHT_TERMS
, FREIGHT_TERMS_EXT1 FREIGHT_TERMS_EXT1
, TAXABLE_FLAG TAXABLE_FLAG
, SHIPMENT_ATTRIBUTE_CATEGORY SHIPMENT_ATTRIBUTE_CATEGORY
, SHIPMENT_ATTRIBUTE1 SHIPMENT_ATTRIBUTE1
, SHIPMENT_ATTRIBUTE2 SHIPMENT_ATTRIBUTE2
, SHIPMENT_ATTRIBUTE3 SHIPMENT_ATTRIBUTE3
, SHIPMENT_ATTRIBUTE4 SHIPMENT_ATTRIBUTE4
, SHIPMENT_ATTRIBUTE5 SHIPMENT_ATTRIBUTE5
, SHIPMENT_ATTRIBUTE6 SHIPMENT_ATTRIBUTE6
, SHIPMENT_ATTRIBUTE7 SHIPMENT_ATTRIBUTE7
, SHIPMENT_ATTRIBUTE8 SHIPMENT_ATTRIBUTE8
, SHIPMENT_ATTRIBUTE9 SHIPMENT_ATTRIBUTE9
, SHIPMENT_ATTRIBUTE10 SHIPMENT_ATTRIBUTE10
, SHIPMENT_ATTRIBUTE11 SHIPMENT_ATTRIBUTE11
, SHIPMENT_ATTRIBUTE12 SHIPMENT_ATTRIBUTE12
, SHIPMENT_ATTRIBUTE13 SHIPMENT_ATTRIBUTE13
, SHIPMENT_ATTRIBUTE14 SHIPMENT_ATTRIBUTE14
, SHIPMENT_ATTRIBUTE15 SHIPMENT_ATTRIBUTE15
, SHIP_TO_LOCATION_CODE SHIP_TO_LOCATION_CODE
, SHIP_TO_ENTITY_EXT1 SHIP_TO_ENTITY_EXT1
, SHIP_TO_SITE_NAME SHIP_TO_SITE_NAME
, SHIP_TO_ADDRESS_LINE_1 SHIP_TO_ADDRESS_LINE_1
, SHIP_TO_ADDRESS_LINE_2 SHIP_TO_ADDRESS_LINE_2
, SHIP_TO_ADDRESS_LINE_3 SHIP_TO_ADDRESS_LINE_3
, SHIP_TO_ADDRESS_LINE_4 SHIP_TO_ADDRESS_LINE_4
, SHIP_TO_CITY SHIP_TO_CITY
, SHIP_TO_POSTAL_CODE SHIP_TO_POSTAL_CODE
, SHIP_TO_COUNTRY SHIP_TO_COUNTRY
, SHIP_TO_COUNTRY_EXT1 SHIP_TO_COUNTRY_EXT1
, SHIP_TO_REGION1 SHIP_TO_REGION1
, SHIP_TO_REGION1_EXT1 SHIP_TO_REGION1_EXT1
, SHIP_TO_REGION2 SHIP_TO_REGION2
, SHIP_TO_REGION2_EXT1 SHIP_TO_REGION2_EXT1
, SHIP_TO_REGION3 SHIP_TO_REGION3
, SHIP_TO_REGION3_EXT1 SHIP_TO_REGION3_EXT1
, SHIP_TO_CONTACT_LAST_NAME SHIP_TO_CONTACT_LAST_NAME
, SHIP_TO_CONTACT_FIRST_NAME SHIP_TO_CONTACT_FIRST_NAME
, SHIP_TO_CONTACT_JOB_TITLE SHIP_TO_CONTACT_JOB_TITLE
, SHIP_TO_PHONE1_AREA_CODE SHIP_TO_PHONE1_AREA_CODE
, SHIP_TO_PHONE1 SHIP_TO_PHONE1
, SHIP_TO_PHONE2_AREA_CODE SHIP_TO_PHONE2_AREA_CODE
, SHIP_TO_PHONE2 SHIP_TO_PHONE2
, SHIP_TO_PHONE3_AREA_CODE SHIP_TO_PHONE3_AREA_CODE
, SHIP_TO_PHONE3 SHIP_TO_PHONE3
, PO_HEADER_ID PO_HEADER_ID
, PO_RELEASE_ID PO_RELEASE_ID
, PO_LINE_ID PO_LINE_ID
, LINE_LOCATION_ID LINE_LOCATION_ID
, RUN_ID RUN_ID
, TRANSACTION_RECORD_ID TRANSACTION_RECORD_ID
, CURRENCY_EXCHANGE_RATE CURRENCY_EXCHANGE_RATE
, TERM_DUE_PERCENT TERM_DUE_PERCENT
, TERM_DUE_DATE TERM_DUE_DATE
, TERM_DUE_DAYS TERM_DUE_DAYS
, TERM_DUE_DAY_OF_MONTH TERM_DUE_DAY_OF_MONTH
, TERM_DUE_CUTOFF_DAY TERM_DUE_CUTOFF_DAY
, TERM_DUE_MONTHS_FORWARD TERM_DUE_MONTHS_FORWARD
, DISCOUNT_PERCENT1 DISCOUNT_PERCENT1
, DISCOUNT_DAYS1 DISCOUNT_DAYS1
, DISCOUNT_DATE1 DISCOUNT_DATE1
, DISCOUNT_DAY_OF_MONTH1 DISCOUNT_DAY_OF_MONTH1
, DISCOUNT_MONTHS_FORWARD1 DISCOUNT_MONTHS_FORWARD1
, DISCOUNT_PERCENT2 DISCOUNT_PERCENT2
, DISCOUNT_DAYS2 DISCOUNT_DAYS2
, DISCOUNT_DATE2 DISCOUNT_DATE2
, DISCOUNT_DAY_OF_MONTH2 DISCOUNT_DAY_OF_MONTH2
, DISCOUNT_MONTHS_FORWARD2 DISCOUNT_MONTHS_FORWARD2
, PAYMENT_TERMS PAYMENT_TERMS
, DELIVER_TO_CONTACT_LAST_NAME DELIVER_TO_CONTACT_LAST_NAME
, DELIVER_TO_CONTACT_FIRST_NAME DELIVER_TO_CONTACT_FIRST_NAME
, DELIVER_TO_CONTACT_MIDDLE_NAME DELIVER_TO_CONTACT_MIDDLE_NAME
, DELIVER_TO_CONTACT_TITLE DELIVER_TO_CONTACT_TITLE
, UOM_CODE_EXT2 UOM_CODE_EXT2
, UOM_CODE_EXT3 UOM_CODE_EXT3
, UOM_CODE_EXT4 UOM_CODE_EXT4
, UOM_CODE_EXT5 UOM_CODE_EXT5
, SHIP_VIA_EXT4 SHIP_VIA_EXT4
, SHIP_VIA_EXT5 SHIP_VIA_EXT5
, FOB_CODE_EXT2 FOB_CODE_EXT2
, FOB_CODE_EXT3 FOB_CODE_EXT3
, FOB_CODE_EXT4 FOB_CODE_EXT4
, FOB_CODE_EXT5 FOB_CODE_EXT5
, FREIGHT_TERMS_EXT2 FREIGHT_TERMS_EXT2
, FREIGHT_TERMS_EXT3 FREIGHT_TERMS_EXT3
, FREIGHT_TERMS_EXT4 FREIGHT_TERMS_EXT4
, FREIGHT_TERMS_EXT5 FREIGHT_TERMS_EXT5
, SHIP_TO_COUNTRY_EXT2 SHIP_TO_COUNTRY_EXT2
, SHIP_TO_COUNTRY_EXT3 SHIP_TO_COUNTRY_EXT3
, SHIP_TO_COUNTRY_EXT4 SHIP_TO_COUNTRY_EXT4
, SHIP_TO_COUNTRY_EXT5 SHIP_TO_COUNTRY_EXT5
, SHIP_TO_REGION1_EXT2 SHIP_TO_REGION1_EXT2
, SHIP_TO_REGION1_EXT3 SHIP_TO_REGION1_EXT3
, SHIP_TO_REGION1_EXT4 SHIP_TO_REGION1_EXT4
, SHIP_TO_REGION1_EXT5 SHIP_TO_REGION1_EXT5
, SHIP_TO_REGION2_EXT2 SHIP_TO_REGION2_EXT2
, SHIP_TO_REGION2_EXT3 SHIP_TO_REGION2_EXT3
, SHIP_TO_REGION2_EXT4 SHIP_TO_REGION2_EXT4
, SHIP_TO_REGION2_EXT5 SHIP_TO_REGION2_EXT5
, SHIP_TO_REGION3_EXT2 SHIP_TO_REGION3_EXT2
, SHIP_TO_REGION3_EXT3 SHIP_TO_REGION3_EXT3
, SHIP_TO_REGION3_EXT4 SHIP_TO_REGION3_EXT4
, SHIP_TO_REGION3_EXT5 SHIP_TO_REGION3_EXT5
, DISCOUNT_PERCENT3 DISCOUNT_PERCENT3
, DISCOUNT_DAYS3 DISCOUNT_DAYS3
, DISCOUNT_DATE3 DISCOUNT_DATE3
, DISCOUNT_DAY_OF_MONTH3 DISCOUNT_DAY_OF_MONTH3
, DISCOUNT_MONTHS_FORWARD3 DISCOUNT_MONTHS_FORWARD3
, PO_NUMBER PO_NUMBER
, LINE_NUMBER LINE_NUMBER
, DISTRIBUTION_NUMBER DISTRIBUTION_NUMBER
, RELEASE_NUMBER RELEASE_NUMBER
, PO_TYPE PO_TYPE
, TRANSACTION_TYPE TRANSACTION_TYPE
, COMMUNICATION_METHOD COMMUNICATION_METHOD
, 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
, QUANTITY_PENDING QUANTITY_PENDING
, POR_RELEASE_ID POR_RELEASE_ID
, SHIP_TO_LOCATION_CODE_INT SHIP_TO_LOCATION_CODE_INT
, SHIP_TO_LOCATION_CODE_EXT1 SHIP_TO_LOCATION_CODE_EXT1
, SHIP_TO_LOCATION_CODE_EXT2 SHIP_TO_LOCATION_CODE_EXT2
, SHIP_TO_LOCATION_CODE_EXT3 SHIP_TO_LOCATION_CODE_EXT3
, SHIP_TO_LOCATION_CODE_EXT4 SHIP_TO_LOCATION_CODE_EXT4
, SHIP_TO_LOCATION_CODE_EXT5 SHIP_TO_LOCATION_CODE_EXT5
, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID
, START_DATE START_DATE
, END_DATE END_DATE
, CONSIGNED_FLAG CONSIGNED_FLAG
, CONSIGNED_FLAG_EXT1 CONSIGNED_FLAG_EXT1
, CONSIGNED_FLAG_EXT2 CONSIGNED_FLAG_EXT2
, CONSIGNED_FLAG_EXT3 CONSIGNED_FLAG_EXT3
, CONSIGNED_FLAG_EXT4 CONSIGNED_FLAG_EXT4
, CONSIGNED_FLAG_EXT5 CONSIGNED_FLAG_EXT5
, SHIP_TO_ORGANIZATION_NAME SHIP_TO_ORGANIZATION_NAME
, SHIP_TO_CUSTOMER_NAME SHIP_TO_CUSTOMER_NAME
, SHIP_TO_CONTACT_NAME SHIP_TO_CONTACT_NAME
, SHIP_TO_CONTACT_PHONE SHIP_TO_CONTACT_PHONE
, SHIP_TO_CONTACT_FAX SHIP_TO_CONTACT_FAX
, SHIP_TO_CONTACT_EMAIL SHIP_TO_CONTACT_EMAIL
, SHIPPING_INSTRUCTIONS SHIPPING_INSTRUCTIONS
, PACKING_INSTRUCTIONS PACKING_INSTRUCTIONS
, SHIPPING_METHOD SHIPPING_METHOD
, CUSTOMER_PO_NUMBER CUSTOMER_PO_NUMBER
, CUSTOMER_PO_LINE_NUM CUSTOMER_PO_LINE_NUM
, CUSTOMER_PO_SHIPMENT_NUM CUSTOMER_PO_SHIPMENT_NUM
, CUSTOMER_ITEM_DESCRIPTION CUSTOMER_ITEM_DESCRIPTION
, DELIVER_TO_LOCATION DELIVER_TO_LOCATION
, DELIVER_TO_CUSTOMER_NAME DELIVER_TO_CUSTOMER_NAME
, DELIVER_TO_CONTACT_NAME DELIVER_TO_CONTACT_NAME
, DELIVER_TO_CONTACT_PHONE DELIVER_TO_CONTACT_PHONE
, DELIVER_TO_CONTACT_FAX DELIVER_TO_CONTACT_FAX
, DELIVER_TO_CUSTOMER_ADDRESS DELIVER_TO_CUSTOMER_ADDRESS
, DELIVER_TO_CONTACT_EMAIL DELIVER_TO_CONTACT_EMAIL
FROM "EC"."ECE_PO_INTERFACE_SHIPMENTS"