RESP_PXY_BRF_VW

(SQL View)
 Index Back

SELECT A.BUSINESS_UNIT , A.AUC_ID , A.AUC_ROUND , A.AUC_VERSION , A.BIDDER_SETID , A.BIDDER_ID , A.BIDDER_TYPE , A.BIDDER_LOC , A.BIDNUM , A.LINE_NBR , A.BID_FACTOR_NBR , A.SEQ_NBR , A.PXY_STATUS , A.BID_FACTOR_CD , A.PXY_BEST_PRICE , A.PXY_NEW_PRICE , A.PXY_OLD_PRICE , A.PXY_TRIGGER_PRICE , A.RESP_DTTM_POST , A.RESP_DTTM_LAST FROM PS_RESP_LN_PROXY A WHERE A.PXY_STATUS = 'A' AND A.PXY_NEW_PRICE = ( SELECT MAX(X.PXY_NEW_PRICE) FROM PS_RESP_LN_PROXY X WHERE A.BUSINESS_UNIT = X.BUSINESS_UNIT AND A.AUC_ID = X.AUC_ID AND A.AUC_ROUND = X.AUC_ROUND AND A.AUC_VERSION = X.AUC_VERSION AND A.LINE_NBR = X.LINE_NBR AND A.BID_FACTOR_NBR = X. BID_FACTOR_NBR AND X.PXY_NEW_PRICE > 0 AND X.PXY_STATUS = 'A' )

# 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 BIDNUM Signed Number(6,0) DECIMAL(5) NOT NULL Bid ID
10 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
11 BID_FACTOR_NBR Number(10,0) DECIMAL(10) NOT NULL Bid Factor Number
12 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
13 PXY_STATUS Character(1) VARCHAR2(1) NOT NULL Proxy Row Status
A=Active
W=Disallowed
X=Canceled
14 BID_FACTOR_CD Character(18) VARCHAR2(18) NOT NULL Bid Factor Code
15 PXY_BEST_PRICE Number(19,6) DECIMAL(18,6) NOT NULL Bid Response Price
16 PXY_NEW_PRICE Number(19,6) DECIMAL(18,6) NOT NULL Bid Response Price
17 PXY_OLD_PRICE Number(19,6) DECIMAL(18,6) NOT NULL Bid Response Price
18 PXY_TRIGGER_PRICE Number(19,6) DECIMAL(18,6) NOT NULL Bid Response Price
19 RESP_DTTM_POST DateTime(26) TIMESTAMP Response Date Time
20 RESP_DTTM_LAST DateTime(26) TIMESTAMP Last Entry Date Time