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_DIAGNOSTIC_TEST dependencies on JTF_TERR_RSC_ALL

Line 490: from jtf_terr_rsc_all jtr

486: --#5. Total # of Territory Resource Assignments
487: --=============================================
488: select count(*)
489: into l_terr_res_assign
490: from jtf_terr_rsc_all jtr
491: where jtr.start_date_active <= SYSDATE
492: AND NVL(jtr.end_date_active, SYSDATE) >= SYSDATE
493: AND EXISTS ( SELECT jtdr.terr_id
494: FROM jtf_terr_denorm_rules_all jtdr

Line 506: from jtf_terr_rsc_all jtr

502: --====================================================================
503: SELECT COUNT (*)
504: into l_active_reps FROM (
505: select DISTINCT jtr.resource_id, jtr.resource_type
506: from jtf_terr_rsc_all jtr
507: where jtr.start_date_active <= SYSDATE
508: AND NVL(jtr.end_date_active, SYSDATE) >= SYSDATE
509: AND EXISTS ( SELECT jtdr.terr_id
510: FROM jtf_terr_denorm_rules_all jtdr