DBA Data[Home] [Help]

APPS.EGO_UI_ITEM_PUB dependencies on MTL_CATEGORIES_KFV

Line 2343: FROM MTL_CATEGORIES_KFV C

2339: FETCH get_parent_category_id_csr into l_parent_categories;
2340: EXIT WHEN get_parent_category_id_csr%NOTFOUND;
2341:
2342: SELECT C.CONCATENATED_SEGMENTS into l_category_name
2343: FROM MTL_CATEGORIES_KFV C
2344: WHERE C.CATEGORY_ID = l_parent_categories.CATEGORY_ID;
2345:
2346: l_tmp_names := l_category_hierarchy_names;
2347: IF (l_tmp_names IS NULL) THEN

Line 2361: FROM MTL_CATEGORIES_KFV C

2357: IF l_tmp_names IS NOT NULL THEN
2358: l_category_hierarchy_names := l_category_set_name || ' > ' || l_tmp_names;
2359: ELSE
2360: SELECT C.CONCATENATED_SEGMENTS into l_category_hierarchy_names
2361: FROM MTL_CATEGORIES_KFV C
2362: WHERE C.CATEGORY_ID = p_category_id;
2363: END IF;
2364: RETURN l_category_hierarchy_names;
2365: