Active EBS users
Hi team, i need a list with labeled active and inactive EBS users. In select there is necessary data which i need to extract, and i do need to satisfy these conditions also in where only to return responsibilities that do not contain this text in the name
- Notifications
- iExpenses (but include anything with iExpenses Setup and Admin)
- Inquiry
- Self-Service
- Self Service
- (Read Only)
- Internet Expenses Auditor (but include anything with Internet Expenses Setup and Admin)
- Internet Expenses Help Desk
- Employee Opportunities
My query is like this:
SELECT
fu.user_name "User name",
frt.responsibility_name "Responsibility Name" ,
CASE
WHEN furg.end_date IS NULL OR furg.end_date > sysdate