[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | ECE_PO_INTERFACE_SHIPMENTS |
|---|---|
| Object Type: | TABLE |
| Owner: | EC |
| FND Design Data: |  EC.ECE_PO_INTERFACE_SHIPMENTS
|
| Subobject Name: | |
| Status: | VALID |
ECE_PO_INTERFACE_SHIPMENTS contains purchase order shipment
data to support the outbound Purchase Order (850/ORDERS) and Purchase
Order Change (860/ORDCHG) transactions.
ECE_PO_INTERFACE_SHIPMENTS is based primarily on data stored in
PO_LINE_LOCATIONS in Oracle Purchasing. ECE_PO_INTERFACE_SHIPMENTS
contains approved purchase orders or purchase order changes that match
the e-Commerce Gateway users extract selection criteria.
Each row includes the location, quantity, and dates of each shipment
schedule.
Each row in ECE_PO_INTERFACE_SHIPMENTS is associated with one
row in ECE_PO_INTERFACE_LINES. There is a one-to-many relationship
between ECE_PO_INTERFACE_LINES and ECE_PO_INTERFACE_SHIPMENTS.
RUN_ID uniquely identifies the session that created the row in
ECE_PO_INTERFACE_SHIPMENTS since this table is shared by two
transactions.
Due to the difference in the Oracle Purchasing data model for standard order
lines and blanket releases, each blanket release shipment line is
stored as a purchase order line and purchase order shipment. This is for easy
mapping to the ASC X12 PO1 segment since the ASC X12 SCH segment does
not accommodate prices at the shipment level within the name/address
loop.
All columns denoted with "Int" or "Internal" represent Oracle
Applications internal values. All columns denoted with "Ext" or
"External" represent the equivalent external values sourced from the
ECE_XREF_DATA table if code conversion is enabled for the column.
Each row in ECE_PO_INTERFACE_SHIPMENTS is purged after the data
is written to the data file.
TRANSACTION_RECORD_ID is the unique key that links the
ECE_PO_INTERFACE_SHIPMENTS table to its corresponding extension table
ECE_PO_INTERFACE_SHIPMENTS_X.
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| ECE_PO_INTERFACE_SHIPMENTS_U2 | NORMAL | UNIQUE |
APPS_TS_INTERFACE
|
 TRANSACTION_RECORD_ID
|
| ECE_PO_INTERFACE_SHIPMENTS_N1 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
RUN_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| SHIPMENT_NUMBER | NUMBER | Shipment Number | ||
| QUANTITY_ORIGINAL | NUMBER | Quantity Original | ||
| UOM_CODE | VARCHAR2 | (25) | Unit of Measure Code | |
| UOM_CODE_EXT1 | VARCHAR2 | (80) | Unit of Measure Code 1 (Ext) | |
| SHIPMENT_NEED_BY_DATE | DATE | Shipment Need By Date | ||
| SHIPMENT_PROMISED_DATE | DATE | Shipment Promised Date | ||
| SHIPMENT_LAST_ACCEPTABLE_DATE | DATE | Shipment Last Acceptable Date | ||
| QUANTITY | NUMBER | Quantity | ||
| QUANTITY_CANCELLED | NUMBER | Quantity Cancelled | ||
| QUANTITY_DELIVERED | NUMBER | Quantity Delivered | ||
| PRICE_OVERRIDE | NUMBER | Price Override | ||
| CANCELLED_FLAG | VARCHAR2 | (1) | Cancelled Flag | |
| CANCELLED_DATE | DATE | Cancelled Date | ||
| SHIP_VIA | VARCHAR2 | (25) | Ship Via (Int) | |
| SHIP_VIA_EXT1 | VARCHAR2 | (80) | Ship Via 1 (Ext) | |
| SHIP_VIA_EXT2 | VARCHAR2 | (80) | Ship Via 2 (Ext) | |
| SHIP_VIA_EXT3 | VARCHAR2 | (80) | Ship Via 3 (Ext) | |
| FOB_CODE | VARCHAR2 | (25) | FOB Code (Int) | |
| FOB_CODE_EXT1 | VARCHAR2 | (80) | FOB Code 1 (Ext) | |
| FREIGHT_TERMS | VARCHAR2 | (25) | Freight Terms (Int) | |
| FREIGHT_TERMS_EXT1 | VARCHAR2 | (80) | Freight Terms 1 (Ext) | |
| TAXABLE_FLAG | VARCHAR2 | (1) | Taxable Flag | |
| SHIPMENT_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Shipment Attribute Category | |
| SHIPMENT_ATTRIBUTE1 | VARCHAR2 | (150) | Shipment Attribute 1 | |
| SHIPMENT_ATTRIBUTE2 | VARCHAR2 | (150) | Shipment Attribute 2 | |
| SHIPMENT_ATTRIBUTE3 | VARCHAR2 | (150) | Shipment Attribute 3 | |
| SHIPMENT_ATTRIBUTE4 | VARCHAR2 | (150) | Shipment Attribute 4 | |
| SHIPMENT_ATTRIBUTE5 | VARCHAR2 | (150) | Shipment Attribute 5 | |
| SHIPMENT_ATTRIBUTE6 | VARCHAR2 | (150) | Shipment Attribute 6 | |
| SHIPMENT_ATTRIBUTE7 | VARCHAR2 | (150) | Shipment Attribute 7 | |
| SHIPMENT_ATTRIBUTE8 | VARCHAR2 | (150) | Shipment Attribute 8 | |
| SHIPMENT_ATTRIBUTE9 | VARCHAR2 | (150) | Shipment Attribute 9 | |
| SHIPMENT_ATTRIBUTE10 | VARCHAR2 | (150) | Shipment Attribute 10 | |
| SHIPMENT_ATTRIBUTE11 | VARCHAR2 | (150) | Shipment Attribute 11 | |
| SHIPMENT_ATTRIBUTE12 | VARCHAR2 | (150) | Shipment Attribute 12 | |
| SHIPMENT_ATTRIBUTE13 | VARCHAR2 | (150) | Shipment Attribute 13 | |
| SHIPMENT_ATTRIBUTE14 | VARCHAR2 | (150) | Shipment Attribute 14 | |
| SHIPMENT_ATTRIBUTE15 | VARCHAR2 | (150) | Shipment Attribute 15 | |
| SHIP_TO_LOCATION_CODE | VARCHAR2 | (60) | Ship To Location Code | |
| SHIP_TO_ENTITY_EXT1 | VARCHAR2 | (80) | Ship To Entity Code (Ext) | |
| SHIP_TO_SITE_NAME | VARCHAR2 | (240) | Ship To Name | |
| SHIP_TO_ADDRESS_LINE_1 | VARCHAR2 | (240) | Ship To Address Line 1 | |
| SHIP_TO_ADDRESS_LINE_2 | VARCHAR2 | (240) | Ship To Address Line 2 | |
| SHIP_TO_ADDRESS_LINE_3 | VARCHAR2 | (240) | Ship To Address Line 3 | |
| SHIP_TO_ADDRESS_LINE_4 | VARCHAR2 | (240) | Ship To Address Line 4 | |
| SHIP_TO_CITY | VARCHAR2 | (30) | Ship To City | |
| SHIP_TO_POSTAL_CODE | VARCHAR2 | (30) | Ship To Postal Code | |
| SHIP_TO_COUNTRY | VARCHAR2 | (60) | Ship To Country | |
| SHIP_TO_COUNTRY_EXT1 | VARCHAR2 | (80) | Ship To Country 1 (Ext) | |
| SHIP_TO_REGION1 | VARCHAR2 | (120) | Ship To Region 1 (Int) | |
| SHIP_TO_REGION1_EXT1 | VARCHAR2 | (80) | Ship To Region 1-1 (Ext) | |
| SHIP_TO_REGION2 | VARCHAR2 | (120) | Ship To Region 2 (Int) | |
| SHIP_TO_REGION2_EXT1 | VARCHAR2 | (80) | Ship To Region 2-1 (Ext) | |
| SHIP_TO_REGION3 | VARCHAR2 | (120) | Ship To Region 3 (Int) | |
| SHIP_TO_REGION3_EXT1 | VARCHAR2 | (80) | Ship To Region 3-1 (Ext) | |
| SHIP_TO_CONTACT_LAST_NAME | VARCHAR2 | (150) | Ship To Contact Last Name | |
| SHIP_TO_CONTACT_FIRST_NAME | VARCHAR2 | (150) | Ship To Contact First Name | |
| SHIP_TO_CONTACT_JOB_TITLE | VARCHAR2 | (30) | Ship To Contact Job Title | |
| SHIP_TO_PHONE1_AREA_CODE | VARCHAR2 | (10) | Ship To Contact Area Code 1 | |
| SHIP_TO_PHONE1 | VARCHAR2 | (60) | Ship To Phone 1 | |
| SHIP_TO_PHONE2_AREA_CODE | VARCHAR2 | (10) | Ship To Contact Area Code 2 | |
| SHIP_TO_PHONE2 | VARCHAR2 | (60) | Ship To Phone 2 | |
| SHIP_TO_PHONE3_AREA_CODE | VARCHAR2 | (10) | Ship To Contact Area Code 3 | |
| SHIP_TO_PHONE3 | VARCHAR2 | (60) | Ship To Phone 3 | |
| PO_HEADER_ID | NUMBER | PO Header ID | ||
| PO_RELEASE_ID | NUMBER | |||
| PO_LINE_ID | NUMBER | PO Line ID | ||
| LINE_LOCATION_ID | NUMBER | Line Location ID | ||
| RUN_ID | NUMBER | Run ID | ||
| TRANSACTION_RECORD_ID | NUMBER | Unique identifier which links the transaction base table to its associated extension table. | ||
| CURRENCY_EXCHANGE_RATE | NUMBER | Currency Exchange Rate | ||
| TERM_DUE_PERCENT | NUMBER | Terms Due Percentage | ||
| TERM_DUE_DATE | DATE | Terms Due Date | ||
| TERM_DUE_DAYS | NUMBER | Terms Due Days | ||
| TERM_DUE_DAY_OF_MONTH | NUMBER | Terms Due Day of Month | ||
| TERM_DUE_CUTOFF_DAY | NUMBER | Terms Due Cutoff Day | ||
| TERM_DUE_MONTHS_FORWARD | NUMBER | Terms Due Months Forward | ||
| DISCOUNT_PERCENT1 | NUMBER | Discount Percentage 1 | ||
| DISCOUNT_DAYS1 | NUMBER | Discount Days 1 | ||
| DISCOUNT_DATE1 | DATE | Discount Date 1 | ||
| DISCOUNT_DAY_OF_MONTH1 | NUMBER | Discount Day of Month 1 | ||
| DISCOUNT_MONTHS_FORWARD1 | NUMBER | Discount Months Forward 1 | ||
| DISCOUNT_PERCENT2 | NUMBER | Discount Percentage 2 | ||
| DISCOUNT_DAYS2 | NUMBER | Discount Days 2 | ||
| DISCOUNT_DATE2 | DATE | Discount Date 2 | ||
| DISCOUNT_DAY_OF_MONTH2 | NUMBER | Discount Day of Month 2 | ||
| DISCOUNT_MONTHS_FORWARD2 | NUMBER | Discount Months Forward 2 | ||
| PAYMENT_TERMS | VARCHAR2 | (50) | Payment Terms | |
| DELIVER_TO_CONTACT_LAST_NAME | VARCHAR2 | (40) | Deliver To Contact Last Name | |
| DELIVER_TO_CONTACT_FIRST_NAME | VARCHAR2 | (20) | Deliver To Contact First Name | |
| DELIVER_TO_CONTACT_MIDDLE_NAME | VARCHAR2 | (60) | Deliver To Contact Middle Name | |
| DELIVER_TO_CONTACT_TITLE | VARCHAR2 | (30) | Deliver To Contact Title | |
| UOM_CODE_EXT2 | VARCHAR2 | (80) | Unit of Measure Code 2 (Ext) | |
| UOM_CODE_EXT3 | VARCHAR2 | (80) | Unit of Measure Code 3 (Ext) | |
| UOM_CODE_EXT4 | VARCHAR2 | (80) | Unit of Measure Code 4 (Ext) | |
| UOM_CODE_EXT5 | VARCHAR2 | (80) | Unit of Measure Code 5 (Ext) | |
| SHIP_VIA_EXT4 | VARCHAR2 | (80) | Ship Via 4 (Ext) | |
| SHIP_VIA_EXT5 | VARCHAR2 | (80) | Ship Via 5 (Ext) | |
| FOB_CODE_EXT2 | VARCHAR2 | (80) | FOB Code 2 (Ext) | |
| FOB_CODE_EXT3 | VARCHAR2 | (80) | FOB Code 3 (Ext) | |
| FOB_CODE_EXT4 | VARCHAR2 | (80) | FOB Code 4 (Ext) | |
| FOB_CODE_EXT5 | VARCHAR2 | (80) | FOB Code 5 (Ext) | |
| FREIGHT_TERMS_EXT2 | VARCHAR2 | (80) | Freight Terms 2 (Ext) | |
| FREIGHT_TERMS_EXT3 | VARCHAR2 | (80) | Freight Terms 3 (Ext) | |
| FREIGHT_TERMS_EXT4 | VARCHAR2 | (80) | Freight Terms 4 (Ext) | |
| FREIGHT_TERMS_EXT5 | VARCHAR2 | (80) | Freight Terms 5 (Ext) | |
| SHIP_TO_COUNTRY_EXT2 | VARCHAR2 | (80) | Ship To Country 2 (Ext) | |
| SHIP_TO_COUNTRY_EXT3 | VARCHAR2 | (80) | Ship To Country 3 (Ext) | |
| SHIP_TO_COUNTRY_EXT4 | VARCHAR2 | (80) | Ship To Country 4 (Ext) | |
| SHIP_TO_COUNTRY_EXT5 | VARCHAR2 | (80) | Ship To Country 5 (Ext) | |
| SHIP_TO_REGION1_EXT2 | VARCHAR2 | (80) | Ship To Region 1-2 (Ext) | |
| SHIP_TO_REGION1_EXT3 | VARCHAR2 | (80) | Ship To Region 1-3 (Ext) | |
| SHIP_TO_REGION1_EXT4 | VARCHAR2 | (80) | Ship To Region 1-4 (Ext) | |
| SHIP_TO_REGION1_EXT5 | VARCHAR2 | (80) | Ship To Region 1-5 (Ext) | |
| SHIP_TO_REGION2_EXT2 | VARCHAR2 | (80) | Ship To Region 2-2 (Ext) | |
| SHIP_TO_REGION2_EXT3 | VARCHAR2 | (80) | Ship To Region 2-3 (Ext) | |
| SHIP_TO_REGION2_EXT4 | VARCHAR2 | (80) | Ship To Region 2-4 (Ext) | |
| SHIP_TO_REGION2_EXT5 | VARCHAR2 | (80) | Ship To Region 2-5 (Ext) | |
| SHIP_TO_REGION3_EXT2 | VARCHAR2 | (80) | Ship To Region 3-2 (Ext) | |
| SHIP_TO_REGION3_EXT3 | VARCHAR2 | (80) | Ship To Region 3-3 (Ext) | |
| SHIP_TO_REGION3_EXT4 | VARCHAR2 | (80) | Ship To Region 3-4 (Ext) | |
| SHIP_TO_REGION3_EXT5 | VARCHAR2 | (1) | Ship To Region 3-5 (Ext) | |
| DISCOUNT_PERCENT3 | NUMBER | Discount Percentage 3 | ||
| DISCOUNT_DAYS3 | NUMBER | Discount Days 3 | ||
| DISCOUNT_DATE3 | DATE | Discount Date 3 | ||
| DISCOUNT_DAY_OF_MONTH3 | NUMBER | Discount Day of Month 3 | ||
| DISCOUNT_MONTHS_FORWARD3 | NUMBER | Discount Months Forward 3 | ||
| PO_NUMBER | VARCHAR2 | (20) | PO Number | |
| LINE_NUMBER | NUMBER | Line Number | ||
| DISTRIBUTION_NUMBER | NUMBER | Distribution Number | ||
| RELEASE_NUMBER | NUMBER | PO Release Number | ||
| PO_TYPE | VARCHAR2 | (25) | Type of PO | |
| TRANSACTION_TYPE | VARCHAR2 | (3) | Transaction Type | |
| COMMUNICATION_METHOD | VARCHAR2 | (30) | Communications Method | |
| CREATION_DATE | DATE | Standard Who column | ||
| CREATED_BY | NUMBER | (15) | Standard Who column | |
| LAST_UPDATE_DATE | DATE | Standard Who column | ||
| LAST_UPDATED_BY | NUMBER | (15) | Standard Who column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
| REQUEST_ID | NUMBER | Standard Who column | ||
| PROGRAM_APPLICATION_ID | NUMBER | Standard Who column | ||
| PROGRAM_ID | NUMBER | Standard Who column | ||
| PROGRAM_UPDATE_DATE | DATE | Standard Who column | ||
| QUANTITY_PENDING | NUMBER | Quantity Pending | ||
| POR_RELEASE_ID | NUMBER | PO Release ID | ||
| SHIP_TO_LOCATION_CODE_INT | VARCHAR2 | (40) | Ship to Location Code (Internal) | |
| SHIP_TO_LOCATION_CODE_EXT1 | VARCHAR2 | (20) | Ship to Location Code (External 1) | |
| SHIP_TO_LOCATION_CODE_EXT2 | VARCHAR2 | (20) | Ship to Location Code (External 2) | |
| SHIP_TO_LOCATION_CODE_EXT3 | VARCHAR2 | (20) | Ship to Location Code (External 3) | |
| SHIP_TO_LOCATION_CODE_EXT4 | VARCHAR2 | (20) | Ship to Location Code (External 4) | |
| SHIP_TO_LOCATION_CODE_EXT5 | VARCHAR2 | (20) | Ship to Location Code (External 5) | |
| SHIP_TO_LOCATION_ID | NUMBER | (22) | Ship to Location ID | |
| START_DATE | DATE | START DATE | ||
| END_DATE | DATE | END_DATE | ||
| CONSIGNED_FLAG | VARCHAR2 | (1) | CONSIGNED_FLAG | |
| CONSIGNED_FLAG_EXT1 | VARCHAR2 | (1) | CONSIGNED_FLAG_EXT1 | |
| CONSIGNED_FLAG_EXT2 | VARCHAR2 | (1) | CONSIGNED_FLAG_EXT2 | |
| CONSIGNED_FLAG_EXT3 | VARCHAR2 | (1) | CONSIGNED_FLAG_EXT3 | |
| CONSIGNED_FLAG_EXT4 | VARCHAR2 | (1) | CONSIGNED_FLAG_EXT4 | |
| CONSIGNED_FLAG_EXT5 | VARCHAR2 | (1) | CONSIGNED_FLAG_EXT5 | |
| SHIP_TO_ORGANIZATION_NAME | VARCHAR2 | (240) | SHIP_TO_ORGANIZATION_NAME | |
| SHIP_TO_CUSTOMER_NAME | VARCHAR2 | (400) | SHIP_TO_CUSTOMER_NAME | |
| SHIP_TO_CONTACT_NAME | VARCHAR2 | (400) | SHIP_TO_CONTACT_NAME | |
| SHIP_TO_CONTACT_PHONE | VARCHAR2 | (200) | SHIP_TO_CONTACT_PHONE | |
| SHIP_TO_CONTACT_FAX | VARCHAR2 | (200) | SHIP_TO_CONTACT_FAX | |
| SHIP_TO_CONTACT_EMAIL | VARCHAR2 | (2000) | SHIP_TO_CONTACT_EMAIL | |
| SHIPPING_INSTRUCTIONS | VARCHAR2 | (2000) | SHIPPING_INSTRUCTIONS | |
| PACKING_INSTRUCTIONS | VARCHAR2 | (2000) | PACKING_INSTRUCTIONS | |
| SHIPPING_METHOD | VARCHAR2 | (200) | SHIPPING_METHOD | |
| CUSTOMER_PO_NUMBER | NUMBER | CUSTOMER_PO_NUMBER | ||
| CUSTOMER_PO_LINE_NUM | NUMBER | CUSTOMER_PO_LINE_NUM | ||
| CUSTOMER_PO_SHIPMENT_NUM | NUMBER | CUSTOMER_PO_SHIPMENT_NUM | ||
| CUSTOMER_ITEM_DESCRIPTION | VARCHAR2 | (1000) | CUSTOMER_ITEM_DESCRIPTION | |
| DELIVER_TO_LOCATION | VARCHAR2 | (2000) | DELIVER_TO_LOCATION | |
| DELIVER_TO_CUSTOMER_NAME | VARCHAR2 | (400) | DELIVER_TO_CUSTOMER_NAME | |
| DELIVER_TO_CONTACT_NAME | VARCHAR2 | (400) | DELIVER_TO_CONTACT_NAME | |
| DELIVER_TO_CONTACT_PHONE | VARCHAR2 | (200) | DELIVER_TO_CONTACT_PHONE | |
| DELIVER_TO_CONTACT_FAX | VARCHAR2 | (200) | DELIVER_TO_CONTACT_FAX | |
| DELIVER_TO_CUSTOMER_ADDRESS | VARCHAR2 | (2000) | DELIVER_TO_CUSTOMER_ADDRESS | |
| DELIVER_TO_CONTACT_EMAIL | VARCHAR2 | (2000) | DELIVER_TO_CONTACT_EMAIL |
Cut, paste (and edit) the following text to query this object:
SELECT SHIPMENT_NUMBER
, QUANTITY_ORIGINAL
, UOM_CODE
, UOM_CODE_EXT1
, SHIPMENT_NEED_BY_DATE
, SHIPMENT_PROMISED_DATE
, SHIPMENT_LAST_ACCEPTABLE_DATE
, QUANTITY
, QUANTITY_CANCELLED
, QUANTITY_DELIVERED
, PRICE_OVERRIDE
, CANCELLED_FLAG
, CANCELLED_DATE
, SHIP_VIA
, SHIP_VIA_EXT1
, SHIP_VIA_EXT2
, SHIP_VIA_EXT3
, FOB_CODE
, FOB_CODE_EXT1
, FREIGHT_TERMS
, FREIGHT_TERMS_EXT1
, TAXABLE_FLAG
, SHIPMENT_ATTRIBUTE_CATEGORY
, SHIPMENT_ATTRIBUTE1
, SHIPMENT_ATTRIBUTE2
, SHIPMENT_ATTRIBUTE3
, SHIPMENT_ATTRIBUTE4
, SHIPMENT_ATTRIBUTE5
, SHIPMENT_ATTRIBUTE6
, SHIPMENT_ATTRIBUTE7
, SHIPMENT_ATTRIBUTE8
, SHIPMENT_ATTRIBUTE9
, SHIPMENT_ATTRIBUTE10
, SHIPMENT_ATTRIBUTE11
, SHIPMENT_ATTRIBUTE12
, SHIPMENT_ATTRIBUTE13
, SHIPMENT_ATTRIBUTE14
, SHIPMENT_ATTRIBUTE15
, SHIP_TO_LOCATION_CODE
, SHIP_TO_ENTITY_EXT1
, SHIP_TO_SITE_NAME
, SHIP_TO_ADDRESS_LINE_1
, SHIP_TO_ADDRESS_LINE_2
, SHIP_TO_ADDRESS_LINE_3
, SHIP_TO_ADDRESS_LINE_4
, SHIP_TO_CITY
, SHIP_TO_POSTAL_CODE
, SHIP_TO_COUNTRY
, SHIP_TO_COUNTRY_EXT1
, SHIP_TO_REGION1
, SHIP_TO_REGION1_EXT1
, SHIP_TO_REGION2
, SHIP_TO_REGION2_EXT1
, SHIP_TO_REGION3
, SHIP_TO_REGION3_EXT1
, SHIP_TO_CONTACT_LAST_NAME
, SHIP_TO_CONTACT_FIRST_NAME
, SHIP_TO_CONTACT_JOB_TITLE
, SHIP_TO_PHONE1_AREA_CODE
, SHIP_TO_PHONE1
, SHIP_TO_PHONE2_AREA_CODE
, SHIP_TO_PHONE2
, SHIP_TO_PHONE3_AREA_CODE
, SHIP_TO_PHONE3
, PO_HEADER_ID
, PO_RELEASE_ID
, PO_LINE_ID
, LINE_LOCATION_ID
, RUN_ID
, TRANSACTION_RECORD_ID
, CURRENCY_EXCHANGE_RATE
, TERM_DUE_PERCENT
, TERM_DUE_DATE
, TERM_DUE_DAYS
, TERM_DUE_DAY_OF_MONTH
, TERM_DUE_CUTOFF_DAY
, TERM_DUE_MONTHS_FORWARD
, DISCOUNT_PERCENT1
, DISCOUNT_DAYS1
, DISCOUNT_DATE1
, DISCOUNT_DAY_OF_MONTH1
, DISCOUNT_MONTHS_FORWARD1
, DISCOUNT_PERCENT2
, DISCOUNT_DAYS2
, DISCOUNT_DATE2
, DISCOUNT_DAY_OF_MONTH2
, DISCOUNT_MONTHS_FORWARD2
, PAYMENT_TERMS
, DELIVER_TO_CONTACT_LAST_NAME
, DELIVER_TO_CONTACT_FIRST_NAME
, DELIVER_TO_CONTACT_MIDDLE_NAME
, DELIVER_TO_CONTACT_TITLE
, UOM_CODE_EXT2
, UOM_CODE_EXT3
, UOM_CODE_EXT4
, UOM_CODE_EXT5
, SHIP_VIA_EXT4
, SHIP_VIA_EXT5
, FOB_CODE_EXT2
, FOB_CODE_EXT3
, FOB_CODE_EXT4
, FOB_CODE_EXT5
, FREIGHT_TERMS_EXT2
, FREIGHT_TERMS_EXT3
, FREIGHT_TERMS_EXT4
, FREIGHT_TERMS_EXT5
, SHIP_TO_COUNTRY_EXT2
, SHIP_TO_COUNTRY_EXT3
, SHIP_TO_COUNTRY_EXT4
, SHIP_TO_COUNTRY_EXT5
, SHIP_TO_REGION1_EXT2
, SHIP_TO_REGION1_EXT3
, SHIP_TO_REGION1_EXT4
, SHIP_TO_REGION1_EXT5
, SHIP_TO_REGION2_EXT2
, SHIP_TO_REGION2_EXT3
, SHIP_TO_REGION2_EXT4
, SHIP_TO_REGION2_EXT5
, SHIP_TO_REGION3_EXT2
, SHIP_TO_REGION3_EXT3
, SHIP_TO_REGION3_EXT4
, SHIP_TO_REGION3_EXT5
, DISCOUNT_PERCENT3
, DISCOUNT_DAYS3
, DISCOUNT_DATE3
, DISCOUNT_DAY_OF_MONTH3
, DISCOUNT_MONTHS_FORWARD3
, PO_NUMBER
, LINE_NUMBER
, DISTRIBUTION_NUMBER
, RELEASE_NUMBER
, PO_TYPE
, TRANSACTION_TYPE
, COMMUNICATION_METHOD
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, QUANTITY_PENDING
, POR_RELEASE_ID
, SHIP_TO_LOCATION_CODE_INT
, SHIP_TO_LOCATION_CODE_EXT1
, SHIP_TO_LOCATION_CODE_EXT2
, SHIP_TO_LOCATION_CODE_EXT3
, SHIP_TO_LOCATION_CODE_EXT4
, SHIP_TO_LOCATION_CODE_EXT5
, SHIP_TO_LOCATION_ID
, START_DATE
, END_DATE
, CONSIGNED_FLAG
, CONSIGNED_FLAG_EXT1
, CONSIGNED_FLAG_EXT2
, CONSIGNED_FLAG_EXT3
, CONSIGNED_FLAG_EXT4
, CONSIGNED_FLAG_EXT5
, SHIP_TO_ORGANIZATION_NAME
, SHIP_TO_CUSTOMER_NAME
, SHIP_TO_CONTACT_NAME
, SHIP_TO_CONTACT_PHONE
, SHIP_TO_CONTACT_FAX
, SHIP_TO_CONTACT_EMAIL
, SHIPPING_INSTRUCTIONS
, PACKING_INSTRUCTIONS
, SHIPPING_METHOD
, CUSTOMER_PO_NUMBER
, CUSTOMER_PO_LINE_NUM
, CUSTOMER_PO_SHIPMENT_NUM
, CUSTOMER_ITEM_DESCRIPTION
, DELIVER_TO_LOCATION
, DELIVER_TO_CUSTOMER_NAME
, DELIVER_TO_CONTACT_NAME
, DELIVER_TO_CONTACT_PHONE
, DELIVER_TO_CONTACT_FAX
, DELIVER_TO_CUSTOMER_ADDRESS
, DELIVER_TO_CONTACT_EMAIL
FROM EC.ECE_PO_INTERFACE_SHIPMENTS;
EC.ECE_PO_INTERFACE_SHIPMENTS does not reference any database object
EC.ECE_PO_INTERFACE_SHIPMENTS is referenced by following:
APPS
ECE_PO_INTERFACE_SHIPMENTS
|
|
|
|