AUC_AWARD_DT_VW

(SQL View)
 Index Back

SELECT a.business_unit ,a.auc_id ,a.auc_round , a.auc_version ,a.bidder_setid ,a.bidder_id ,c.name1 ,a.bidder_loc ,a.bidder_type , %Round(%DecDiv(%DecMult(SUM(a.qty_auc),100),SUM(a.auc_req_qty)),2) ,d.emailid FROM PS_AUC_AWARD_LN a ,ps_vendor c ,ps_AUC_BID_PART_VW d WHERE a.auc_award_lock_flg='Y' AND c.vendor_id= a.bidder_id AND c.setid=a.bidder_setid AND d.bidder_id = c.vendor_id AND d.bidder_setid= c.setid AND a.auc_id = d.auc_id AND a.auc_version=d.auc_version AND a.auc_round=d.auc_round AND a.business_unit=d.business_unit AND d.emailid=( SELECT MIN(div.emailid) FROM ps_AUC_BID_PART_VW div WHERE div.bidder_id = c.vendor_id AND div.bidder_setid= c.setid AND div.auc_id = d.auc_id AND div.auc_version=d.auc_version AND div.auc_round=d.auc_round AND div.business_unit=d.business_unit) GROUP BY a.business_unit,a.auc_id,a.auc_round, a.auc_version,a.bidder_setid,a.bidder_id,c.name1,a.bidder_loc,a.bidder_type,d.emailid HAVING SUM(a.auc_req_qty)>0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 AUC_ID Character(10) VARCHAR2(10) NOT NULL Event ID
3 AUC_ROUND Number(5,0) INTEGER NOT NULL Event Round
4 AUC_VERSION Number(5,0) INTEGER NOT NULL Event Version
5 BIDDER_SETID Character(5) VARCHAR2(5) NOT NULL Bidder Setid
6 BIDDER_ID Character(15) VARCHAR2(15) NOT NULL Bidder ID
7 NAME Character(50) VARCHAR2(50) NOT NULL Name
8 BIDDER_LOC Character(10) VARCHAR2(10) NOT NULL Bidder Location
9 BIDDER_TYPE Character(1) VARCHAR2(1) NOT NULL Bidder Type
B=Bidder
C=Customer
P=Public
U=Uploaded
V=Supplier
10 PERCENTAGE Signed Number(7,2) DECIMAL(5,2) NOT NULL Percentage
11 EMAILID2 Character(70) VARCHAR2(70) NOT NULL Email ID