AUC_DISP_BDR_VW

(SQL View)
Index Back

SELECT DISTINCT A.BUSINESS_UNIT , A.BIDDER_SETID ,A.BIDDER_ID ,A.BIDDER_TYPE ,A.BIDDER_LOC ,'SCH' AS RESP_DISP_SRC FROM PS_RESP_HDR A WHERE AUC_BID_STATUS = 'P'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: BUS_UNIT_TBL_A1

2 BIDDER_SETID Character(5) VARCHAR2(5) NOT NULL Bidder Setid
3 BIDDER_ID Character(15) VARCHAR2(15) NOT NULL Bidder ID
4 BIDDER_TYPE Character(1) VARCHAR2(1) NOT NULL Bidder Type
B=Bidder
C=Customer
P=Public
U=Uploaded
V=Supplier
5 BIDDER_LOC Character(10) VARCHAR2(10) NOT NULL Bidder Location
6 RESP_DISP_SRC Character(3) VARCHAR2(3) NOT NULL Disp Table Source