APPS.QP_PRICE_BOOK_UTIL dependencies on MTL_SYSTEM_ITEMS_KFV

Line 1575: FROM mtl_system_items_kfv

1571: ELSE
1572: BEGIN
1573: SELECT 1
1574: INTO l_count
1575: FROM mtl_system_items_kfv
1576: WHERE inventory_item_id =
1577: to_number(p_pb_input_header_rec.product_attr_value)
1578: AND organization_id = QP_UTIL.Get_Item_Validation_Org
1579: AND purchasing_enabled_flag =

Line 2513: from mtl_system_items_kfv

2509: begin
2510: if (p_attribute_code = 'PRICING_ATTRIBUTE1') then
2511: select concatenated_segments
2512: into l_attribute_value
2513: from mtl_system_items_kfv
2514: where inventory_item_id = to_number(p_attribute_value_code) and rownum = 1;
2515:
2516: elsif (p_attribute_code = 'PRICING_ATTRIBUTE2') then
2517: begin

Line 2648: select concatenated_segments into l_item_number from mtl_system_items_kfv where

2644: FUNCTION get_item_number(p_item_number in number, p_pb_header_id in number)
2645: return varchar2 is
2646: l_item_number varchar2(40) := Null;
2647: begin
2648: select concatenated_segments into l_item_number from mtl_system_items_kfv where
2649: inventory_item_id = p_item_number and rownum = 1;
2650: return l_item_number;
2651: exception
2652: when no_data_found then return null;