[Home] [Help] [Dependency Information]
Object Name: | MSC_PLAN_SCHEDULES |
---|---|
Object Type: | TABLE |
Owner: | MSC |
FND Design Data: | MSC.MSC_PLAN_SCHEDULES |
Subobject Name: | |
Status: | VALID |
This table stores master production schedules and master demand schedules for the planning process in an organization. This table is also used to store the input production schedule name
for In line vehicle sequencing (ILVS) on Oracle Supply Chain Hub.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MSC_PLAN_SCHEDULES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PLAN_ID
ORGANIZATION_ID SR_INSTANCE_ID INPUT_SCHEDULE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PLAN_ID | NUMBER | Yes | Plan identifier | |
ORGANIZATION_ID | NUMBER | Yes | Organization identifier | |
INPUT_SCHEDULE_ID | NUMBER | Yes | Input schedule identifier | |
SR_INSTANCE_ID | NUMBER | Yes | Source application instance identifier | |
INPUT_TYPE | NUMBER | Yes | Schedule type. MDS or MPS | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
REQUEST_ID | NUMBER | Concurrent Who column | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent Who column | ||
PROGRAM_ID | NUMBER | Concurrent Who column | ||
PROGRAM_UPDATE_DATE | DATE | Concurrent Who column | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
DESIGNATOR_TYPE | NUMBER | Yes | Designator type | |
INTERPLANT_DEMAND_FLAG | NUMBER | Interplant demand flag | ||
SCENARIO_SET | NUMBER | Scenario Set | ||
PROBABILITY | NUMBER | Probability | ||
DEMAND_VARIABILITY_TYPE | NUMBER | Demand variability type used for arriving at demand variability | ||
MAPE_VALUE | NUMBER | Mean Absolute forecast Percentage forecast error | ||
SHIP_TO | NUMBER | The level at which forecast will get consumed | ||
INCLUDE_TARGET_DEMANDS | NUMBER | Include targets - yes or no | ||
INCLUDE_PO | NUMBER | Include PO, 1-Yes, 2-No | ||
INCLUDE_PLN_ORD | NUMBER | 1 yes, 2 No. Populated for ds plan schedule ASCP plan |
Cut, paste (and edit) the following text to query this object:
SELECT PLAN_ID
, ORGANIZATION_ID
, INPUT_SCHEDULE_ID
, SR_INSTANCE_ID
, INPUT_TYPE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, DESIGNATOR_TYPE
, INTERPLANT_DEMAND_FLAG
, SCENARIO_SET
, PROBABILITY
, DEMAND_VARIABILITY_TYPE
, MAPE_VALUE
, SHIP_TO
, INCLUDE_TARGET_DEMANDS
, INCLUDE_PO
, INCLUDE_PLN_ORD
FROM MSC.MSC_PLAN_SCHEDULES;
MSC.MSC_PLAN_SCHEDULES does not reference any database object
MSC.MSC_PLAN_SCHEDULES is referenced by following:
|
|
|