APPS.EDW_ITEMS_PKG dependencies on MTL_CATEGORIES_B

Line 229: MTL_CATEGORIES_B MC,

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
233: AND FIFS.ID_FLEX_STRUCTURE_CODE = 'SALES_CATEGORIES'