APPS.QP_PRICE_BOOK_UTIL dependencies on ENI_PROD_DEN_HRCHY_PARENTS_V

Line 2520: from eni_prod_den_hrchy_parents_v

2516: elsif (p_attribute_code = 'PRICING_ATTRIBUTE2') then
2517: begin
2518: select concat_cat_parentage
2519: into l_attribute_value
2520: from eni_prod_den_hrchy_parents_v
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

Line 2616: select concat_cat_parentage into l_item_category from eni_prod_den_hrchy_parents_v

2612: FUNCTION get_item_category (p_item_category in number) return varchar2 is
2613: l_item_category varchar2(240) :=null;
2614: begin
2615: begin
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

Line 2632: select category_desc into l_item_cat_description from eni_prod_den_hrchy_parents_v where

2628: FUNCTION get_item_cat_description (p_item_category in number) return varchar2 is
2629: l_item_cat_description varchar2(240) := Null;
2630: begin
2631: begin
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

Line 2807: from eni_prod_den_hrchy_parents_v

2803: if p_context = 'ITEM' and p_attribute = 'PRICING_ATTRIBUTE2' then
2804: begin
2805: select concat_cat_parentage
2806: into l_attribute_value
2807: from eni_prod_den_hrchy_parents_v
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