516: begin
517: select 'restricted loc exists'
518: into dummy
519: from mtl_item_locations loc,
520: mtl_secondary_locators item
521: where loc.inventory_location_id = c1rec.CLI
522: and loc.organization_id = c1rec.OI
523: and loc.subinventory_code = c1rec.CS
524: and nvl(loc.disable_date,trunc(SYSDATE)+1) >
568: begin
569: select 'restricted loc exists'
570: into dummy
571: from mtl_item_locations loc,
572: mtl_secondary_locators item
573: where loc.inventory_location_id = c1rec.CLI
574: and loc.organization_id = c1rec.OI
575: and loc.subinventory_code = c1rec.CS
576: and nvl(loc.disable_date,trunc(SYSDATE)+1) >
622: begin
623: select 'restricted loc exists'
624: into dummy
625: from mtl_item_locations loc,
626: mtl_secondary_locators item
627: where loc.inventory_location_id = c1rec.CLI
628: and loc.organization_id = c1rec.OI
629: and loc.subinventory_code = c1rec.CS
630: and nvl(loc.disable_date,trunc(SYSDATE)+1) >