DBA Data[Home] [Help] [Dependency Information]

TABLE: MRP.MRP_PLANS

Object Details
Object Name: MRP_PLANS
Object Type: TABLE
Owner: MRP
FND Design Data: TableMRP.MRP_PLANS
Subobject Name:
Status: VALID


MRP_PLANS stores the settings that determine the behavior of the
planning process for a given plan name. Each row stores information
for a particular plan name.
.
There are two sets of columns for a given setting. The columns that
begin with "CURR" store the current value for that setting, or the
value that will be used the next time the plan is run. The
corresponding columns that do not begin with "CURR" store the setting
that was used the last time the plan was run. The values are copied
from the first set of columns to the second set during the Snapshot
and Planner processes.
.
The columns CURRENT_PLANNER_LEVEL and PLANNER_BATCH_NUMBER are used by
the Planner to coordinate the planning of items by the Planner Workers
running in parallel.
.
This table is populated by the Launch Planning Process form.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 20
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MRP_PLANS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCOMPILE_DESIGNATOR
ColumnORGANIZATION_ID
Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER
Yes Organization identifier
COMPILE_DESIGNATOR VARCHAR2 (10) Yes MPS, MRP or DRP plan identifier
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
CURR_SCHEDULE_DESIGNATOR VARCHAR2 (10)
Current schedule designator code
CURR_OPERATION_SCHEDULE_TYPE NUMBER
Yes Current lead time offset type
CURR_PLAN_TYPE NUMBER
Yes Current planning type code (MRP or MPS)
CURR_OVERWRITE_OPTION NUMBER
Yes Current value of whether to overwrite the existing plan
CURR_APPEND_PLANNED_ORDERS NUMBER
Yes Current value of whether or not to append planned orders at the the end of the plan
CURR_SCHEDULE_TYPE NUMBER

Current schedule type
CURR_CUTOFF_DATE DATE
Yes Current cutoff date
CURR_PART_INCLUDE_TYPE NUMBER
Yes Current include all parts on only msed
CURR_PLANNING_TIME_FENCE_FLAG NUMBER
Yes Current consider planning time fences
CURR_DEMAND_TIME_FENCE_FLAG NUMBER
Yes Current consider demand time fences
CURR_CONSIDER_RESERVATIONS NUMBER
Yes Current plan material reservations
CURR_PLAN_SAFETY_STOCK NUMBER
Yes Current plan safety stock
CURR_CONSIDER_WIP NUMBER
Yes Current consider work in process
CURR_CONSIDER_PO NUMBER
Yes Current consider purchase orders
CURR_SNAPSHOT_LOCK NUMBER
Yes Current value of the flag that determines whether the Snapshot tries to lock tables
COMPILE_DEFINITION_DATE DATE
Yes Compile definition date
SCHEDULE_DESIGNATOR VARCHAR2 (10)
Master schedule identifier
OPERATION_SCHEDULE_TYPE NUMBER

Lead time offset type
PLAN_TYPE NUMBER

Planning type code (MRP or MPS)
OVERWRITE_OPTION NUMBER

Whether to overwrite the existing plan
APPEND_PLANNED_ORDERS NUMBER

Whether or not to append planned orders at the the end of the plan
SCHEDULE_TYPE NUMBER

Schedule type
CUTOFF_DATE DATE

Cutoff date
PART_INCLUDE_TYPE NUMBER

Include all parts on only msed
PLANNING_TIME_FENCE_FLAG NUMBER

Consider planning time fences
DEMAND_TIME_FENCE_FLAG NUMBER

Consider demand time fences
CONSIDER_RESERVATIONS NUMBER

Plan material reservations
PLAN_SAFETY_STOCK NUMBER

Plan safety stock
CONSIDER_WIP NUMBER

Consider work in process
CONSIDER_PO NUMBER

Consider purchase orders
SNAPSHOT_LOCK NUMBER

Flag to determine whether the Snapshot should try to lock tables
EXPLOSION_START_DATE DATE

Explosion start date and time
EXPLOSION_COMPLETION_DATE DATE

Explosion completion date and time
DATA_START_DATE DATE

Data snapshot start date and time
DATA_COMPLETION_DATE DATE

Data snapshot completion date and time
PLAN_START_DATE DATE

Planner start date and time
CRP_PLAN_COMPLETION_DATE DATE

CRP planner completion date and time
PLAN_COMPLETION_DATE DATE

Planner completion date and time
CRP_PLAN_START_DATE DATE

CRP planner start date and time
CURRENT_PLANNER_LEVEL NUMBER

Level currently being planned by the MRP Planner Workers
PLANNER_BATCH_NUMBER NUMBER

Batch number currently being planned by the Planner Workers
DESCRIPTION VARCHAR2 (50)
Compile description
UPDATE_BOM NUMBER

Should the Snapshot update the MRP_PENDING_ENG_CHANGES and operation offset % information (Internal use only)
DEMAND_CLASS VARCHAR2 (30)
Demand class
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
CURR_RESCHED_ASSUMPTION NUMBER

Not currently used
RESCHED_ASSUMPTION NUMBER

Not currently used
CURR_USER_PLAN_START_DATE DATE

Not currently used
USER_PLAN_START_DATE DATE

Not currently used
ONLINE_PLANNER_START_DATE DATE

Not currently used
ONLINE_PLANNER_COMPLETION_DATE DATE

Not currently used
USE_NEW_PLANNER NUMBER

Not currently used
CURR_FULL_PEGGING NUMBER

Current Full Pegging
FULL_PEGGING NUMBER

Full Pegging
ASSIGNMENT_SET_ID NUMBER

Assignment Set Id
CURR_ASSIGNMENT_SET_ID NUMBER

Current Assignment Set Id
ORGANIZATION_SELECTION NUMBER

Organization Selection
CURR_RESERVATION_LEVEL NUMBER

Current value of reservation level
CURR_HARD_PEGGING_LEVEL NUMBER

Current value of hard pegging level
RESERVATION_LEVEL NUMBER

Plan level option which indicates at what level MRP will reserve supply against demand
HARD_PEGGING_LEVEL NUMBER

Plan level option that determines the pegging granularity of planned orders
CURR_PLAN_CAPACITY_FLAG NUMBER

Current value of plan capacity flag
CURR_SIMULATION_SET VARCHAR2 (10)
Current simulation set identifier
CURR_BILL_OF_RESOURCES VARCHAR2 (10)
Current Bill of resource code
PLAN_CAPACITY_FLAG NUMBER

Flag to indicate whether to plan capacity requirements
SIMULATION_SET VARCHAR2 (10)
Simulation set identifier
BILL_OF_RESOURCES VARCHAR2 (10)
Bill of resource code
MIN_WF_EXCEPT_ID NUMBER

Minimum exception ID
MAX_WF_EXCEPT_ID NUMBER

Maximum exception ID
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ORGANIZATION_ID
,      COMPILE_DESIGNATOR
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      CURR_SCHEDULE_DESIGNATOR
,      CURR_OPERATION_SCHEDULE_TYPE
,      CURR_PLAN_TYPE
,      CURR_OVERWRITE_OPTION
,      CURR_APPEND_PLANNED_ORDERS
,      CURR_SCHEDULE_TYPE
,      CURR_CUTOFF_DATE
,      CURR_PART_INCLUDE_TYPE
,      CURR_PLANNING_TIME_FENCE_FLAG
,      CURR_DEMAND_TIME_FENCE_FLAG
,      CURR_CONSIDER_RESERVATIONS
,      CURR_PLAN_SAFETY_STOCK
,      CURR_CONSIDER_WIP
,      CURR_CONSIDER_PO
,      CURR_SNAPSHOT_LOCK
,      COMPILE_DEFINITION_DATE
,      SCHEDULE_DESIGNATOR
,      OPERATION_SCHEDULE_TYPE
,      PLAN_TYPE
,      OVERWRITE_OPTION
,      APPEND_PLANNED_ORDERS
,      SCHEDULE_TYPE
,      CUTOFF_DATE
,      PART_INCLUDE_TYPE
,      PLANNING_TIME_FENCE_FLAG
,      DEMAND_TIME_FENCE_FLAG
,      CONSIDER_RESERVATIONS
,      PLAN_SAFETY_STOCK
,      CONSIDER_WIP
,      CONSIDER_PO
,      SNAPSHOT_LOCK
,      EXPLOSION_START_DATE
,      EXPLOSION_COMPLETION_DATE
,      DATA_START_DATE
,      DATA_COMPLETION_DATE
,      PLAN_START_DATE
,      CRP_PLAN_COMPLETION_DATE
,      PLAN_COMPLETION_DATE
,      CRP_PLAN_START_DATE
,      CURRENT_PLANNER_LEVEL
,      PLANNER_BATCH_NUMBER
,      DESCRIPTION
,      UPDATE_BOM
,      DEMAND_CLASS
,      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
,      CURR_RESCHED_ASSUMPTION
,      RESCHED_ASSUMPTION
,      CURR_USER_PLAN_START_DATE
,      USER_PLAN_START_DATE
,      ONLINE_PLANNER_START_DATE
,      ONLINE_PLANNER_COMPLETION_DATE
,      USE_NEW_PLANNER
,      CURR_FULL_PEGGING
,      FULL_PEGGING
,      ASSIGNMENT_SET_ID
,      CURR_ASSIGNMENT_SET_ID
,      ORGANIZATION_SELECTION
,      CURR_RESERVATION_LEVEL
,      CURR_HARD_PEGGING_LEVEL
,      RESERVATION_LEVEL
,      HARD_PEGGING_LEVEL
,      CURR_PLAN_CAPACITY_FLAG
,      CURR_SIMULATION_SET
,      CURR_BILL_OF_RESOURCES
,      PLAN_CAPACITY_FLAG
,      SIMULATION_SET
,      BILL_OF_RESOURCES
,      MIN_WF_EXCEPT_ID
,      MAX_WF_EXCEPT_ID
FROM MRP.MRP_PLANS;

Dependencies

[top of page]

MRP.MRP_PLANS does not reference any database object

MRP.MRP_PLANS is referenced by following:

SchemaAPPS
SynonymMRP_PLANS