[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | ECE_PO_INTERFACE_HEADERS |
|---|---|
| Object Type: | TABLE |
| Owner: | EC |
| FND Design Data: |  EC.ECE_PO_INTERFACE_HEADERS
|
| Subobject Name: | |
| Status: | VALID |
ECE_PO_INTERFACE_HEADERS contains purchase order header data
to support the outbound Purchase Order (850/ORDERS) and Purchase Order
Change (860/ORDCHG) transactions.
Oracle e-Commerce Gateway supports Standard Purchase Orders, Planned
Purchase Orders, Blanket Agreements, and Blanket Releases. Oracle
e-Commerce Gateway does not support Quotations or Contracts via the
outbound Purchase Order or Purchase Order Change transactions although
these document types are supported by Oracle Purchasing.
ECE_PO_INTERFACE_HEADERS is based primarily on data stored in
PO_HEADERS (for standard purchase orders, blanket agreements, and
planned purchase orders) and PO_RELEASES (for blanket releases) in
Oracle Purchasing. ECE_PO_INTERFACE_HEADERS contains approved
purchase orders or purchase order changes that match the e-Commerce
Gateway users extract selection criteria.
Each row contains buyer, supplier, bill-to and ship-to data, brief
notes, foreign currency data, and terms and conditions for new and
changed orders. In addition, blanket release data is maintained for
blanket agreements and purchase order revision data is maintained for
changed purchase orders.
RUN_ID uniquely identifies the session that created the row in
ECE_PO_INTERFACE_HEADERS since this table is shared by two
transactions.
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_HEADERS is purged after the data is
written to the data file.
TRANSACTION_RECORD_ID is the unique key that links the
ECE_PO_INTERFACE_HEADERS table to its corresponding extension table
ECE_PO_INTERFACE_HEADERS_X.
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| ECE_PO_INTERFACE_HEADERS_U2 | NORMAL | UNIQUE |
APPS_TS_INTERFACE
|
 TRANSACTION_RECORD_ID
|
| ECE_PO_INTERFACE_HEADERS_N1 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
RUN_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| COMMUNICATION_METHOD | VARCHAR2 | (30) | Communication Method | |
| TP_TEST_FLAG | VARCHAR2 | (1) | Trading Partner Test Flag | |
| DOCUMENT_ID | VARCHAR2 | (6) | Document ID | |
| DOCUMENT_TYPE | VARCHAR2 | (10) | Document Type | |
| DOCUMENT_PURPOSE_CODE | VARCHAR2 | (2) | Document Purpose Code | |
| DOCUMENT_CODE | VARCHAR2 | (20) | Document Code | |
| TP_TRANSLATOR_CODE | VARCHAR2 | (30) | Trading Partner Translator Code | |
| TP_LOCATION_CODE_EXT | VARCHAR2 | (35) | Trading Partner Location Code | |
| TP_DESCRIPTION | VARCHAR2 | (240) | Trading Partner Description | |
| TP_REFERENCE_EXT1 | VARCHAR2 | (240) | Trading Partner Reference 1 (Ext) | |
| TP_REFERENCE_EXT2 | VARCHAR2 | (240) | Trading Partner Reference 2 (Ext) | |
| TRANSACTION_DATE | DATE | Transaction Date/Time | ||
| RUN_ID | NUMBER | Yes | Transaction Run ID | |
| TPH_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Trading Partner Header Attribute Category | |
| TPH_ATTRIBUTE1 | VARCHAR2 | (150) | Trading Partner Header Attribute 1 | |
| TPH_ATTRIBUTE2 | VARCHAR2 | (150) | Trading Partner Header Attribute 2 | |
| TPH_ATTRIBUTE3 | VARCHAR2 | (150) | Trading Partner Header Attribute 3 | |
| TPH_ATTRIBUTE4 | VARCHAR2 | (150) | Trading Partner Header Attribute 4 | |
| TPH_ATTRIBUTE5 | VARCHAR2 | (150) | Trading Partner Header Attribute 5 | |
| TPH_ATTRIBUTE6 | VARCHAR2 | (150) | Trading Partner Header Attribute 6 | |
| TPH_ATTRIBUTE7 | VARCHAR2 | (150) | Trading Partner Header Attribute 7 | |
| TPH_ATTRIBUTE8 | VARCHAR2 | (150) | Trading Partner Header Attribute 8 | |
| TPH_ATTRIBUTE9 | VARCHAR2 | (150) | Trading Partner Header Attribute 9 | |
| TPH_ATTRIBUTE10 | VARCHAR2 | (150) | Trading Partner Header Attribute 10 | |
| TPH_ATTRIBUTE11 | VARCHAR2 | (150) | Trading Partner Header Attribute 11 | |
| TPH_ATTRIBUTE12 | VARCHAR2 | (150) | Trading Partner Header Attribute 12 | |
| TPH_ATTRIBUTE13 | VARCHAR2 | (150) | Trading Partner Header Attribute 13 | |
| TPH_ATTRIBUTE14 | VARCHAR2 | (150) | Trading Partner Header Attribute 14 | |
| TPH_ATTRIBUTE15 | VARCHAR2 | (150) | Trading Partner Header Attribute 15 | |
| TPD_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Trading Partner Detail Attribute Category | |
| TPD_ATTRIBUTE1 | VARCHAR2 | (150) | Trading Partner Detail Attribute 1 | |
| TPD_ATTRIBUTE2 | VARCHAR2 | (150) | Trading Partner Detail Attribute 2 | |
| TPD_ATTRIBUTE3 | VARCHAR2 | (150) | Trading Partner Detail Attribute 3 | |
| TPD_ATTRIBUTE4 | VARCHAR2 | (150) | Trading Partner Detail Attribute 4 | |
| TPD_ATTRIBUTE5 | VARCHAR2 | (150) | Trading Partner Detail Attribute 5 | |
| PO_NUMBER | VARCHAR2 | (40) | PO Number | |
| RELEASE_NUMBER | NUMBER | Release Number | ||
| RELEASE_DATE | DATE | Release Date | ||
| CREATION_DATE | DATE | Creation Date | ||
| PO_REVISION_NUMBER | NUMBER | PO Revison Number | ||
| PO_REVISION_DATE | DATE | PO Revision Date | ||
| RELEASE_REVISION_NUMBER | NUMBER | Release Revision Number | ||
| RELEASE_REVISION_DATE | VARCHAR2 | (25) | Release Revision Date | |
| PO_DESCRIPTION | VARCHAR2 | (240) | PO Description | |
| PO_TYPE | VARCHAR2 | (10) | PO Type | |
| PAYMENT_TERM | VARCHAR2 | (50) | Payment Terms (Int) | |
| PAYMENT_TERM_EXT1 | VARCHAR2 | (80) | Payment Terms 1 (Ext) | |
| PAYMENT_TERM_EXT2 | VARCHAR2 | (80) | Payment Terms 2 (Ext) | |
| PAYMENT_TERM_EXT3 | VARCHAR2 | (80) | Payment Terms 3 (Ext) | |
| PAYMENT_TERM_EXT4 | VARCHAR2 | (80) | Payment Terms 4 (Ext) | |
| PAYMENT_TERM_EXT5 | VARCHAR2 | (80) | Payment Terms 5 (Ext) | |
| PO_CURRENCY_CODE | VARCHAR2 | (15) | PO Currency Code (Int) | |
| PO_CURRENCY_CODE_EXT1 | VARCHAR2 | (80) | PO Currency Code 1 (Ext) | |
| CURRENCY_EXCHANGE_RATE | NUMBER | Currency Exchange Rate | ||
| PO_SHIP_VIA | VARCHAR2 | (25) | PO Ship Via (Int) | |
| PO_SHIP_VIA_EXT1 | VARCHAR2 | (80) | PO Ship Via 1 (Ext) | |
| PO_SHIP_VIA_EXT2 | VARCHAR2 | (80) | PO Ship Via 2 (Ext) | |
| PO_SHIP_VIA_EXT3 | VARCHAR2 | (80) | PO Ship Via 3 (Ext) | |
| PO_FOB_CODE | VARCHAR2 | (25) | PO FOB Code (Int) | |
| PO_FOB_CODE_EXT1 | VARCHAR2 | (80) | PO FOB Code 1 (Ext) | |
| PO_FREIGHT_TERMS | VARCHAR2 | (25) | PO Freight Terms (Int) | |
| PO_FREIGHT_TERMS_EXT1 | VARCHAR2 | (80) | PO Freight Terms 1 (Ext) | |
| PO_CANCELLED_FLAG | VARCHAR2 | (1) | PO Cancelled Flag | |
| PO_ACCEPTANCE_REQUIRED_FLAG | VARCHAR2 | (1) | PO Acceptance Required Flag | |
| PO_ACCEPTANCE_DUE_BY_DATE | DATE | PO Acceptance Due By Date | ||
| PO_CONFIRMING_ORDER_FLAG | VARCHAR2 | (1) | PO Confirming Order Flag | |
| BLANKET_START_DATE | DATE | Blanket Start Date | ||
| BLANKET_END_DATE | DATE | Blanket End Date | ||
| BLANKET_TOTAL_AMOUNT | NUMBER | Blanket Total Amount | ||
| SUPPLIER_NUMBER | VARCHAR2 | (30) | Supplier Number | |
| SUPPLIER_NAME | VARCHAR2 | (80) | Supplier Name | |
| PO_NOTES_TO_VENDOR | VARCHAR2 | (480) | PO Notes to Supplier | |
| PO_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | PO Attribute Category | |
| PO_ATTRIBUTE1 | VARCHAR2 | (150) | PO Attribute 1 | |
| PO_ATTRIBUTE2 | VARCHAR2 | (150) | PO Attribute 2 | |
| PO_ATTRIBUTE3 | VARCHAR2 | (150) | PO Attribute 3 | |
| PO_ATTRIBUTE4 | VARCHAR2 | (150) | PO Attribute 4 | |
| PO_ATTRIBUTE5 | VARCHAR2 | (150) | PO Attribute 5 | |
| PO_ATTRIBUTE6 | VARCHAR2 | (150) | PO Attribute 6 | |
| PO_ATTRIBUTE7 | VARCHAR2 | (150) | PO Attribute 7 | |
| PO_ATTRIBUTE8 | VARCHAR2 | (150) | PO Attribute 8 | |
| PO_ATTRIBUTE9 | VARCHAR2 | (150) | PO Attribute 9 | |
| PO_ATTRIBUTE10 | VARCHAR2 | (150) | PO Attribute 10 | |
| PO_ATTRIBUTE11 | VARCHAR2 | (150) | PO Attribute 11 | |
| PO_ATTRIBUTE12 | VARCHAR2 | (150) | PO Attribute 12 | |
| PO_ATTRIBUTE13 | VARCHAR2 | (150) | PO Attribute 13 | |
| PO_ATTRIBUTE14 | VARCHAR2 | (150) | PO Attribute 14 | |
| PO_ATTRIBUTE15 | VARCHAR2 | (150) | PO Attribute 15 | |
| VENDOR_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Supplier Attribute Category | |
| VENDOR_ATTRIBUTE1 | VARCHAR2 | (150) | Supplier Attribute 1 | |
| VENDOR_ATTRIBUTE2 | VARCHAR2 | (150) | Supplier Attribute 2 | |
| VENDOR_ATTRIBUTE3 | VARCHAR2 | (150) | Supplier Attribute 3 | |
| VENDOR_ATTRIBUTE4 | VARCHAR2 | (150) | Supplier Attribute 4 | |
| VENDOR_ATTRIBUTE5 | VARCHAR2 | (150) | Supplier Attribute 5 | |
| VENDOR_ATTRIBUTE6 | VARCHAR2 | (150) | Supplier Attribute 6 | |
| VENDOR_ATTRIBUTE7 | VARCHAR2 | (150) | Supplier Attribute 7 | |
| VENDOR_ATTRIBUTE8 | VARCHAR2 | (150) | Supplier Attribute 8 | |
| VENDOR_ATTRIBUTE9 | VARCHAR2 | (150) | Supplier Attribute 9 | |
| VENDOR_ATTRIBUTE10 | VARCHAR2 | (150) | Supplier Attribute 10 | |
| VENDOR_ATTRIBUTE11 | VARCHAR2 | (150) | Supplier Attribute 11 | |
| VENDOR_ATTRIBUTE12 | VARCHAR2 | (150) | Supplier Attribute 12 | |
| VENDOR_ATTRIBUTE13 | VARCHAR2 | (150) | Supplier Attribute 13 | |
| VENDOR_ATTRIBUTE14 | VARCHAR2 | (150) | Supplier Attribute 14 | |
| VENDOR_ATTRIBUTE15 | VARCHAR2 | (150) | Supplier Attribute 15 | |
| VENDOR_SITE_ATTRIB_CATEGORY | VARCHAR2 | (30) | Supplier Site Attribute Category | |
| VENDOR_SITE_ATTRIBUTE1 | VARCHAR2 | (150) | Supplier Site Attribute 1 | |
| VENDOR_SITE_ATTRIBUTE2 | VARCHAR2 | (150) | Supplier Site Attribute 2 | |
| VENDOR_SITE_ATTRIBUTE3 | VARCHAR2 | (150) | Supplier Site Attribute 3 | |
| VENDOR_SITE_ATTRIBUTE4 | VARCHAR2 | (150) | Supplier Site Attribute 4 | |
| VENDOR_SITE_ATTRIBUTE5 | VARCHAR2 | (150) | Supplier Site Attribute 5 | |
| VENDOR_SITE_ATTRIBUTE6 | VARCHAR2 | (150) | Supplier Site Attribute 6 | |
| VENDOR_SITE_ATTRIBUTE7 | VARCHAR2 | (150) | Supplier Site Attribute 7 | |
| VENDOR_SITE_ATTRIBUTE8 | VARCHAR2 | (150) | Supplier Site Attribute 8 | |
| VENDOR_SITE_ATTRIBUTE9 | VARCHAR2 | (150) | Supplier Site Attribute 9 | |
| VENDOR_SITE_ATTRIBUTE10 | VARCHAR2 | (150) | Supplier Site Attribute 10 | |
| VENDOR_SITE_ATTRIBUTE11 | VARCHAR2 | (150) | Supplier Site Attribute 11 | |
| VENDOR_SITE_ATTRIBUTE12 | VARCHAR2 | (150) | Supplier Site Attribute 12 | |
| VENDOR_SITE_ATTRIBUTE13 | VARCHAR2 | (150) | Supplier Site Attribute 13 | |
| VENDOR_SITE_ATTRIBUTE14 | VARCHAR2 | (150) | Supplier Site Attribute 14 | |
| VENDOR_SITE_ATTRIBUTE15 | VARCHAR2 | (150) | Supplier Site Attribute 15 | |
| VENDOR_CUSTOMER_NUMBER | VARCHAR2 | (25) | Supplier Customer Number | |
| VENDOR_SITE_ENTITY | NUMBER | |||
| VENDOR_SITE_ENTITY_EXT1 | VARCHAR2 | (80) | ||
| VENDOR_SITE_NAME | VARCHAR2 | (240) | Supplier Name | |
| VENDOR_SITE_ADDR_LINE_1 | VARCHAR2 | (240) | Supplier Site Address Line 1 | |
| VENDOR_SITE_ADDR_LINE_2 | VARCHAR2 | (240) | Supplier Site Address Line 2 | |
| VENDOR_SITE_ADDR_LINE_3 | VARCHAR2 | (240) | Supplier Site Address Line 3 | |
| VENDOR_SITE_ADDR_LINE_4 | VARCHAR2 | (240) | Supplier Site Address Line 4 | |
| VENDOR_SITE_CITY | VARCHAR2 | (25) | Supplier Site City | |
| VENDOR_SITE_ZIP | VARCHAR2 | (20) | Supplier Site Zip | |
| VENDOR_SITE_COUNTRY | VARCHAR2 | (150) | Supplier Site Country (Int) | |
| VENDOR_SITE_COUNTRY_EXT1 | VARCHAR2 | (80) | Supplier Site Country (Ext) | |
| VENDOR_SITE_STATE | VARCHAR2 | (150) | Supplier Site State (Int) | |
| VENDOR_SITE_STATE_EXT1 | VARCHAR2 | (80) | Supplier Site State (Ext) | |
| VENDOR_SITE_PROVINCE | VARCHAR2 | (150) | Supplier Site Province (Int) | |
| VENDOR_SITE_PROVINCE_EXT1 | VARCHAR2 | (80) | Supplier Site Province (Ext) | |
| VENDOR_SITE_CONTACT_LAST_NAME | VARCHAR2 | (50) | Supplier Site Contact Last Name | |
| VENDOR_SITE_CONTACT_FIRST_NAME | VARCHAR2 | (50) | Supplier Site Contact First Name | |
| VENDOR_SITE_AREA_CODE | VARCHAR2 | (10) | Supplier Site Area Code | |
| VENDOR_SITE_PHONE | VARCHAR2 | (15) | Supplier Site Phone | |
| VENDOR_SITE_FAX_AREA_CODE | VARCHAR2 | (10) | Supplier Site Fax Area Code | |
| VENDOR_SITE_FAX | VARCHAR2 | (15) | Supplier Site Fax | |
| VENDOR_SITE_TELEX_AREA_CODE | VARCHAR2 | (10) | Supplier Site Telex Area Code | |
| VENDOR_SITE_TELEX | VARCHAR2 | (15) | Supplier Site Telex | |
| VENDOR_CONTACT_LAST_NAME | VARCHAR2 | (20) | Supplier Contact Last Name | |
| VENDOR_CONTACT_FIRST_NAME | VARCHAR2 | (15) | Supplier Contact First Name | |
| VENDOR_CONTACT_AREA_CODE | VARCHAR2 | (10) | Supplier Contact Area Code | |
| VENDOR_CONTACT_PHONE | VARCHAR2 | (15) | Supplier Contact Phone | |
| SHIP_TO_LOCATION_CODE | VARCHAR2 | (60) | Ship To Location Code (Int) | |
| SHIP_TO_ENTITY_EXT1 | VARCHAR2 | (80) | Ship To Location 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 (Int) | |
| SHIP_TO_COUNTRY_EXT1 | VARCHAR2 | (80) | Ship To Country (Ext) | |
| SHIP_TO_REGION1 | VARCHAR2 | (120) | Ship To Region 1 (Int) | |
| SHIP_TO_REGION1_EXT1 | VARCHAR2 | (80) | Ship To Region 1 (Ext) | |
| SHIP_TO_REGION2 | VARCHAR2 | (120) | Ship To Region 2 (Int) | |
| SHIP_TO_REGION2_EXT1 | VARCHAR2 | (80) | Ship To Region 2 (Ext) | |
| SHIP_TO_REGION3 | VARCHAR2 | (120) | Ship To Region 3 (Int) | |
| SHIP_TO_REGION3_EXT1 | VARCHAR2 | (80) | Ship To Region 3 (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_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 | |
| BILL_TO_LOCATION_CODE | VARCHAR2 | (60) | Bill To Location Code (Int) | |
| BILL_TO_ENTITY_EXT1 | VARCHAR2 | (20) | Bill To Location Code (Ext) | |
| BILL_TO_SITE_NAME | VARCHAR2 | (240) | Bill To Name | |
| BILL_TO_ADDRESS_LINE_1 | VARCHAR2 | (240) | Bill To Address Line 1 | |
| BILL_TO_ADDRESS_LINE_2 | VARCHAR2 | (240) | Bill To Address Line 2 | |
| BILL_TO_ADDRESS_LINE_3 | VARCHAR2 | (240) | Bill To Address Line 3 | |
| BILL_TO_ADDRESS_LINE_4 | VARCHAR2 | (240) | Bill To Address Line 4 | |
| BILL_TO_CITY | VARCHAR2 | (60) | Bill To City | |
| BILL_TO_POSTAL_CODE | VARCHAR2 | (30) | Bill To Postal Code | |
| BILL_TO_COUNTRY | VARCHAR2 | (60) | Bill To Country (Int) | |
| BILL_TO_COUNTRY_EXT1 | VARCHAR2 | (80) | Bill To Country (Ext) | |
| BILL_TO_REGION1 | VARCHAR2 | (120) | Bill To Region 1 (Int) | |
| BILL_TO_REGION1_EXT1 | VARCHAR2 | (80) | Bill To Region 1 (Ext) | |
| BILL_TO_REGION2 | VARCHAR2 | (120) | Bill To Region 2 (Int) | |
| BILL_TO_REGION2_EXT1 | VARCHAR2 | (80) | Bill To Region 2 (Ext) | |
| BILL_TO_REGION3 | VARCHAR2 | (120) | Bill To Region 3 (Int) | |
| BILL_TO_REGION3_EXT1 | VARCHAR2 | (80) | Bill To Region 3 (Ext) | |
| BILL_TO_CONTACT_LAST_NAME | VARCHAR2 | (150) | Bill To Contact Last Name | |
| BILL_TO_CONTACT_FIRST_NAME | VARCHAR2 | (150) | Bill To Contact First Name | |
| BILL_TO_PHONE1_AREA_CODE | VARCHAR2 | (10) | Bill To Contact Area Code 1 | |
| BILL_TO_PHONE1 | VARCHAR2 | (60) | Bill To Phone 1 | |
| BILL_TO_PHONE2_AREA_CODE | VARCHAR2 | (10) | Bill To Contact Area Code 2 | |
| BILL_TO_PHONE2 | VARCHAR2 | (60) | Bill To Phone 2 | |
| BILL_TO_PHONE3_AREA_CODE | VARCHAR2 | (10) | Bill To Contact Area Code 3 | |
| BILL_TO_PHONE3 | VARCHAR2 | (60) | Bill To Phone 3 | |
| PO_BUYER_LAST_NAME | VARCHAR2 | (150) | PO Buyer Last Name | |
| PO_BUYER_FIRST_NAME | VARCHAR2 | (150) | PO Buyer First Name | |
| PO_HEADER_ID | NUMBER | PO Header ID | ||
| PO_RELEASE_ID | NUMBER | PO Release ID | ||
| TRANSACTION_RECORD_ID | NUMBER | Unique identifier which links the transaction base table to its associated extension table. | ||
| PO_CURRENCY_CODE_EXT2 | VARCHAR2 | (80) | PO Currency Code 2 (Ext) | |
| PO_CURRENCY_CODE_EXT3 | VARCHAR2 | (80) | PO Currency Code 3 (Ext) | |
| PO_CURRENCY_CODE_EXT4 | VARCHAR2 | (80) | PO Currency Code 4 (Ext) | |
| PO_CURRENCY_CODE_EXT5 | VARCHAR2 | (80) | PO Currency Code 5 (Ext) | |
| PO_SHIP_VIA_EXT4 | VARCHAR2 | (80) | PO Ship Via 4 (Ext) | |
| PO_SHIP_VIA_EXT5 | VARCHAR2 | (80) | PO Ship Via 5 (Ext) | |
| PO_FOB_CODE_EXT2 | VARCHAR2 | (80) | PO FOB Code 2 (Ext) | |
| PO_FOB_CODE_EXT3 | VARCHAR2 | (80) | PO FOB Code 3 (Ext) | |
| PO_FOB_CODE_EXT4 | VARCHAR2 | (80) | PO FOB Code 4 (Ext) | |
| PO_FOB_CODE_EXT5 | VARCHAR2 | (80) | PO FOB Code 5 (Ext) | |
| PO_FREIGHT_TERMS_EXT2 | VARCHAR2 | (80) | PO Freight Terms 2 (Ext) | |
| PO_FREIGHT_TERMS_EXT3 | VARCHAR2 | (80) | PO Freight Terms 3 (Ext) | |
| PO_FREIGHT_TERMS_EXT4 | VARCHAR2 | (80) | PO Freight Terms 4 (Ext) | |
| PO_FREIGHT_TERMS_EXT5 | VARCHAR2 | (80) | PO Freight Terms 5 (Ext) | |
| 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 | ||
| PO_BUYER_EMAIL_ADDRESS | VARCHAR2 | (240) | PO Buyer E-Mail Address | |
| PO_BUYER_WORK_TELEPHONE | VARCHAR2 | (60) | PO Buyer Work Phone | |
| PO_BUYER_MISC_TELEPHONE1 | VARCHAR2 | (60) | PO Buyer Misc Phone 1 | |
| PO_BUYER_MISC_TELEPHONE2 | VARCHAR2 | (60) | PO Buyer Misc Phone 2 | |
| PO_BUYER_MISC_TELEPHONE3 | VARCHAR2 | (60) | PO Buyer Misc Phone 3 | |
| PO_CANCELLED_DATE | DATE | PO Cancelled Date | ||
| DOCUMENT_STANDARD | VARCHAR2 | (240) | EDI Document Standard | |
| PCARDMEMBER_NAME | VARCHAR2 | (80) | Procurement Card Member Name | |
| PCARD_NUMBER | VARCHAR2 | (80) | Procurement Card Number | |
| PCARD_EXPIRATION_DATE | DATE | Procurement Card Expiration Date | ||
| PCARD_BRAND | VARCHAR2 | (80) | Procurement Card Brand | |
| PCARD_BRAND_EXT1 | VARCHAR2 | (80) | Procurement Card Brand 1 (Ext) | |
| PCARD_BRAND_EXT2 | VARCHAR2 | (80) | Procurement Card Brand 2 (Ext) | |
| PCARD_BRAND_EXT3 | VARCHAR2 | (80) | Procurement Card Brand 3 (Ext) | |
| PCARD_BRAND_EXT4 | VARCHAR2 | (80) | Procurement Card Brand 4 (Ext) | |
| PCARD_BRAND_EXT5 | VARCHAR2 | (80) | Procurement Card Brand 5 (Ext) | |
| MAP_ID | NUMBER | Map ID | ||
| SUPPLIER_SITE_CODE | VARCHAR2 | (15) | Vendor Site code | |
| VS_EDI_LOCATION_CODE_INT | VARCHAR2 | (35) | EDI Location Code (Internal) | |
| VS_EDI_LOCATION_CODE_EXT1 | VARCHAR2 | (35) | EDI Location Code (External 1) | |
| VS_EDI_LOCATION_CODE_EXT2 | VARCHAR2 | (35) | EDI Location code (External2) | |
| VS_EDI_LOCATION_CODE_EXT3 | VARCHAR2 | (35) | EDI Location Code (External 3) | |
| VS_EDI_LOCATION_CODE_EXT4 | VARCHAR2 | (35) | EDI Location Code (External 4) | |
| VS_EDI_LOCATION_CODE_EXT5 | VARCHAR2 | (35) | EDI Location Code (External 5) | |
| VENDOR_SITE_ID | NUMBER | (22) | Vendor ID | |
| SHIP_TO_LOCATION_CODE_INT | VARCHAR2 | (35) | Ship to Location Code (Internal) | |
| SHIP_TO_LOCATION_CODE_EXT1 | VARCHAR2 | (35) | Ship to Location Code (External 1) | |
| SHIP_TO_LOCATION_CODE_EXT2 | VARCHAR2 | (35) | Ship to Location code (external 2) | |
| SHIP_TO_LOCATION_CODE_EXT3 | VARCHAR2 | (35) | Ship to Location Code (External 3) | |
| SHIP_TO_LOCATION_CODE_EXT4 | VARCHAR2 | (35) | Ship to Location Code (External 4) | |
| SHIP_TO_LOCATION_CODE_EXT5 | VARCHAR2 | (35) | Ship to Location Code (External 5) | |
| BILL_TO_LOCATION_CODE_INT | VARCHAR2 | (35) | Bill to Location Code (Internal) | |
| BILL_TO_LOCATION_CODE_EXT1 | VARCHAR2 | (35) | Bill to Location code (External 1) | |
| BILL_TO_LOCATION_CODE_EXT2 | VARCHAR2 | (35) | Bill to Location Code (Externa 2) | |
| BILL_TO_LOCATION_CODE_EXT3 | VARCHAR2 | (35) | Bill to Location Code (External 3) | |
| BILL_TO_LOCATION_CODE_EXT4 | VARCHAR2 | (35) | Bill to Location Code (External 5) | |
| BILL_TO_LOCATION_CODE_EXT5 | VARCHAR2 | (35) | Bill to Location Code (External 5) | |
| ORG_ID | VARCHAR2 | (30) | ORG ID | |
| BILL_TO_REGION1_EXT2 | VARCHAR2 | (80) | Bill to Region 1 (External 2) | |
| BILL_TO_REGION1_EXT3 | VARCHAR2 | (80) | Bill to Region1 (External 3) | |
| BILL_TO_REGION1_EXT4 | VARCHAR2 | (80) | Bill to region 1(External 4) | |
| BILL_TO_REGION1_EXT5 | VARCHAR2 | (80) | Bill to Region1(External 5) | |
| BILL_TO_REGION2_EXT2 | VARCHAR2 | (80) | Bill to Region 2(External 2) | |
| BILL_TO_REGION2_EXT3 | VARCHAR2 | (80) | Bill to Region 2(External 3) | |
| BILL_TO_REGION2_EXT4 | VARCHAR2 | (80) | Bill to Region 2(External 4) | |
| BILL_TO_REGION2_EXT5 | VARCHAR2 | (80) | Bill to region 2(External 5) | |
| BILL_TO_REGION3_EXT2 | VARCHAR2 | (80) | Bill to Region 3(External 2) | |
| BILL_TO_REGION3_EXT3 | VARCHAR2 | (80) | Bill to Region 3(External 3) | |
| BILL_TO_REGION3_EXT4 | VARCHAR2 | (80) | Bill to Region 3(External 4) | |
| BILL_TO_REGION3_EXT5 | VARCHAR2 | (80) | Bill to Region 3(External 5) | |
| SHIP_TO_REGION1_EXT2 | VARCHAR2 | (80) | Ship to Region 2(External 2) | |
| SHIP_TO_REGION1_EXT3 | VARCHAR2 | (80) | Ship to Region 1(External 3) | |
| SHIP_TO_REGION1_EXT4 | VARCHAR2 | (80) | Ship to Region 1(External 4) | |
| SHIP_TO_REGION1_EXT5 | VARCHAR2 | (80) | Ship to Region 1(External 5) | |
| SHIP_TO_REGION2_EXT2 | VARCHAR2 | (80) | Ship to Region 2(External 2) | |
| SHIP_TO_REGION2_EXT3 | VARCHAR2 | (80) | Ship to Region 2(External 3) | |
| SHIP_TO_REGION2_EXT4 | VARCHAR2 | (80) | Ship to Region 2(External 4) | |
| SHIP_TO_REGION2_EXT5 | VARCHAR2 | (80) | Ship to Region 2(External 5) | |
| SHIP_TO_REGION3_EXT2 | VARCHAR2 | (80) | Ship to Region 3(External 2) | |
| SHIP_TO_REGION3_EXT3 | VARCHAR2 | (80) | Ship to Region 3(External 3) | |
| SHIP_TO_REGION3_EXT4 | VARCHAR2 | (80) | Ship to Region 3(External 4) | |
| SHIP_TO_REGION3_EXT5 | VARCHAR2 | (80) | Ship to Region 3(External 5) | |
| SHIP_TO_COUNTRY_EXT2 | VARCHAR2 | (80) | Ship to Country(External 2) | |
| SHIP_TO_COUNTRY_EXT3 | VARCHAR2 | (80) | Ship to Country(external 3) | |
| SHIP_TO_COUNTRY_EXT4 | VARCHAR2 | (80) | Ship to Country (External 4) | |
| SHIP_TO_COUNTRY_EXT5 | VARCHAR2 | (80) | Ship to Country (External 5) | |
| VENDOR_SITE_PROVINCE_EXT2 | VARCHAR2 | (80) | Vendor Site Province (External 2) | |
| VENDOR_SITE_PROVINCE_EXT3 | VARCHAR2 | (80) | Vendor Site Province (External 3) | |
| VENDOR_SITE_PROVINCE_EXT4 | VARCHAR2 | (80) | Vendor Site Province (External 4) | |
| VENDOR_SITE_PROVINCE_EXT5 | VARCHAR2 | (80) | Vendor Site Province (External 5) | |
| VENDOR_SITE_STATE_EXT2 | VARCHAR2 | (80) | Vendor Site State (External 2) | |
| VENDOR_SITE_STATE_EXT3 | VARCHAR2 | (80) | Vendor Site State(External 3) | |
| VENDOR_SITE_STATE_EXT4 | VARCHAR2 | (80) | Vendor Site State (External 4) | |
| VENDOR_SITE_STATE_EXT5 | VARCHAR2 | (80) | Vendor Site State (External 5) | |
| VENDOR_SITE_COUNTRY_EXT2 | VARCHAR2 | (80) | Vendor Site Country (External 2) | |
| VENDOR_SITE_COUNTRY_EXT3 | VARCHAR2 | (80) | Vendor Site Country (External 3) | |
| VENDOR_SITE_COUNTRY_EXT4 | VARCHAR2 | (80) | Vendor Site Country (External 4) | |
| VENDOR_SITE_COUNTRY_EXT5 | VARCHAR2 | (80) | Vendor Site Country (External 5) | |
| VENDOR_SITE_ID_EXT1 | VARCHAR2 | (80) | Vendor site Id (External 1) | |
| VENDOR_SITE_ID_EXT2 | VARCHAR2 | (80) | Vendor site ID (External 2) | |
| VENDOR_SITE_ID_EXT3 | VARCHAR2 | (80) | Vendor Site ID (External 3) | |
| VENDOR_SITE_ID_EXT4 | VARCHAR2 | (80) | Vendor site ID (External 4) | |
| VENDOR_SITE_ID_EXT5 | VARCHAR2 | (80) | Vendor site ID (External 5) | |
| BILL_TO_COUNTRY_EXT2 | VARCHAR2 | (60) | Bill to Country (External 2) | |
| BILL_TO_COUNTRY_EXT3 | VARCHAR2 | (60) | Bill to Country (External 3) | |
| BILL_TO_COUNTRY_EXT4 | VARCHAR2 | (60) | Bill to Country (External 4) | |
| BILL_TO_COUNTRY_EXT5 | VARCHAR2 | (60) | Bill to Country (External 5) | |
| SHIPPING_CONTROL | VARCHAR2 | (30) | SHIPPING_CONTROL |
Cut, paste (and edit) the following text to query this object:
SELECT COMMUNICATION_METHOD
, TP_TEST_FLAG
, DOCUMENT_ID
, DOCUMENT_TYPE
, DOCUMENT_PURPOSE_CODE
, DOCUMENT_CODE
, TP_TRANSLATOR_CODE
, TP_LOCATION_CODE_EXT
, TP_DESCRIPTION
, TP_REFERENCE_EXT1
, TP_REFERENCE_EXT2
, TRANSACTION_DATE
, RUN_ID
, TPH_ATTRIBUTE_CATEGORY
, TPH_ATTRIBUTE1
, TPH_ATTRIBUTE2
, TPH_ATTRIBUTE3
, TPH_ATTRIBUTE4
, TPH_ATTRIBUTE5
, TPH_ATTRIBUTE6
, TPH_ATTRIBUTE7
, TPH_ATTRIBUTE8
, TPH_ATTRIBUTE9
, TPH_ATTRIBUTE10
, TPH_ATTRIBUTE11
, TPH_ATTRIBUTE12
, TPH_ATTRIBUTE13
, TPH_ATTRIBUTE14
, TPH_ATTRIBUTE15
, TPD_ATTRIBUTE_CATEGORY
, TPD_ATTRIBUTE1
, TPD_ATTRIBUTE2
, TPD_ATTRIBUTE3
, TPD_ATTRIBUTE4
, TPD_ATTRIBUTE5
, PO_NUMBER
, RELEASE_NUMBER
, RELEASE_DATE
, CREATION_DATE
, PO_REVISION_NUMBER
, PO_REVISION_DATE
, RELEASE_REVISION_NUMBER
, RELEASE_REVISION_DATE
, PO_DESCRIPTION
, PO_TYPE
, PAYMENT_TERM
, PAYMENT_TERM_EXT1
, PAYMENT_TERM_EXT2
, PAYMENT_TERM_EXT3
, PAYMENT_TERM_EXT4
, PAYMENT_TERM_EXT5
, PO_CURRENCY_CODE
, PO_CURRENCY_CODE_EXT1
, CURRENCY_EXCHANGE_RATE
, PO_SHIP_VIA
, PO_SHIP_VIA_EXT1
, PO_SHIP_VIA_EXT2
, PO_SHIP_VIA_EXT3
, PO_FOB_CODE
, PO_FOB_CODE_EXT1
, PO_FREIGHT_TERMS
, PO_FREIGHT_TERMS_EXT1
, PO_CANCELLED_FLAG
, PO_ACCEPTANCE_REQUIRED_FLAG
, PO_ACCEPTANCE_DUE_BY_DATE
, PO_CONFIRMING_ORDER_FLAG
, BLANKET_START_DATE
, BLANKET_END_DATE
, BLANKET_TOTAL_AMOUNT
, SUPPLIER_NUMBER
, SUPPLIER_NAME
, PO_NOTES_TO_VENDOR
, PO_ATTRIBUTE_CATEGORY
, PO_ATTRIBUTE1
, PO_ATTRIBUTE2
, PO_ATTRIBUTE3
, PO_ATTRIBUTE4
, PO_ATTRIBUTE5
, PO_ATTRIBUTE6
, PO_ATTRIBUTE7
, PO_ATTRIBUTE8
, PO_ATTRIBUTE9
, PO_ATTRIBUTE10
, PO_ATTRIBUTE11
, PO_ATTRIBUTE12
, PO_ATTRIBUTE13
, PO_ATTRIBUTE14
, PO_ATTRIBUTE15
, VENDOR_ATTRIBUTE_CATEGORY
, VENDOR_ATTRIBUTE1
, VENDOR_ATTRIBUTE2
, VENDOR_ATTRIBUTE3
, VENDOR_ATTRIBUTE4
, VENDOR_ATTRIBUTE5
, VENDOR_ATTRIBUTE6
, VENDOR_ATTRIBUTE7
, VENDOR_ATTRIBUTE8
, VENDOR_ATTRIBUTE9
, VENDOR_ATTRIBUTE10
, VENDOR_ATTRIBUTE11
, VENDOR_ATTRIBUTE12
, VENDOR_ATTRIBUTE13
, VENDOR_ATTRIBUTE14
, VENDOR_ATTRIBUTE15
, VENDOR_SITE_ATTRIB_CATEGORY
, VENDOR_SITE_ATTRIBUTE1
, VENDOR_SITE_ATTRIBUTE2
, VENDOR_SITE_ATTRIBUTE3
, VENDOR_SITE_ATTRIBUTE4
, VENDOR_SITE_ATTRIBUTE5
, VENDOR_SITE_ATTRIBUTE6
, VENDOR_SITE_ATTRIBUTE7
, VENDOR_SITE_ATTRIBUTE8
, VENDOR_SITE_ATTRIBUTE9
, VENDOR_SITE_ATTRIBUTE10
, VENDOR_SITE_ATTRIBUTE11
, VENDOR_SITE_ATTRIBUTE12
, VENDOR_SITE_ATTRIBUTE13
, VENDOR_SITE_ATTRIBUTE14
, VENDOR_SITE_ATTRIBUTE15
, VENDOR_CUSTOMER_NUMBER
, VENDOR_SITE_ENTITY
, VENDOR_SITE_ENTITY_EXT1
, VENDOR_SITE_NAME
, VENDOR_SITE_ADDR_LINE_1
, VENDOR_SITE_ADDR_LINE_2
, VENDOR_SITE_ADDR_LINE_3
, VENDOR_SITE_ADDR_LINE_4
, VENDOR_SITE_CITY
, VENDOR_SITE_ZIP
, VENDOR_SITE_COUNTRY
, VENDOR_SITE_COUNTRY_EXT1
, VENDOR_SITE_STATE
, VENDOR_SITE_STATE_EXT1
, VENDOR_SITE_PROVINCE
, VENDOR_SITE_PROVINCE_EXT1
, VENDOR_SITE_CONTACT_LAST_NAME
, VENDOR_SITE_CONTACT_FIRST_NAME
, VENDOR_SITE_AREA_CODE
, VENDOR_SITE_PHONE
, VENDOR_SITE_FAX_AREA_CODE
, VENDOR_SITE_FAX
, VENDOR_SITE_TELEX_AREA_CODE
, VENDOR_SITE_TELEX
, VENDOR_CONTACT_LAST_NAME
, VENDOR_CONTACT_FIRST_NAME
, VENDOR_CONTACT_AREA_CODE
, VENDOR_CONTACT_PHONE
, 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_PHONE1_AREA_CODE
, SHIP_TO_PHONE1
, SHIP_TO_PHONE2_AREA_CODE
, SHIP_TO_PHONE2
, SHIP_TO_PHONE3_AREA_CODE
, SHIP_TO_PHONE3
, BILL_TO_LOCATION_CODE
, BILL_TO_ENTITY_EXT1
, BILL_TO_SITE_NAME
, BILL_TO_ADDRESS_LINE_1
, BILL_TO_ADDRESS_LINE_2
, BILL_TO_ADDRESS_LINE_3
, BILL_TO_ADDRESS_LINE_4
, BILL_TO_CITY
, BILL_TO_POSTAL_CODE
, BILL_TO_COUNTRY
, BILL_TO_COUNTRY_EXT1
, BILL_TO_REGION1
, BILL_TO_REGION1_EXT1
, BILL_TO_REGION2
, BILL_TO_REGION2_EXT1
, BILL_TO_REGION3
, BILL_TO_REGION3_EXT1
, BILL_TO_CONTACT_LAST_NAME
, BILL_TO_CONTACT_FIRST_NAME
, BILL_TO_PHONE1_AREA_CODE
, BILL_TO_PHONE1
, BILL_TO_PHONE2_AREA_CODE
, BILL_TO_PHONE2
, BILL_TO_PHONE3_AREA_CODE
, BILL_TO_PHONE3
, PO_BUYER_LAST_NAME
, PO_BUYER_FIRST_NAME
, PO_HEADER_ID
, PO_RELEASE_ID
, TRANSACTION_RECORD_ID
, PO_CURRENCY_CODE_EXT2
, PO_CURRENCY_CODE_EXT3
, PO_CURRENCY_CODE_EXT4
, PO_CURRENCY_CODE_EXT5
, PO_SHIP_VIA_EXT4
, PO_SHIP_VIA_EXT5
, PO_FOB_CODE_EXT2
, PO_FOB_CODE_EXT3
, PO_FOB_CODE_EXT4
, PO_FOB_CODE_EXT5
, PO_FREIGHT_TERMS_EXT2
, PO_FREIGHT_TERMS_EXT3
, PO_FREIGHT_TERMS_EXT4
, PO_FREIGHT_TERMS_EXT5
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, PO_BUYER_EMAIL_ADDRESS
, PO_BUYER_WORK_TELEPHONE
, PO_BUYER_MISC_TELEPHONE1
, PO_BUYER_MISC_TELEPHONE2
, PO_BUYER_MISC_TELEPHONE3
, PO_CANCELLED_DATE
, DOCUMENT_STANDARD
, PCARDMEMBER_NAME
, PCARD_NUMBER
, PCARD_EXPIRATION_DATE
, PCARD_BRAND
, PCARD_BRAND_EXT1
, PCARD_BRAND_EXT2
, PCARD_BRAND_EXT3
, PCARD_BRAND_EXT4
, PCARD_BRAND_EXT5
, MAP_ID
, SUPPLIER_SITE_CODE
, VS_EDI_LOCATION_CODE_INT
, VS_EDI_LOCATION_CODE_EXT1
, VS_EDI_LOCATION_CODE_EXT2
, VS_EDI_LOCATION_CODE_EXT3
, VS_EDI_LOCATION_CODE_EXT4
, VS_EDI_LOCATION_CODE_EXT5
, VENDOR_SITE_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
, BILL_TO_LOCATION_CODE_INT
, BILL_TO_LOCATION_CODE_EXT1
, BILL_TO_LOCATION_CODE_EXT2
, BILL_TO_LOCATION_CODE_EXT3
, BILL_TO_LOCATION_CODE_EXT4
, BILL_TO_LOCATION_CODE_EXT5
, ORG_ID
, BILL_TO_REGION1_EXT2
, BILL_TO_REGION1_EXT3
, BILL_TO_REGION1_EXT4
, BILL_TO_REGION1_EXT5
, BILL_TO_REGION2_EXT2
, BILL_TO_REGION2_EXT3
, BILL_TO_REGION2_EXT4
, BILL_TO_REGION2_EXT5
, BILL_TO_REGION3_EXT2
, BILL_TO_REGION3_EXT3
, BILL_TO_REGION3_EXT4
, BILL_TO_REGION3_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
, SHIP_TO_COUNTRY_EXT2
, SHIP_TO_COUNTRY_EXT3
, SHIP_TO_COUNTRY_EXT4
, SHIP_TO_COUNTRY_EXT5
, VENDOR_SITE_PROVINCE_EXT2
, VENDOR_SITE_PROVINCE_EXT3
, VENDOR_SITE_PROVINCE_EXT4
, VENDOR_SITE_PROVINCE_EXT5
, VENDOR_SITE_STATE_EXT2
, VENDOR_SITE_STATE_EXT3
, VENDOR_SITE_STATE_EXT4
, VENDOR_SITE_STATE_EXT5
, VENDOR_SITE_COUNTRY_EXT2
, VENDOR_SITE_COUNTRY_EXT3
, VENDOR_SITE_COUNTRY_EXT4
, VENDOR_SITE_COUNTRY_EXT5
, VENDOR_SITE_ID_EXT1
, VENDOR_SITE_ID_EXT2
, VENDOR_SITE_ID_EXT3
, VENDOR_SITE_ID_EXT4
, VENDOR_SITE_ID_EXT5
, BILL_TO_COUNTRY_EXT2
, BILL_TO_COUNTRY_EXT3
, BILL_TO_COUNTRY_EXT4
, BILL_TO_COUNTRY_EXT5
, SHIPPING_CONTROL
FROM EC.ECE_PO_INTERFACE_HEADERS;
EC.ECE_PO_INTERFACE_HEADERS does not reference any database object
EC.ECE_PO_INTERFACE_HEADERS is referenced by following:
APPS
ECE_PO_INTERFACE_HEADERS
|
|
|
|