RESP_TOT_LN_VW

(SQL View)

SELECT B.BUSINESS_UNIT , B.AUC_ID , B.AUC_ROUND , B.AUC_VERSION , B.BIDNUM , B.LINE_NBR , B.BIDDER_SETID , B.BIDDER_ID , B.BIDDER_TYPE , B.BIDDER_LOC , D.WEIGHTING , %Round ( (SUM(%DecMult(B.BID_SCORE , C.WEIGHTING) ) ) , 7) FROM PS_RESP_HDR A ,PS_RESP_LN_FACTOR B , PS_AUC_LN_BID_FCTR C , PS_AUC_LINE D 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 = A.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 C.BUSINESS_UNIT = B.BUSINESS_UNIT AND C.AUC_ID = B.AUC_ID AND C.AUC_ROUND = B.AUC_ROUND AND C.AUC_VERSION =B.AUC_VERSION AND C.LINE_NBR = B.LINE_NBR AND C.BID_FACTOR_NBR = B.BID_FACTOR_NBR AND C.BUSINESS_UNIT = D.BUSINESS_UNIT AND C.AUC_ID = D.AUC_ID AND C.AUC_ROUND = D.AUC_ROUND AND C.AUC_VERSION = D.AUC_VERSION AND C.LINE_NBR = D.LINE_NBR AND A.AUC_BID_STATUS = 'P' GROUP BY B.BUSINESS_UNIT , B.AUC_ID , B.AUC_ROUND, B.AUC_VERSION , B.BIDNUM , B.BIDDER_SETID , B.BIDDER_ID , B.BIDDER_TYPE , B.BIDDER_LOC , B.LINE_NBR , D.WEIGHTING

# 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

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

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 WEIGHTING Signed Number(10,5) DECIMAL(8,5) NOT NULL Used for applying a weighting to totals. e.g. Limit Utilisation totals

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

#	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
4	AUC_VERSION	Number(5,0)	INTEGER NOT NULL	Event Version
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	WEIGHTING	Signed Number(10,5)	DECIMAL(8,5) NOT NULL	Used for applying a weighting to totals. e.g. Limit Utilisation totals
12	AUC_LN_BF_SCR_TTL	Number(11,7)	DECIMAL(10,7) NOT NULL	Total Line Bid Factor Score