SUPOB_BIDDER_VW

(SQL View)
 Index Back

Bidder Contact


SELECT DISTINCT A.SETID , %Substring(%TrimSubstr(B.FIRST_NAME, 1, 30) %Concat ' ' %Concat B.LAST_NAME, 1, 40) , A.BIDDER_ID , A.AUC_COMPANY_NAME , %NumToChar(B.CONTACT_SEQ_NUM) AS BIDDER_LOC , B.TITLE , 'B' , B.EMAILID , B.CONTACT_SEQ_NUM AS CNTCT_SEQ_NUM FROM PS_AUC_BIDDER_HDR A , PS_AUC_CONTACT_HDR B , PSOPRALIAS C WHERE C.OPRALIASTYPE = 'BID' AND C.OPRALIASVALUE = A.BIDDER_ID AND B.SETID = A.SETID AND B.BIDDER_ID = A.BIDDER_ID AND A.EFF_STATUS = 'A' AND A.APPROVAL_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SETID_TBL

2 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
3 BIDDER_ID Character(15) VARCHAR2(15) NOT NULL Bidder ID
4 AUC_COMPANY_NAME Character(40) VARCHAR2(40) NOT NULL Company ID - Company Tax ID
5 BIDDER_LOC Character(10) VARCHAR2(10) NOT NULL Bidder Location
6 TITLE Character(35) VARCHAR2(35) NOT NULL Title
7 BID_CONTACT_TYPE Character(1) VARCHAR2(1) NOT NULL Bidder Type
B=Business
I=Individual
8 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
9 CNTCT_SEQ_NUM Number(5,0) INTEGER NOT NULL Contact Sequence Number