SELECT 1 sort_col, lookup_code dnis_id , meaning dnis_name from fnd_lookups WHERE lookup_type = 'BIX_DM_ALL_LOOKUP' union select 2 sort_col, to_char(dnis_id) dnis_id, dnis dnis_name from bix_dm_dnis
View Text - HTML Formatted
SELECT 1 SORT_COL , LOOKUP_CODE DNIS_ID , MEANING DNIS_NAME FROM FND_LOOKUPS WHERE LOOKUP_TYPE = 'BIX_DM_ALL_LOOKUP' UNION SELECT 2 SORT_COL , TO_CHAR(DNIS_ID) DNIS_ID , DNIS DNIS_NAME FROM BIX_DM_DNIS