FND Users

Description

Categories
Enginatics
Repository
GitHub
Listing of all EBS users, their status, responsibility count, and if they were using blitz reports

SQL 45 lines

Parameters 7

ParameterTypeList of values SQL
User NameLOV
fu.user_name=:user_name
Has Access to ResponsibilityLOV
fu.user_id in (
select
furg.user_id
from
fnd_responsibility_vl frv,
fnd_user_resp_groups furg
where
frv.responsibility_name=:responsibility and
frv.responsibility_id=furg.responsibility_id and
frv.application_id=furg.responsibility_application_id
)
Has Access to ApplicationLOV
fu.user_id in (
select
furg.user_id
from
fnd_application_vl fav,
fnd_user_resp_groups furg
where
fav.application_name=:application and
fav.application_id=furg.responsibility_application_id
)
Active onlyLOV
sysdate between fu.start_date and nvl(fu.end_date,sysdate)
Creation Date FromDate
fu.creation_date>=:creation_date_from
Creation Date ToDate
fu.creation_date<:creation_date_to+1
Created within daysNumber
fu.creation_date>=sysdate-:days