VIEW: APPS.BIL_OBI_RS_GROUPS_V

Source

View Text - Preformatted

SELECT j.group_id, j.group_name from jtf_rs_groups_vl j, jtf_rs_group_usages u WHERE j.group_id = u.group_id and usage = 'SALES' WITH READ ONLY

View Text - HTML Formatted

SELECT J.GROUP_ID
, J.GROUP_NAME
FROM JTF_RS_GROUPS_VL J
, JTF_RS_GROUP_USAGES U
WHERE J.GROUP_ID = U.GROUP_ID
AND USAGE = 'SALES' WITH READ ONLY