eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.WIP_TX_REP_INTRAOP_STEPS_VAL_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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