DBA Data[Home] [Help]

APPS.OE_OE_AVAILABILITY dependencies on MTL_SYSTEM_ITEMS_KFV

Line 1620: FROM mtl_system_items_kfv

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

Line 1729: FROM mtl_system_items_kfv

1725: /*If p_item_identifier_type ='INT' then
1726:
1727: SELECT concatenated_segments
1728: INTO oe_order_pub.g_line.ordered_item
1729: FROM mtl_system_items_kfv
1730: WHERE inventory_item_id = g_inventory_item_id
1731: AND organization_id = l_org_id;
1732:
1733: End If;*/

Line 4069: FROM mtl_system_items_kfv

4065: oe_debug_pub.add('GSA warning or error');
4066: Begin
4067: SELECT concatenated_segments
4068: INTO l_msg_text
4069: FROM mtl_system_items_kfv
4070: WHERE inventory_item_id = g_inventory_item_id
4071: AND organization_id = l_org_id;
4072: Exception
4073: when no_data_found then