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


TABLE: MSC.MSC_INT_MODEL_NAVIGATION

Object Details
Object Name: MSC_INT_MODEL_NAVIGATION
Object Type: TABLE
Owner: MSC
Subobject Name:
Status: VALID


PS/SNO Integration table that is used to generate the XML files during serialization


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
API_ID VARCHAR2 (30) Yes API ID of the packages
MODEL VARCHAR2 (30) Yes Name of the XML model
PACKAGE_NAME VARCHAR2 (30) Yes Name of the package that together makes the XML files
PARENT_TABLE VARCHAR2 (50) Yes PS/SNO Integration table name that stores the header records for the XML files
TABLE_NAME VARCHAR2 (50) Yes PS/SNO Integration table name that stores the detail records for the XML files
POSITION NUMBER
Yes Position ID of each detail record
TV_TABLE_TYPE VARCHAR2 (30)
TV table that has the Time Varrying records for the XML files
Query Text

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


SELECT API_ID
,      MODEL
,      PACKAGE_NAME
,      PARENT_TABLE
,      TABLE_NAME
,      POSITION
,      TV_TABLE_TYPE
FROM MSC.MSC_INT_MODEL_NAVIGATION;

Dependencies

[top of page]

MSC.MSC_INT_MODEL_NAVIGATION does not reference any database object

MSC.MSC_INT_MODEL_NAVIGATION is referenced by following:

SchemaAPPS
SynonymMSC_INT_MODEL_NAVIGATION