View: WIP_DISC_INTRAOP_STEPS_VAL_V

Product:	WIP - Work in Process
Description:	Intraoperation steps
Implementation/DBA Data:	APPS.WIP_DISC_INTRAOP_STEPS_VAL_V

View Text

SELECT WO.ORGANIZATION_ID
, WO.WIP_ENTITY_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
, WO.QUANTITY_IN_QUEUE
, 2
, WO.QUANTITY_RUNNING
, 3
, WO.QUANTITY_WAITING_TO_MOVE
, 4
, WO.QUANTITY_REJECTED
, 5
, WO.QUANTITY_SCRAPPED) INTRAOPERATION_STEP_QUANTITY
FROM MFG_LOOKUPS LU
, WIP_VALID_INTRAOPERATION_STEPS WVIS
, 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 LU.LOOKUP_TYPE = 'WIP_INTRAOPERATION_STEP'
AND LU.LOOKUP_CODE = WVIS.STEP_LOOKUP_TYPE

Columns