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_USGS_ALL

Line 1025: from jtf_terr_usgs_all jtua

1021: COUNT(*) INACTIVE_TERR_COUNT
1022: FROM jtf_terr_all jt
1023: WHERE
1024: exists ( select jtua.terr_id
1025: from jtf_terr_usgs_all jtua
1026: where jtua.source_id = p_param2 and jtua.terr_id = jt.terr_id)
1027: and NOT EXISTS ( SELECT jtdr.terr_id
1028: FROM jtf_terr_denorm_rules_all jtdr
1029: WHERE jtdr.terr_id = jt.terr_id );

Line 1039: from jtf_terr_usgs_all jtua

1035: hou.organization_id org_id
1036: FROM jtf_terr_all jt, hr_organization_units hou
1037: WHERE jt.org_id = hou.organization_id
1038: and exists ( select jtua.terr_id
1039: from jtf_terr_usgs_all jtua
1040: where jtua.source_id = p_param2 and jtua.terr_id = jt.terr_id)
1041: AND NOT EXISTS ( SELECT jtdr.terr_id
1042: FROM jtf_terr_denorm_rules_all jtdr
1043: WHERE jtdr.terr_id = jt.terr_id )