AUC_PROMPT_VW2

(SQL View)
 Index Back

AUC Record View


SELECT DISTINCT a.BUSINESS_UNIT ,a.AUC_ID ,a.AUC_ROUND ,a.AUC_VERSION ,a.BIDDER_ID ,a.BIDDER_TYPE ,a.RESP_BIDDER_NAME1 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) 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_comm_hf_at 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))

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