1 query found for "User Group User"
User's User Groups with Access to Application Service
select distinct UPROF.USR_GRP_ID, UGRPL.DESCR, UPROF.EXPIRATION_DT, UPROF.APP_SVC_ID
from SC_USR_GRP_PROF UPROF , SC_USER_GROUP_L UGRPL , SC_USR_GRP_USR UGRPU1
where UPROF.APP_SVC_ID = 'INSERT_APPLICATION_SERVICE'
and UPROF.USR_GRP_ID = UGRPL.USR_GRP_ID
and UGRPL.LANGUAGE_CD = 'INSER_LANGUAGE_CD_MOSTLY_ENG'
and UPROF.USR_GRP_ID = UGRPU1.USR_GRP_ID
and UGRPU1.USER_ID = 'INSERT_USER_ID'
uploaded by Nuno Rodrigues