VIEW: APPS.MRP_PLANNER_TASKS_V

Source

View Text - Preformatted

SELECT P.ORGANIZATION_ID , P.COMPILE_DESIGNATOR , P.REQUEST_ID , P.PLAN_LEVEL , L1.MEANING , P.BATCH_NUMBER , P.START_DATE , P.END_DATE , LPAD(TO_CHAR(TRUNC(P.PROCESSING_SECONDS/(60*60))), 2) || ':' || LPAD(TO_CHAR(MOD(ROUND(P.PROCESSING_SECONDS/60),60)), 2, '0') || ':' || LPAD(TO_CHAR(MOD(ROUND(P.PROCESSING_SECONDS), 60)), 2, '0') , LPAD(TO_CHAR(TRUNC(GREATEST(ROUND((P.END_DATE-P.START_DATE) *60*60*24 - P.PROCESSING_SECONDS) ,0)/(60*60))), 2) || ':' || LPAD(TO_CHAR(MOD(ROUND(GREATEST(ROUND((P.END_DATE-P.START_DATE) *60*60*24 - P.PROCESSING_SECONDS) ,0)/60),60)), 2, '0') || ':' || LPAD(TO_CHAR(MOD(ROUND(GREATEST(ROUND((P.END_DATE-P.START_DATE) *60*60*24 - P.PROCESSING_SECONDS) ,0)), 60)), 2, '0') FROM MFG_LOOKUPS L1, MRP_PLANNER_TASKS P WHERE L1.LOOKUP_TYPE = 'MRP_PLANNER_STATUS' AND L1.LOOKUP_CODE = P.STATUS

View Text - HTML Formatted

SELECT P.ORGANIZATION_ID
, P.COMPILE_DESIGNATOR
, P.REQUEST_ID
, P.PLAN_LEVEL
, L1.MEANING
, P.BATCH_NUMBER
, P.START_DATE
, P.END_DATE
, LPAD(TO_CHAR(TRUNC(P.PROCESSING_SECONDS/(60*60)))
, 2) || ':' || LPAD(TO_CHAR(MOD(ROUND(P.PROCESSING_SECONDS/60)
, 60))
, 2
, '0') || ':' || LPAD(TO_CHAR(MOD(ROUND(P.PROCESSING_SECONDS)
, 60))
, 2
, '0')
, LPAD(TO_CHAR(TRUNC(GREATEST(ROUND((P.END_DATE-P.START_DATE) *60*60*24 - P.PROCESSING_SECONDS)
, 0)/(60*60)))
, 2) || ':' || LPAD(TO_CHAR(MOD(ROUND(GREATEST(ROUND((P.END_DATE-P.START_DATE) *60*60*24 - P.PROCESSING_SECONDS)
, 0)/60)
, 60))
, 2
, '0') || ':' || LPAD(TO_CHAR(MOD(ROUND(GREATEST(ROUND((P.END_DATE-P.START_DATE) *60*60*24 - P.PROCESSING_SECONDS)
, 0))
, 60))
, 2
, '0')
FROM MFG_LOOKUPS L1
, MRP_PLANNER_TASKS P
WHERE L1.LOOKUP_TYPE = 'MRP_PLANNER_STATUS'
AND L1.LOOKUP_CODE = P.STATUS