AUC_MLT_SUP_VW

(SQL View)
 Index Back

Multi-Supplier View


SELECT B.OPRID ,B.SETID ,B.VENDOR_ID ,D.BIDDER_TYPE ,D.CNTCT_SEQ_NUM ,D.BUSINESS_UNIT ,D.AUC_ID ,D.AUC_ROUND ,D.AUC_VERSION ,J.OPRID FROM PS_VENDOR_USER B ,PS_AUC_DISP_ADDR D ,PS_VENDOR_CNTCT E ,PSOPRALIAS J ,PSOPRDEFN K WHERE B.SETID = D.BIDDER_SETID AND B.VENDOR_ID = D.BIDDER_ID AND D.BIDDER_TYPE = 'V' AND D.BIDDER_SETID = E.SETID AND D.BIDDER_ID = E.VENDOR_ID AND D.CNTCT_SEQ_NUM = E.CNTCT_SEQ_NUM AND J.SETID = D.BIDDER_SETID AND J.VENDOR_ID = D.BIDDER_ID AND J.OPRID <> B.OPRID AND J.OPRID = K.OPRID AND K.OPRDEFNDESC = E.CONTACT_NAME UNION SELECT G.OPRID ,G.SETID ,G.BIDDER_ID ,H.BIDDER_TYPE , H.CNTCT_SEQ_NUM ,H.BUSINESS_UNIT ,H.AUC_ID ,H.AUC_ROUND ,H.AUC_VERSION , M.OPRID FROM PS_AUC_BIDDER_USER G ,PS_AUC_DISP_ADDR H , PSOPRALIAS M , PS_AUC_CONTACT_HDR L WHERE G.SETID = H.BIDDER_SETID AND G.BIDDER_ID = H.BIDDER_ID AND H.BIDDER_TYPE = 'B' AND M.SETID = H.BIDDER_SETID AND M.BIDDER_ID = H.BIDDER_ID AND M.OPRID <> G.OPRID AND L.SETID = H.BIDDER_SETID AND L.BIDDER_ID = H.BIDDER_ID AND L.CONTACT_SEQ_NUM = H.CNTCT_SEQ_NUM AND L.OPRID = M.OPRID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
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 CNTCT_SEQ_NUM Number(5,0) INTEGER NOT NULL Contact Sequence Number
6 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
7 AUC_ID Character(10) VARCHAR2(10) NOT NULL Event ID
8 AUC_ROUND Number(5,0) INTEGER NOT NULL Event Round
9 AUC_VERSION Number(5,0) INTEGER NOT NULL Event Version
10 OPRID2 Character(30) VARCHAR2(30) NOT NULL A user's ID