AUC_PROMPT_VW3

(SQL View)
 Index Back

AUC Record View


SELECT DISTINCT A.BUSINESS_UNIT ,A.AUC_ID ,A.AUC_ROUND ,A.AUC_VERSION ,A.RESP_BIDDER_NAME1 ,A.BIDDER_TYPE ,A.BIDDER_ID ,G.BID_CNTR_ACTION FROM PS_AUC_RESP_TTL_VW A ,PS_RESP_LN G WHERE (EXISTS ( SELECT B.BIDDER_ID FROM PS_RESP_COMM_ATTCH B WHERE A.BIDDER_ID = B.BIDDER_ID AND A.AUC_ID = B.AUC_ID AND B.AUC_EVENT_PDF_FLG<>'Y') OR EXISTS ( SELECT C.BIDDER_ID FROM PS_RESP_COMM_HF_AT C WHERE C.BIDDER_ID = A.BIDDER_ID AND A.AUC_ID = C.AUC_ID) OR EXISTS ( SELECT D.BIDDER_ID FROM PS_RESP_LN_ATTCH D WHERE A.BIDDER_ID = D.BIDDER_ID AND A.AUC_ID = D.AUC_ID) OR EXISTS ( SELECT E.BIDDER_ID FROM PS_RESP_LN_FCTRATT E WHERE A.BIDDER_ID = E.BIDDER_ID AND A.AUC_ID = E.AUC_ID)) AND A.AUC_ROUND = ( SELECT MAX(F.AUC_ROUND) FROM PS_AUC_RESP_TTL_VW F WHERE A.BUSINESS_UNIT = F.BUSINESS_UNIT AND A.AUC_ID = F.AUC_ID AND A.AUC_VERSION = F.AUC_VERSION) AND A.BUSINESS_UNIT = G.BUSINESS_UNIT AND A.AUC_ID = G.AUC_ID AND A.AUC_VERSION = G.AUC_VERSION AND A.AUC_ROUND = G.AUC_ROUND UNION SELECT DISTINCT A.BUSINESS_UNIT ,A.AUC_ID ,A.AUC_ROUND ,A.AUC_VERSION ,A.RESP_BIDDER_NAME1 ,A.BIDDER_TYPE ,A.BIDDER_ID ,' ' FROM PS_AUC_RESP_TTL_VW A WHERE (EXISTS ( SELECT B.BIDDER_ID FROM PS_RESP_COMM_ATTCH B WHERE A.BIDDER_ID = B.BIDDER_ID AND A.AUC_ID = B.AUC_ID AND B.AUC_EVENT_PDF_FLG<>'Y') OR EXISTS ( SELECT C.BIDDER_ID FROM PS_RESP_COMM_HF_AT C WHERE C.BIDDER_ID = A.BIDDER_ID AND A.AUC_ID = C.AUC_ID) OR EXISTS ( SELECT D.BIDDER_ID FROM PS_RESP_LN_ATTCH D WHERE A.BIDDER_ID = D.BIDDER_ID AND A.AUC_ID = D.AUC_ID) OR EXISTS ( SELECT E.BIDDER_ID FROM PS_RESP_LN_FCTRATT E WHERE A.BIDDER_ID = E.BIDDER_ID AND A.AUC_ID = E.AUC_ID)) AND A.AUC_ROUND = ( SELECT MAX(F.AUC_ROUND) FROM PS_AUC_RESP_TTL_VW F WHERE A.BUSINESS_UNIT = F.BUSINESS_UNIT AND A.AUC_ID = F.AUC_ID AND A.AUC_VERSION = F.AUC_VERSION)

# 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 RESP_BIDDER_NAME1 Character(40) VARCHAR2(40) NOT NULL Name
6 BIDDER_TYPE Character(1) VARCHAR2(1) NOT NULL Bidder Type
B=Bidder
C=Customer
P=Public
U=Uploaded
V=Supplier
7 BIDDER_ID Character(15) VARCHAR2(15) NOT NULL Bidder ID
8 AUC_WTH_DRWNBIDDER Character(4) VARCHAR2(4) NOT NULL Withdrawn Bidder