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.INV_EGO_REVISION_VALIDATE dependencies on EGO_CAT_GRP_TEMPLATES

Line 2369: FROM EGO_CAT_GRP_TEMPLATES cat_temp,

2365: RETURN NUMBER IS
2366:
2367: CURSOR C_Default_Template(cp_catalog_group_id NUMBER) IS
2368: SELECT cat_temp.TEMPLATE_ID
2369: FROM EGO_CAT_GRP_TEMPLATES cat_temp,
2370: MTL_ITEM_TEMPLATES temp
2371: WHERE cat_temp.CATALOG_GROUP_ID = cp_catalog_group_id
2372: AND cat_temp.DEFAULT_FLAG = 'Y'
2373: AND cat_temp.TEMPLATE_ID = temp.TEMPLATE_ID;

Line 2909: WHERE EXISTS(SELECT 1 FROM ego_cat_grp_templates

2905: IF (INV_ITEM_UTIL.APPL_INST_EGO <> 0) THEN
2906: EXECUTE IMMEDIATE
2907: 'SELECT count(*)
2908: FROM dual
2909: WHERE EXISTS(SELECT 1 FROM ego_cat_grp_templates
2910: WHERE template_id = :p_template_id)'
2911: INTO l_template_exists
2912: USING p_template_id;
2913: END IF;