APPS.OE_OE_PRICING_AVAILABILITY dependencies on MTL_SYSTEM_ITEMS_KFV

Line 2301: FROM mtl_system_items_kfv

2297: IF g_panda_rec_table(p_line_index).p_item_identifier_type ='INT' then
2298:
2299: SELECT concatenated_segments
2300: INTO oe_order_pub.g_line.ordered_item
2301: FROM mtl_system_items_kfv
2302: WHERE inventory_item_id = g_panda_rec_table(p_line_index).p_inventory_item_id
2303: AND organization_id = l_master_org_id; -- bug 5645866/5847803
2304:
2305: End IF;

Line 5420: FROM mtl_system_items_kfv

5416: oe_debug_pub.add('GSA warning or error');
5417: Begin
5418: SELECT concatenated_segments
5419: INTO l_msg_text
5420: FROM mtl_system_items_kfv
5421: WHERE inventory_item_id = g_inventory_item_id
5422: AND organization_id = l_org_id;
5423: Exception
5424: when no_data_found then

Line 5527: FROM mtl_system_items_kfv

5523: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5524: BEGIN
5525: SELECT concatenated_segments
5526: INTO out_inv_item_name
5527: FROM mtl_system_items_kfv
5528: WHERE inventory_item_id = l_inv_item_id
5529: AND organization_id = l_org_id;
5530:
5531:

Line 5582: FROM mtl_system_items_kfv

5578: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5579: BEGIN
5580: SELECT concatenated_segments,description,item_type
5581: INTO out_inv_item_name,out_inv_desc,out_inv_item_type
5582: FROM mtl_system_items_kfv
5583: WHERE inventory_item_id = l_inv_item_id
5584: AND organization_id = l_org_id;
5585:
5586: