APPS.ENG_NEW_ITEM_REQ_UTIL dependencies on EGO_ITEM_CAT_DENORM_HIER

Line 375: -- Modified the following query for using the ego_item_cat_denorm_hier table

371: order by organization_id;
372: */
373: --Bug 6162913
374: -- The above query was not working correctly because the ITEM_CATALOG_GROUP_ID taken is not from the MSII table.
375: -- Modified the following query for using the ego_item_cat_denorm_hier table
376: SELECT DISTINCT MSII.ITEM_CATALOG_GROUP_ID ,-- msii.segment1,
377: eng_types.type_name,
378: msii.organization_id
379: BULK COLLECT INTO l_icc_array ,

Line 385: ego_item_cat_denorm_hier heir,

381: l_org_array
382: FROM MTL_SYSTEM_ITEMS_INTERFACE msii,
383: ENG_CHANGE_ORDER_TYPES_VL eng_types,
384: MTL_PARAMETERS mp,
385: ego_item_cat_denorm_hier heir,
386: mtl_item_catalog_groups_b micgb
387: WHERE msii.set_process_id = P_BATCH_ID
388: AND PROCESS_FLAG = l_process_flag
389: AND mp.organization_id = msii.organization_id