EM_CVNNM_OPR_VW

(SQL View)
 Index Back

Complete Supplier Name - BD

This view is used by the voucher inquiries screen to list the supplier's related to an OPRID based on the BD model.

SELECT DISTINCT A.VENDOR_NAME_SHORT , B.OPRID , A.NAME1 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_VNNM_OPR_LNG

    • # 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 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1