Roles of a User

SQL Query to list All User Roles in ERP Cloud

SELECT * FROM (SELECT user_info.user_login, user_info.user_id, user_roles.role_name, user_info.creation_date, user_info.first_name, user_info.last_name, user_info.location_code, user_info.location_name, user_info.town, user_info.country, user_info.department, user_info.username, user_info.active_flag FROM (SELECT DISTINCT pp.creation_date creation_date, ppf.first_name first_name, ppf.last_name… Read More »SQL Query to list All User Roles in ERP Cloud