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

TABLE: EC.ECE_XREF_CATEGORIES

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


ECE_XREF_CATEGORIES contains information for code conversion
categories. Each seeded code category occupies one row. You need one
row for each unique code category. Each row contains the category code
and description and up to five processing flags.

XREF_CATEGORY_ID is the unique system-generated primary key that is
invisible to the user. XREF_CATEGORY_CODE is the user defined
identifier for the code category.

KEY(1-5)_USED_FLAG represent search key enable flags. If a code
conversion applies to all trading partners and all EDI transactions, then
KEY_USED_FLAG fields do not enable. If the code conversion is meant
to be applied for a given rule, then enable as many KEY(1-5)_USED_FLAG
fields as needed to represent the code conversion rule.

INT_DATA_TABLE, INT_DATA_COLUMN, KEY(1-5)_USED_TABLE, and
KEY(1-5)_USED_COLUMN are for future use.

A set of commonly used code categories are seeded for your
convenience. You define new code categories using the Define Code
Conversion Categories form.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ECE_XREF_CATEGORIES_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnXREF_CATEGORY_ID
ECE_XREF_CATEGORIES_U2 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnXREF_CATEGORY_CODE
Columns
Name Datatype Length Mandatory Comments
XREF_CATEGORY_ID NUMBER
Yes Cross-Reference Category 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_CODE VARCHAR2 (30) Yes Cross-Reference Category Code
DESCRIPTION VARCHAR2 (80)
Cross-Reference Description
INT_DATA_TABLE VARCHAR2 (80)
Internal Data Table
INT_DATA_COLUMN VARCHAR2 (80)
Internal Data Column
KEY1_USED_FLAG VARCHAR2 (1) Yes Key 1 Used Flag
KEY2_USED_FLAG VARCHAR2 (1) Yes Key 2 Used Flag
KEY3_USED_FLAG VARCHAR2 (1) Yes Key 3 Used Flag
KEY4_USED_FLAG VARCHAR2 (1) Yes Key 4 Used Flag
KEY5_USED_FLAG VARCHAR2 (1) Yes Key 5 Used Flag
KEY1_USED_TABLE VARCHAR2 (80)
Key 1 Used Table
KEY1_USED_COLUMN VARCHAR2 (80)
Key 1 Used Column
KEY2_USED_TABLE VARCHAR2 (80)
Key 2 Used Table
KEY2_USED_COLUMN VARCHAR2 (80)
Key 2 Used Column
KEY3_USED_TABLE VARCHAR2 (80)
Key 3 Used Table
KEY3_USED_COLUMN VARCHAR2 (80)
Key 3 Used Column
KEY4_USED_TABLE VARCHAR2 (80)
Key 4 Used Table
KEY4_USED_COLUMN VARCHAR2 (80)
Key 4 Used Column
KEY5_USED_TABLE VARCHAR2 (80)
Key 5 Used Table
KEY5_USED_COLUMN VARCHAR2 (80)
Key 5 Used Column
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_CATEGORY_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      XREF_CATEGORY_CODE
,      DESCRIPTION
,      INT_DATA_TABLE
,      INT_DATA_COLUMN
,      KEY1_USED_FLAG
,      KEY2_USED_FLAG
,      KEY3_USED_FLAG
,      KEY4_USED_FLAG
,      KEY5_USED_FLAG
,      KEY1_USED_TABLE
,      KEY1_USED_COLUMN
,      KEY2_USED_TABLE
,      KEY2_USED_COLUMN
,      KEY3_USED_TABLE
,      KEY3_USED_COLUMN
,      KEY4_USED_TABLE
,      KEY4_USED_COLUMN
,      KEY5_USED_TABLE
,      KEY5_USED_COLUMN
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM EC.ECE_XREF_CATEGORIES;

Dependencies

[top of page]

EC.ECE_XREF_CATEGORIES does not reference any database object

EC.ECE_XREF_CATEGORIES is referenced by following:

SchemaAPPS
SynonymECE_XREF_CATEGORIES