EM_REQUEST_LANG

(SQL View)
Index Back

eS Requestor-Related Language

Related Language view for EM_REQUEST_VW. Returns list of Requestor IDs that are OPRIDs and are mapped to an eS Role via the EM_ROLE_CONFIG page/component. OPRID must have a Role that is configured/mapped to eS Buyer role types (includes System Administrator in result set).

SELECT DISTINCT C.OPRID , E.LANGUAGE_CD , E.DESCR , C.EMAILID FROM PSROLEDEFN A , PS_EM_ROLE_CONFIG B , PS_ROLEXLATOPR C , PSROLEUSER D , PS_ROLEXLATOPR_LNG E , PS_REQUESTOR_TBL F WHERE A.ROLENAME = B.EM_ROLENAME AND B.EM_ROLENAME = D.ROLENAME AND D.ROLEUSER=C.ROLEUSER AND C.EMAIL_USER_SW = 'Y' AND C.EMAILID <> ' ' AND A.ROLESTATUS = 'A' AND B.EM_ROLETYPE IN ('05', '10', '15', '20', '35') AND E.ROLEUSER = C.ROLEUSER AND F.REQUESTOR_ID = C.ROLEUSER

# 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
4 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address