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 1049: from jtf_terr_usgs_all jtua

1045: COUNT(*) INACTIVE_TERR_COUNT
1046: FROM jtf_terr_all jt
1047: WHERE
1048: exists ( select jtua.terr_id
1049: from jtf_terr_usgs_all jtua
1050: where jtua.source_id = p_param2 and jtua.terr_id = jt.terr_id)
1051: and NOT EXISTS ( SELECT jtdr.terr_id
1052: FROM jtf_terr_denorm_rules_all jtdr
1053: WHERE jtdr.terr_id = jt.terr_id );

Line 1063: from jtf_terr_usgs_all jtua

1059: hou.organization_id org_id
1060: FROM jtf_terr_all jt, hr_organization_units hou
1061: WHERE jt.org_id = hou.organization_id
1062: and exists ( select jtua.terr_id
1063: from jtf_terr_usgs_all jtua
1064: where jtua.source_id = p_param2 and jtua.terr_id = jt.terr_id)
1065: AND NOT EXISTS ( SELECT jtdr.terr_id
1066: FROM jtf_terr_denorm_rules_all jtdr
1067: WHERE jtdr.terr_id = jt.terr_id )