[Home] [Help] [Dependency Information]

TABLE: EC.ECE_ADVO_HEADERS_INTERFACE

Object Details

Object Name:	ECE_ADVO_HEADERS_INTERFACE
Object Type:	TABLE
Owner:	EC
FND Design Data:	EC.ECE_ADVO_HEADERS_INTERFACE
Subobject Name:
Status:	VALID

ECE_ADVO_HEADERS_INTERFACE contains the data to support the outbound
Application Advice (824/APERAK) transaction.
ECE_ADVO_HEADERS_INTERFACE is based on data stored in
ECE_ADVO_HEADERS.
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.
Each row in ECE_ADVO_HEADERS_INTERFACE is purged after the data is
written to the data file.
TRANSACTION_RECORD_ID is the unique key that links the
ECE_ADVO_HEADERS_INTERFACE table to its corresponding extension table
ECE_ADVO_HEADERS_INTERFACE_X.
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:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ECE_ADVO_HEADERS_INTERFACE_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	ADVICE_HEADER_ID RUN_ID

Columns

Query Text

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

SELECT ADVICE_HEADER_ID
,      COMMUNICATION_METHOD
,      TP_TEST_FLAG
,      TP_DOCUMENT_ID
,      DOCUMENT_TYPE
,      DOCUMENT_CODE
,      DOCUMENT_PURPOSE_CODE
,      TP_ENTITY_TYPE
,      TP_TRANSLATOR_CODE
,      TP_LOCATION_CODE_EXT
,      TP_DESCRIPTION
,      TP_REFERENCE_EXT1
,      TP_REFERENCE_EXT2
,      TRANSACTION_DATE
,      RUN_ID
,      TRANSACTION_CONTROL1
,      TRANSACTION_CONTROL2
,      TRANSACTION_CONTROL3
,      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
,      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_CODE_INTERNAL
,      TP_CODE_EXTERNAL
,      TP_NAME
,      TP_ADDRESS1
,      TP_ADDRESS2
,      TP_ADDRESS3
,      TP_ADDRESS4
,      TP_CITY
,      TP_POSTAL_CODE
,      TP_COUNTRY_INT
,      TP_COUNTRY_EXT
,      TP_STATE_INT
,      TP_STATE_EXT
,      TP_PROVINCE_INT
,      TP_PROVINCE_EXT
,      TP_COUNTY_INT
,      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
,      SECURITY_GROUP_ID
FROM EC.ECE_ADVO_HEADERS_INTERFACE;

Dependencies

[top of page]

EC.ECE_ADVO_HEADERS_INTERFACE does not reference any database object

EC.ECE_ADVO_HEADERS_INTERFACE is referenced by following:

APPS

ECE_ADVO_HEADERS_INTERFACE