[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: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MSC_PLAN_RUNS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | PLAN_RUN_ID |
MSC_PLAN_RUNS_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PLAN_ID
PLAN_RUN_ID |
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 |
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
FROM MSC.MSC_PLAN_RUNS;
MSC.MSC_PLAN_RUNS does not reference any database object
MSC.MSC_PLAN_RUNS is referenced by following:
|
|
|