DBA Data[Home] [Help]

VIEW: APPS.BIV_MAINT_WO_STATUS_LVL_V

Source

View Text - Preformatted

SELECT status_id id ,work_order_status value ,case system_status when 1 then 1 when 3 then 1 when 6 then 1 when 17 then 1 else 0 end area_flag from eam_wo_statuses_v
View Text - HTML Formatted

SELECT STATUS_ID ID
, WORK_ORDER_STATUS VALUE
, CASE SYSTEM_STATUS WHEN 1 THEN 1 WHEN 3 THEN 1 WHEN 6 THEN 1 WHEN 17 THEN 1 ELSE 0 END AREA_FLAG
FROM EAM_WO_STATUSES_V