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.JTF_TERR_JSP_REPORTS dependencies on JTF_TERR_RSC

Line 94: from jtf_terr_rsc jtr, jtf_terr_qual jtq

90: where NVL(j.end_date_active, sysdate) >= sysdate
91: AND j.start_date_active <= sysdate
92: AND EXISTS
93: ( select jtr.terr_id
94: from jtf_terr_rsc jtr, jtf_terr_qual jtq
95: where jtr.terr_id = jtq.terr_id
96: and jtr.resource_id = decode(lc_resource_id ,null, jtr.resource_id, lc_resource_id)
97: and jtq.qual_usg_id = decode(lc_qual_usg_id ,null, jtq.qual_usg_id, lc_qual_usg_id)
98: AND jtr.terr_id = j.terr_id

Line 259: from JTF_TERR_RSC

255: */
256: select resource_id, WF_NOTIFICATION.SubstituteSpecialChars(jtf_territory_resource_pvt.get_resource_name(
257: RESOURCE_ID , DECODE( RESOURCE_TYPE , 'RS_SUPPLIER', 'RS_SUPPLIER_CONTACT' ,
258: RESOURCE_TYPE ) )) resource_name, resource_type, terr_rsc_id
259: from JTF_TERR_RSC
260: where terr_id = ci_terr_id
261: order by resource_name;
262:
263: -- resource accesses

Line 266: from jtf_terr_rsc_access_v

262:
263: -- resource accesses
264: CURSOR c_get_rsc_access(ci_terr_rsc_id NUMBER) IS
265: select terr_rsc_access_id, access_type, WF_NOTIFICATION.SubstituteSpecialChars(meaning) meaning
266: from jtf_terr_rsc_access_v
267: where terr_rsc_id = ci_terr_rsc_id;
268:
269: lp_sysdate DATE := SYSDATE;
270: l_match_qual NUMBER := 0;

Line 333: from jtf_terr_rsc jtr, jtf_terr_qual jtq, jtf_terr_usgs jtu

329: TRUNC(j.start_date_active) <= NVL(p_param4, lp_sysdate)
330: )
331: AND EXISTS
332: ( select jtr.terr_id
333: from jtf_terr_rsc jtr, jtf_terr_qual jtq, jtf_terr_usgs jtu
334: where jtr.terr_id = jtq.terr_id
335: and jtr.terr_id = jtu.terr_id
336: and jtr.resource_id = decode(l_resource_id ,null, jtr.resource_id, l_resource_id)
337: /* ARPATEL: 10/16, bug#2832442 */

Line 858: FROM jtf_terr_rsc_all jtr

854: WHERE EXISTS ( SELECT jtdr.terr_id
855: FROM jtf_terr_denorm_rules_all jtdr
856: WHERE jtdr.source_id = p_param2 and jtdr.terr_id = jt.terr_id )
857: AND EXISTS ( SELECT jtr.terr_id
858: FROM jtf_terr_rsc_all jtr
859: WHERE jtr.role IN ('TELESALES_AGENT', 'Telesales Agent', 'TELESALES_MANAGER', 'Telesales Manager', NULL)
860: AND jtr.terr_id = jt.terr_id )
861: AND EXISTS ( SELECT jtr.terr_id
862: FROM jtf_terr_rsc_all jtr

Line 862: FROM jtf_terr_rsc_all jtr

858: FROM jtf_terr_rsc_all jtr
859: WHERE jtr.role IN ('TELESALES_AGENT', 'Telesales Agent', 'TELESALES_MANAGER', 'Telesales Manager', NULL)
860: AND jtr.terr_id = jt.terr_id )
861: AND EXISTS ( SELECT jtr.terr_id
862: FROM jtf_terr_rsc_all jtr
863: WHERE jtr.role IN ('SALES_REP', 'Sales Representative', 'SALES_MANAGER', 'Sales Manager', NULL)
864: AND jtr.terr_id = jt.terr_id )
865: ) tdac,
866:

Line 896: FROM jtf_terr_rsc_all jtr

892: ) tuc,
893:
894: -- Total Distinct # of People Assigned to Active Territories -- 2930
895: ( SELECT COUNT(DISTINCT jtr.resource_id) ACTIVE_DIST_REP_COUNT
896: FROM jtf_terr_rsc_all jtr
897: WHERE EXISTS ( SELECT jtdr.terr_id
898: FROM jtf_terr_denorm_rules_all jtdr
899: WHERE jtdr.resource_exists_flag = 'Y'
900: AND jtdr.terr_id = jtr.terr_id and jtdr.source_id = p_param2)

Line 944: FROM jtf_terr_rsc_all jtr

940: AND EXISTS ( SELECT jtdr.terr_id
941: FROM jtf_terr_denorm_rules_all jtdr
942: WHERE jtdr.terr_id = jt.terr_id and jtdr.source_id = p_param2)
943: AND EXISTS ( SELECT jtr.terr_id
944: FROM jtf_terr_rsc_all jtr
945: WHERE jtr.role IN ('TELESALES_AGENT', 'Telesales Agent', 'TELESALES_MANAGER', 'Telesales Manager', NULL)
946: AND jtr.terr_id = jt.terr_id )
947: AND EXISTS ( SELECT jtr.terr_id
948: FROM jtf_terr_rsc_all jtr

Line 948: FROM jtf_terr_rsc_all jtr

944: FROM jtf_terr_rsc_all jtr
945: WHERE jtr.role IN ('TELESALES_AGENT', 'Telesales Agent', 'TELESALES_MANAGER', 'Telesales Manager', NULL)
946: AND jtr.terr_id = jt.terr_id )
947: AND EXISTS ( SELECT jtr.terr_id
948: FROM jtf_terr_rsc_all jtr
949: WHERE jtr.role IN ('SALES_REP', 'Sales Representative', 'SALES_MANAGER', 'Sales Manager', NULL)
950: AND jtr.terr_id = jt.terr_id )
951: GROUP BY hou.name, hou.organization_id
952: ) tdac,

Line 1001: FROM jtf_terr_rsc_all jtr, hr_organization_units hou

997: ( SELECT
998: hou.name,
999: hou.organization_id,
1000: COUNT(DISTINCT jtr.resource_id) ACTIVE_DIST_REP_COUNT
1001: FROM jtf_terr_rsc_all jtr, hr_organization_units hou
1002: WHERE jtr.org_id = hou.organization_id
1003: AND EXISTS ( SELECT jtdr.terr_id
1004: FROM jtf_terr_denorm_rules_all jtdr
1005: WHERE jtdr.resource_exists_flag = 'Y'