WIE_WORK_ORDERS_UNRELEASED_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 = 'UNRELEASED') AND wo.order_less_flag = 'N' AND wo.work_method_id = wm.work_method_id