CNTRCT_MSTR_LVW

(SQL View)
 Index Back

Master Contract View


SELECT b.setid , b.vendor_setid , b.vendor_id , b.mstr_cntrct_id , a.language_cd , a.vendor_name_short , c.descr50 FROM PS_VENDOR_lang a , ps_cntrct_mstr b , ps_cntrct_mstr_lng c WHERE b.vendor_setid = a.setid AND b.vendor_id = a.vendor_id AND b.setid = c.setid AND b.mstr_cntrct_id = c.mstr_cntrct_id AND a.language_cd = c.language_cd UNION SELECT b2.setid , b2.vendor_setid , b2.vendor_id , b2.mstr_cntrct_id , a2.language_cd , a2.vendor_name_short , b2.descr50 FROM PS_VENDOR_lang a2 , ps_cntrct_mstr b2 WHERE b2.vendor_setid = a2.setid AND b2.vendor_id = a2.vendor_id AND NOT EXISTS ( SELECT 'X' FROM ps_cntrct_mstr_lng c2 WHERE b2.setid = c2.setid AND b2.mstr_cntrct_id = c2.mstr_cntrct_id AND a2.language_cd = c2.language_cd) UNION SELECT b3.setid , b3.vendor_setid , b3.vendor_id , b3.mstr_cntrct_id , c3.language_cd , a3.vendor_name_short , c3.descr50 FROM PS_VENDOR a3 , ps_cntrct_mstr b3 , ps_cntrct_mstr_lng c3 WHERE b3.vendor_setid = a3.setid AND b3.vendor_id = a3.vendor_id AND b3.setid = c3.setid AND b3.mstr_cntrct_id = c3.mstr_cntrct_id AND NOT EXISTS ( SELECT 'X' FROM PS_VENDOR_lang d3 WHERE b3.vendor_setid = d3.setid AND b3.vendor_id = d3.vendor_id AND c3.language_cd = d3.language_cd)

  • Related Language Record for CNTRCT_MSTR_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
    3 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
    4 MSTR_CNTRCT_ID Character(10) VARCHAR2(10) NOT NULL Master Contract ID
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
    7 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50