View: WIP_TX_REP_INTRAOP_STEPS_VAL_V

Product:	WIP - Work in Process
Description:	Repetitive intraoperation steps for released/complete schedules
Implementation/DBA Data:	APPS.WIP_TX_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 (3
, 4)
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