EM_LOCL_VN_LGVW

(SQL View)
 Index Back

Local Adm Supp Perm - Language

MarketPay Security Related language view of EM_LOCL_SUPP_VW This SQLview is used as a prompt table behind Supplier IDs in the Seller Security page.This list is retreived from PS_SUPPLIER_USER, where the Host or System Administrator has entered the Seller Administrator's SUPPLIER_IDs from Maintain Suppliers, Use, Supplier User.

SELECT DISTINCT A.OPRID , A.VENDOR_ID , D.LANGUAGE_CD , D.NAME1 , A.SETID FROM PS_VENDOR_USER A , PS_VENDOR B , PS_EM_VENDOR_REG C , PS_VENDOR_LANG D WHERE A.SETID = B.SETID AND A.SETID = C.SETID AND A.SETID = D.SETID AND A.VENDOR_ID = B.VENDOR_ID AND A.VENDOR_ID = C.VENDOR_ID AND A.VENDOR_ID = D.VENDOR_ID

  • Related Language Record for EM_LOCL_VNDR_VW

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

    Prompt Table: VENDOR

    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    5 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SETID_TBL