APPS.EDW_ITEMS_PKG dependencies on MTL_ITEM_CATEGORIES

Line 228: FROM MTL_ITEM_CATEGORIES MIC,

224: CURSOR c_get_ids IS
225: SELECT TO_NUMBER(MC.SEGMENT1) INTEREST_TYPE_ID,
226: TO_NUMBER(MC.SEGMENT2) PRIMARY_INTEREST_CODE_ID,
227: TO_NUMBER(MC.SEGMENT3) SECONDARY_INTEREST_CODE_ID
228: FROM MTL_ITEM_CATEGORIES MIC,
229: MTL_CATEGORIES_B MC,
230: FND_ID_FLEX_STRUCTURES FIFS
231: WHERE FIFS.ID_FLEX_CODE = 'MCAT'
232: AND FIFS.APPLICATION_ID = 401