SUP_NON_MINOR_L

(SQL View)
Index Back

Emerging BU


SELECT B.LANGUAGE_CD , A.SETID ,A.BIDDER_ID ,B.MESSAGE_TEXT FROM PS_BIDDER_FPDS A , PSMSGCATLANG B WHERE A.DISABLED ='N' AND A.EMERGING_SM_BUS =' ' AND A.VETERAN_FLG ='N' AND A.WOMEN_OWNED =' ' AND B.MESSAGE_SET_NBR = '10320' AND B.MESSAGE_NBR = '792'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
2 SETID Character(5) VARCHAR2(5) NOT NULL SetID
3 BIDDER_ID Character(15) VARCHAR2(15) NOT NULL Bidder ID
4 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description