CS_BID_PRMPT_VW

(SQL View)
 Index Back

Bidder Prompts

Bidder prompt view which collects bidder id/name from various sources for use on Contract Workbench

SELECT DISTINCT A.BIDDER_SETID , A.BIDDER_ID , A.BIDDER_TYPE , B.NAME1 FROM PS_AUC_DISP_HDR A , PS_VENDOR B WHERE A.BIDDER_TYPE = 'V' AND B.VENDOR_ID = A.BIDDER_ID AND B.SETID = ( SELECT S.SETID FROM PS_SET_CNTRL_REC S WHERE S.SETCNTRLVALUE = A.BUSINESS_UNIT AND S.REC_GROUP_ID = 'FS_38' AND S.RECNAME = 'VENDOR') UNION SELECT DISTINCT A.BIDDER_SETID , A.BIDDER_ID , A.BIDDER_TYPE , B.NAME1 FROM PS_AUC_DISP_HDR A , PS_CUSTOMER B WHERE A.BIDDER_TYPE = 'C' AND B.CUST_ID = A.BIDDER_ID AND B.SETID = ( SELECT S.SETID FROM PS_SET_CNTRL_REC S WHERE S.SETCNTRLVALUE = A.BUSINESS_UNIT AND S.REC_GROUP_ID = 'FS_23' AND S.RECNAME = 'CUSTOMER') UNION SELECT DISTINCT A.BIDDER_SETID , A.BIDDER_ID , A.BIDDER_TYPE , B.AUC_COMPANY_NAME FROM PS_AUC_DISP_HDR A , PS_AUC_BIDDER_HDR B WHERE A.BIDDER_TYPE = 'B' AND B.SETID = A.BIDDER_SETID AND B.BIDDER_ID = A.BIDDER_ID UNION SELECT DISTINCT A.BIDDER_SETID , A.BIDDER_ID , A.BIDDER_TYPE , 'Public' FROM PS_AUC_DISP_HDR A WHERE A.BIDDER_TYPE = 'P'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 BIDDER_ID Character(15) VARCHAR2(15) NOT NULL Bidder ID
3 BIDDER_TYPE Character(1) VARCHAR2(1) NOT NULL Bidder Type
B=Bidder
C=Customer
P=Public
U=Uploaded
V=Supplier
4 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1