[Home] [Help] [Dependency Information]
Object Name: | MSC_ST_BIS_TARGET_LEVELS# |
---|---|
Object Type: | VIEW |
Owner: | MSC |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TARGET_LEVEL_ID | NUMBER | |||
TARGET_LEVEL_SHORT_NAME | VARCHAR2 | (80) | ||
TARGET_LEVEL_NAME | VARCHAR2 | (80) | ||
DESCRIPTION | VARCHAR2 | (240) | ||
MEASURE_ID | NUMBER | |||
ORG_LEVEL_ID | NUMBER | |||
TIME_LEVEL_ID | NUMBER | |||
DIMENSION1_LEVEL_ID | NUMBER | |||
DIMENSION2_LEVEL_ID | NUMBER | |||
DIMENSION3_LEVEL_ID | NUMBER | |||
DIMENSION4_LEVEL_ID | NUMBER | |||
DIMENSION5_LEVEL_ID | NUMBER | |||
WORKFLOW_ITEM_TYPE | VARCHAR2 | (8) | ||
WORKFLOW_PROCESS_SHORT_NAME | VARCHAR2 | (30) | ||
DEFAULT_NOTIFY_RESP_ID | NUMBER | |||
DEFAULT_NOTIFY_RESP_SHORT_NAME | VARCHAR2 | (100) | ||
COMPUTING_FUNCTION_ID | NUMBER | |||
REPORT_FUNCTION_ID | NUMBER | |||
UNIT_OF_MEASURE | VARCHAR2 | (25) | ||
SYSTEM_FLAG | VARCHAR2 | (1) | ||
DELETED_FLAG | NUMBER | |||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | |||
CREATION_DATE | DATE | |||
CREATED_BY | NUMBER | |||
LAST_UPDATE_LOGIN | NUMBER | |||
REQUEST_ID | NUMBER | |||
PROGRAM_APPLICATION_ID | NUMBER | |||
PROGRAM_ID | NUMBER | |||
PROGRAM_UPDATE_DATE | DATE | |||
REFRESH_ID | NUMBER | |||
SR_INSTANCE_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT TARGET_LEVEL_ID
, TARGET_LEVEL_SHORT_NAME
, TARGET_LEVEL_NAME
, DESCRIPTION
, MEASURE_ID
, ORG_LEVEL_ID
, TIME_LEVEL_ID
, DIMENSION1_LEVEL_ID
, DIMENSION2_LEVEL_ID
, DIMENSION3_LEVEL_ID
, DIMENSION4_LEVEL_ID
, DIMENSION5_LEVEL_ID
, WORKFLOW_ITEM_TYPE
, WORKFLOW_PROCESS_SHORT_NAME
, DEFAULT_NOTIFY_RESP_ID
, DEFAULT_NOTIFY_RESP_SHORT_NAME
, COMPUTING_FUNCTION_ID
, REPORT_FUNCTION_ID
, UNIT_OF_MEASURE
, SYSTEM_FLAG
, DELETED_FLAG
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REFRESH_ID
, SR_INSTANCE_ID
FROM MSC.MSC_ST_BIS_TARGET_LEVELS#;
|
|
|