RESP_BPRC_AL_VW

(SQL View)
 Index Back

SELECT C.BUSINESS_UNIT , C.AUC_ID , C.AUC_ROUND , C.AUC_VERSION , C.LINE_NBR , C.BID_FACTOR_NBR , C.BID_FACTOR_CD , MIN(C.BID_RESP_QTY ) , MAX(C.BID_RESP_QTY ) , MAX(B.BID_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.BIDNUM = B.BIDNUM 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 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.BIDNUM = C.BIDNUM AND B.LINE_NBR = C.LINE_NBR 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 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.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 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
6 BID_FACTOR_NBR Number(10,0) DECIMAL(10) NOT NULL Bid Factor Number
7 BID_FACTOR_CD Character(18) VARCHAR2(18) NOT NULL Bid Factor Code

Prompt Table: BID_FACTOR_VW

8 MIN_QTY Signed Number(20,6) DECIMAL(18,6) NOT NULL Minimum Quantity
9 MAX_QTY Signed Number(20,6) DECIMAL(18,6) NOT NULL Maximum Quantity
10 BID_QTY Number(16,4) DECIMAL(15,4) NOT NULL Bid Quantity