VIEW: APPS.BIX_DM_GROUP_PARAM_V

Source

View Text - Preformatted

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