VIEW: APPS.OKL_BOOK_CONT_STAGE_UV

Source

View Text - Preformatted

SELECT CODE, MEANING FROM OKC_STATUSES_V WHERE CODE IN ('COMPLETE','APPROVED','BOOKED') ORDER BY DECODE(MEANING,'Complete','A', 'Approved','B', 'Booked','C','Z')

View Text - HTML Formatted

SELECT CODE
, MEANING
FROM OKC_STATUSES_V
WHERE CODE IN ('COMPLETE'
, 'APPROVED'
, 'BOOKED') ORDER BY DECODE(MEANING
, 'COMPLETE'
, 'A'
, 'APPROVED'
, 'B'
, 'BOOKED'
, 'C'
, 'Z')