[Home] [Help] [Dependency Information]
Object Name: | MRP_PLANNER_TASKS |
---|---|
Object Type: | TABLE |
Owner: | MRP |
FND Design Data: | MRP.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.
.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MRP_PLANNER_TASKS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
REQUEST_ID
PLAN_LEVEL STATUS |
MRP_PLANNER_TASKS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
COMPILE_DESIGNATOR
ORGANIZATION_ID |
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 |
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;
MRP.MRP_PLANNER_TASKS does not reference any database object
MRP.MRP_PLANNER_TASKS is referenced by following:
|
|
|