SELECT fu.user_name,
frv.responsibility_name,
TO_CHAR (furgd.start_date, 'DD-MON-YYYY') "START_DATE",
TO_CHAR (furgd.end_date, 'DD-MON-YYYY') "END_DATE"
FROM fnd_user fu,
fnd_user_resp_groups_direct furgd,
fnd_responsibility_vl frv
WHERE fu.user_id = furgd.user_id
AND furgd.responsibility_id = frv.responsibility_id
AND furgd.end_date IS NULL
AND furgd.start_date <= sysdate
AND fu.start_date <= sysdate
AND frv.start_date <= sysdate;
frv.responsibility_name,
TO_CHAR (furgd.start_date, 'DD-MON-YYYY') "START_DATE",
TO_CHAR (furgd.end_date, 'DD-MON-YYYY') "END_DATE"
FROM fnd_user fu,
fnd_user_resp_groups_direct furgd,
fnd_responsibility_vl frv
WHERE fu.user_id = furgd.user_id
AND furgd.responsibility_id = frv.responsibility_id
AND furgd.end_date IS NULL
AND furgd.start_date <= sysdate
AND fu.start_date <= sysdate
AND frv.start_date <= sysdate;
No comments:
Post a Comment