AUC_AWARD_P1_VW

(SQL View)
 Index Back

SELECT DISTINCT r.business_unit ,r.auc_id , r.auc_round ,r.auc_version ,r.bidder_id ,r.bidder_setid ,r.bidder_type ,1 ,%DecMult((select sum(l.auc_ext_price) from ps_auc_line l WHERE l.business_unit = r.business_unit and l.auc_id = r.auc_id and l.auc_round = r.auc_round and l.auc_version = r.auc_version) , ( SELECT DISTINCT z.cur_exchng_rt FROM ps_cur_rt_tbl z ,PS_AUC_HDR q ,ps_auc_line l WHERE q.auc_id=l.auc_id AND q.auc_version=l.auc_version AND q.auc_round=l.auc_round AND q.business_unit=l.business_unit AND q.auc_id=r.auc_id AND q.auc_version=r.auc_version AND q.auc_round=r.auc_round AND q.business_unit=a.business_unit AND z.from_cur=l.currency_cd AND z.to_cur='USD' AND z.cur_rt_type = q.rt_type AND z.effdt=( SELECT MAX(r.effdt) FROM ps_cur_rt_tbl r WHERE r.from_cur=z.from_cur AND r.to_cur=z.to_cur AND r.cur_rt_type=q.rt_type AND r.effdt<=%CurrentDateIn AND r.eff_status='A') )) AS amount FROM PS_AUC_DISP_HDR a ,PS_AUC_AWARD_LN r WHERE a.auc_id=r.auc_id AND a.auc_version=r.auc_version AND a.auc_round=r.auc_round AND a.business_unit=r.business_unit AND a.bidder_id = r.bidder_id AND a.bidder_type = r.bidder_type AND a.bidder_setid = r.bidder_setid AND r.auc_req_qty > 0 AND r.auc_award_lock_flg = 'Y'

# 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_ID Character(15) VARCHAR2(15) NOT NULL Bidder ID
6 BIDDER_SETID Character(5) VARCHAR2(5) NOT NULL Bidder Setid
7 BIDDER_TYPE Character(1) VARCHAR2(1) NOT NULL Bidder Type
B=Bidder
C=Customer
P=Public
U=Uploaded
V=Supplier
8 NUMBER3 Number(10,0) DECIMAL(10) NOT NULL Number
9 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount