Query with users and responsibility start and end dates returning multiple rows. It need to return o
SELECT DISTINCT u.user_name uname, rtl.RESPONSIBILITY_NAME resp_name,
to_char(furgd.start_date,'DD-Mon-YYYY') st_date,
to_char(furgd.end_date,'DD-Mon-YYYY') e_date,
frg.request_group_name rg_name
FROM fnd_responsibility r,
apps.fnd_responsibility_TL rtl,
apps.fnd_user_resp_groups urg,
apps.fnd_user u,
apps.fnd_request_groups frg,
apps.fnd_user_resp_groups_direct furgd
WHERE urg.responsibility_id = r.responsibility_id
AND rtl.responsibility_id = r.responsibility_id
AND r.APPLICATION_ID = urg.RESPONSIBILITY_APPLICATION_ID
AND furgd.responsibility_id = urg.responsibility_id
AND r.REQUEST_GROUP_ID = frg.REQUEST_GROUP_ID
Tagged:
0