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

VIEW: APPS.MRP_PLANNER_TASKS_V

Object Details
Object Name: MRP_PLANNER_TASKS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewMRP.MRP_PLANNER_TASKS_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER
Yes Organization identifier
COMPILE_DESIGNATOR VARCHAR2 (10) Yes MPS, MRP or DRP plan identifier
REQUEST_ID NUMBER
Yes Concurrent Who column
PLAN_LEVEL NUMBER
Yes Level planned
STATUS VARCHAR2 (80) Yes Status
BATCH_NUMBER NUMBER

Batch number
START_DATE DATE
Yes Start date of a task
END_DATE DATE

End date of a task
PROCESSING_TIME VARCHAR2 (8)
The number of seconds it takes to complete a task
IDLE_TIME VARCHAR2 (8)
Idle time
Query Text

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


SELECT ORGANIZATION_ID
,      COMPILE_DESIGNATOR
,      REQUEST_ID
,      PLAN_LEVEL
,      STATUS
,      BATCH_NUMBER
,      START_DATE
,      END_DATE
,      PROCESSING_TIME
,      IDLE_TIME
FROM APPS.MRP_PLANNER_TASKS_V;

Dependencies

[top of page]

APPS.MRP_PLANNER_TASKS_V references the following:

SchemaAPPS
ViewMFG_LOOKUPS
SynonymMRP_PLANNER_TASKS

APPS.MRP_PLANNER_TASKS_V is not referenced by any database object