AUC_NONAWARD_VW

(SQL View)
 Index Back

SELECT DISTINCT B.BUSINESS_UNIT , B.AUC_ID , B.AUC_ROUND , B.AUC_VERSION , B.BIDDER_SETID , B.BIDDER_ID , B.BIDDER_TYPE , ( SELECT DISTINCT C.RESP_BIDDER_NAME1 FROM PS_RESP_HDR C WHERE 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.BIDDER_SETID = B.BIDDER_SETID AND C.BIDDER_ID = B.BIDDER_ID AND C.BIDDER_TYPE = B.BIDDER_TYPE) ,' ' FROM PS_AUC_AWARDBDR_VW A , PS_AUC_RESPBDR_VW B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.AUC_ID = B.AUC_ID AND B.BIDDER_ID NOT IN ( SELECT A.BIDDER_ID FROM PS_AUC_AWARDBDR_VW A 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 B.BIDDER_SETID NOT IN ( SELECT A.BIDDER_SETID FROM PS_AUC_AWARDBDR_VW A 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 B.BIDDER_TYPE NOT IN ( SELECT A.BIDDER_TYPE FROM PS_AUC_AWARDBDR_VW A 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)))

# 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 RESP_BIDDER_NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
9 DESCRLONG Long Character CLOB Long Description