WIE_WORK_ORDERS_ON_HOLD_V
Details
-
Schema: FUSION
-
Object owner: WIE
-
Object type: VIEW
Columns
Name |
---|
WORK_ORDER_ID WORK_ORDER_STATUS_ID PLANNED_COMPLETION_DATE ORGANIZATION_ID WORK_METHOD_CODE |
Query
SQL_Statement |
---|
SELECT wo.work_order_id, wo.work_order_status_id, wo.planned_completion_date, wo.organization_id, wm.work_method_code FROM wie_work_orders_b wo, wis_work_methods_b wm WHERE wo.work_order_status_id IN (SELECT wosts.wo_status_id FROM wie_wo_statuses_b wosts WHERE wosts.wo_system_status_code = 'ON_HOLD') AND wo.order_less_flag = 'N' AND wo.work_method_id = wm.work_method_id |