DBA Data[Home] [Help]

APPS.AST_OFL_ACCESSES_REPORT dependencies on JTF_RS_GROUPS_DENORM

Line 66: from jtf_rs_groups_denorm grpd,

62: decode(grpd.immediate_parent_flag, 'Y',
63: '-'||grptl.group_name, '--'||grptl.group_name),
64: decode(grpd.immediate_parent_flag, 'Y',
65: ' -'||grptl.group_name, ' --'||grptl.group_name))) name
66: from jtf_rs_groups_denorm grpd,
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,

Line 105: from jtf_rs_groups_denorm grpd,

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,
108: jtf_rs_resource_extns rsc2,
109: jtf_rs_group_members mem,