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 283: from JTF_TERR_RSC

279: */
280: select resource_id, WF_NOTIFICATION.SubstituteSpecialChars(jtf_territory_resource_pvt.get_resource_name(
281: RESOURCE_ID , DECODE( RESOURCE_TYPE , 'RS_SUPPLIER', 'RS_SUPPLIER_CONTACT' ,
282: RESOURCE_TYPE ) )) resource_name, resource_type, terr_rsc_id
283: from JTF_TERR_RSC
284: where terr_id = ci_terr_id
285: order by resource_name;
286:
287: -- resource accesses

Line 290: from jtf_terr_rsc_access_v

286:
287: -- resource accesses
288: CURSOR c_get_rsc_access(ci_terr_rsc_id NUMBER) IS
289: select terr_rsc_access_id, access_type, WF_NOTIFICATION.SubstituteSpecialChars(meaning) meaning
290: from jtf_terr_rsc_access_v
291: where terr_rsc_id = ci_terr_rsc_id;
292:
293: lp_sysdate DATE := SYSDATE;
294: l_match_qual NUMBER := 0;

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

353: TRUNC(j.start_date_active) <= NVL(p_param4, lp_sysdate)
354: )
355: AND EXISTS
356: ( select jtr.terr_id
357: from jtf_terr_rsc jtr, jtf_terr_qual jtq, jtf_terr_usgs jtu
358: where jtr.terr_id = jtq.terr_id
359: and jtr.terr_id = jtu.terr_id
360: and jtr.resource_id = decode(l_resource_id ,null, jtr.resource_id, l_resource_id)
361: /* ARPATEL: 10/16, bug#2832442 */

Line 882: FROM jtf_terr_rsc_all jtr

878: WHERE EXISTS ( SELECT jtdr.terr_id
879: FROM jtf_terr_denorm_rules_all jtdr
880: WHERE jtdr.source_id = p_param2 and jtdr.terr_id = jt.terr_id )
881: AND EXISTS ( SELECT jtr.terr_id
882: FROM jtf_terr_rsc_all jtr
883: WHERE jtr.role IN ('TELESALES_AGENT', 'Telesales Agent', 'TELESALES_MANAGER', 'Telesales Manager', NULL)
884: AND jtr.terr_id = jt.terr_id )
885: AND EXISTS ( SELECT jtr.terr_id
886: FROM jtf_terr_rsc_all jtr

Line 886: FROM jtf_terr_rsc_all jtr

882: FROM jtf_terr_rsc_all jtr
883: WHERE jtr.role IN ('TELESALES_AGENT', 'Telesales Agent', 'TELESALES_MANAGER', 'Telesales Manager', NULL)
884: AND jtr.terr_id = jt.terr_id )
885: AND EXISTS ( SELECT jtr.terr_id
886: FROM jtf_terr_rsc_all jtr
887: WHERE jtr.role IN ('SALES_REP', 'Sales Representative', 'SALES_MANAGER', 'Sales Manager', NULL)
888: AND jtr.terr_id = jt.terr_id )
889: ) tdac,
890:

Line 920: FROM jtf_terr_rsc_all jtr

916: ) tuc,
917:
918: -- Total Distinct # of People Assigned to Active Territories -- 2930
919: ( SELECT COUNT(DISTINCT jtr.resource_id) ACTIVE_DIST_REP_COUNT
920: FROM jtf_terr_rsc_all jtr
921: WHERE EXISTS ( SELECT jtdr.terr_id
922: FROM jtf_terr_denorm_rules_all jtdr
923: WHERE jtdr.resource_exists_flag = 'Y'
924: AND jtdr.terr_id = jtr.terr_id and jtdr.source_id = p_param2)

Line 968: FROM jtf_terr_rsc_all jtr

964: AND EXISTS ( SELECT jtdr.terr_id
965: FROM jtf_terr_denorm_rules_all jtdr
966: WHERE jtdr.terr_id = jt.terr_id and jtdr.source_id = p_param2)
967: AND EXISTS ( SELECT jtr.terr_id
968: FROM jtf_terr_rsc_all jtr
969: WHERE jtr.role IN ('TELESALES_AGENT', 'Telesales Agent', 'TELESALES_MANAGER', 'Telesales Manager', NULL)
970: AND jtr.terr_id = jt.terr_id )
971: AND EXISTS ( SELECT jtr.terr_id
972: FROM jtf_terr_rsc_all jtr

Line 972: FROM jtf_terr_rsc_all jtr

968: FROM jtf_terr_rsc_all jtr
969: WHERE jtr.role IN ('TELESALES_AGENT', 'Telesales Agent', 'TELESALES_MANAGER', 'Telesales Manager', NULL)
970: AND jtr.terr_id = jt.terr_id )
971: AND EXISTS ( SELECT jtr.terr_id
972: FROM jtf_terr_rsc_all jtr
973: WHERE jtr.role IN ('SALES_REP', 'Sales Representative', 'SALES_MANAGER', 'Sales Manager', NULL)
974: AND jtr.terr_id = jt.terr_id )
975: GROUP BY hou.name, hou.organization_id
976: ) tdac,

Line 1025: FROM jtf_terr_rsc_all jtr, hr_organization_units hou

1021: ( SELECT
1022: hou.name,
1023: hou.organization_id,
1024: COUNT(DISTINCT jtr.resource_id) ACTIVE_DIST_REP_COUNT
1025: FROM jtf_terr_rsc_all jtr, hr_organization_units hou
1026: WHERE jtr.org_id = hou.organization_id
1027: AND EXISTS ( SELECT jtdr.terr_id
1028: FROM jtf_terr_denorm_rules_all jtdr
1029: WHERE jtdr.resource_exists_flag = 'Y'