OPRIDSETIDVENDOR_IDEM_VE_BUAGR1_VW(SQL View) |
Index Back |
|---|---|
View of Active Suppliers |
| SELECT DISTINCT sec.oprid , v.setid , v.vendor_id , v.vendor_name_short 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 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 3 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 4 | VENDOR_NAME_SHORT | Character(14) | VARCHAR2(14) NOT NULL | Short Vendor Name |