[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | ECE_SPSO_HEADERS |
|---|---|
| Object Type: | TABLE |
| Owner: | EC |
| FND Design Data: |  EC.ECE_SPSO_HEADERS
|
| Subobject Name: | |
| Status: | VALID |
ECE_SPSO_HEADERS contains supplier schedule data to support the
outbound Planning Schedule (830/DELFOR) and Shipping Schedule
(862/DELJIT) transactions.
ECE_SPSO_HEADERS is based primarily on data stored in
CHV_SCHEDULE_HEADERS in Oracle Supplier Scheduling.
ECE_SPSO_HEADERS contains the confirmed planning or shipping schedule
identified by the Oracle Supplier Scheduler Workbench, Oracle Supplier
Schedulings AutoSchedule process, or selected by the e-Commerce
Gateway user. In addition, ECE_SPSO_HEADERS contains the scheduling
options and ship-to organization defaults found in CHV_ORG_OPTIONS.
Each row includes data for the forecast planning horizon, schedule ID
and type, schedule revision and options, ship-to organization
defaults, and supplier data.
SCHEDULE_ID is the primary key for this table.
RUN_ID uniquely identifies the session that created the row in
ECE_SPSO_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_SPSO_HEADERS is purged after the data is written
to the data file.
TRANSACTION_RECORD_ID is the unique key that links the
ECE_SPSO_HEADER table to its corresponding extension table
ECE_SPSO_HEADER_X.
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| ECE_SPSO_HEADERS_U1 | NORMAL | UNIQUE |
APPS_TS_INTERFACE
|
 SCHEDULE_ID
RUN_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| TP_LOCATION_CODE_EXT | VARCHAR2 | (35) | Trading Partner Location Code | |
| TP_TRANSLATOR_CODE | VARCHAR2 | (30) | Trading Partner Translator Code | |
| TP_DESCRIPTION | VARCHAR2 | (240) | Trading Partner Description | |
| TRANSACTION_DATE | DATE | Transaction Date/Time | ||
| TRANSACTION_CONTROL1 | VARCHAR2 | (80) | Transaction Control 1 | |
| TRANSACTION_CONTROL2 | VARCHAR2 | (80) | Transaction Control 2 | |
| TRANSACTION_CONTROL3 | VARCHAR2 | (80) | Transaction Control 3 | |
| TEST_FLAG | VARCHAR2 | (1) | Trading Partner Test Flag | |
| TP_REFERENCE_EXT1 | VARCHAR2 | (240) | Trading Partner Reference 1 (Ext) | |
| TP_REFERENCE_EXT2 | VARCHAR2 | (240) | Trading Partner Reference 2 (Ext) | |
| COMMUNICATION_METHOD | VARCHAR2 | (30) | Yes | Communications Method |
| DOCUMENT_ID | VARCHAR2 | (6) | Document ID | |
| DOCUMENT_TYPE | VARCHAR2 | (3) | Document Type | |
| DOCUMENT_CODE | VARCHAR2 | (20) | Document Code | |
| DOCUMENT_PURPOSE_CODE | VARCHAR2 | (2) | Document Purpose Code | |
| SCHEDULE_ID | NUMBER | Schedule ID | ||
| SCHEDULE_TYPE | VARCHAR2 | (25) | Schedule Type | |
| SCHEDULE_SUB_TYPE | VARCHAR2 | (25) | Schedule Sub-Type | |
| SCHEDULE_NUMBER_REVISION | VARCHAR2 | (30) | Schedule Revision | |
| SCHEDULE_STATUS | VARCHAR2 | (25) | Schedule Status | |
| SCHEDULE_GENERATION_DATE | DATE | Schedule Generation Date | ||
| FORECAST_HORIZON_START_DATE | DATE | Forecast Horizon Start Date | ||
| FORECAST_HORIZON_END_DATE | DATE | Forecast Horizon End Date | ||
| MULTIPLE_SHIP_TO_ORG_FLAG | VARCHAR2 | (1) | Multiple Ship To Organization Flag | |
| SHIP_TO_ORG_ENABLE_CUM_FLAG | VARCHAR2 | (1) | Ship To Organization Enable CUM Flag | |
| SHIP_TO_ORG_CUM_START_DATE | DATE | Ship To Organization CUM Period Start Date | ||
| SHIP_TO_ORG_NAME | VARCHAR2 | (240) | Ship To Name | |
| SHIP_TO_ORG_CODE | VARCHAR2 | (10) | Ship To Code (Internal) | |
| SHIP_TO_ORG_CODE_EXT | VARCHAR2 | (50) | Ship To Code (Ext) | |
| SHIP_TO_ORG_LOCATION | VARCHAR2 | (60) | Ship To Code (Internal) | |
| SHIP_TO_ORG_LOCATION_EXT | VARCHAR2 | (60) | Ship To Code (Ext) | |
| SHIP_TO_ORG_ADDRESS_LINE_1 | VARCHAR2 | (240) | Ship To Address Line 1 | |
| SHIP_TO_ORG_ADDRESS_LINE_2 | VARCHAR2 | (240) | Ship To Address Line 2 | |
| SHIP_TO_ORG_ADDRESS_LINE_3 | VARCHAR2 | (240) | Ship To Address Line 3 | |
| SHIP_TO_ORG_CITY | VARCHAR2 | (30) | Ship To City | |
| SHIP_TO_ORG_REGION_1 | VARCHAR2 | (120) | Ship To Region 1 (Internal) | |
| SHIP_TO_ORG_REGION_1_EXT | VARCHAR2 | (120) | Ship To Region 2 (Ext) | |
| SHIP_TO_ORG_REGION_3 | VARCHAR2 | (120) | Ship To Region 3 (Internal) | |
| SHIP_TO_ORG_REGION_3_EXT | VARCHAR2 | (120) | Ship To Region 3 (Ext) | |
| SHIP_TO_ORG_REGION_2 | VARCHAR2 | (120) | Ship To Region 2 (Internal) | |
| SHIP_TO_ORG_REGION_2_EXT | VARCHAR2 | (120) | Ship To Region 2 (Ext) | |
| SHIP_TO_ORG_COUNTRY | VARCHAR2 | (60) | Ship To Country (Internal) | |
| SHIP_TO_ORG_COUNTRY_EXT | VARCHAR2 | (60) | Ship To Country (Ext) | |
| SHIP_TO_ORG_POSTAL_CODE | VARCHAR2 | (30) | Ship To Postal Code | |
| SHIP_TO_ORG_TELEPHONE | VARCHAR2 | (60) | Ship To Telephone | |
| SUPPLIER_NAME | VARCHAR2 | (240) | Supplier Name | |
| SUPPLIER_SITE_ADDRESS_LINE_4 | VARCHAR2 | (240) | Supplier Site Address Line 4 | |
| SUPPLIER_NUMBER | VARCHAR2 | (30) | Supplier Number (Internal) | |
| SUPPLIER_NUMBER_EXT | VARCHAR2 | (30) | Supplier Number (Ext) | |
| SUPPLIER_SITE_CODE | VARCHAR2 | (15) | Supplier Site Code (Internal) | |
| SUPPLIER_SITE_CODE_EXT | VARCHAR2 | (50) | Supplier Site Code (Ext) | |
| SUPPLIER_SITE_ADDRESS_LINE_1 | VARCHAR2 | (240) | Supplier Site Address Line 1 | |
| SUPPLIER_SITE_ADDRESS_LINE_2 | VARCHAR2 | (240) | Supplier Site Address Line 2 | |
| SUPPLIER_SITE_ADDRESS_LINE_3 | VARCHAR2 | (240) | Supplier Site Address Line 3 | |
| SUPPLIER_SITE_CITY | VARCHAR2 | (25) | Supplier Site City | |
| SUPPLIER_SITE_STATE | VARCHAR2 | (150) | Supplier Site State | |
| SUPPLIER_SITE_STATE_EXT | VARCHAR2 | (150) | Supplier Site State (Ext) | |
| SUPPLIER_SITE_POSTAL_CODE | VARCHAR2 | (20) | Supplier Site Postal Code | |
| SUPPLIER_SITE_PROVINCE | VARCHAR2 | (150) | Supplier Site Province | |
| SUPPLIER_SITE_PROVINCE_EXT | VARCHAR2 | (150) | Supplier Site Province (Ext) | |
| SUPPLIER_SITE_COUNTRY | VARCHAR2 | (150) | Supplier Site Country | |
| SUPPLIER_SITE_COUNTRY_EXT | VARCHAR2 | (150) | Supplier Site Country (Ext) | |
| SUPPLIER_SITE_AREA_CODE | VARCHAR2 | (10) | Supplier Site Area Code | |
| SUPPLIER_SITE_TELEPHONE | VARCHAR2 | (15) | Supplier Site Telephone | |
| SCH_HEADER_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Schedule Header Flexfield Context | |
| SCH_HEADER_ATTRIBUTE1 | VARCHAR2 | (150) | Schedule Header Flexfield 1 | |
| SCH_HEADER_ATTRIBUTE2 | VARCHAR2 | (150) | Schedule Header Flexfield 2 | |
| SCH_HEADER_ATTRIBUTE3 | VARCHAR2 | (150) | Schedule Header Flexfield 3 | |
| SCH_HEADER_ATTRIBUTE4 | VARCHAR2 | (150) | Schedule Header Flexfield 4 | |
| SCH_HEADER_ATTRIBUTE5 | VARCHAR2 | (150) | Schedule Header Flexfield 5 | |
| SCH_HEADER_ATTRIBUTE6 | VARCHAR2 | (150) | Schedule Header Flexfield 6 | |
| SCH_HEADER_ATTRIBUTE7 | VARCHAR2 | (150) | Schedule Header Flexfield 7 | |
| SCH_HEADER_ATTRIBUTE8 | VARCHAR2 | (150) | Schedule Header Flexfield 8 | |
| SCH_HEADER_ATTRIBUTE9 | VARCHAR2 | (150) | Schedule Header Flexfield 9 | |
| SCH_HEADER_ATTRIBUTE10 | VARCHAR2 | (150) | Schedule Header Flexfield 10 | |
| SCH_HEADER_ATTRIBUTE11 | VARCHAR2 | (150) | Schedule Header Flexfield 11 | |
| SCH_HEADER_ATTRIBUTE12 | VARCHAR2 | (150) | Schedule Header Flexfield 12 | |
| SCH_HEADER_ATTRIBUTE13 | VARCHAR2 | (150) | Schedule Header Flexfield 13 | |
| SCH_HEADER_ATTRIBUTE14 | VARCHAR2 | (150) | Schedule Header Flexfield 14 | |
| SCH_HEADER_ATTRIBUTE15 | VARCHAR2 | (150) | Schedule Header Flexfield 15 | |
| VENDOR_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Supplier Flexfield Context | |
| VENDOR_ATTRIBUTE1 | VARCHAR2 | (150) | Supplier Flexfield 1 | |
| VENDOR_ATTRIBUTE2 | VARCHAR2 | (150) | Supplier Flexfield 2 | |
| VENDOR_ATTRIBUTE3 | VARCHAR2 | (150) | Supplier Flexfield 3 | |
| VENDOR_ATTRIBUTE4 | VARCHAR2 | (150) | Supplier Flexfield 4 | |
| VENDOR_ATTRIBUTE5 | VARCHAR2 | (150) | Supplier Flexfield 5 | |
| VENDOR_ATTRIBUTE6 | VARCHAR2 | (150) | Supplier Flexfield 6 | |
| VENDOR_ATTRIBUTE7 | VARCHAR2 | (150) | Supplier Flexfield 7 | |
| VENDOR_ATTRIBUTE8 | VARCHAR2 | (150) | Supplier Flexfield 8 | |
| VENDOR_ATTRIBUTE9 | VARCHAR2 | (150) | Supplier Flexfield 9 | |
| VENDOR_ATTRIBUTE10 | VARCHAR2 | (150) | Supplier Flexfield 10 | |
| VENDOR_ATTRIBUTE11 | VARCHAR2 | (150) | Supplier Flexfield 11 | |
| VENDOR_ATTRIBUTE12 | VARCHAR2 | (150) | Supplier Flexfield 12 | |
| VENDOR_ATTRIBUTE13 | VARCHAR2 | (150) | Supplier Flexfield 13 | |
| VENDOR_ATTRIBUTE14 | VARCHAR2 | (150) | Supplier Flexfield 14 | |
| VENDOR_ATTRIBUTE15 | VARCHAR2 | (150) | Supplier Flexfield 15 | |
| VENDOR_SITE_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Supplier Site Flexfield Context | |
| VENDOR_SITE_ATTRIBUTE1 | VARCHAR2 | (150) | Supplier Site Flexfield 1 | |
| VENDOR_SITE_ATTRIBUTE2 | VARCHAR2 | (150) | Supplier Site Flexfield 2 | |
| VENDOR_SITE_ATTRIBUTE3 | VARCHAR2 | (150) | Supplier Site Flexfield 3 | |
| VENDOR_SITE_ATTRIBUTE4 | VARCHAR2 | (150) | Supplier Site Flexfield 4 | |
| VENDOR_SITE_ATTRIBUTE5 | VARCHAR2 | (150) | Supplier Site Flexfield 5 | |
| VENDOR_SITE_ATTRIBUTE6 | VARCHAR2 | (150) | Supplier Site Flexfield 6 | |
| VENDOR_SITE_ATTRIBUTE7 | VARCHAR2 | (150) | Supplier Site Flexfield 7 | |
| VENDOR_SITE_ATTRIBUTE8 | VARCHAR2 | (150) | Supplier Site Flexfield 8 | |
| VENDOR_SITE_ATTRIBUTE9 | VARCHAR2 | (150) | Supplier Site Flexfield 9 | |
| VENDOR_SITE_ATTRIBUTE10 | VARCHAR2 | (150) | Supplier Site Flexfield 10 | |
| VENDOR_SITE_ATTRIBUTE11 | VARCHAR2 | (150) | Supplier Site Flexfield 11 | |
| VENDOR_SITE_ATTRIBUTE12 | VARCHAR2 | (150) | Supplier Site Flexfield 12 | |
| VENDOR_SITE_ATTRIBUTE13 | VARCHAR2 | (150) | Supplier Site Flexfield 13 | |
| VENDOR_SITE_ATTRIBUTE14 | VARCHAR2 | (150) | Supplier Site Flexfield 14 | |
| VENDOR_SITE_ATTRIBUTE15 | VARCHAR2 | (150) | Supplier Site Flexfield 15 | |
| SHIP_ORG_ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Ship To Flexfield Context | |
| SHIP_ORG_ATTRIBUTE1 | VARCHAR2 | (150) | Ship To Flexfield 1 | |
| SHIP_ORG_ATTRIBUTE2 | VARCHAR2 | (150) | Ship To Flexfield 2 | |
| SHIP_ORG_ATTRIBUTE3 | VARCHAR2 | (150) | Ship To Flexfield 3 | |
| SHIP_ORG_ATTRIBUTE4 | VARCHAR2 | (150) | Ship To Flexfield 4 | |
| SHIP_ORG_ATTRIBUTE5 | VARCHAR2 | (150) | Ship To Flexfield 5 | |
| SHIP_ORG_ATTRIBUTE6 | VARCHAR2 | (150) | Ship To Flexfield 6 | |
| SHIP_ORG_ATTRIBUTE7 | VARCHAR2 | (150) | Ship To Flexfield 7 | |
| SHIP_ORG_ATTRIBUTE8 | VARCHAR2 | (150) | Ship To Flexfield 8 | |
| SHIP_ORG_ATTRIBUTE9 | VARCHAR2 | (150) | Ship To Flexfield 9 | |
| SHIP_ORG_ATTRIBUTE10 | VARCHAR2 | (150) | Ship To Flexfield 10 | |
| SHIP_ORG_ATTRIBUTE11 | VARCHAR2 | (150) | Ship To Flexfield 11 | |
| SHIP_ORG_ATTRIBUTE12 | VARCHAR2 | (150) | Ship To Flexfield 12 | |
| SHIP_ORG_ATTRIBUTE13 | VARCHAR2 | (150) | Ship To Flexfield 13 | |
| SHIP_ORG_ATTRIBUTE14 | VARCHAR2 | (150) | Ship To Flexfield 14 | |
| SHIP_ORG_ATTRIBUTE15 | VARCHAR2 | (150) | Ship To Flexfield 15 | |
| ORG_OPT_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Ship To Options Flexfield Context | |
| ORG_OPT_ATTRIBUTE1 | VARCHAR2 | (150) | Ship To Options Flexfield 1 | |
| ORG_OPT_ATTRIBUTE2 | VARCHAR2 | (150) | Ship To Options Flexfield 2 | |
| ORG_OPT_ATTRIBUTE3 | VARCHAR2 | (150) | Ship To Options Flexfield 3 | |
| ORG_OPT_ATTRIBUTE4 | VARCHAR2 | (150) | Ship To Options Flexfield 4 | |
| ORG_OPT_ATTRIBUTE5 | VARCHAR2 | (150) | Ship To Options Flexfield 5 | |
| ORG_OPT_ATTRIBUTE6 | VARCHAR2 | (150) | Ship To Options Flexfield 6 | |
| ORG_OPT_ATTRIBUTE7 | VARCHAR2 | (150) | Ship To Options Flexfield 7 | |
| ORG_OPT_ATTRIBUTE8 | VARCHAR2 | (150) | Ship To Options Flexfield 8 | |
| ORG_OPT_ATTRIBUTE9 | VARCHAR2 | (150) | Ship To Options Flexfield 9 | |
| ORG_OPT_ATTRIBUTE10 | VARCHAR2 | (150) | Ship To Options Flexfield 10 | |
| ORG_OPT_ATTRIBUTE11 | VARCHAR2 | (150) | Ship To Options Flexfield 11 | |
| ORG_OPT_ATTRIBUTE12 | VARCHAR2 | (150) | Ship To Options Flexfield 12 | |
| ORG_OPT_ATTRIBUTE13 | VARCHAR2 | (150) | Ship To Options Flexfield 13 | |
| ORG_OPT_ATTRIBUTE14 | VARCHAR2 | (150) | Ship To Options Flexfield 14 | |
| ORG_OPT_ATTRIBUTE15 | VARCHAR2 | (150) | Ship To Options Flexfield 15 | |
| TPH_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Trading Partner Header Flexfield Context | |
| TPH_ATTRIBUTE1 | VARCHAR2 | (150) | Trading Partner Header Flexfield 1 | |
| TPH_ATTRIBUTE2 | VARCHAR2 | (150) | Trading Partner Header Flexfield 2 | |
| TPH_ATTRIBUTE3 | VARCHAR2 | (150) | Trading Partner Header Flexfield 3 | |
| TPH_ATTRIBUTE4 | VARCHAR2 | (150) | Trading Partner Header Flexfield 4 | |
| TPH_ATTRIBUTE5 | VARCHAR2 | (150) | Trading Partner Header Flexfield 5 | |
| TPH_ATTRIBUTE6 | VARCHAR2 | (150) | Trading Partner Header Flexfield 6 | |
| TPH_ATTRIBUTE7 | VARCHAR2 | (150) | Trading Partner Header Flexfield 7 | |
| TPH_ATTRIBUTE8 | VARCHAR2 | (150) | Trading Partner Header Flexfield 8 | |
| TPH_ATTRIBUTE9 | VARCHAR2 | (150) | Trading Partner Header Flexfield 9 | |
| TPH_ATTRIBUTE10 | VARCHAR2 | (150) | Trading Partner Header Flexfield 10 | |
| TPH_ATTRIBUTE11 | VARCHAR2 | (150) | Trading Partner Header Flexfield 11 | |
| TPH_ATTRIBUTE12 | VARCHAR2 | (150) | Trading Partner Header Flexfield 12 | |
| TPH_ATTRIBUTE13 | VARCHAR2 | (150) | Trading Partner Header Flexfield 13 | |
| TPH_ATTRIBUTE14 | VARCHAR2 | (150) | Trading Partner Header Flexfield 14 | |
| TPH_ATTRIBUTE15 | VARCHAR2 | (150) | Trading Partner Header Flexfield 15 | |
| TPD_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Trading Partner Detail Flexfield Context | |
| TPD_ATTRIBUTE1 | VARCHAR2 | (150) | Trading Partner Detail Flexfield 1 | |
| TPD_ATTRIBUTE2 | VARCHAR2 | (150) | Trading Partner Detail Flexfield 2 | |
| TPD_ATTRIBUTE3 | VARCHAR2 | (150) | Trading Partner Detail Flexfield 3 | |
| TPD_ATTRIBUTE4 | VARCHAR2 | (150) | Trading Partner Detail Flexfield 4 | |
| TPD_ATTRIBUTE5 | VARCHAR2 | (150) | Trading Partner Detail Flexfield 5 | |
| RUN_ID | NUMBER | Transaction Run ID | ||
| TRANSACTION_RECORD_ID | NUMBER | Unique identifier which links the transaction base table to its associated extension table. | ||
| 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 | ||
| DOCUMENT_STANDARD | VARCHAR2 | (30) | EDI Document Standard | |
| MAP_ID | NUMBER | Map ID |
Cut, paste (and edit) the following text to query this object:
SELECT TP_LOCATION_CODE_EXT
, TP_TRANSLATOR_CODE
, TP_DESCRIPTION
, TRANSACTION_DATE
, TRANSACTION_CONTROL1
, TRANSACTION_CONTROL2
, TRANSACTION_CONTROL3
, TEST_FLAG
, TP_REFERENCE_EXT1
, TP_REFERENCE_EXT2
, COMMUNICATION_METHOD
, DOCUMENT_ID
, DOCUMENT_TYPE
, DOCUMENT_CODE
, DOCUMENT_PURPOSE_CODE
, SCHEDULE_ID
, SCHEDULE_TYPE
, SCHEDULE_SUB_TYPE
, SCHEDULE_NUMBER_REVISION
, SCHEDULE_STATUS
, SCHEDULE_GENERATION_DATE
, FORECAST_HORIZON_START_DATE
, FORECAST_HORIZON_END_DATE
, MULTIPLE_SHIP_TO_ORG_FLAG
, SHIP_TO_ORG_ENABLE_CUM_FLAG
, SHIP_TO_ORG_CUM_START_DATE
, SHIP_TO_ORG_NAME
, SHIP_TO_ORG_CODE
, SHIP_TO_ORG_CODE_EXT
, SHIP_TO_ORG_LOCATION
, SHIP_TO_ORG_LOCATION_EXT
, SHIP_TO_ORG_ADDRESS_LINE_1
, SHIP_TO_ORG_ADDRESS_LINE_2
, SHIP_TO_ORG_ADDRESS_LINE_3
, SHIP_TO_ORG_CITY
, SHIP_TO_ORG_REGION_1
, SHIP_TO_ORG_REGION_1_EXT
, SHIP_TO_ORG_REGION_3
, SHIP_TO_ORG_REGION_3_EXT
, SHIP_TO_ORG_REGION_2
, SHIP_TO_ORG_REGION_2_EXT
, SHIP_TO_ORG_COUNTRY
, SHIP_TO_ORG_COUNTRY_EXT
, SHIP_TO_ORG_POSTAL_CODE
, SHIP_TO_ORG_TELEPHONE
, SUPPLIER_NAME
, SUPPLIER_SITE_ADDRESS_LINE_4
, SUPPLIER_NUMBER
, SUPPLIER_NUMBER_EXT
, SUPPLIER_SITE_CODE
, SUPPLIER_SITE_CODE_EXT
, SUPPLIER_SITE_ADDRESS_LINE_1
, SUPPLIER_SITE_ADDRESS_LINE_2
, SUPPLIER_SITE_ADDRESS_LINE_3
, SUPPLIER_SITE_CITY
, SUPPLIER_SITE_STATE
, SUPPLIER_SITE_STATE_EXT
, SUPPLIER_SITE_POSTAL_CODE
, SUPPLIER_SITE_PROVINCE
, SUPPLIER_SITE_PROVINCE_EXT
, SUPPLIER_SITE_COUNTRY
, SUPPLIER_SITE_COUNTRY_EXT
, SUPPLIER_SITE_AREA_CODE
, SUPPLIER_SITE_TELEPHONE
, SCH_HEADER_ATTRIBUTE_CATEGORY
, SCH_HEADER_ATTRIBUTE1
, SCH_HEADER_ATTRIBUTE2
, SCH_HEADER_ATTRIBUTE3
, SCH_HEADER_ATTRIBUTE4
, SCH_HEADER_ATTRIBUTE5
, SCH_HEADER_ATTRIBUTE6
, SCH_HEADER_ATTRIBUTE7
, SCH_HEADER_ATTRIBUTE8
, SCH_HEADER_ATTRIBUTE9
, SCH_HEADER_ATTRIBUTE10
, SCH_HEADER_ATTRIBUTE11
, SCH_HEADER_ATTRIBUTE12
, SCH_HEADER_ATTRIBUTE13
, SCH_HEADER_ATTRIBUTE14
, SCH_HEADER_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_ATTRIBUTE_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
, SHIP_ORG_ATTRIBUTE_CATEGORY
, SHIP_ORG_ATTRIBUTE1
, SHIP_ORG_ATTRIBUTE2
, SHIP_ORG_ATTRIBUTE3
, SHIP_ORG_ATTRIBUTE4
, SHIP_ORG_ATTRIBUTE5
, SHIP_ORG_ATTRIBUTE6
, SHIP_ORG_ATTRIBUTE7
, SHIP_ORG_ATTRIBUTE8
, SHIP_ORG_ATTRIBUTE9
, SHIP_ORG_ATTRIBUTE10
, SHIP_ORG_ATTRIBUTE11
, SHIP_ORG_ATTRIBUTE12
, SHIP_ORG_ATTRIBUTE13
, SHIP_ORG_ATTRIBUTE14
, SHIP_ORG_ATTRIBUTE15
, ORG_OPT_ATTRIBUTE_CATEGORY
, ORG_OPT_ATTRIBUTE1
, ORG_OPT_ATTRIBUTE2
, ORG_OPT_ATTRIBUTE3
, ORG_OPT_ATTRIBUTE4
, ORG_OPT_ATTRIBUTE5
, ORG_OPT_ATTRIBUTE6
, ORG_OPT_ATTRIBUTE7
, ORG_OPT_ATTRIBUTE8
, ORG_OPT_ATTRIBUTE9
, ORG_OPT_ATTRIBUTE10
, ORG_OPT_ATTRIBUTE11
, ORG_OPT_ATTRIBUTE12
, ORG_OPT_ATTRIBUTE13
, ORG_OPT_ATTRIBUTE14
, ORG_OPT_ATTRIBUTE15
, 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
, RUN_ID
, TRANSACTION_RECORD_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, DOCUMENT_STANDARD
, MAP_ID
FROM EC.ECE_SPSO_HEADERS;
EC.ECE_SPSO_HEADERS does not reference any database object
EC.ECE_SPSO_HEADERS is referenced by following:
APPS
ECE_SPSO_HEADERS
|
|
|
|