APPS.INV_RESERVATION_PVT dependencies on MTL_SYSTEM_ITEMS

Line 855: from mtl_system_items

851: -- Get primary UOM of the item
852: BEGIN
853: select primary_uom_code
854: into l_primary_uom_code
855: from mtl_system_items
856: where organization_id = l_line_rec_org_id
857: and inventory_item_id = l_line_rec_inventory_item_id;
858: EXCEPTION
859: WHEN no_data_found THEN

Line 985: FROM mtl_system_items

981: -- INVCONV - Retrieve secondary uom
982: IF px_rsv_rec.primary_uom_code IS NULL or px_rsv_rec.secondary_uom_code IS NULL THEN
983: SELECT primary_uom_code, secondary_uom_code,tracking_quantity_ind
984: INTO px_rsv_rec.primary_uom_code, px_rsv_rec.secondary_uom_code,l_tracking_quantity_ind
985: FROM mtl_system_items
986: WHERE inventory_item_id = px_rsv_rec.inventory_item_id
987: AND organization_id = px_rsv_rec.organization_id;
988: END IF;
989:

Line 2525: -- This function interrogates mtl_system_items.lot_divisible_flag

2521: -- Description
2522: -- ===========
2523: -- Determine lot divisibility for cases where caching is not in use
2524: -- and function is_lot_divisible above is not appropriate
2525: -- This function interrogates mtl_system_items.lot_divisible_flag
2526: FUNCTION lot_divisible(p_inventory_item_id NUMBER,p_organization_id NUMBER)
2527: RETURN BOOLEAN IS
2528: l_debug number;
2529: l_lot_divisible_flag VARCHAR2(1);

Line 2541: l_lot_control_code, l_lot_divisible_flag FROM mtl_system_items

2537: l_debug := g_debug;
2538:
2539: BEGIN
2540: SELECT lot_control_code, lot_divisible_flag INTO
2541: l_lot_control_code, l_lot_divisible_flag FROM mtl_system_items
2542: WHERE inventory_item_id = p_inventory_item_id
2543: AND organization_id = p_organization_id;
2544: EXCEPTION
2545: WHEN no_data_found THEN

Line 8144: FROM mtl_system_items

8140: -- adding org_id in the condition
8141: -- bug 9874238
8142: CURSOR c_item(p_inventory_item_id NUMBER,p_organization_id NUMBER) IS
8143: SELECT *
8144: FROM mtl_system_items
8145: WHERE inventory_Item_Id = p_inventory_item_id
8146: AND organization_id = p_organization_id;
8147: /*** End R12 ***/
8148: BEGIN

Line 10016: FROM mtl_system_items

10012:
10013: -- changes for bug 9874238 start
10014: CURSOR c_item(p_inventory_item_id NUMBER,p_organization_id NUMBER) IS
10015: SELECT *
10016: FROM mtl_system_items
10017: WHERE inventory_Item_Id = p_inventory_item_id
10018: AND organization_id = p_organization_id;
10019: l_item_rec inv_reservation_global.item_record;
10020: -- changes for bug 9874238 end