This is in a PL/SQL loop:
Code:
            SELECT item, 
			       loc,
		           max(decode(loc, 'ATL', p_pdcstockingind,'N')) atl,
                   max(decode(loc, 'LAN', p_pdcstockingind,'N')) lan,
                   max(decode(loc, 'NEW', p_pdcstockingind,'N')) new,
                   max(decode(loc, 'ROC', p_pdcstockingind,'N')) roc,
                   max(decode(loc, 'SEA', p_pdcstockingind,'N')) sea,
                   max(decode(loc, 'TOR', p_pdcstockingind,'N')) tor,
				   max(decode(loc, 'OKC', p_pdcstockingind,'N')) okc
              INTO item,
			       loc,
			       atl_stocking,
			       lan_stocking,
				   new_stocking,
				   roc_stocking,
				   sea_stocking,
				   tor_stocking,
				   okc_stocking                                 
			  FROM stsc.sku
			 WHERE item = sku_rec.item
			   AND loc = sku_rec.loc
			   AND p_acdcode != 'D'
			 GROUP BY item, loc;