[Home] [Help]
7229:
7230: -- verify if locator is active
7231: SELECT COUNT(*)
7232: INTO l_loc_active
7233: FROM mtl_item_locations_kfv
7234: WHERE NVL(disable_date, SYSDATE + 1) > SYSDATE
7235: AND organization_id = p_org_id
7236: AND subinventory_code = l_sub
7237: AND inventory_location_id = l_loc_id;