APPS.OE_OE_PRICING_AVAILABILITY dependencies on MTL_SYSTEM_ITEMS_KFV

Line 2326: FROM mtl_system_items_kfv

2322: IF g_panda_rec_table(p_line_index).p_item_identifier_type ='INT' then
2323:
2324: SELECT concatenated_segments
2325: INTO oe_order_pub.g_line.ordered_item
2326: FROM mtl_system_items_kfv
2327: WHERE inventory_item_id = g_panda_rec_table(p_line_index).p_inventory_item_id
2328: AND organization_id = l_master_org_id; -- bug 5645866/5847803
2329:
2330: End IF;

Line 5445: FROM mtl_system_items_kfv

5441: oe_debug_pub.add('GSA warning or error');
5442: Begin
5443: SELECT concatenated_segments
5444: INTO l_msg_text
5445: FROM mtl_system_items_kfv
5446: WHERE inventory_item_id = g_inventory_item_id
5447: AND organization_id = l_org_id;
5448: Exception
5449: when no_data_found then

Line 5552: FROM mtl_system_items_kfv

5548: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5549: BEGIN
5550: SELECT concatenated_segments
5551: INTO out_inv_item_name
5552: FROM mtl_system_items_kfv
5553: WHERE inventory_item_id = l_inv_item_id
5554: AND organization_id = l_org_id;
5555:
5556:

Line 5607: FROM mtl_system_items_kfv

5603: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5604: BEGIN
5605: SELECT concatenated_segments,description,item_type
5606: INTO out_inv_item_name,out_inv_desc,out_inv_item_type
5607: FROM mtl_system_items_kfv
5608: WHERE inventory_item_id = l_inv_item_id
5609: AND organization_id = l_org_id;
5610:
5611: