VNDR_PSTL_VW_LG

(SQL View)
 Index Back

Supplier by Postal Cose


SELECT c.language_cd , b.name1 , a.vendor_id FROM ps_vendor_addr a , ps_vendor_lang b , PS_VENDOR_ADDR_LNG c WHERE a.setid = b.setid AND a.vendor_id = b.vendor_id AND a.postal <> ' ' AND a.setid = c.setid AND a.vendor_id = c.vendor_id AND a.address_seq_num = c.address_seq_num AND a.effdt = c.effdt

  • Related Language Record for VNDR_PSTL_VW_LC

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    2 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    3 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier