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_PRODUCTS

Line 138: FROM ams_act_products_v

134:
135: /* bug 4957294 fix musman 18-jan-06
136: CURSOR c_product_name(p_category_id IN NUMBER) IS
137: SELECT DISTINCT (category_name)
138: FROM ams_act_products_v
139: WHERE category_id = p_category_id;
140: */
141: CURSOR c_product_name(p_category_id IN NUMBER) IS
142: SELECT concatenated_segments

Line 543: FROM ams_act_products

539: WHERE master_object_id = p_obj_id
540: AND master_object_type = p_obj_type ;
541: CURSOR c_prod_exists(p_obj_id NUMBER, p_obj_type VARCHAR2) IS
542: SELECT COUNT(1)
543: FROM ams_act_products
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)