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

SELECT DISTINCT V.VENDOR_ID , V.NAME1 , 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 AG.EM_AGREE_BUYER = 'Y' AND AG.EM_AGREE_SELLER='Y' AND %Sql(EM_SET_CNTRL_EXISTS_OR_NOT)

  • Related Language Record: EM_VENID_OPR_LN

    • # 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).