[Home] [Help]
603: IF (p_subinventory_code IS NOT NULL) THEN
604: BEGIN
605: SELECT location_id
606: INTO l_location_id
607: FROM mtl_secondary_inventories
608: WHERE secondary_inventory_name = p_subinventory_code
609: AND organization_id = p_organization_id;
610: EXCEPTION
611: WHEN OTHERS THEN