DBA Data[Home] [Help]

APPS.ICX_CAT_POPULATE_CATG_PVT dependencies on FND_LANGUAGES

Line 1063: AND mctl.language IN (SELECT language_code FROM fnd_languages WHERE installed_flag IN ('B', 'I'))

1059: icx_cat_categories_tl icat2
1060: WHERE mck.category_id = P_CATEGORY_ID
1061: AND mck.structure_id = ICX_CAT_UTIL_PVT.g_structure_id
1062: AND mctl.category_id = mck.category_id
1063: AND mctl.language IN (SELECT language_code FROM fnd_languages WHERE installed_flag IN ('B', 'I'))
1064: AND to_char(mctl.category_id) = icat.key (+)
1065: AND to_char(mctl.category_id) = icat2.key (+)
1066: AND mctl.language = icat2.language (+)
1067: ORDER BY 1;

Line 1124: AND mctl.language IN (SELECT language_code FROM fnd_languages WHERE installed_flag IN ('B', 'I'))

1120: icx_cat_categories_tl icat2
1121: WHERE mck.category_id = P_CATEGORY_ID
1122: AND mck.structure_id = ICX_CAT_UTIL_PVT.g_structure_id
1123: AND mctl.category_id = mck.category_id
1124: AND mctl.language IN (SELECT language_code FROM fnd_languages WHERE installed_flag IN ('B', 'I'))
1125: AND to_char(mctl.category_id) = icat.key (+)
1126: AND to_char(mctl.category_id) = icat2.key (+)
1127: AND mctl.language = icat2.language (+)
1128: AND mcsvc.category_set_id = ICX_CAT_UTIL_PVT.g_category_set_id