EM_VENID1OPR_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 v.vendor_id , sec.oprid FROM PS_EM_AGREEMENT ag , ps_sec_bu_opr sec , ps_set_cntrl_rec st , ps_vendor v WHERE ag.setid = st.setid AND st.setcntrlvalue = sec.business_unit AND st.recname = 'EM_AGREEMENT' AND v.setid = ag.vendor_setid AND v.vendor_id = ag.vendor_id AND v.vendor_status = 'A'

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