APPS.OE_RELATED_ITEMS_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 152: FROM mtl_system_items_kfv

148: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
149: BEGIN
150: SELECT concatenated_segments,description,item_type
151: INTO out_inv_item_name,out_inv_desc,out_inv_item_type
152: FROM mtl_system_items_kfv
153: WHERE inventory_item_id = l_inv_item_id
154: AND organization_id = l_org_id;
155:
156:

Line 1119: FROM mtl_system_items_kfv

1115: IF g_item_identifier_type ='INT' then
1116:
1117: SELECT concatenated_segments
1118: INTO oe_order_pub.g_line.ordered_item
1119: FROM mtl_system_items_kfv
1120: WHERE inventory_item_id = g_related_item_id
1121: AND organization_id = l_org_id;
1122:
1123: End IF;

Line 1307: FROM mtl_system_items_kfv

1303: /*If p_item_identifier_type ='INT' then
1304:
1305: SELECT concatenated_segments
1306: INTO oe_order_pub.g_line.ordered_item
1307: FROM mtl_system_items_kfv
1308: WHERE inventory_item_id = g_inventory_item_id
1309: AND organization_id = l_org_id;
1310:
1311: End If;*/

Line 3328: FROM mtl_system_items_kfv

3324: oe_debug_pub.add('GSA warning or error');
3325: Begin
3326: SELECT concatenated_segments
3327: INTO l_msg_text
3328: FROM mtl_system_items_kfv
3329: WHERE inventory_item_id = g_related_item_id
3330: AND organization_id = l_org_id;
3331: Exception
3332: when no_data_found then