DBA Data[Home] [Help]

APPS.JA_CN_CUSTOM_SOURCES dependencies on MTL_ITEM_CATEGORIES

Line 165: FROM MTL_ITEM_CATEGORIES MIC

161: INTO MASTER_ITEM
162: FROM MTL_CATEGORIES_B_KFV MC
163: WHERE CATEGORY_ID IN(
164: SELECT CATEGORY_ID
165: FROM MTL_ITEM_CATEGORIES MIC
166: WHERE MIC.CATEGORY_SET_ID IN (
167: SELECT CATEGORY_SET_ID
168: FROM MTL_CATEGORY_SETS_TL MCST
169: WHERE MCST.LANGUAGE = USERENV('LANG')

Line 219: FROM MTL_ITEM_CATEGORIES MIC

215: INTO MASTER_ITEM
216: FROM MTL_CATEGORIES_B_KFV MC
217: WHERE CATEGORY_ID IN(
218: SELECT CATEGORY_ID
219: FROM MTL_ITEM_CATEGORIES MIC
220: WHERE MIC.CATEGORY_SET_ID IN (
221: SELECT CATEGORY_SET_ID
222: FROM MTL_CATEGORY_SETS_TL MCST
223: WHERE MCST.LANGUAGE = USERENV('LANG')

Line 400: FROM MTL_ITEM_CATEGORIES MIC

396: INTO MASTER_ITEM
397: FROM MTL_CATEGORIES_B_KFV MC
398: WHERE CATEGORY_ID IN(
399: SELECT CATEGORY_ID
400: FROM MTL_ITEM_CATEGORIES MIC
401: WHERE MIC.CATEGORY_SET_ID IN (
402: SELECT CATEGORY_SET_ID
403: FROM MTL_CATEGORY_SETS_TL MCST
404: WHERE MCST.LANGUAGE = USERENV('LANG')