VIEW: APPS.WIP_DISC_INTRAOP_STEPS_VAL_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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