APPS.OE_OE_AVAILABILITY dependencies on MTL_SYSTEM_ITEMS

Line 589: FROM MTL_SYSTEM_ITEMS

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

Line 1182: FROM mtl_system_items msi

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

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

Line 4517: FROM mtl_system_items

4513: planning_make_buy_code,
4514: taxable_flag ,
4515: serviceable_product_flag,
4516: atp_flag
4517: FROM mtl_system_items
4518: WHERE inventory_item_id = in_inventory_item_id
4519: AND organization_id = in_org_id;
4520:
4521: l_default_shipping_org number;

Line 5129: FROM mtl_system_items_b

5125: )IS
5126:
5127: CURSOR c_items IS
5128: SELECT primary_uom_code
5129: FROM mtl_system_items_b
5130: WHERE organization_id = in_org_id
5131: AND inventory_item_id = g_panda_rec_table(1).p_Inventory_item_id;
5132:
5133: CURSOR c_class(in_ordered_uom in varchar2) is