VIEW: APPS.BIX_DM_AGENT_SEC_PARAM_V

Source

View Text - Preformatted

SELECT distinct to_char(r.resource_id) resource_id, r.resource_name resource_name from jtf_rs_resource_extns_vl r, bix_dm_group_bin_param_v g, jtf_rs_group_members m WHERE r.resource_id = m.resource_id and m.group_id = substr(g.group_id, 2, length(g.group_id)) and g.group_id like 'g%' UNION select distinct to_char(r.resource_id) resource_id, r.resource_name resource_name from jtf_rs_resource_extns_vl r, bix_dm_group_bin_param_v g where r.resource_id = substr(g.group_id, 2, length(g.group_id)) and g.group_id like 'a%'

View Text - HTML Formatted

SELECT DISTINCT TO_CHAR(R.RESOURCE_ID) RESOURCE_ID
, R.RESOURCE_NAME RESOURCE_NAME
FROM JTF_RS_RESOURCE_EXTNS_VL R
, BIX_DM_GROUP_BIN_PARAM_V G
, JTF_RS_GROUP_MEMBERS M
WHERE R.RESOURCE_ID = M.RESOURCE_ID
AND M.GROUP_ID = SUBSTR(G.GROUP_ID
, 2
, LENGTH(G.GROUP_ID))
AND G.GROUP_ID LIKE 'G%' UNION SELECT DISTINCT TO_CHAR(R.RESOURCE_ID) RESOURCE_ID
, R.RESOURCE_NAME RESOURCE_NAME
FROM JTF_RS_RESOURCE_EXTNS_VL R
, BIX_DM_GROUP_BIN_PARAM_V G
WHERE R.RESOURCE_ID = SUBSTR(G.GROUP_ID
, 2
, LENGTH(G.GROUP_ID))
AND G.GROUP_ID LIKE 'A%'