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_CPYUTILITY_PVT dependencies on AMS_ACT_GEO_AREAS

Line 233: FROM ams_act_geo_areas_v

229: AND location_type_code = p_geo_area_type;
230: /* dbiswas changed the following select clause and replaced with the decode select clause above
231: for sql repository performance issue bug # 3631235
232: SELECT geo_area_name
233: FROM ams_act_geo_areas_v
234: WHERE geo_hierarchy_id = p_geo_hierarchy_id
235: AND geo_type_code = p_geo_area_type;
236: */
237: -- PL/SQL Block

Line 548: FROM ams_act_geo_areas

544: WHERE act_product_used_by_id = p_obj_id
545: AND arc_act_product_used_by = p_obj_type;
546: CURSOR c_geos_exists(p_obj_id NUMBER, p_obj_type VARCHAR2) IS
547: SELECT COUNT(1)
548: FROM ams_act_geo_areas
549: WHERE act_geo_area_used_by_id = p_obj_id
550: AND arc_act_geo_area_used_by = p_obj_type;
551: CURSOR c_atch_exists(p_obj_id NUMBER, p_obj_type VARCHAR2) IS
552: SELECT COUNT(1)