DBA Data[Home] [Help]

APPS.JA_CN_CUSTOM_SOURCES dependencies on MTL_ITEM_CATEGORIES

Line 227: FROM MTL_ITEM_CATEGORIES MIC

223: INTO MASTER_ITEM
224: FROM MTL_CATEGORIES_B_KFV MC
225: WHERE CATEGORY_ID IN(
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')

Line 281: FROM MTL_ITEM_CATEGORIES MIC

277: INTO MASTER_ITEM
278: FROM MTL_CATEGORIES_B_KFV MC
279: WHERE CATEGORY_ID IN(
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')

Line 462: FROM MTL_ITEM_CATEGORIES MIC

458: INTO MASTER_ITEM
459: FROM MTL_CATEGORIES_B_KFV MC
460: WHERE CATEGORY_ID IN(
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')