APPS.OE_OE_AVAILABILITY dependencies on MTL_SYSTEM_ITEMS

Line 586: FROM MTL_SYSTEM_ITEMS

582: out_price_list_id := null;
583: BEGIN
584: SELECT BOM_ITEM_TYPE,PICK_COMPONENTS_FLAG
585: INTO l_bom_item_type,l_pick_components_flag
586: FROM MTL_SYSTEM_ITEMS
587: WHERE INVENTORY_ITEM_ID= in_item_id
588: AND ORGANIZATION_ID=in_org_id;
589: IF l_bom_item_type=4 AND l_pick_components_flag='N' THEN
590: out_item_type_code := 'STANDARD';

Line 1179: FROM mtl_system_items msi

1175: END IF;
1176:
1177: SELECT msi.lot_control_code
1178: INTO l_lot_control_code
1179: FROM mtl_system_items msi
1180: WHERE msi.inventory_item_id = p_item_id
1181: AND msi.organization_id = nvl(p_org_id,l_org_id);
1182:
1183: IF l_lot_control_code = 2 THEN

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

Line 4500: FROM mtl_system_items

4496: planning_make_buy_code,
4497: taxable_flag ,
4498: serviceable_product_flag,
4499: atp_flag
4500: FROM mtl_system_items
4501: WHERE inventory_item_id = in_inventory_item_id
4502: AND organization_id = in_org_id;
4503:
4504: l_default_shipping_org number;

Line 5112: FROM mtl_system_items_b

5108: )IS
5109:
5110: CURSOR c_items IS
5111: SELECT primary_uom_code
5112: FROM mtl_system_items_b
5113: WHERE organization_id = in_org_id
5114: AND inventory_item_id = g_panda_rec_table(1).p_Inventory_item_id;
5115:
5116: CURSOR c_class(in_ordered_uom in varchar2) is