EM_S_ROL_LSA_VW (SQL View)	Index Back
eS Supplier Roles Configured Returns list of user-defined Roles that are configured/mapped to eS Supplier role type (excludes System and Supplier Administrators in result set. Add a Supplier Role to System Administrators User Profile to include).

EM_S_ROL_LSA_VW

(SQL View)

eS Supplier Roles Configured

Returns list of user-defined Roles that are configured/mapped to eS Supplier role type (excludes System and Supplier Administrators in result set. Add a Supplier Role to System Administrators User Profile to include).

SELECT DISTINCT A.ROLEUSER , D.GRANTROLENAME , B.DESCR FROM PSROLEUSER A , PSROLEDEFN B , PS_EM_ROLE_CONFIG C , PSROLECANGRANT D WHERE A.ROLENAME = D.ROLENAME AND D.GRANTROLENAME = C.EM_ROLENAME AND B.ROLENAME = C.EM_ROLENAME AND C.EM_ROLETYPE IN ('25')

Related Language Record: EM_S_ROL_LSA_LN

# 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 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	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	ROLENAME	Character(30)	VARCHAR2(30) NOT NULL	The name of a Role in the Role Definition Table (see PSROLEDEFN).
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description