Product: | MRP - Master Scheduling/MRP |
---|---|
Description: | An Integration Toolkit view supporting information about the items in work in process. |
Implementation/DBA Data: | Not implemented in this database |
SELECT WO.WIP_ENTITY_NAME
, WO.WIP_ENTITY_ID
, OPS.OPERATION_SEQ_NUM
, OPS.OPERATION_SEQUENCE_ID
, OPS.PREVIOUS_OPERATION_SEQ_NUM
, DECODE(OPS.DUMMY
, 1
, 1
, 2
, 2
, 3
, 3
, 4
, 4
, 5
, 5)
, WO.ITEM_NUMBER
, WO.INVENTORY_ITEM_ID
, WO.ORGANIZATION_ID
, DECODE(OPS.DUMMY
, 1
, SYSDATE
, 2
, MRP_I2_INT.MAX_ID_WIP_MOVE_TRANSACTIONS(OPS.WIP_ENTITY_ID
, OPS.OPERATION_SEQ_NUM)
, 3
, SYSDATE
, 4
, SYSDATE
, 5
, SYSDATE)
, DECODE(OPS.DUMMY
, 1
, OPS.QUANTITY_IN_QUEUE
, 2
, OPS.QUANTITY_RUNNING
, 3
, 0
, 4
, 0
, 5
, 0)
, DECODE(OPS.DUMMY
, 1
, 0
, 2
, 0
, 3
, OPS.QUANTITY_WAITING_TO_MOVE
, 4
, OPS.QUANTITY_REJECTED
, 5
, OPS.QUANTITY_SCRAPPED)
, DECODE(OPS.DUMMY
, 1
, 2
, 2
, 2
, 3
, 1
, 4
, 1
, 5
, 1)
FROM MRP_RHX_PLANNED_JOBS_V WO
, (SELECT OPSINNER.WIP_ENTITY_ID
, OPSINNER.ORGANIZATION_ID
, OPSINNER.OPERATION_SEQ_NUM
, OPSINNER.OPERATION_SEQUENCE_ID
, OPSINNER.PREVIOUS_OPERATION_SEQ_NUM
, OPSINNER.QUANTITY_IN_QUEUE
, OPSINNER.QUANTITY_RUNNING
, OPSINNER.QUANTITY_WAITING_TO_MOVE
, OPSINNER.QUANTITY_REJECTED
, OPSINNER.QUANTITY_SCRAPPED
, PENTA.DUMMY
FROM WIP_OPERATIONS OPSINNER
, MRP_RHX_PENTA PENTA
WHERE (OPSINNER.QUANTITY_IN_QUEUE > 0 OR OPSINNER.QUANTITY_RUNNING > 0 OR OPSINNER.QUANTITY_WAITING_TO_MOVE > 0 OR OPSINNER.QUANTITY_REJECTED > 0 OR OPSINNER.QUANTITY_SCRAPPED > 0) ) OPS
WHERE DECODE(OPS.DUMMY
, 1
, OPS.QUANTITY_IN_QUEUE
, 2
, OPS.QUANTITY_RUNNING
, 3
, OPS.QUANTITY_WAITING_TO_MOVE
, 4
, OPS.QUANTITY_REJECTED
, 5
, OPS.QUANTITY_SCRAPPED) > 0
AND OPS.WIP_ENTITY_ID = WO.WIP_ENTITY_ID
AND OPS.ORGANIZATION_ID = WO.ORGANIZATION_ID