AUC_BID_SUP_VW1

(SQL View)
 Index Back

Bidder & Supplier Name View


SELECT SETID ,NAME1 ,VENDOR_ID , 'V' FROM PS_VENDOR WHERE VENDOR_STATUS IN ('A', 'E') AND VENDOR_PERSISTENCE <> 'S' UNION SELECT SETID ,AUC_COMPANY_NAME ,BIDDER_ID , 'B' FROM PS_AUC_BIDDER_HDR WHERE EFF_STATUS = 'A' AND 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 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
4 AUC_BID_SUP_TYPE Character(1) VARCHAR2(1) NOT NULL Bidder Supplier Type
B=Bidder
V=Supplier