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

Line 1437: FROM jtf_loc_hierarchies_vl

1433: l_obj_area2 VARCHAR2(30);
1434:
1435: CURSOR c_area2 IS
1436: SELECT area2_code
1437: FROM jtf_loc_hierarchies_vl
1438: WHERE location_hierarchy_id = p_country_id;
1439:
1440: CURSOR c_camp_area2 IS
1441: SELECT B.area2_code

Line 1442: FROM ams_campaigns_vl A, jtf_loc_hierarchies_vl B

1438: WHERE location_hierarchy_id = p_country_id;
1439:
1440: CURSOR c_camp_area2 IS
1441: SELECT B.area2_code
1442: FROM ams_campaigns_vl A, jtf_loc_hierarchies_vl B
1443: WHERE A.campaign_id = p_object_id
1444: AND A.city_id = B.location_hierarchy_id;
1445:
1446: BEGIN