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

TABLE: GCS.GCS_LEX_MAP_COLUMNS

Object Details
Object Name: GCS_LEX_MAP_COLUMNS
Object Type: TABLE
Owner: GCS
FND Design Data: TableGCS.GCS_LEX_MAP_COLUMNS
Subobject Name:
Status: VALID


GCS_LEX_MAP_COLUMNS stores the columns in the Interface Data Transformer table structures that are defined by GCS_LEX_MAP_STRUCTS. Each column can be read-only or read-write.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GCS_LEX_MAP_COLUMNS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCOLUMN_ID
GCS_LEX_MAP_COLUMNS_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSTRUCTURE_ID
ColumnCOLUMN_NAME
Columns
Name Datatype Length Mandatory Comments
COLUMN_ID NUMBER (15) Yes Staging table column defining column
STRUCTURE_ID NUMBER (15) Yes Staging table structure defining column
COLUMN_NAME VARCHAR2 (30) Yes Staging table column name
COLUMN_TYPE_CODE VARCHAR2 (30) Yes Data type stored by the column. This can be 'V' for VARCHAR2, 'N' for NUMBER, or 'D' for DATE
WRITE_FLAG VARCHAR2 (1) Yes Ability to write to staging table column flag
ERROR_CODE_COLUMN_FLAG VARCHAR2 (1) Yes Stores error codes in column flag
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
Query Text

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


SELECT COLUMN_ID
,      STRUCTURE_ID
,      COLUMN_NAME
,      COLUMN_TYPE_CODE
,      WRITE_FLAG
,      ERROR_CODE_COLUMN_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM GCS.GCS_LEX_MAP_COLUMNS;

Dependencies

[top of page]

GCS.GCS_LEX_MAP_COLUMNS does not reference any database object

GCS.GCS_LEX_MAP_COLUMNS is referenced by following:

SchemaAPPS
SynonymGCS_LEX_MAP_COLUMNS