[Home] [Help]
View: WIP_REP_INTRAOP_STEPS_VAL_V
View Text
SELECT WO.ORGANIZATION_ID
, WO.WIP_ENTITY_ID
, WRS.LINE_ID
, WO.OPERATION_SEQ_NUM
, WO.NEXT_OPERATION_SEQ_NUM
, WVIS.STEP_LOOKUP_TYPE INTRAOPERATION_STEP_TYPE
, LU.MEANING INTRAOPERATION_STEP_MEANING
, DECODE(WVIS.STEP_LOOKUP_TYPE
, 1
, SUM(WO.QUANTITY_IN_QUEUE)
, 2
, SUM(WO.QUANTITY_RUNNING)
, 3
, SUM(WO.QUANTITY_WAITING_TO_MOVE)
, 4
, SUM(WO.QUANTITY_REJECTED)
, 5
, SUM(WO.QUANTITY_SCRAPPED)) INTRAOPERATION_STEP_QUANTITY
FROM MFG_LOOKUPS LU
, WIP_VALID_INTRAOPERATION_STEPS WVIS
, WIP_REPETITIVE_SCHEDULES WRS
, WIP_OPERATIONS WO
WHERE WVIS.ORGANIZATION_ID = WO.ORGANIZATION_ID
AND ((WVIS.RECORD_CREATOR = 'USER' OR WVIS.STEP_LOOKUP_TYPE = 1) OR (WVIS.RECORD_CREATOR = 'SYSTEM'
AND WO.NEXT_OPERATION_SEQ_NUM IS NULL))
AND WO.REPETITIVE_SCHEDULE_ID = WRS.REPETITIVE_SCHEDULE_ID
AND WRS.WIP_ENTITY_ID = WO.WIP_ENTITY_ID
AND WRS.ORGANIZATION_ID = WO.ORGANIZATION_ID
AND WRS.STATUS_TYPE IN (1
, 3
, 4
, 6)
AND LU.LOOKUP_TYPE = 'WIP_INTRAOPERATION_STEP'
AND LU.LOOKUP_CODE = WVIS.STEP_LOOKUP_TYPE GROUP BY WO.ORGANIZATION_ID
, WO.WIP_ENTITY_ID
, WRS.LINE_ID
, WO.OPERATION_SEQ_NUM
, WO.NEXT_OPERATION_SEQ_NUM
, WVIS.STEP_LOOKUP_TYPE
, LU.MEANING
Columns
Name |
ORGANIZATION_ID |
WIP_ENTITY_ID |
LINE_ID |
OPERATION_SEQ_NUM |
NEXT_OPERATION_SEQ_NUM |
INTRAOPERATION_STEP_TYPE |
INTRAOPERATION_STEP_MEANING |
INTRAOPERATION_STEP_QUANTITY |