Payables and Cash Management - EBS (MOSC)

MOSC Banner

Query with users and responsibility start and end dates returning multiple rows. It need to return o

edited Feb 7, 2013 10:10AM in Payables and Cash Management - EBS (MOSC) 2 commentsAnswered ✓
 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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center