[Home] [Help]
[Dependency Information]
Object Name: | MSC_PLAN_RUNS |
---|---|
Object Type: | TABLE |
Owner: | MSC |
Subobject Name: | |
Status: | VALID |
This table stores plan run information for Plan Archival and Planning Hub modules.
Tablespace: | ![]() |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MSC_PLAN_RUNS_U1 | NORMAL | UNIQUE |
![]() |
![]() |
MSC_PLAN_RUNS_U2 | NORMAL | UNIQUE |
![]() |
![]() ![]() |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PLAN_ID | NUMBER | Yes | Plan ID | |
PLAN_RUN_ID | NUMBER | Yes | Plan Run ID | |
PLAN_RUN_NAME | VARCHAR2 | (100) | Paln Run Name | |
PLAN_COMPLETION_DATE | DATE | Plan Completion Date | ||
LAST_RUN_FLAG | NUMBER | Yes | Last Run Flag | |
ARCHIVE_FLAG | NUMBER | Yes | Archive Flag | |
PLANNING_HUB_FLAG | NUMBER | Yes | Planning Hub Flag | |
START_DATE | DATE | Yes | Stat Date | |
END_DATE | DATE | End Date | ||
CREATED_BY | NUMBER | Yes | Standard Who Column | |
CREATION_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | Yes | Standard Who Column | |
PROGRAM_ID | NUMBER | Standard Who Column | ||
PROGRAM_LOGIN_ID | NUMBER | Standard Who Column | ||
PROGRAM_APPLICATION_ID | NUMBER | Standard Who Column | ||
REQUEST_ID | NUMBER | Standard Who Column | ||
PLAN_TYPE | NUMBER | Plan Type | ||
SR_INSTANCE_ID | NUMBER | Source instance ID | ||
ORGANIZATION_ID | NUMBER | Organization ID | ||
PLAN_NAME | VARCHAR2 | (50) | Plan name | |
PLAN_DESCRIPTION | VARCHAR2 | (100) | Plan description | |
PLAN_START_DATE | DATE | Plan start date | ||
PLAN_CUTOFF_DATE | DATE | Plan cutoff date | ||
LOCAL_ARCHIVE_FLAG | NUMBER | Local archive flag: 1:archived plan, 2:imported plan | ||
LCID | NUMBER | Last executed collection program number | ||
REFRESH_MODE | NUMBER | Refresh mode, 1:complete_refresh, 2:target_refresh | ||
PLAN_RUN_VERSION | NUMBER | Plan run version number | ||
TEMP_TRANSFER_ID | NUMBER | Temp transfer ID | ||
PUBLISHER | VARCHAR2 | (200) | Publisher | |
SCENARIO_NAME | VARCHAR2 | (100) | Plan run scenario name. |
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;
MSC.MSC_PLAN_RUNS does not reference any database object
MSC.MSC_PLAN_RUNS is referenced by following:
|
|
|