EM_VNNM_OPR_LNG

(SQL View)
 Index Back

Supp Sec Drop Down View - Lang

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

SELECT DISTINCT VL.VENDOR_NAME_SHORT , 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 V.SETID = VL.SETID AND V.VENDOR_ID = VL.VENDOR_ID AND %Sql(EM_SET_CNTRL_EXISTS_OR_NOT)

  • Related Language Record for EM_CVNNM_OPR_VW EM_VENNM_OPR_VW

    • # 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).
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code