[Home] [Help] [Dependency Information]
Object Name: | MSC_INT_SQL_EXTRACT |
---|---|
Object Type: | TABLE |
Owner: | MSC |
Subobject Name: | |
Status: | VALID |
PS/SNO Integration table that stores the list of SQL statements in the order of execution
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MSC_INT_SQL_EXTRACT_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
API_ID
MODEL PACKAGE_NAME ENTITY_NAME EXECUTE_SEQUENCE 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 |
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 |
EXECUTE_SEQUENCE | NUMBER | Yes | The sequence in which the insert statements are fired during the refresh/publish process | |
POST_PROCESSOR | VARCHAR2 | (100) | The process that should be fired at the end of each refresh process | |
WHERE_CLAUSE | VARCHAR2 | (4000) | Where clause of the insert statement | |
COPY_TO_STRATEGIC_SQL | VARCHAR2 | (4000) | SQL statements specific to SNO plans | |
EXTRACT_SQL | VARCHAR2 | (4000) | ||
DELETE_PLANNING_TARGET_SQL | VARCHAR2 | (4000) | Specifies whether the target tables should be deleted or not | |
EXTRACT_SQL_FIRST_PART | VARCHAR2 | (4000) | First part of the actual insert/select statement | |
EXTRACT_SQL_SECOND_PART | VARCHAR2 | (4000) | Second part of the actual insert/select statement | |
EXTRACT_SQL_THIRD_PART | VARCHAR2 | (4000) | Third part of the actual insert/select statement | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT API_ID
, MODEL
, PACKAGE_NAME
, ENTITY_NAME
, EXECUTE_SEQUENCE
, POST_PROCESSOR
, WHERE_CLAUSE
, COPY_TO_STRATEGIC_SQL
, EXTRACT_SQL
, DELETE_PLANNING_TARGET_SQL
, EXTRACT_SQL_FIRST_PART
, EXTRACT_SQL_SECOND_PART
, EXTRACT_SQL_THIRD_PART
, ZD_EDITION_NAME
FROM MSC.MSC_INT_SQL_EXTRACT;
MSC.MSC_INT_SQL_EXTRACT does not reference any database object
MSC.MSC_INT_SQL_EXTRACT is referenced by following:
|
|
|