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

Line 58: FROM EGO_CAT_GRP_TEMPLATES

54: CONTEXT_ORGANIZATION_ID
55: FROM MTL_ITEM_TEMPLATES MIT
56: WHERE TEMPLATE_NAME = CP_TEMPLATE_NAME
57: AND EXISTS (SELECT 1
58: FROM EGO_CAT_GRP_TEMPLATES
59: WHERE CATALOG_GROUP_ID IN (SELECT ITEM_CATALOG_GROUP_ID
60: FROM MTL_ITEM_CATALOG_GROUPS_B
61: START WITH ITEM_CATALOG_GROUP_ID = CP_CAT_GRP_ID
62: CONNECT BY PRIOR PARENT_CATALOG_GROUP_ID = ITEM_CATALOG_GROUP_ID)

Line 71: FROM EGO_CAT_GRP_TEMPLATES

67: CONTEXT_ORGANIZATION_ID
68: FROM MTL_ITEM_TEMPLATES MIT
69: WHERE TEMPLATE_ID = CP_TEMPLATE_ID
70: AND EXISTS (SELECT 1
71: FROM EGO_CAT_GRP_TEMPLATES
72: WHERE CATALOG_GROUP_ID IN (SELECT ITEM_CATALOG_GROUP_ID
73: FROM MTL_ITEM_CATALOG_GROUPS_B
74: START WITH ITEM_CATALOG_GROUP_ID = CP_CAT_GRP_ID
75: CONNECT BY PRIOR PARENT_CATALOG_GROUP_ID = ITEM_CATALOG_GROUP_ID)

Line 171: l_ego_cat_grp_flag := INV_ITEM_UTIL.Object_Exists(p_object_type => 'SYNONYM',p_object_name => 'EGO_CAT_GRP_TEMPLATES');

167: INVPUTLI.info('INVPULI2: begin copy_template_attributes');
168: END IF;
169:
170: --added for bug: 7033786
171: l_ego_cat_grp_flag := INV_ITEM_UTIL.Object_Exists(p_object_type => 'SYNONYM',p_object_name => 'EGO_CAT_GRP_TEMPLATES');
172:
173:
174: -- Populate Template Ids.
175: FOR cur IN item_rec LOOP

Line 190: FROM EGO_CAT_GRP_TEMPLATES

186: cur.item_catalog_group_id <> FND_API.G_MISS_NUM) THEN
187: l_icc_id := cur.item_catalog_group_id;/*Change for Bug 13786862*/
188: SELECT COUNT(1)
189: INTO L_CAT_TEMPL_COUNT
190: FROM EGO_CAT_GRP_TEMPLATES
191: WHERE CATALOG_GROUP_ID IN (SELECT ITEM_CATALOG_GROUP_ID
192: FROM MTL_ITEM_CATALOG_GROUPS_B
193: START WITH ITEM_CATALOG_GROUP_ID = CUR.ITEM_CATALOG_GROUP_ID
194: CONNECT BY PRIOR PARENT_CATALOG_GROUP_ID = ITEM_CATALOG_GROUP_ID);

Line 208: FROM EGO_CAT_GRP_TEMPLATES

204: END LOOP;
205:
206: SELECT COUNT(1)
207: INTO L_CAT_TEMPL_COUNT
208: FROM EGO_CAT_GRP_TEMPLATES
209: WHERE CATALOG_GROUP_ID IN (SELECT ITEM_CATALOG_GROUP_ID
210: FROM MTL_ITEM_CATALOG_GROUPS_B
211: START WITH ITEM_CATALOG_GROUP_ID = (SELECT NVL(ITEM_CATALOG_GROUP_ID,0)
212: FROM MTL_SYSTEM_ITEMS_B

Line 320: --AND (INV_ITEM_UTIL.Object_Exists(p_object_type => 'SYNONYM', p_object_name => 'EGO_CAT_GRP_TEMPLATES') = 'Y')

316: (cur.TRANSACTION_TYPE = 'CREATE') AND
317: (cur.ITEM_CATALOG_GROUP_ID IS NOT NULL and
318: cur.ITEM_CATALOG_GROUP_ID <> FND_API.G_MISS_NUM) AND
319: (INV_ITEM_UTIL.Appl_Inst_EGO > 0)
320: --AND (INV_ITEM_UTIL.Object_Exists(p_object_type => 'SYNONYM', p_object_name => 'EGO_CAT_GRP_TEMPLATES') = 'Y')
321: --end added for bug: 7033786
322: AND (l_ego_cat_grp_flag = 'Y')
323: -- Adding the below clause to prevent application of default templates in the case of SKU Item
324: AND ( cur.style_item_flag IS NULL OR cur.style_item_flag = 'Y')