SELECT lookup_code group_id , meaning group_name from fnd_lookups WHERE lookup_type = 'BIX_DM_ALL_LOOKUP' union select to_char(group_id) group_id , group_name group_name from jtf_rs_groups_vl order by group_name
View Text - HTML Formatted
SELECT LOOKUP_CODE GROUP_ID , MEANING GROUP_NAME FROM FND_LOOKUPS WHERE LOOKUP_TYPE = 'BIX_DM_ALL_LOOKUP' UNION SELECT TO_CHAR(GROUP_ID) GROUP_ID , GROUP_NAME GROUP_NAME FROM JTF_RS_GROUPS_VL ORDER BY GROUP_NAME