APPS.QP_PRICE_BOOK_UTIL dependencies on MTL_CATEGORIES_KFV

Line 2525: from mtl_categories_kfv

2521: where category_id = to_number(p_attribute_value_code) and rownum = 1;
2522: exception when others then
2523: select concatenated_segments
2524: into l_attribute_value
2525: from mtl_categories_kfv
2526: where category_id = to_number(p_attribute_value_code);
2527: return l_attribute_value;
2528: end;
2529:

Line 2620: select concatenated_segments into l_item_category from mtl_categories_kfv where

2616: select concat_cat_parentage into l_item_category from eni_prod_den_hrchy_parents_v
2617: where category_id = p_item_category and rownum = 1;
2618: return l_item_category;
2619: exception when others then
2620: select concatenated_segments into l_item_category from mtl_categories_kfv where
2621: category_id = p_item_category ;
2622: return l_item_category;
2623: end;
2624: exception

Line 2636: select description into l_item_cat_description from mtl_categories_kfv where

2632: select category_desc into l_item_cat_description from eni_prod_den_hrchy_parents_v where
2633: category_id = p_item_category and rownum = 1;
2634: return l_item_cat_description;
2635: exception when others then
2636: select description into l_item_cat_description from mtl_categories_kfv where
2637: category_id = p_item_category;
2638: return l_item_cat_description;
2639: end ;
2640: exception

Line 2812: from mtl_categories_kfv

2808: where category_id = to_number(p_attribute_value) and rownum = 1;
2809: exception when others then
2810: select concatenated_segments
2811: into l_attribute_value
2812: from mtl_categories_kfv
2813: where category_id = to_number(p_attribute_value);
2814: return l_attribute_value;
2815: end;
2816: else