APPS.BIV_SR_DETAILS_PKG dependencies on JTF_RS_GRP_RELATIONS

Line 178: select/*+index_ffs(grp_out jtf_rs_grp_relations_n1) index_ffs(usg JTF_RS_GROUP_USAGES_U2)*/ distinct related_group_id

174: This cursor will give you all the groups which are at top level
175: ***************************/
176: /*****Hints added and "not exists" replaced with "not in" as part of appsperf bug fix (bug#5029442)********/
177: cursor c_parent_groups is
178: select/*+index_ffs(grp_out jtf_rs_grp_relations_n1) index_ffs(usg JTF_RS_GROUP_USAGES_U2)*/ distinct related_group_id
179: from jtf_rs_grp_relations grp_out,
180: jtf_rs_group_usages usg
181: where relation_type = 'PARENT_GROUP'
182: and grp_out.related_group_id = usg.group_id

Line 179: from jtf_rs_grp_relations grp_out,

175: ***************************/
176: /*****Hints added and "not exists" replaced with "not in" as part of appsperf bug fix (bug#5029442)********/
177: cursor c_parent_groups is
178: select/*+index_ffs(grp_out jtf_rs_grp_relations_n1) index_ffs(usg JTF_RS_GROUP_USAGES_U2)*/ distinct related_group_id
179: from jtf_rs_grp_relations grp_out,
180: jtf_rs_group_usages usg
181: where relation_type = 'PARENT_GROUP'
182: and grp_out.related_group_id = usg.group_id
183: and usg.usage in ( 'METRICS', 'SUPPORT')

Line 186: (select/*+index_ffs(grp_in jtf_rs_grp_relations_n1)*/ grp_in.group_id

182: and grp_out.related_group_id = usg.group_id
183: and usg.usage in ( 'METRICS', 'SUPPORT')
184: and grp_out.related_group_id
185: not in
186: (select/*+index_ffs(grp_in jtf_rs_grp_relations_n1)*/ grp_in.group_id
187: from jtf_rs_grp_relations grp_in
188: );
189:
190: /**End of appsperf fix for bug#5029442**/

Line 187: from jtf_rs_grp_relations grp_in

183: and usg.usage in ( 'METRICS', 'SUPPORT')
184: and grp_out.related_group_id
185: not in
186: (select/*+index_ffs(grp_in jtf_rs_grp_relations_n1)*/ grp_in.group_id
187: from jtf_rs_grp_relations grp_in
188: );
189:
190: /**End of appsperf fix for bug#5029442**/
191:

Line 208: from jtf_rs_grp_relations

204: ****************/
205: -- dbms_output.put_line('Parent Group Id:'|| to_char(l_group_id));
206: insert into biv_resource_groups ( group_id, group_level)
207: select group_id, level+1
208: from jtf_rs_grp_relations
209: where relation_type = 'PARENT_GROUP'
210: start with related_group_id = l_group_id
211: connect by prior group_id = related_group_id;
212: