EM_VNRID_USR_VW

(SQL View)
 Index Back

Supplier Security Drop Down Vi

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 , v.vendor_name_short FROM ps_vendor v , PS_VENDOR_USER sec WHERE v.setid = sec.setid AND v.vendor_id = sec.vendor_id

  • Related Language Record: EM_VNRID_USR_LG

    • # 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 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name