RESP_TOT_LNW_VW

(SQL View)
 Index Back

Response Line

Used to store Response Line details

SELECT A.BUSINESS_UNIT , A.AUC_ID , A.AUC_ROUND , A.AUC_VERSION , A.BIDNUM , A.LINE_NBR , A.BIDDER_SETID , A.BIDDER_ID , A.BIDDER_TYPE , A.BIDDER_LOC , E.BID_CNTR_ACTION , E.IS_NOBID , (CASE C.AUC_LINE_TYPE WHEN 'G' THEN %Round(SUM( %DecMult(A.BID_SCORE , B.WEIGHTING) ), 3) ELSE %Round(SUM( (%DecDiv ( (%DecMult ( (%DecMult(A.BID_SCORE , B.WEIGHTING) ) , C.WEIGHTING )) , 100 ) )), 3) END) FROM PS_RESP_LN_FACTOR A , PS_AUC_LN_BID_FCTR B , PS_AUC_LINE C , PS_RESP_HDR D , PS_RESP_LN E WHERE B.AUC_ID = A.AUC_ID AND B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.AUC_ROUND = A.AUC_ROUND AND B.AUC_VERSION = A.AUC_VERSION AND B.LINE_NBR = A.LINE_NBR AND B.BID_FACTOR_NBR = A.BID_FACTOR_NBR AND B.SETID = A.SETID AND B.BID_FACTOR_CD = A.BID_FACTOR_CD AND B.BID_FACTOR_TYPE = A.BID_FACTOR_TYPE AND C.BUSINESS_UNIT = A.BUSINESS_UNIT AND C.AUC_ID = A.AUC_ID AND C.AUC_ROUND = A.AUC_ROUND AND C.AUC_VERSION = A.AUC_VERSION AND C.LINE_NBR = A.LINE_NBR AND E.BUSINESS_UNIT = A.BUSINESS_UNIT AND E.AUC_ID = A.AUC_ID AND E.AUC_ROUND = A.AUC_ROUND AND E.AUC_VERSION = A.AUC_VERSION AND E.BIDNUM = A.BIDNUM AND E.BIDDER_SETID = A.BIDDER_SETID AND E.BIDDER_ID = A.BIDDER_ID AND E.BIDDER_TYPE = A.BIDDER_TYPE AND E.BIDDER_LOC = A.BIDDER_LOC AND E.LINE_NBR = A.LINE_NBR AND D.BUSINESS_UNIT = A.BUSINESS_UNIT AND D.AUC_ID = A.AUC_ID AND D.AUC_ROUND = A.AUC_ROUND AND D.AUC_VERSION = A.AUC_VERSION AND D.BIDNUM = A.BIDNUM AND D.BIDDER_SETID = A.BIDDER_SETID AND D.BIDDER_ID = A.BIDDER_ID AND D.BIDDER_TYPE = A.BIDDER_TYPE AND D.BIDDER_LOC = A.BIDDER_LOC AND (D.AUC_BID_STATUS = 'P' OR d.auc_bid_status = 'D') GROUP BY A.BUSINESS_UNIT, A.AUC_ID, A.AUC_ROUND, A.AUC_VERSION, A.BIDNUM, A.LINE_NBR , A.BIDDER_SETID , A.BIDDER_ID, A.BIDDER_TYPE, A.BIDDER_LOC , E.BID_CNTR_ACTION, E.IS_NOBID, C.AUC_LINE_TYPE

# 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

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 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
7 BIDDER_SETID Character(5) VARCHAR2(5) NOT NULL Bidder Setid
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 BID_CNTR_ACTION Character(1) VARCHAR2(1) NOT NULL Bid Counter Action
A=Accept
C=Counter
W=Withdrawal
12 IS_NOBID Character(1) VARCHAR2(1) NOT NULL No Bid

Y/N Table Edit

13 AUC_LN_BF_SCR_TTL Number(11,7) DECIMAL(10,7) NOT NULL Total Line Bid Factor Score