eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_TSR_PVT dependencies on JTF_RS_SALESREPS

Line 88: jtf_rs_salesreps jrs,

84: NOT EXISTS (
85: SELECT 1
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

Line 127: jtf_rs_salesreps jrs,

123: EXISTS (
124: SELECT 1
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

Line 162: jtf_rs_salesreps s,

158: AND NOT EXISTS --- Check this
159: (
160: SELECT s.salesrep_id
161: from jtf_rs_role_relations rr,
162: jtf_rs_salesreps s,
163: cn_srp_role_dtls srd,
164: jtf_rs_roles_b r
165: WHERE rr.role_resource_id = s.resource_id
166: and rr.role_relate_id = srd.srp_role_id