APPS.EDW_ITEMS_PKG dependencies on FND_ID_FLEX_STRUCTURES

Line 230: FND_ID_FLEX_STRUCTURES FIFS

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'
234: AND MC.STRUCTURE_ID = FIFS.ID_FLEX_NUM