CREATE OR REPLACE FORCE VIEW "TRAINING"."ROOM_STATUS_CODES_ALL_ORDER" ("ROOM_STATUS_ID", "ROOM_STATUS_CODE", "ROOM_STATUS_DESC") AS 
SELECT 1 as ROOM_STATUS_ID,'DI' as ROOM_STATUS_CODE, f_message('DI', 'Dirty') as ROOM_STATUS_DESC FROM DUAL
UNION  
SELECT 2 as ROOM_STATUS_ID,'CL' as ROOM_STATUS_CODE, f_message('CL', 'Clean')  as ROOM_STATUS_DESC FROM DUAL
UNION
SELECT 3 as ROOM_STATUS_ID,'IP' as ROOM_STATUS_CODE, f_message('IP', 'Inspected') as ROOM_STATUS_DESC FROM DUAL 
UNION
SELECT 4 as ROOM_STATUS_ID,'OS' as ROOM_STATUS_CODE, f_message('OS', 'Out of Service') as ROOM_STATUS_DESC FROM DUAL
UNION
SELECT 5 as ROOM_STATUS_ID,'OO' as ROOM_STATUS_CODE, f_message('OO', 'Out of Order') as ROOM_STATUS_DESC FROM DUAL;
