Tuesday 15 March 2022

query to find active responsibilities in oracle apps

SELECT
frt.responsibility_name,
fr.responsibility_key,
frt.description,
to_char(fr.start_date,'DD-MON-RRRR') start_date,
to_char(fr.end_date,'DD-MON-RRRR') end_date
FROM
fnd_responsibility_tl frt,
fnd_responsibility fr
WHERE
1 = 1
AND fr.responsibility_id = frt.responsibility_id
AND frt.language = userenv('LANG')
--AND upper(frt.responsibility_name) IN upper('OM Super User')
AND trunc(nvl(fr.end_date,sysdate)) <= trunc(sysdate);

No comments:

Post a Comment