EM_VNUSR_LNG_VW

(SQL View)
 Index Back

Supplier Security View

This view lists the supplier ids related to an OPRID. It's using the EM_SUPP_USR security table.

SELECT DISTINCT sec.vendor_id , sec.oprid , vl.language_cd , vl.vendor_name_short ,v.setid FROM ps_vendor v , ps_vendor_lang vl , PS_VENDOR_USER sec WHERE v.setid = sec.setid AND v.vendor_id = sec.vendor_id AND v.setid = vl.setid AND v.vendor_id = vl.vendor_id

  • Related Language Record for EM_VND_USER_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
    2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
    5 SETID Character(5) VARCHAR2(5) NOT NULL SetID