DBA Data[Home] [Help]

APPS.CN_TSR_PVT dependencies on JTF_RS_GROUP_MBR_ROLE_VL

Line 90: jtf_rs_group_mbr_role_vl jgm,

86: from jtf_rs_groups_vl jg,
87: jtf_rs_role_relations jrr,
88: jtf_rs_salesreps jrs,
89: jtf_rs_roles_b jr,
90: jtf_rs_group_mbr_role_vl jgm,
91: jtf_rs_group_usages u
92: WHERE jg.group_id = jgm.group_id
93: and (jgm.manager_flag = 'Y' or jgm.member_flag = 'Y')
94: and jrs.resource_id = jgm.resource_id

Line 129: jtf_rs_group_mbr_role_vl jgm,

125: from jtf_rs_groups_vl jg,
126: jtf_rs_role_relations jrr,
127: jtf_rs_salesreps jrs,
128: jtf_rs_roles_b jr,
129: jtf_rs_group_mbr_role_vl jgm,
130: cn_srp_role_dtls srd,
131: jtf_rs_group_usages u
132: WHERE jg.group_id = jgm.group_id
133: and (jgm.manager_flag = 'Y' or jgm.member_flag = 'Y')