[Home] [Help] [Dependency Information]
Object Name: | MSC_PLAN_RUNS# |
---|---|
Object Type: | VIEW |
Owner: | MSC |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PLAN_ID | NUMBER | Yes | ||
PLAN_RUN_ID | NUMBER | Yes | ||
PLAN_RUN_NAME | VARCHAR2 | (100) | ||
PLAN_COMPLETION_DATE | DATE | |||
LAST_RUN_FLAG | NUMBER | Yes | ||
ARCHIVE_FLAG | NUMBER | Yes | ||
PLANNING_HUB_FLAG | NUMBER | Yes | ||
START_DATE | DATE | Yes | ||
END_DATE | DATE | |||
CREATED_BY | NUMBER | Yes | ||
CREATION_DATE | DATE | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | Yes | ||
PROGRAM_ID | NUMBER | |||
PROGRAM_LOGIN_ID | NUMBER | |||
PROGRAM_APPLICATION_ID | NUMBER | |||
REQUEST_ID | NUMBER | |||
PLAN_TYPE | NUMBER | |||
SR_INSTANCE_ID | NUMBER | |||
ORGANIZATION_ID | NUMBER | |||
PLAN_NAME | VARCHAR2 | (50) | ||
PLAN_DESCRIPTION | VARCHAR2 | (100) | ||
PLAN_START_DATE | DATE | |||
PLAN_CUTOFF_DATE | DATE | |||
LOCAL_ARCHIVE_FLAG | NUMBER | |||
LCID | NUMBER | |||
REFRESH_MODE | NUMBER | |||
PLAN_RUN_VERSION | NUMBER | |||
TEMP_TRANSFER_ID | NUMBER | |||
PUBLISHER | VARCHAR2 | (200) | ||
SCENARIO_NAME | VARCHAR2 | (100) |
Cut, paste (and edit) the following text to query this object:
SELECT PLAN_ID
, PLAN_RUN_ID
, PLAN_RUN_NAME
, PLAN_COMPLETION_DATE
, LAST_RUN_FLAG
, ARCHIVE_FLAG
, PLANNING_HUB_FLAG
, START_DATE
, END_DATE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PROGRAM_ID
, PROGRAM_LOGIN_ID
, PROGRAM_APPLICATION_ID
, REQUEST_ID
, PLAN_TYPE
, SR_INSTANCE_ID
, ORGANIZATION_ID
, PLAN_NAME
, PLAN_DESCRIPTION
, PLAN_START_DATE
, PLAN_CUTOFF_DATE
, LOCAL_ARCHIVE_FLAG
, LCID
, REFRESH_MODE
, PLAN_RUN_VERSION
, TEMP_TRANSFER_ID
, PUBLISHER
, SCENARIO_NAME
FROM MSC.MSC_PLAN_RUNS#;
|
|
|