eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: EC.ECE_ADVO_DETAILS_INTERFACE

Object Details

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

ECE_ADVO_DETAILS_INTERFACE contains the data to support the outbound
Application Advice (824/APERAK) transaction.

ECE_ADVO_DETAILS_INTERFACE is based on data stored in
ECE_ADVO_DETAILS.

ADVICE_DETAIL_ID is the unique system-generated primary key that is
invisible to the user. ADVICE_HEADER_ID is a foreign key to
ECE_ADVO_HEADERS_INTERFACE.

Each ECE_ADVO_DETAILS_INTERFACE row is associated with one row in
ECE_ADVO_HEADERS_INTERFACE. There is a one-to-many relationship
between ECE_ADVO_HEADERS_INTERFACE and ECE_ADVO_DETAILS_INTERFACE.

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_DETAILS_INTERFACE is purged after the data is
written to the data file.

TRANSACTION_RECORD_ID is the unique key that links the
ECE_ADVO_DETAILS_INTERFACE table to its corresponding extension table
ECE_ADVO_DETAILS_INTERFACE_X.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ECE_ADVO_DETAILS_INTERFACE_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	RUN_ID ADVICE_DETAIL_ID

Columns

Name	Datatype	Length	Mandatory	Comments
RUN_ID	NUMBER		Yes	Run ID
ADVICE_DETAIL_ID	NUMBER		Yes	Advice Detail ID
ADVICE_HEADER_ID	NUMBER			Advice Header ID
ADVO_DATE_TIME	DATE			Advice Date/Time
ADVO_STATUS_CODE	VARCHAR2	(30)		Advice Status
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
ADVO_MESSAGE_CODE	VARCHAR2	(30)		Advice Message Code
ADVO_MESSAGE_DESC	VARCHAR2	(240)		Advice Message Description
ADVO_DATA_BAD	VARCHAR2	(240)		Advice Data - Bad
ADVO_DATA_GOOD	VARCHAR2	(240)		Advice Data - Good
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
SECURITY_GROUP_ID	NUMBER

Query Text

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


SELECT RUN_ID
,      ADVICE_DETAIL_ID
,      ADVICE_HEADER_ID
,      ADVO_DATE_TIME
,      ADVO_STATUS_CODE
,      EXTERNAL_REFERENCE1
,      EXTERNAL_REFERENCE2
,      EXTERNAL_REFERENCE3
,      EXTERNAL_REFERENCE4
,      EXTERNAL_REFERENCE5
,      EXTERNAL_REFERENCE6
,      INTERNAL_REFERENCE1
,      INTERNAL_REFERENCE2
,      INTERNAL_REFERENCE3
,      INTERNAL_REFERENCE4
,      INTERNAL_REFERENCE5
,      INTERNAL_REFERENCE6
,      ADVO_MESSAGE_CODE
,      ADVO_MESSAGE_DESC
,      ADVO_DATA_BAD
,      ADVO_DATA_GOOD
,      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
,      SECURITY_GROUP_ID
FROM EC.ECE_ADVO_DETAILS_INTERFACE;

Dependencies

[top of page]

EC.ECE_ADVO_DETAILS_INTERFACE does not reference any database object

EC.ECE_ADVO_DETAILS_INTERFACE is referenced by following:

APPS: ECE_ADVO_DETAILS_INTERFACE