RESP_BPRC_BD_VW

(SQL View)
Index Back

SELECT C.BUSINESS_UNIT , C.AUC_ID , C.AUC_ROUND , C.AUC_VERSION , C.BIDDER_SETID , C.BIDDER_ID , C.BIDDER_TYPE , C.BIDDER_LOC , C.LINE_NBR , C.GRP_LINE_NBR , C.BID_FACTOR_NBR , C.BID_FACTOR_CD , MIN(C.BID_RESP_QTY ) , MAX(C.BID_RESP_QTY ) FROM PS_RESP_HDR A ,PS_RESP_LN B ,PS_RESP_LN_FACTOR C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.AUC_ID = B.AUC_ID AND A.AUC_ROUND = B.AUC_ROUND AND A.AUC_VERSION = B.AUC_VERSION AND A.BIDDER_SETID = B.BIDDER_SETID AND A.BIDDER_ID = B.BIDDER_ID AND A.BIDDER_TYPE = B.BIDDER_TYPE AND A.BIDDER_LOC = B.BIDDER_LOC AND A.BIDNUM = B.BIDNUM AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.AUC_ID = C.AUC_ID AND B.AUC_ROUND = C.AUC_ROUND AND B.AUC_VERSION = C.AUC_VERSION AND B.BIDDER_SETID = C.BIDDER_SETID AND B.BIDDER_ID = C.BIDDER_ID AND B.BIDDER_TYPE = C.BIDDER_TYPE AND B.BIDDER_LOC = C.BIDDER_LOC AND B.BIDNUM = C.BIDNUM AND B.LINE_NBR = C.LINE_NBR AND A.AUC_BID_STATUS = 'P' AND C.GRP_LINE_NBR = 0 AND C.PRICE_FLG = 'Y' AND C.BID_RESP_QTY > 0 GROUP BY C.BUSINESS_UNIT , C.AUC_ID , C.AUC_ROUND , C.AUC_VERSION , C.BIDDER_SETID , C.BIDDER_ID , C.BIDDER_TYPE , C.BIDDER_LOC , C.LINE_NBR , C.GRP_LINE_NBR , C.BID_FACTOR_NBR , C.BID_FACTOR_CD

# 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_SETID Character(5) VARCHAR2(5) NOT NULL Bidder Setid
6 BIDDER_ID Character(15) VARCHAR2(15) NOT NULL Bidder ID
7 BIDDER_TYPE Character(1) VARCHAR2(1) NOT NULL Bidder Type
B=Bidder
C=Customer
P=Public
U=Uploaded
V=Supplier
8 BIDDER_LOC Character(10) VARCHAR2(10) NOT NULL Bidder Location
9 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
10 GRP_LINE_NBR Number(5,0) INTEGER NOT NULL Group Line Number
11 BID_FACTOR_NBR Number(10,0) DECIMAL(10) NOT NULL Bid Factor Number
12 BID_FACTOR_CD Character(18) VARCHAR2(18) NOT NULL Bid Factor Code

Prompt Table: BID_FACTOR_VW

13 MIN_QTY Signed Number(20,6) DECIMAL(18,6) NOT NULL Minimum Quantity
14 MAX_QTY Signed Number(20,6) DECIMAL(18,6) NOT NULL Maximum Quantity