DBA Data[Home] [Help]

APPS.OE_RELATED_ITEMS_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 151: FROM mtl_system_items_kfv

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

Line 1085: FROM mtl_system_items_kfv

1081: IF g_item_identifier_type ='INT' then
1082:
1083: SELECT concatenated_segments
1084: INTO oe_order_pub.g_line.ordered_item
1085: FROM mtl_system_items_kfv
1086: WHERE inventory_item_id = g_related_item_id
1087: AND organization_id = l_org_id;
1088:
1089: End IF;

Line 1273: FROM mtl_system_items_kfv

1269: /*If p_item_identifier_type ='INT' then
1270:
1271: SELECT concatenated_segments
1272: INTO oe_order_pub.g_line.ordered_item
1273: FROM mtl_system_items_kfv
1274: WHERE inventory_item_id = g_inventory_item_id
1275: AND organization_id = l_org_id;
1276:
1277: End If;*/

Line 3294: FROM mtl_system_items_kfv

3290: oe_debug_pub.add('GSA warning or error');
3291: Begin
3292: SELECT concatenated_segments
3293: INTO l_msg_text
3294: FROM mtl_system_items_kfv
3295: WHERE inventory_item_id = g_related_item_id
3296: AND organization_id = l_org_id;
3297: Exception
3298: when no_data_found then