WIE_WO_OPERATIONS_PAST_DUE_V

Details

• Schema: FUSION

• Object owner: WIE

• Object type: VIEW

Columns

Name
WORK_ORDER_ID WO_OPERATION_ID WORK_ORDER_STATUS_ID PLANNED_COMPLETION_DATE ORGANIZATION_ID WORK_CENTER_ID READY_QUANTITY REJECTED_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.PLANNED_COMPLETION_DATE PLANNED_COMPLETION_DATE, OPER.ORGANIZATION_ID ORGANIZATION_ID, OPER.WORK_CENTER_ID WORK_CENTER_ID, OPER.READY_QUANTITY READY_QUANTITY, OPER.REJECTED_QUANTITY REJECTED_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 OPER.COUNT_POINT_OPERATION_FLAG ='Y' 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.PLANNED_COMPLETION_DATE < SYSTIMESTAMP AND (OPER.READY_QUANTITY > 0 OR OPER.REJECTED_QUANTITY > 0) AND WC.WORK_CENTER_ID = OPER.WORK_CENTER_ID AND WO.WORK_METHOD_ID = MT.WORK_METHOD_ID