EM_CVENNMOPR_LN

(SQL View)
 Index Back

Supplier Security Drop Down Vi

Language view is used by the voucher inquiries screen to list the supplier's related to an OPRID. Used in the Buyer Direct model. Market Pay Module

SELECT DISTINCT VL.NAME1 , B.OPRID , VL.LANGUAGE_CD FROM PS_VENDOR A , PS_SEC_BU_OPR B , PS_SET_CNTRL_REC C , PS_VENDOR_LANG VL WHERE A.SETID = C.SETID AND C.SETCNTRLVALUE = B.BUSINESS_UNIT AND C.RECNAME = 'VENDOR' AND VL.SETID = A.SETID AND VL.VENDOR_ID = A.VENDOR_ID

  • Related Language Record for EM_CVENNMOPR_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    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