ITPub博客

抓供應商的交易量與對應機型[@more@]drop table po_hf_from_2007create table po_hf_from_2007 asselect pv.vendor_id,pv.vendor_name,pv.segment1 vendor_no, pll.ORG_ID,pl.item_id,msi.segment1 item,msi.description, sum(pll.QUANTITY-nvl(pll.QUANTITY_CANCELLED,0)) qty, max(pll.LAST_UPDATE_DATE) last_date --sum(pll.PRICE_OVERRIDE*nvl(ph.RATE,1)*(pll.QUANTITY-nvl(pll.QUANTITY_CANCELLED,0))) amtfrom po_line_locations_all pll,po_releases_all pr, po_lines_all pl,po_headers_all ph,