|
SELECT z.auc_id ,z.auc_round ,z.auc_version , z.business_unit ,z.bidder_id ,z.resp_bidder_name1 ,z.bidnum ,z.auc_ln_bf_scr_ttl ,( SELECT COUNT(DISTINCT A.BIDDER_ID) FROM PS_RESP_BID_RNK_VW A , PS_RESP_BID_TIMEMX 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.BIDDER_ID = B.BIDDER_ID AND A.BUSINESS_UNIT = z.business_unit AND A.AUC_ID = z.auc_id AND A.AUC_ROUND = z .AUC_ROUND AND A.AUC_VERSION = z .AUC_VERSION AND ( (A.AUC_LN_BF_SCR_TTL > z.auc_ln_bf_scr_ttl ) OR ( (A.AUC_LN_BF_SCR_TTL = z.auc_ln_bf_scr_ttl ) AND ( B.RESP_DTTM_POST < ( SELECT MIN(Y.RESP_DTTM_POST ) FROM PS_RESP_BID_TIMEMX Y WHERE Y.BUSINESS_UNIT = A.BUSINESS_UNIT AND Y.AUC_ID = A.AUC_ID AND Y.AUC_ROUND = A.AUC_ROUND AND Y.AUC_VERSION = B.AUC_VERSION AND Y.BIDDER_ID = z.bidder_id) ))) )+1,'',z.auc_bid_amt_ttl ,( SELECT DISTINCT Q.Emailid FROM ps_auc_bid_re_p_vw Q WHERE Q.business_unit=z.business_unit AND Q.auc_id =z.auc_id AND Q.auc_version=z.auc_version AND q.auc_round=z.auc_round AND Q.bidder_id = z.bidder_id AND Q.bidder_setid=z.bidder_setid AND Q.bidder_loc= z.bidder_loc AND q.name=( SELECT MIN(div.name) FROM ps_auc_bid_re_p_vw div WHERE div.business_unit=z.business_unit AND div.auc_id =z.auc_id AND div.auc_version=z.auc_version AND div.auc_round=z.auc_round AND div.bidder_id = z.bidder_id AND div.bidder_setid=z.bidder_setid AND div.bidder_loc= z.bidder_loc) AND q.emailid = ( SELECT MIN(div.emailid) FROM ps_auc_bid_re_p_vw div WHERE div.business_unit=z.business_unit AND div.auc_id =z.auc_id AND div.auc_version=z.auc_version AND div.auc_round=z.auc_round AND div.bidder_id = z.bidder_id AND div.bidder_setid=z.bidder_setid AND div.bidder_loc= z.bidder_loc AND div.name=q.name ) ),z.resp_currency_cd,z.bidder_setid FROM PS_AUC_RESP_TTL_VW z
|
AUC_ID