|
SELECT A.BUSINESS_UNIT , A.AUC_ID , A.AUC_ROUND , A.AUC_VERSION , A.LINE_NBR , %Round(MAX(%DecMult(B.BID_RESP_QTY , A.BID_QTY) ) , 5) FROM PS_RESP_LN A , PS_RESP_LN_FACTOR B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.AUC_ID = B.AUC_ID AND A.AUC_ROUND = B.AUC_ROUND AND A.AUC_VERSION = B.AUC_VERSION AND A.LINE_NBR = B.LINE_NBR AND A.BIDNUM = B.BIDNUM AND A.BIDDER_SETID = B.BIDDER_SETID AND A.BIDDER_ID = B.BIDDER_ID AND A.BIDDER_TYPE = B.BIDDER_TYPE AND A.BIDDER_LOC = B.BIDDER_LOC AND B.PRICE_FLG = 'Y' GROUP BY A.BUSINESS_UNIT, A.AUC_ID, A.AUC_ROUND, A.AUC_VERSION, A.LINE_NBR
|