DBA Data[Home] [Help]

APPS.OE_OE_AVAILABILITY dependencies on MTL_SYSTEM_ITEMS_KFV

Line 1617: FROM mtl_system_items_kfv

1613: IF g_panda_rec_table(p_line_index).p_item_identifier_type ='INT' then
1614:
1615: SELECT concatenated_segments
1616: INTO oe_order_pub.g_line.ordered_item
1617: FROM mtl_system_items_kfv
1618: WHERE inventory_item_id = g_panda_rec_table(p_line_index).p_inventory_item_id
1619: AND organization_id = l_master_org_id;
1620:
1621: End IF;

Line 1724: FROM mtl_system_items_kfv

1720: /*If p_item_identifier_type ='INT' then
1721:
1722: SELECT concatenated_segments
1723: INTO oe_order_pub.g_line.ordered_item
1724: FROM mtl_system_items_kfv
1725: WHERE inventory_item_id = g_inventory_item_id
1726: AND organization_id = l_org_id;
1727:
1728: End If;*/

Line 4052: FROM mtl_system_items_kfv

4048: oe_debug_pub.add('GSA warning or error');
4049: Begin
4050: SELECT concatenated_segments
4051: INTO l_msg_text
4052: FROM mtl_system_items_kfv
4053: WHERE inventory_item_id = g_inventory_item_id
4054: AND organization_id = l_org_id;
4055: Exception
4056: when no_data_found then