View: MRP_PLANNER_TASKS_V

Product:	MRP - Master Scheduling/MRP
Description:	Planner task information view
Implementation/DBA Data:	APPS.MRP_PLANNER_TASKS_V

View Text

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

Columns