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.AMS_UTILITY_PVT dependencies on JTF_LOC_HIERARCHIES_VL

Line 1377: FROM jtf_loc_hierarchies_vl

1373: l_obj_area2 VARCHAR2(30);
1374:
1375: CURSOR c_area2 IS
1376: SELECT area2_code
1377: FROM jtf_loc_hierarchies_vl
1378: WHERE location_hierarchy_id = p_country_id;
1379:
1380: CURSOR c_camp_area2 IS
1381: SELECT B.area2_code

Line 1382: FROM ams_campaigns_vl A, jtf_loc_hierarchies_vl B

1378: WHERE location_hierarchy_id = p_country_id;
1379:
1380: CURSOR c_camp_area2 IS
1381: SELECT B.area2_code
1382: FROM ams_campaigns_vl A, jtf_loc_hierarchies_vl B
1383: WHERE A.campaign_id = p_object_id
1384: AND A.city_id = B.location_hierarchy_id;
1385:
1386: BEGIN