DBA Data[Home] [Help]

APPS.AST_OFL_ACCESSES_REPORT dependencies on JTF_RS_ROLES_B

Line 71: jtf_rs_roles_b rrb2,

67: jtf_rs_groups_tl grptl,
68: (select distinct grpb.group_id, rrb2.manager_flag
69: from jtf_rs_groups_b grpb,
70: jtf_rs_role_relations rrel2,
71: jtf_rs_roles_b rrb2,
72: jtf_rs_resource_extns rsc2,
73: jtf_rs_group_members mem,
74: fnd_user fnu
75: where grpb.group_id = mem.group_id

Line 103: jtf_rs_roles_b rrb,

99: rsc.source_name flname
100: from jtf_rs_resource_extns rsc,
101: jtf_rs_group_members gmem,
102: jtf_rs_role_relations rrel,
103: jtf_rs_roles_b rrb,
104: (select distinct grpd.group_id
105: from jtf_rs_groups_denorm grpd,
106: jtf_rs_role_relations rrel2,
107: jtf_rs_roles_b rrb2,

Line 107: jtf_rs_roles_b rrb2,

103: jtf_rs_roles_b rrb,
104: (select distinct grpd.group_id
105: from jtf_rs_groups_denorm grpd,
106: jtf_rs_role_relations rrel2,
107: jtf_rs_roles_b rrb2,
108: jtf_rs_resource_extns rsc2,
109: jtf_rs_group_members mem,
110: fnd_user fnu
111: where grpd.parent_group_id = mem.group_id