EM_VE_BUAGRT_LG

(SQL View)
Index Back

View of Active Suppliers


SELECT DISTINCT SEC.OPRID , V.SETID , V.VENDOR_ID , VL.LANGUAGE_CD , VL.VENDOR_NAME_SHORT FROM PS_EM_AGREEMENT AG , PS_SEC_BU_OPR SEC , PS_VENDOR V , PS_VENDOR_LANG VL WHERE SEC.BUSINESS_UNIT = AG.SETID AND V.SETID = AG.VENDOR_SETID AND V.VENDOR_ID = AG.VENDOR_ID AND V.SETID = VL.SETID AND V.VENDOR_ID = VL.VENDOR_ID

  • Related Language Record for EM_VE_BUAGRT_VW
  • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name