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_INTERFACE_TABLES

Object Details

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

ECE_INTERFACE_TABLES contains information regarding the interface and
extension tables used to support each EDI transaction. Oracle
Applications source data to support EDI transactions is stored in
e-Commerce Gateway interface tables. Non-Oracle source data to support
EDI transactions is stored in e-Commerce Gateway extension tables that
require customization to implement. The e-Commerce Gateway
extensible architecture supports customizations to integrate with
non-Oracle data sources.

You need one row for each level of an EDI transaction. A level
represents a table within the specific transaction. These tables are
analogous to the base application tables such as header, line, and line
details. Each row contains the transaction type, interface table name,
and, if applicable, the extension table name.

INTERFACE_TABLE_ID is the unique system-generated primary key that is
invisible to the user.

Each transaction specific interface table row is associated with one
row in ECE_INTERFACE_TABLES. There is a one-to-one relationship
between ECE_INTERFACE_TABLES and transaction-specific interface
tables.

The data presented in a data file is represented in a hierarchical
structure. Each level of the structure is identified by a name stored
in the OUTPUT_LEVEL column.

START_NUMBER represents the beginning record number for each
OUTPUT_LEVEL of the transaction specific interface table (and
extension table, if applicable).

KEY_COLUMN_NAME contains the common key data for the data file. Data
file definitions are seeded for each transaction. You do not need to
create these definitions. However, you may use the Interface File
Definition window to change the seeded definitions.

TRANSACTION_TYPE and OUTPUT_LEVEL are used by the Interface File
Definition window to allow you to specify on which portion of the data
file definitions to focus. Data file definitions will need to include file
information for data in the extension tables if they are customized.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ECE_INTERFACE_TABLE_U1	NORMAL	UNIQUE	APPS_TS_SEED	INTERFACE_TABLE_ID
ECE_INTERFACE_TABLES_N1	NORMAL	NONUNIQUE	APPS_TS_SEED	TRANSACTION_TYPE OUTPUT_LEVEL

Columns

Name	Datatype	Length	Mandatory	Comments
INTERFACE_TABLE_ID	NUMBER		Yes	Interface Column ID
TRANSACTION_TYPE	VARCHAR2	(30)		EDI Transaction Type
FLATFILE_VERSION	NUMBER			Flatfile Version
OUTPUT_LEVEL	VARCHAR2	(30)		Output Level
DIRECTION	VARCHAR2	(3)		Transaction Direction
INTERFACE_TABLE_NAME	VARCHAR2	(50)		Interface Table Name
EXTENSION_TABLE_NAME	VARCHAR2	(50)		Extension Table Name
KEY_COLUMN_NAME	VARCHAR2	(50)		Key Column Name
START_NUMBER	NUMBER			Start Number
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	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
PRIMARY_ADDRESS_TYPE	VARCHAR2	(20)		Primary Address Type
INSTALLED_FLAG	VARCHAR2	(1)		Installed Flag
PARENT_LEVEL	NUMBER	(15)		Parent Level
MAP_ID	NUMBER	(15)		Map ID
ENABLED	VARCHAR2	(1)		Level Enabled Flag
UPGRADED_FLAG	VARCHAR2	(1)		Upgraded Flag

Query Text

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


SELECT INTERFACE_TABLE_ID
,      TRANSACTION_TYPE
,      FLATFILE_VERSION
,      OUTPUT_LEVEL
,      DIRECTION
,      INTERFACE_TABLE_NAME
,      EXTENSION_TABLE_NAME
,      KEY_COLUMN_NAME
,      START_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      PRIMARY_ADDRESS_TYPE
,      INSTALLED_FLAG
,      PARENT_LEVEL
,      MAP_ID
,      ENABLED
,      UPGRADED_FLAG
FROM EC.ECE_INTERFACE_TABLES;

Dependencies

[top of page]

EC.ECE_INTERFACE_TABLES does not reference any database object

EC.ECE_INTERFACE_TABLES is referenced by following:

APPS: ECE_INTERFACE_TABLES