Product: | MRP - Master Scheduling/MRP |
---|---|
Description: | MRP snapshot task information view |
Implementation/DBA Data: | APPS.MRP_SNAPSHOT_TASKS_V |
SELECT S.TASK
, S.DEPENDENT_TASK
, S.DEPENDENT_TASK2
, PLAN.ORGANIZATION_ID
, PLAN.COMPILE_DESIGNATOR
, L1.MEANING
, L2.MEANING
, L3.MEANING
, DECODE(S.REQUIRES_ITEMS
, 1
, L4.MEANING
, NULL)
, S.START_DATE
, S.COMPLETION_DATE
, LPAD(TRUNC((S.COMPLETION_DATE - S.START_DATE) * 24)
, 2
, '0') || ':' || LPAD(TRUNC(MOD(S.COMPLETION_DATE - S.START_DATE
, 1/24) *24 *60)
, 2
, '0') || ':' || LPAD(TRUNC(MOD(S.COMPLETION_DATE - S.START_DATE
, 1/(24*60)) * 24 * 60 * 60)
, 2
, '0')
, S.REQUEST_ID
, S.REQUIRES_LOCK
FROM MFG_LOOKUPS L4
, MFG_LOOKUPS L3
, MFG_LOOKUPS L2
, MFG_LOOKUPS L1
, MRP_PLANS PLAN
, MRP_SNAPSHOT_TASKS S
WHERE L2.LOOKUP_TYPE (+) = 'MRP_SNAPSHOT_TASK'
AND L2.LOOKUP_CODE (+) = S.DEPENDENT_TASK
AND L3.LOOKUP_TYPE (+) = 'MRP_SNAPSHOT_TASK'
AND L3.LOOKUP_CODE (+) = S.DEPENDENT_TASK2
AND L4.LOOKUP_TYPE (+) = 'MRP_SNAPSHOT_TASK'
AND L4.LOOKUP_CODE (+)= 0
AND L1.LOOKUP_TYPE = DECODE(PLAN.USE_NEW_PLANNER
, 1
, 'MRP_SNAPSHOT_DELETE_TASK'
, 'MRP_SNAPSHOT_TASK')
AND L1.LOOKUP_CODE = S.TASK
AND S.ORGANIZATION_ID = PLAN.ORGANIZATION_ID
AND S.COMPILE_DESIGNATOR = PLAN.COMPILE_DESIGNATOR