EM_CVENNMOPR_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. Market Pay Module

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

  • Related Language Record: EM_CVENNMOPR_LN

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