VIEW: APPS.MRP_SNAPSHOT_TASKS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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