DBA Data[Home] [Help]

APPS.JA_CN_CUSTOM_SOURCES dependencies on MTL_CATEGORY_SETS_TL

Line 230: FROM MTL_CATEGORY_SETS_TL MCST

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

Line 284: FROM MTL_CATEGORY_SETS_TL MCST

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

Line 465: FROM MTL_CATEGORY_SETS_TL MCST

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