eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: MRP_I2_WORK_ORDER_OUTPUT_V

Product:	MRP - Master Scheduling/MRP
Description:	A Rhythm view supporting information regarding work order outputs generated by Rhythm
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT MOO.WORK_ORDER
, MOO.PART_NUMBER
, PMV.INVENTORY_ITEM_ID
, MOO.ORGANIZATION_ID
, SUBSTR(MRP_I2_ERP.PARSE_ROUTING(MOO.ROUTING
, MOO.ORGANIZATION_ID)
, 1
, 240)
, SUBSTR(MRP_I2_ERP.PARSE_BOM(MOO.ROUTING
, MOO.ORGANIZATION_ID)
, 1
, 240)
, MOO.DEMAND_ORDER
, GREATEST(MOO.QUANTITY
, NVL(GREATEST(0
, (LEAST(JOBS.START_QUANTITY
, JOBS.START_QUANTITY - NVL(OPS.QUANTITY_IN_QUEUE
, JOBS.START_QUANTITY))) - NVL(JOBS.QUANTITY_COMPLETED
, 0) - NVL(JOBS.QUANTITY_SCRAPPED
, 0))
, 0))
, NVL(MWO.COMPLETED_QUANTITY
, 0)
, NVL(MWO.SCRAPPED_QUANTITY
, 0)
, TO_DATE(TO_CHAR(MOO.START_DATE
, 'DD-MM-YYYY HH24:MI')
, ' DD-MM-YYYY HH24:MI')
, TO_DATE(TO_CHAR(MOO.END_DATE
, 'DD-MM-YYYY HH24:MI')
, ' DD-MM-YYYY HH24:MI')
, PMV.RELEASE_TIME_FENCE_CODE
, MOO.STATUS
, ENT.WIP_ENTITY_ID
, PMV.ASSEMBLE_TO_ORDER
, PMV.PHANTOM_FLAG
, MOO.DESCRIPTION
FROM WIP_OPERATIONS OPS
, WIP_ENTITIES ENT
, WIP_DISCRETE_JOBS JOBS
, MRP_I2_PART_MASTER_V PMV
, MRP_I2_MFG_ORDER_OUTPUT MOO
, MRP_I2_WORK_ORDERS MWO
WHERE OPS.ORGANIZATION_ID(+) = ENT.ORGANIZATION_ID
AND OPS.WIP_ENTITY_ID (+) = ENT.WIP_ENTITY_ID
AND OPS.PREVIOUS_OPERATION_SEQ_NUM IS NULL
AND ENT.WIP_ENTITY_NAME = MOO.WORK_ORDER
AND ENT.ORGANIZATION_ID = MOO.ORGANIZATION_ID
AND ENT.WIP_ENTITY_ID = JOBS.WIP_ENTITY_ID
AND JOBS.STATUS_TYPE IN (1
, 3
, 6) AND MOO.QUANTITY > 0 AND MOO.ORGANIZATION_ID = PMV.ORGANIZATION_ID AND MOO.PART_NUMBER = PMV.PART_NUMBER
AND ENT.WIP_ENTITY_ID = MWO.JOB_ID UNION ALL SELECT MOO.WORK_ORDER
, MOO.PART_NUMBER
, PMV.INVENTORY_ITEM_ID
, MOO.ORGANIZATION_ID
, SUBSTR(MRP_I2_ERP.PARSE_ROUTING(MOO.ROUTING
, MOO.ORGANIZATION_ID)
, 1
, 240)
, SUBSTR(MRP_I2_ERP.PARSE_BOM(MOO.ROUTING
, MOO.ORGANIZATION_ID)
, 1
, 240)
, MOO.DEMAND_ORDER
, MOO.QUANTITY
, 0
, 0
, TO_DATE(TO_CHAR(MOO.START_DATE
, 'DD-MM-YYYY HH24:MI')
, 'DD-MM-YYYY HH24:MI')
, TO_DATE(TO_CHAR(MOO.END_DATE
, 'DD-MM-YYYY HH24:MI')
, 'DD-MM-YYYY HH24:MI')
, PMV.RELEASE_TIME_FENCE_CODE
, MOO.STATUS
, -1
, PMV.ASSEMBLE_TO_ORDER
, PMV.PHANTOM_FLAG
, MOO.DESCRIPTION
FROM MRP_I2_PART_MASTER_V PMV
, MRP_I2_MFG_ORDER_OUTPUT MOO WHERE MOO.QUANTITY > 0 AND MOO.ORGANIZATION_ID = PMV.ORGANIZATION_ID AND MOO.PART_NUMBER = PMV.PART_NUMBER AND NOT EXISTS ( SELECT NULL FROM WIP_ENTITIES W
, WIP_DISCRETE_JOBS J WHERE W.WIP_ENTITY_NAME = MOO.WORK_ORDER
AND W.ORGANIZATION_ID = MOO.ORGANIZATION_ID AND W.WIP_ENTITY_ID = J.WIP_ENTITY_ID AND J.STATUS_TYPE IN (1
, 3
, 6) )
AND NOT EXISTS ( SELECT NULL
FROM WIP_ENTITIES W
, WIP_FLOW_SCHEDULES J
WHERE W.WIP_ENTITY_NAME = MOO.WORK_ORDER
AND W.ORGANIZATION_ID = MOO.ORGANIZATION_ID
AND W.WIP_ENTITY_ID = J.WIP_ENTITY_ID
AND J.STATUS = 1 ) AND ( ( MRP_I2_ERP.GET_PARAMETER('WO_RELEASE_METHOD'
, MOO.ORGANIZATION_ID) = 'PTF' AND MOO.START_DATE <= MRP_I2_ERP.GET_START_DATE(PMV.ORGANIZATION_ID) + NVL(PMV.PLANNING_TIME_FENCE
, 0) ) OR ( MRP_I2_ERP.GET_PARAMETER('WO_RELEASE_METHOD'
, PMV.ORGANIZATION_ID) = 'DS' AND EXISTS ( SELECT NULL FROM MRP_I2_PROD_SCHEDULE WHERE WORK_ORDER = MOO.WORK_ORDER
AND ORGANIZATION_ID = MOO.ORGANIZATION_ID ) ) ) UNION ALL SELECT MOO.WORK_ORDER
, MOO.PART_NUMBER
, PMV.INVENTORY_ITEM_ID
, MOO.ORGANIZATION_ID
, SUBSTR(MRP_I2_ERP.PARSE_ROUTING(MOO.ROUTING
, MOO.ORGANIZATION_ID)
, 1
, 240)
, SUBSTR(MRP_I2_ERP.PARSE_BOM(MOO.ROUTING
, MOO.ORGANIZATION_ID)
, 1
, 240)
, MOO.DEMAND_ORDER
, GREATEST(MOO.QUANTITY
, NVL(GREATEST(0
, (LEAST(JOBS.PLANNED_QUANTITY
, JOBS.PLANNED_QUANTITY - NVL(OPS.QUANTITY_IN_QUEUE
, JOBS.PLANNED_QUANTITY))) - NVL(JOBS.QUANTITY_COMPLETED
, 0))
, 0))
, NVL(JOBS.QUANTITY_COMPLETED
, 0)
, 0
, TO_DATE(TO_CHAR(MOO.START_DATE
, 'DD-MM-YYYY HH24:MI')
, ' DD-MM-YYYY HH24:MI')
, TO_DATE(TO_CHAR(MOO.END_DATE
, 'DD-MM-YYYY HH24:MI')
, ' DD-MM-YYYY HH24:MI')
, PMV.RELEASE_TIME_FENCE_CODE
, MOO.STATUS
, ENT.WIP_ENTITY_ID
, PMV.ASSEMBLE_TO_ORDER
, PMV.PHANTOM_FLAG
, MOO.DESCRIPTION
FROM WIP_OPERATIONS OPS
, WIP_ENTITIES ENT
, WIP_FLOW_SCHEDULES JOBS
, MRP_I2_PART_MASTER_V PMV
, MRP_I2_MFG_ORDER_OUTPUT MOO
WHERE OPS.ORGANIZATION_ID(+) = ENT.ORGANIZATION_ID
AND OPS.WIP_ENTITY_ID (+) = ENT.WIP_ENTITY_ID
AND OPS.PREVIOUS_OPERATION_SEQ_NUM IS NULL
AND ENT.WIP_ENTITY_NAME = MOO.WORK_ORDER
AND ENT.ORGANIZATION_ID = MOO.ORGANIZATION_ID
AND ENT.WIP_ENTITY_ID = JOBS.WIP_ENTITY_ID
AND JOBS.STATUS = 1
AND MOO.QUANTITY > 0
AND MOO.ORGANIZATION_ID = PMV.ORGANIZATION_ID
AND MOO.PART_NUMBER = PMV.PART_NUMBER

Columns

Name
WORK_ORDER
PART_NUMBER
INVENTORY_ITEM_ID
ORGANIZATION_ID
ROUTING
BOM
DEMAND_ORDER
QUANTITY
COMPLETED_QUANTITY
SCRAPPED_QUANTITY
START_DATE
END_DATE
RELEASE_TIME_FENCE_CODE
STATUS
WIP_ENTITY_ID
ASSEMBLE_TO_ORDER
PHANTOM_FLAG
DESCRIPTION