EM_VENNM_OPR_VW

(SQL View)
 Index Back

Supplier Security Drop Down Vi

This view is used by the voucher inquiries screen to list the supplier's related to an OPRID.

SELECT DISTINCT V.VENDOR_NAME_SHORT , SEC.OPRID FROM PS_EM_AGREEMENT AG , PS_SEC_BU_OPR SEC , PS_VENDOR V WHERE SEC.BUSINESS_UNIT = AG.SETID AND V.SETID = AG.VENDOR_SETID AND V.VENDOR_ID = AG.VENDOR_ID AND V.VENDOR_STATUS = 'A' AND %Sql(EM_SET_CNTRL_EXISTS_OR_NOT)

  • Related Language Record: EM_VNNM_OPR_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
    2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).