APPS.INV_RESERVATION_PVT dependencies on MTL_SYSTEM_ITEMS

Line 613: from mtl_system_items

609: -- Get primary UOM of the item
610: BEGIN
611: select primary_uom_code
612: into l_primary_uom_code
613: from mtl_system_items
614: where organization_id = l_line_rec_org_id
615: and inventory_item_id = l_line_rec_inventory_item_id;
616: EXCEPTION
617: WHEN no_data_found THEN

Line 725: FROM mtl_system_items

721: -- INVCONV - Retrieve secondary uom
722: IF px_rsv_rec.primary_uom_code IS NULL or px_rsv_rec.secondary_uom_code IS NULL THEN
723: SELECT primary_uom_code, secondary_uom_code,tracking_quantity_ind
724: INTO px_rsv_rec.primary_uom_code, px_rsv_rec.secondary_uom_code,l_tracking_quantity_ind
725: FROM mtl_system_items
726: WHERE inventory_item_id = px_rsv_rec.inventory_item_id
727: AND organization_id = px_rsv_rec.organization_id;
728: END IF;
729:

Line 2176: -- This function interrogates mtl_system_items.lot_divisible_flag

2172: -- Description
2173: -- ===========
2174: -- Determine lot divisibility for cases where caching is not in use
2175: -- and function is_lot_divisible above is not appropriate
2176: -- This function interrogates mtl_system_items.lot_divisible_flag
2177: FUNCTION lot_divisible(p_inventory_item_id NUMBER,p_organization_id NUMBER)
2178: RETURN BOOLEAN IS
2179: l_debug number;
2180: l_lot_divisible_flag VARCHAR2(1);

Line 2192: l_lot_control_code, l_lot_divisible_flag FROM mtl_system_items

2188: l_debug := g_debug;
2189:
2190: BEGIN
2191: SELECT lot_control_code, lot_divisible_flag INTO
2192: l_lot_control_code, l_lot_divisible_flag FROM mtl_system_items
2193: WHERE inventory_item_id = p_inventory_item_id
2194: AND organization_id = p_organization_id;
2195: EXCEPTION
2196: WHEN no_data_found THEN

Line 7728: FROM mtl_system_items

7724: l_supply_source_type_id NUMBER;
7725:
7726: CURSOR c_item(p_inventory_item_id NUMBER) IS
7727: SELECT *
7728: FROM mtl_system_items
7729: WHERE inventory_Item_Id = p_inventory_item_id;
7730: /*** End R12 ***/
7731: BEGIN
7732: -- Use cache to get value for l_debug