DBA Data[Home] [Help]

APPS.JA_CN_CUSTOM_SOURCES dependencies on MTL_CATEGORY_SETS_TL

Line 168: FROM MTL_CATEGORY_SETS_TL MCST

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')
170: AND MCST.CATEGORY_SET_NAME = 'Cash Flow Category')
171: AND INVENTORY_ITEM_ID IN(
172: SELECT ITEM_ID

Line 222: FROM MTL_CATEGORY_SETS_TL MCST

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')
224: AND MCST.CATEGORY_SET_NAME = 'Cash Flow Category')
225: AND INVENTORY_ITEM_ID IN(
226: SELECT ITEM_ID

Line 403: FROM MTL_CATEGORY_SETS_TL MCST

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')
405: AND MCST.CATEGORY_SET_NAME = 'Cash Flow Category')
406: AND INVENTORY_ITEM_ID IN(
407: SELECT ITEM_ID