WIE_WO_OPERATIONS_SCRAP_V

Details

• Schema: FUSION

• Object owner: WIE

• Object type: VIEW

Columns

Name
WORK_ORDER_ID WO_OPERATION_ID WORK_ORDER_STATUS_ID ORGANIZATION_ID WORK_CENTER_ID SCRAPPED_QUANTITY OPERATION_TYPE WORK_AREA_ID WORK_METHOD_CODE

Query

SQL_Statement

SELECT WO.WORK_ORDER_ID WORK_ORDER_ID, OPER.WO_OPERATION_ID WO_OPERATION_ID, WO.WORK_ORDER_STATUS_ID WORK_ORDER_STATUS_ID, OPER.ORGANIZATION_ID ORGANIZATION_ID, OPER.WORK_CENTER_ID WORK_CENTER_ID, OPER.SCRAPPED_QUANTITY SCRAPPED_QUANTITY, OPER.OPERATION_TYPE, WC.WORK_AREA_ID, MT.WORK_METHOD_CODE WORK_METHOD_CODE FROM WIE_WORK_ORDERS_B WO, WIE_WO_OPERATIONS_B OPER, WIS_WORK_CENTERS_B WC, WIS_WORK_METHODS_B MT WHERE OPER.WORK_ORDER_ID = WO.WORK_ORDER_ID AND WO.ORDER_LESS_FLAG = 'N' AND WO.WORK_ORDER_STATUS_ID IN (SELECT WOSTS.WO_STATUS_ID FROM WIE_WO_STATUSES_B WOSTS WHERE WOSTS.WO_SYSTEM_STATUS_CODE IN ('RELEASED', 'COMPLETED') ) AND OPER.SCRAPPED_QUANTITY > 0 AND WC.WORK_CENTER_ID = OPER.WORK_CENTER_ID AND WO.WORK_METHOD_ID = MT.WORK_METHOD_ID