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

TABLE: MSC.MSC_INT_OITABLE_CREATE

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


PS/SNO Integration table that stores the list of temp table names associated with Package and Entity names


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MSC_INT_OITABLE_CREATE_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnAPI_ID
ColumnMODEL
ColumnPACKAGE_NAME
ColumnENTITY_NAME
ColumnCREATE_SEQUENCE
ColumnZD_EDITION_NAME
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
ENTITY_NAME VARCHAR2 (50) Yes Name of the entity name that makes the model
CREATE_SEQUENCE NUMBER
Yes Sequence in which the insert statements are fired during the Refresh process
TABLE_NAME VARCHAR2 (50)
Name of the PS/SNO Integration table
CREATETABLE_SQL VARCHAR2 (4000)
Create statement to create PS/SNO table
XML_TAG VARCHAR2 (50)
Column to hold the second half of the Oracle statement when the length is more than 4000 chars
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

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


SELECT API_ID
,      MODEL
,      PACKAGE_NAME
,      ENTITY_NAME
,      CREATE_SEQUENCE
,      TABLE_NAME
,      CREATETABLE_SQL
,      XML_TAG
,      ZD_EDITION_NAME
FROM MSC.MSC_INT_OITABLE_CREATE;

Dependencies

[top of page]

MSC.MSC_INT_OITABLE_CREATE does not reference any database object

MSC.MSC_INT_OITABLE_CREATE is referenced by following:

SchemaMSC
ViewMSC_INT_OITABLE_CREATE#