Hi all.
As title queries, my script is failing to return all those users with only 1 particular responsibility even though I'm putting NOT LIKE's in it to restrict others. Can someone please help?
many thanks.
SELECT DISTINCT
u.user_name, SUBSTR(u.description,1,30) FullName,
r.responsibility_name, u.START_DATE, u.LAST_LOGON_DATE, u.END_DATE
FROM
fnd_user u,
fnd_responsibility_tl r,
fnd_user_resp_groups ur
WHERE
r.responsibility_id = ur.responsibility_id
AND u.user_id = ur.user_id
AND r.application_id = ur.responsibility_application_id
AND u.END_DATE IS NULL
AND user_name NOT LIKE 'SYS%'
AND user_name NOT LIKE 'WIZ%'
AND user_name NOT LIKE 'AUTO%'
AND r.responsibility_name NOT LIKE 'System%'
AND r.responsibility_name NOT LIKE 'A%'
AND r.responsibility_name NOT LIKE 'B%'
AND r.responsibility_name NOT LIKE 'C%' -- (etc..)
AND r.responsibility_name LIKE 'Internet Expense%'
ORDER BY 1, 2, 4 ASC