246: else
247: --
248: SELECT count(1)
249: INTO l_dummy
250: FROM po_requisition_lines porl
251: WHERE porl.deliver_to_location_id = l_inventory_location_id
252: AND nvl(porl.source_type_code, 'VENDOR') = 'INVENTORY';
253: --
254: if ( l_dummy >= 1 ) then
318: else
319: --
320: SELECT count(1)
321: INTO l_dummy
322: FROM po_requisition_lines porl
323: WHERE porl.deliver_to_location_id = l_inventory_location_id
324: AND nvl(porl.source_type_code, 'VENDOR') = 'INVENTORY';
325: --
326: if ( l_dummy >= 1 ) then