EM_VENID_OPR_LN

(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 based on an agreement between a buyer and supplier. Market Pay Module

SELECT DISTINCT V.VENDOR_ID , V.NAME1 , SEC.OPRID , VL.LANGUAGE_CD FROM PS_EM_AGREEMENT AG , PS_SEC_BU_OPR SEC , PS_VENDOR V , PS_VENDOR_LANG VL 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) AND VL.SETID = V.SETID AND VL.VENDOR_ID = V.VENDOR_ID

  • Related Language Record for EM_VENID_OPR_VW

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