APPS.EGO_ITEM_PUB dependencies on MTL_CATEGORIES_KFV

Line 3767: FROM MTL_CATEGORIES_KFV C

3763: FETCH get_parent_category_id_csr into l_parent_categories;
3764: EXIT WHEN get_parent_category_id_csr%NOTFOUND;
3765:
3766: SELECT C.CONCATENATED_SEGMENTS into l_category_name
3767: FROM MTL_CATEGORIES_KFV C
3768: WHERE C.CATEGORY_ID = l_parent_categories.CATEGORY_ID;
3769:
3770: l_tmp_names := l_category_hierarchy_names;
3771: IF (l_tmp_names IS NULL) THEN

Line 3785: FROM MTL_CATEGORIES_KFV C

3781: IF l_tmp_names IS NOT NULL THEN
3782: l_category_hierarchy_names := l_category_set_name || ' > ' || l_tmp_names;
3783: ELSE
3784: SELECT C.CONCATENATED_SEGMENTS into l_category_hierarchy_names
3785: FROM MTL_CATEGORIES_KFV C
3786: WHERE C.CATEGORY_ID = p_category_id;
3787: END IF;
3788:
3789: RETURN l_category_hierarchy_names;