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_XREF_DATA

Object Details

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

ECE_XREF_DATA contains information for code conversion values that
identify the external values for a given Oracle internal value and vice
versa. Each row represents a unique internal to external relationship.
Each row contains the category code, description, up to five search
key values, one internal value, and up to five external values.

XREF_DATA_ID is the unique system-generated primary key that is
invisible to the user. XREF_CATEGORY_ID is the foreign key
associated with ECE_XREF_CATEGORIES.

Each ECE_XREF_DATA row is associated with one row in
ECE_XREF_CATEGORIES. There is a one to many relationship between
ECE_XREF_CATEGORIES and ECE_XREF_DATA.

For outbound transactions, XREF_INT_VALUE represents the Oracle
internal value that may require code conversion to the equivalent
1-5 external values. XREF_KEY(1-5) represents the search key values
to apply to derive the external values given the internal value.
XREF_EXT_VALUE(1-5) represents the external values derived from
one internal Oracle value.
For inbound transactions, XREF_INT_VALUE represents the
Oracle internal value derived from applying code conversion to the 1-5
external values received from the trading partner transaction.
XREF_KEY (1-5) represents the search key values to apply to derive
the internal value given the 1-5 external values received from the
trading partner. XREF_EXT_VALUE(1-5) represents the external value
received from the trading partner to derive the one internal value.

You define new code conversion values using the Define Code Conversion
Values window.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ECE_XREF_DATA_U1	NORMAL	UNIQUE	APPS_TS_SEED	XREF_DATA_ID
ECE_XREF_DATA_N1	NORMAL	NONUNIQUE	APPS_TS_SEED	XREF_CATEGORY_ID XREF_DATA_ID XREF_KEY1 XREF_KEY2 XREF_KEY3 XREF_KEY4 XREF_KEY5
ECE_XREF_DATA_N2	NORMAL	NONUNIQUE	APPS_TS_SEED	XREF_CATEGORY_CODE DIRECTION XREF_KEY1 XREF_KEY2 XREF_KEY3 XREF_KEY4 XREF_KEY5
ECE_XREF_DATA_N3	NORMAL	NONUNIQUE	APPS_TS_SEED	XREF_CATEGORY_CODE XREF_EXT_VALUE1

Columns

Name	Datatype	Length	Mandatory	Comments
XREF_DATA_ID	NUMBER		Yes	Cross-Reference Data ID
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
XREF_CATEGORY_ID	NUMBER		Yes	Cross-Reference Category ID
DESCRIPTION	VARCHAR2	(80)		Cross-Reference Description
DIRECTION	VARCHAR2	(10)	Yes	Cross-Reference Direction
XREF_CATEGORY_CODE	VARCHAR2	(30)	Yes	Cross-Reference Category Code
XREF_INT_VALUE	VARCHAR2	(500)	Yes	Cross-Reference Value (Int)
XREF_EXT_VALUE1	VARCHAR2	(500)	Yes	Cross-Reference Value 1 (Ext)
XREF_KEY1	VARCHAR2	(30)		Cross-Reference Key 1
XREF_KEY2	VARCHAR2	(30)		Cross-Reference Key 2
XREF_KEY3	VARCHAR2	(30)		Cross-Reference Key 3
XREF_KEY4	VARCHAR2	(30)		Cross-Reference Key 4
XREF_KEY5	VARCHAR2	(30)		Cross-Reference Key 5
XREF_EXT_VALUE2	VARCHAR2	(500)		Cross-Reference Value 2 (Ext)
XREF_EXT_VALUE3	VARCHAR2	(500)		Cross-Reference Value 3 (Ext)
XREF_EXT_VALUE4	VARCHAR2	(500)		Cross-Reference Value 4 (Ext)
XREF_EXT_VALUE5	VARCHAR2	(500)		Cross-Reference Value 5 (Ext)
LAST_UPDATE_LOGIN	NUMBER			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

Query Text

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


SELECT XREF_DATA_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      XREF_CATEGORY_ID
,      DESCRIPTION
,      DIRECTION
,      XREF_CATEGORY_CODE
,      XREF_INT_VALUE
,      XREF_EXT_VALUE1
,      XREF_KEY1
,      XREF_KEY2
,      XREF_KEY3
,      XREF_KEY4
,      XREF_KEY5
,      XREF_EXT_VALUE2
,      XREF_EXT_VALUE3
,      XREF_EXT_VALUE4
,      XREF_EXT_VALUE5
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM EC.ECE_XREF_DATA;

Dependencies

[top of page]

EC.ECE_XREF_DATA does not reference any database object

EC.ECE_XREF_DATA is referenced by following:

APPS: ECE_XREF_DATA