AUC_BIDSUP_ID_V

(SQL View)
 Index Back

Bidder & Supplier ID View


SELECT SETID , VENDOR_ID , NAME1 , 'V' FROM PS_VENDOR WHERE VENDOR_STATUS = 'A' AND VENDOR_PERSISTENCE IN ('O','P','R') UNION SELECT DISTINCT A.SETID , A.BIDDER_ID , A.AUC_COMPANY_NAME , 'B' 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 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
3 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
4 AUC_BID_SUP_TYPE Character(1) VARCHAR2(1) NOT NULL Bidder Supplier Type
B=Bidder
V=Supplier