[Home] [Help] [Dependency Information]
Object Name: | MSC_INT_SQL_EXTRACT# |
---|---|
Object Type: | VIEW |
Owner: | MSC |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
API_ID | VARCHAR2 | (30) | Yes | |
MODEL | VARCHAR2 | (30) | Yes | |
PACKAGE_NAME | VARCHAR2 | (30) | Yes | |
ENTITY_NAME | VARCHAR2 | (50) | Yes | |
EXECUTE_SEQUENCE | NUMBER | Yes | ||
POST_PROCESSOR | VARCHAR2 | (100) | ||
WHERE_CLAUSE | VARCHAR2 | (4000) | ||
COPY_TO_STRATEGIC_SQL | VARCHAR2 | (4000) | ||
EXTRACT_SQL | VARCHAR2 | (4000) | ||
DELETE_PLANNING_TARGET_SQL | VARCHAR2 | (4000) | ||
EXTRACT_SQL_FIRST_PART | VARCHAR2 | (4000) | ||
EXTRACT_SQL_SECOND_PART | VARCHAR2 | (4000) | ||
EXTRACT_SQL_THIRD_PART | VARCHAR2 | (4000) | ||
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#;
|
|
|