226: SELECT CATEGORY_ID
227: FROM MTL_ITEM_CATEGORIES MIC
228: WHERE MIC.CATEGORY_SET_ID IN (
229: SELECT CATEGORY_SET_ID
230: FROM MTL_CATEGORY_SETS_TL MCST
231: WHERE MCST.LANGUAGE = USERENV('LANG')
232: AND MCST.CATEGORY_SET_NAME = 'Cash Flow Category')
233: AND INVENTORY_ITEM_ID IN(
234: SELECT ITEM_ID
280: SELECT CATEGORY_ID
281: FROM MTL_ITEM_CATEGORIES MIC
282: WHERE MIC.CATEGORY_SET_ID IN (
283: SELECT CATEGORY_SET_ID
284: FROM MTL_CATEGORY_SETS_TL MCST
285: WHERE MCST.LANGUAGE = USERENV('LANG')
286: AND MCST.CATEGORY_SET_NAME = 'Cash Flow Category')
287: AND INVENTORY_ITEM_ID IN(
288: SELECT ITEM_ID
461: SELECT CATEGORY_ID
462: FROM MTL_ITEM_CATEGORIES MIC
463: WHERE MIC.CATEGORY_SET_ID IN (
464: SELECT CATEGORY_SET_ID
465: FROM MTL_CATEGORY_SETS_TL MCST
466: WHERE MCST.LANGUAGE = USERENV('LANG')
467: AND MCST.CATEGORY_SET_NAME = 'Cash Flow Category')
468: AND INVENTORY_ITEM_ID IN(
469: SELECT ITEM_ID