AUC_BDR_GRP_VW

(SQL View)
 Index Back

Bidder Group Search View

Active Bidders associated with Bidder Groups.

SELECT A.SETID , A.BIDDER_GRP_ID , A.BIDDER_GRP_TYPE , A.BIDDER_GRP_NAME , B.BIDDER_SETID , B.BIDDER_ID , B.BIDDER_TYPE , B.BIDDER_LOC , B.CNTCT_SEQ_NUM , B.NAME1 , B.AUC_COMPANY_NAME ,'' ,'' FROM PS_BIDDER_GROUP A , PS_BIDDER_GRP_LST B WHERE B.SETID = A.SETID AND B.BIDDER_GRP_ID = A.BIDDER_GRP_ID AND (EXISTS ( SELECT 'X' FROM PS_CUSTOMER C WHERE C.SETID = B.SETID AND C.CUST_ID = B.BIDDER_ID AND C.CUST_STATUS = 'A' ) OR EXISTS ( SELECT 'X' FROM PS_VENDOR D WHERE D.SETID = B.SETID AND D.VENDOR_ID = B.BIDDER_ID AND D.VENDOR_STATUS = 'A' AND D.VNDR_STATUS_PO = 'Y' AND D.VENDOR_PERSISTENCE <> 'S') OR EXISTS ( SELECT 'X' FROM PS_AUC_BIDDER_HDR E WHERE E.SETID = B.SETID AND E.BIDDER_ID = B.BIDDER_ID AND E.EFF_STATUS = 'A' AND E.APPROVAL_STATUS = 'A') )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 BIDDER_GRP_ID Character(15) VARCHAR2(15) NOT NULL Bidder Group ID
3 BIDDER_GRP_TYPE Character(1) VARCHAR2(1) NOT NULL Bidder Group Type
D=Department
P=Personal
4 BIDDER_GRP_NAME Character(50) VARCHAR2(50) NOT NULL Bidder Group Name
5 BIDDER_SETID Character(5) VARCHAR2(5) NOT NULL Bidder Setid
6 BIDDER_ID Character(15) VARCHAR2(15) NOT NULL Bidder ID
7 BIDDER_TYPE Character(1) VARCHAR2(1) NOT NULL Bidder Type
B=Bidder
C=Customer
P=Public
U=Uploaded
V=Supplier
8 BIDDER_LOC Character(10) VARCHAR2(10) NOT NULL Bidder Location
9 CNTCT_SEQ_NUM Number(5,0) INTEGER NOT NULL Contact Sequence Number
10 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
11 AUC_COMPANY_NAME Character(40) VARCHAR2(40) NOT NULL Company ID - Company Tax ID
12 VENDOR_TYPE Character(3) VARCHAR2(3) NOT NULL Vendor Type
ADV=Ads
CNS=Consultant
CNT=Contractor
ENT=Entertain
FRG=Foreign
GVT=Government
MNR=Minority
PR=PR
TRD=Tradesman
TRN=Transport
TRV=Travel
13 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID