[Home] [Help] [Dependency Information]
Object Name: | MSC_INT_TABLE_MAP |
---|---|
Object Type: | TABLE |
Owner: | MSC |
Subobject Name: | |
Status: | VALID |
PS/SNO Integration table that translates tables of more than 30 chars to a short name
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MSC_INT_TABLE_MAP_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
API_ID
MODEL ENTITY_NAME ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
API_ID | VARCHAR2 | (30) | Yes | API ID of the packages |
MODEL | VARCHAR2 | (30) | Yes | Name of the XML model |
ENTITY_NAME | VARCHAR2 | (100) | Yes | Name of the entity name that makes the model |
TABLE_NAME | VARCHAR2 | (50) | Actual PS/SNO Integration table name | |
TV_TABLE_NAME | VARCHAR2 | (100) | The equivalent TV table for SNO Integration table | |
MEMBER_TABLE_NAME | VARCHAR2 | (100) | The equivalent member SNO table for SNO Integration table | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT API_ID
, MODEL
, ENTITY_NAME
, TABLE_NAME
, TV_TABLE_NAME
, MEMBER_TABLE_NAME
, ZD_EDITION_NAME
FROM MSC.MSC_INT_TABLE_MAP;
MSC.MSC_INT_TABLE_MAP does not reference any database object
MSC.MSC_INT_TABLE_MAP is referenced by following:
|
|
|