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

TABLE: MRP.MRP_PLANNER_TASKS

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


MRP_PLANNER_TASKS stores the level planned by the planner and the
planner workers and the time spent at each level.
.
The Planner launches several workers to assist in planning the items.
The Planner and workers insert rows into MRP_PLANNER_TASKS with a
status indicating the task being currently done. Initially the planner
inserts a row with a status "Initializing" to indicate the clean-up
tasks, such as deleting rows from the Planner output tables. When the
Planner or the Planner workers start processing a batch of items at a
specific level, they insert a row in this table with the status
"Processing" and the level and the batch number being processed. This
row is updated with the next batch number as the planner or the
workers plan a particular batch and start planning the next batch.
.
The Planner and the workers update the status to "Idle" while they are
waiting to proceed to next level after planning all the items at the
current level in their batch. The status "Complete" indicates that
the planner and the planner workers are done with planning the current
level and free to proceed to the next level.
.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MRP_PLANNER_TASKS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnREQUEST_ID
ColumnPLAN_LEVEL
ColumnSTATUS
MRP_PLANNER_TASKS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCOMPILE_DESIGNATOR
ColumnORGANIZATION_ID
Columns
Name Datatype Length Mandatory Comments
REQUEST_ID NUMBER
Yes Concurrent Who column
STATUS NUMBER
Yes Status
PLAN_LEVEL NUMBER
Yes Level planned
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
START_DATE DATE
Yes Start date of a task
END_DATE DATE

End date of a task
COMPILE_DESIGNATOR VARCHAR2 (10) Yes MPS, MRP or DRP plan identifier
ORGANIZATION_ID NUMBER
Yes Organization identifier
BATCH_NUMBER NUMBER

Batch number
PROCESSING_SECONDS NUMBER

The number of seconds it takes to complete a task
BATCH_START_DATE DATE

Date when the planning of the batch is started
Query Text

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


SELECT REQUEST_ID
,      STATUS
,      PLAN_LEVEL
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      START_DATE
,      END_DATE
,      COMPILE_DESIGNATOR
,      ORGANIZATION_ID
,      BATCH_NUMBER
,      PROCESSING_SECONDS
,      BATCH_START_DATE
FROM MRP.MRP_PLANNER_TASKS;

Dependencies

[top of page]

MRP.MRP_PLANNER_TASKS does not reference any database object

MRP.MRP_PLANNER_TASKS is referenced by following:

SchemaMRP
ViewMRP_PLANNER_TASKS#