AUC_BID_ACT2_VW

(SQL View)
 Index Back

Unique Bidders With Response

Same as AUC_BID_ACT_SCH w/o bussiness unit and bidder location

SELECT DISTINCT A.BUSINESS_UNIT , A.BIDDER_SETID , A.BIDDER_ID , A.BIDDER_TYPE , A.BIDDER_LOC , 'E' ,'SCH' FROM PS_RESP_HDR A WHERE A.AUC_BID_STATUS = 'P' UNION SELECT DISTINCT H1.BUSINESS_UNIT , H1.BIDDER_SETID ,H1.BIDDER_ID ,H1.BIDDER_TYPE ,H1.BIDDER_LOC , 'E' ,'SCH' FROM PS_AUC_DISP_HDR H1 , PS_AUC_HDR Y2 WHERE H1.BUSINESS_UNIT = Y2.BUSINESS_UNIT AND H1.AUC_ID= Y2.AUC_ID AND H1.AUC_ROUND = Y2.AUC_ROUND AND H1.AUC_VERSION = Y2.AUC_VERSION AND H1.BIDDER_TYPE <> 'P' AND Y2.AUC_STATUS NOT IN ('O', 'X', 'S') AND NOT EXISTS ( SELECT 'X' FROM PS_RESP_HDR D1 WHERE D1.BUSINESS_UNIT = H1.BUSINESS_UNIT AND D1.AUC_ID = H1.AUC_ID AND D1.AUC_ROUND = H1.AUC_ROUND AND D1.AUC_VERSION = H1.AUC_VERSION AND D1.BIDDER_SETID= H1.BIDDER_SETID AND D1.BIDDER_ID = H1.BIDDER_ID AND D1.BIDDER_TYPE = H1.BIDDER_TYPE AND D1.BIDDER_LOC = H1.BIDDER_LOC AND D1.AUC_BID_STATUS = 'P' )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 BIDDER_SETID Character(5) VARCHAR2(5) NOT NULL Bidder Setid
3 BIDDER_ID Character(15) VARCHAR2(15) NOT NULL Bidder ID
4 BIDDER_TYPE Character(1) VARCHAR2(1) NOT NULL Bidder Type
B=Bidder
C=Customer
P=Public
U=Uploaded
V=Supplier
5 BIDDER_LOC Character(10) VARCHAR2(10) NOT NULL Bidder Location
6 BID_ACT_TYPE_FLG Character(1) VARCHAR2(1) NOT NULL Bidder Activity Report Type
E=Event Creator
M=My Activity
7 RESP_DISP_SRC Character(3) VARCHAR2(3) NOT NULL Disp Table Source