AUC_AWD_P3_VW

(SQL View)
 Index Back

SELECT DISTINCT a.business_unit ,a.bidder_id ,a.bidder_type ,( SELECT COUNT(DISTINCT d.auc_id) FROM PS_AUC_AWARD_LN d WHERE d.auc_award_lock_flg='Y' AND d.business_unit=a.business_unit AND d.bidder_id = a.bidder_id AND d.bidder_setid = a.bidder_setid AND d.bidder_type = a.bidder_type AND d.auc_req_qty>0) FROM ps_auc_disp_hdr a WHERE EXISTS( SELECT 'X' FROM PS_AUC_LINE b WHERE a.auc_id= b.auc_id AND a.auc_version= b.auc_version AND a.auc_round= b.auc_round AND a.business_unit= b.business_unit AND b.auc_version=( SELECT MAX(c.auc_version) FROM PS_AUC_LINE c WHERE c.auc_id= b.auc_id AND c.auc_round= b.auc_round AND c.business_unit= b.business_unit) AND b.auc_round=( SELECT MAX(d.auc_round) FROM PS_AUC_LINE d WHERE d.auc_id= b.auc_id AND d.business_unit= b.business_unit))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 BIDDER_ID Character(15) VARCHAR2(15) NOT NULL Bidder ID
3 BIDDER_TYPE Character(1) VARCHAR2(1) NOT NULL Bidder Type
B=Bidder
C=Customer
P=Public
U=Uploaded
V=Supplier
4 NUMBER3 Number(10,0) DECIMAL(10) NOT NULL Number