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

TABLE: GCS.GCS_LEX_MAP_STRUCTS

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


GCS_LEX_MAP_STRUCTS defines the structures of tables that can be used as staging tables by the Interface Data Transformer. Each Transformation Rule Set must have a table structure associated with it. GCS_LEX_MAP_STRUCTS also keeps the list of tables that can be used as lookup tables.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GCS_LEX_MAP_STRUCTS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSTRUCTURE_ID
GCS_LEX_MAP_STRUCTS_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSTRUCTURE_NAME
ColumnTABLE_USE_TYPE_CODE
Columns
Name Datatype Length Mandatory Comments
STRUCTURE_ID NUMBER (15) Yes Table structure defining column
STRUCTURE_NAME VARCHAR2 (50) Yes Table structure name
TABLE_USE_TYPE_CODE VARCHAR2 (30) Yes Table use lookup
DESCRIPTION VARCHAR2 (240)
Table structure description
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 STRUCTURE_ID
,      STRUCTURE_NAME
,      TABLE_USE_TYPE_CODE
,      DESCRIPTION
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM GCS.GCS_LEX_MAP_STRUCTS;

Dependencies

[top of page]

GCS.GCS_LEX_MAP_STRUCTS does not reference any database object

GCS.GCS_LEX_MAP_STRUCTS is referenced by following:

SchemaAPPS
SynonymGCS_LEX_MAP_STRUCTS