AUC_HDR_COST_VW

(SQL View)
 Index Back

SELECT a.business_unit , a.auc_id , a.auc_round , a.auc_version , a.bidnum , a.bidder_setid , a.bid_factor_nbr , a.bidder_id , a.bidder_type , a.bidder_loc , %Round(SUM(%DecMult(a.bid_resp_qty, b.bid_qty) ) , 5) , SUM(b.bid_pbk_base_qty) , COUNT(*) FROM PS_RESP_LN_factor a , PS_RESP_LN b WHERE b.business_unit = a.business_unit AND b.auc_id = a.auc_id AND B.AUC_ROUND = A.AUC_ROUND AND B.AUC_VERSION = B.AUC_VERSION AND b.bidnum = a.bidnum AND b.bidder_setid = a.bidder_setid AND b.bidder_id = a.bidder_id AND b.bidder_type = a.bidder_type AND b.bidder_loc = a.bidder_loc AND b.line_nbr = a.line_nbr AND a.price_flg = 'Y' AND a.grp_line_nbr = 0 GROUP BY a.business_unit, a.auc_id, a.auc_round, a.auc_version , a.bidnum , a.bidder_setid , a.bid_factor_nbr , a.bidder_id , a.bidder_type , a.bidder_loc

# 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

Default Value: NEXT

3 AUC_ROUND Number(5,0) INTEGER NOT NULL Event Round

Default Value: 1

4 AUC_VERSION Number(5,0) INTEGER NOT NULL Event Version

Default Value: 1

5 BIDNUM Signed Number(6,0) DECIMAL(5) NOT NULL Bid ID
6 BIDDER_SETID Character(5) VARCHAR2(5) NOT NULL Bidder Setid
7 BID_FACTOR_NBR Number(10,0) DECIMAL(10) NOT NULL Bid Factor Number
8 BIDDER_ID Character(15) VARCHAR2(15) NOT NULL Bidder ID
9 BIDDER_TYPE Character(1) VARCHAR2(1) NOT NULL Bidder Type
B=Bidder
C=Customer
P=Public
U=Uploaded
V=Supplier
10 BIDDER_LOC Character(10) VARCHAR2(10) NOT NULL Bidder Location
11 AUC_HDR_PRICE Number(19,6) DECIMAL(18,6) NOT NULL Event Price
12 BID_PBK_BASE_QTY Number(16,4) DECIMAL(15,4) NOT NULL Price Brake Base Qty
13 AUC_NUM_LINES Number(6,0) INTEGER NOT NULL Number of Lines