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

TABLE: EC.ECE_INTERFACE_COLS_UPG

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

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
STAGING_COLUMN VARCHAR2 (50)
INTERFACE_COLUMN_ID NUMBER
Yes Interface Column Id
INTERFACE_TABLE_ID NUMBER

Interface Table Id
INTERFACE_COLUMN_NAME VARCHAR2 (50)
Interface Column Name
BASE_TABLE_NAME VARCHAR2 (50)
Base Table Name
BASE_COLUMN_NAME VARCHAR2 (50)
Base Column Name
TABLE_NAME VARCHAR2 (50)
Table Name
COLUMN_NAME VARCHAR2 (50)
Column Name
RECORD_NUMBER NUMBER

Internal Record Number
POSITION NUMBER

Position of Attribute Value
WIDTH NUMBER

Length of Attribute
CONVERSION_SEQUENCE NUMBER

Conversion Sequence
DATA_TYPE VARCHAR2 (20)
Attrribute's Data Type
CONVERSION_GROUP_ID NUMBER

Conversion Group Id
XREF_CATEGORY_ALLOWED VARCHAR2 (1)
Cross-Reference Category Allowed
XREF_CATEGORY_ID NUMBER

Cross-Reference Category Id
XREF_KEY1_SOURCE_COLUMN VARCHAR2 (30)
Cross-Reference Source Column - Key 1
XREF_KEY2_SOURCE_COLUMN VARCHAR2 (30)
Cross-Reference Source Column - Key 2
XREF_KEY3_SOURCE_COLUMN VARCHAR2 (30)
Cross-Reference Source Column - Key 3
XREF_KEY4_SOURCE_COLUMN VARCHAR2 (30)
Cross-Reference Source Column - Key 4
XREF_KEY5_SOURCE_COLUMN VARCHAR2 (30)
Cross-Reference Source Column - Key 5
RECORD_LAYOUT_CODE VARCHAR2 (30)
Record Layout Code
RECORD_LAYOUT_QUALIFIER VARCHAR2 (30)
Record Layout Qualifier
DATA_LOC_ID NUMBER

Data Location Id
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
EXTERNAL_LEVEL NUMBER (15)
MAP_ID NUMBER (15)
ELEMENT_TAG_NAME VARCHAR2 (80)
Query Text

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


SELECT STAGING_COLUMN
,      INTERFACE_COLUMN_ID
,      INTERFACE_TABLE_ID
,      INTERFACE_COLUMN_NAME
,      BASE_TABLE_NAME
,      BASE_COLUMN_NAME
,      TABLE_NAME
,      COLUMN_NAME
,      RECORD_NUMBER
,      POSITION
,      WIDTH
,      CONVERSION_SEQUENCE
,      DATA_TYPE
,      CONVERSION_GROUP_ID
,      XREF_CATEGORY_ALLOWED
,      XREF_CATEGORY_ID
,      XREF_KEY1_SOURCE_COLUMN
,      XREF_KEY2_SOURCE_COLUMN
,      XREF_KEY3_SOURCE_COLUMN
,      XREF_KEY4_SOURCE_COLUMN
,      XREF_KEY5_SOURCE_COLUMN
,      RECORD_LAYOUT_CODE
,      RECORD_LAYOUT_QUALIFIER
,      DATA_LOC_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      EXTERNAL_LEVEL
,      MAP_ID
,      ELEMENT_TAG_NAME
FROM EC.ECE_INTERFACE_COLS_UPG;

Dependencies

[top of page]

EC.ECE_INTERFACE_COLS_UPG does not reference any database object

EC.ECE_INTERFACE_COLS_UPG is referenced by following:

SchemaEC
ViewECE_INTERFACE_COLS_UPG#