DBA Data[Home] [Help] [Dependency Information]

TABLE: EC.ECE_ADVO_HEADERS

Object Details
Object Name: ECE_ADVO_HEADERS
Object Type: TABLE
Owner: EC
FND Design Data: TableEC.ECE_ADVO_HEADERS
Subobject Name:
Status: VALID


ECE_ADVO_HEADERS contains transaction status data reported by Oracle
Payables and Oracle Purchasing for the following inbound EDI
transactions in Release 11i: Invoice (810/INVOIC), Ship Notice/Manifest
(856/DESADV), and Shipment and Billing Notice (857).

Included in this table is data on the trading partner, inbound transactions
or transaction types reported an error, and the date the EDI transaction
was processed. This table is designed to support all EDI transactions
added in a future product releases.

For Release 11i, ECE_ADVO_HEADERS is populated by the following
application open interfaces:
{{"bul:1"}}Payables Open Interface Import in Oracle Payables for all
inbound Invoice (810/INVOIC) errors
{{"bul:1"}}Receiving Open Interface in Oracle Purchasing for all
inbound Ship Notice/Manifest (856/DESADV) errors
{{"bul:1"}}Receiving Open Interface in Oracle Purchasing for all
inbound Shipment and Billing Notice (857) errors.

{{"bodytext"}}ADVICE_HEADER_ID is the unique system-generated primary
key that is invisible to the user.

EXTERNAL_REFERENCE (1-6) and INTERNAL_REFERENCE (1-6) each represents
up to six key values to uniquely identify the EDI document.

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.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ECE_ADVO_HEADERS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnADVICE_HEADER_ID
Columns
Name Datatype Length Mandatory Comments
ADVICE_HEADER_ID NUMBER
Yes Advice Header ID
TP_HEADER_ID NUMBER

Trading Partner Header ID
COMMUNICATION_METHOD VARCHAR2 (20)
Communication Method
DOCUMENT_TYPE VARCHAR2 (25)
Document Type
DOCUMENT_CODE VARCHAR2 (2)
Document Code
TRANSACTION_DATE DATE

Transaction Date/Time
TRANSACTION_CONTROL1 VARCHAR2 (10)
Transaction Control 1
TRANSACTION_CONTROL2 VARCHAR2 (10)
Transaction Control 2
TRANSACTION_CONTROL3 VARCHAR2 (10)
Transaction Control 3
EDI_PROCESSED_FLAG VARCHAR2 (1)
EDI Processed Flag
EDI_PROCESS_DATE DATE

EDI Date Processed
RELATED_DOCUMENT_ID VARCHAR2 (6)
Related Document ID
EXTERNAL_REFERENCE1 VARCHAR2 (80)
Advice External Reference 1
EXTERNAL_REFERENCE2 VARCHAR2 (80)
Advice External Reference 2
EXTERNAL_REFERENCE3 VARCHAR2 (80)
Advice External Reference 3
EXTERNAL_REFERENCE4 VARCHAR2 (80)
Advice External Reference 4
EXTERNAL_REFERENCE5 VARCHAR2 (80)
Advice External Reference 5
EXTERNAL_REFERENCE6 VARCHAR2 (80)
Advice External Reference 6
INTERNAL_REFERENCE1 VARCHAR2 (80)
Advice Internal Reference 1
INTERNAL_REFERENCE2 VARCHAR2 (80)
Advice Internal Reference 2
INTERNAL_REFERENCE3 VARCHAR2 (80)
Advice Internal Reference 3
INTERNAL_REFERENCE4 VARCHAR2 (80)
Advice Internal Reference 4
INTERNAL_REFERENCE5 VARCHAR2 (80)
Advice Internal Reference 5
INTERNAL_REFERENCE6 VARCHAR2 (80)
Advice Internal Reference 6
TP_LOCATION_CODE_EXT VARCHAR2 (35)
Trading Partner Location Code
TP_ENTITY_TYPE VARCHAR2 (30)
Trading Partner Entity Type
TP_CODE VARCHAR2 (240)
Trading Partner Code
TP_NAME VARCHAR2 (50)
Trading Partner Customer Name
TP_ADDRESS1 VARCHAR2 (240)
Trading Partner Address 1
TP_ADDRESS2 VARCHAR2 (240)
Trading Partner Address 2
TP_ADDRESS3 VARCHAR2 (240)
Trading Partner Address 3
TP_ADDRESS4 VARCHAR2 (240)
Trading Partner Address 4
TP_CITY VARCHAR2 (60)
Trading Partner City
TP_POSTAL_CODE VARCHAR2 (60)
Trading Partner Postal Code
TP_COUNTRY VARCHAR2 (60)
Trading Partner Country
TP_STATE VARCHAR2 (60)
Trading Partner State
TP_PROVINCE VARCHAR2 (60)
Trading Partner Province
TP_COUNTY VARCHAR2 (60)
Trading Partner County
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
SECURITY_GROUP_ID NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ADVICE_HEADER_ID
,      TP_HEADER_ID
,      COMMUNICATION_METHOD
,      DOCUMENT_TYPE
,      DOCUMENT_CODE
,      TRANSACTION_DATE
,      TRANSACTION_CONTROL1
,      TRANSACTION_CONTROL2
,      TRANSACTION_CONTROL3
,      EDI_PROCESSED_FLAG
,      EDI_PROCESS_DATE
,      RELATED_DOCUMENT_ID
,      EXTERNAL_REFERENCE1
,      EXTERNAL_REFERENCE2
,      EXTERNAL_REFERENCE3
,      EXTERNAL_REFERENCE4
,      EXTERNAL_REFERENCE5
,      EXTERNAL_REFERENCE6
,      INTERNAL_REFERENCE1
,      INTERNAL_REFERENCE2
,      INTERNAL_REFERENCE3
,      INTERNAL_REFERENCE4
,      INTERNAL_REFERENCE5
,      INTERNAL_REFERENCE6
,      TP_LOCATION_CODE_EXT
,      TP_ENTITY_TYPE
,      TP_CODE
,      TP_NAME
,      TP_ADDRESS1
,      TP_ADDRESS2
,      TP_ADDRESS3
,      TP_ADDRESS4
,      TP_CITY
,      TP_POSTAL_CODE
,      TP_COUNTRY
,      TP_STATE
,      TP_PROVINCE
,      TP_COUNTY
,      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
,      SECURITY_GROUP_ID
FROM EC.ECE_ADVO_HEADERS;

Dependencies

[top of page]

EC.ECE_ADVO_HEADERS does not reference any database object

EC.ECE_ADVO_HEADERS is referenced by following:

SchemaAPPS
SynonymECE_ADVO_HEADERS