SELECT ecst.status_code AS id, ecst.status_name AS value, ecsa.sort_sequence_num FROM eng_change_statuses_tl ecst, eng_change_statuses ecsa WHERE language = USERENV('lang') AND ecst.status_code = ecsa.status_code
View Text - HTML Formatted
SELECT ECST.STATUS_CODE AS ID , ECST.STATUS_NAME AS VALUE , ECSA.SORT_SEQUENCE_NUM FROM ENG_CHANGE_STATUSES_TL ECST , ENG_CHANGE_STATUSES ECSA WHERE LANGUAGE = USERENV('LANG') AND ECST.STATUS_CODE = ECSA.STATUS_CODE