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;




Reply With Quote