AUC_AWD_BIDNAME

(SQL View)
 Index Back

SELECT DISTINCT A.BUSINESS_UNIT , A.AUC_ID , A.AUC_ROUND , A.AUC_VERSION , A.BIDNUM , A.BIDDER_SETID , A.BIDDER_ID , A.BIDDER_TYPE , A.BIDDER_LOC , A.CURRENCY_CD , A.RESP_CURRENCY_CD , A.RESP_DTTM_POST , (CASE A.BIDDER_TYPE WHEN 'V' THEN B.NAME1 WHEN 'C' THEN C.NAME1 ELSE (CASE D.BID_CONTACT_TYPE WHEN 'B' THEN D.AUC_COMPANY_NAME ELSE %Substring(%trimsubstr(D.FIRST_NAME, 1, 30) %Concat ' ' %Concat %trimsubstr(D.LAST_NAME, 1, 30), 1, 40) END) END) FROM PS_RESP_HDR A LEFT OUTER JOIN PS_VENDOR B ON B.SETID = A.BIDDER_SETID AND B.VENDOR_ID = A.BIDDER_ID LEFT OUTER JOIN PS_CUSTOMER C ON C.SETID = A.BIDDER_SETID AND C.CUST_ID = A.BIDDER_ID LEFT OUTER JOIN PS_AUC_DISP_ADDR E ON E.BUSINESS_UNIT = A.BUSINESS_UNIT AND E.AUC_ID = A.AUC_ID AND E.AUC_ROUND = A.AUC_ROUND AND E.BIDDER_SETID = A.BIDDER_SETID AND E.BIDDER_ID = A.BIDDER_ID AND E.BIDDER_TYPE = A.BIDDER_TYPE AND E.BIDDER_LOC = A.BIDDER_LOC LEFT OUTER JOIN PS_AUC_AWD_BIDDER D ON D.SETID = E.BIDDER_SETID AND D.BIDDER_ID = E.BIDDER_ID AND E.CNTCT_SEQ_NUM = D.CONTACT_SEQ_NUM WHERE A.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
2 AUC_ID Character(10) VARCHAR2(10) NOT NULL Event ID
3 AUC_ROUND Number(5,0) INTEGER NOT NULL Event Round
4 AUC_VERSION Number(5,0) INTEGER NOT NULL Event Version
5 BIDNUM Signed Number(6,0) DECIMAL(5) NOT NULL Bid ID
6 BIDDER_SETID Character(5) VARCHAR2(5) NOT NULL Bidder Setid
7 BIDDER_ID Character(15) VARCHAR2(15) NOT NULL Bidder ID
8 BIDDER_TYPE Character(1) VARCHAR2(1) NOT NULL Bidder Type
B=Bidder
C=Customer
P=Public
U=Uploaded
V=Supplier
9 BIDDER_LOC Character(10) VARCHAR2(10) NOT NULL Bidder Location
10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
11 RESP_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
12 RESP_DTTM_POST DateTime(26) TIMESTAMP Response Date Time
13 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1