add

About Me

My photo
Oracle Apps - Techno Functional consultant

Saturday, August 13

Script to get responsibilities for a user

SELECT fu.user_name,

frt.responsibility_name,

furgd.start_date,

furgd.end_date

FROM fnd_user fu,

fnd_user_resp_groups_direct furgd,

fnd_responsibility_tl frt

WHERE fu.user_id = furgd.user_id

AND FURGD.RESPONSIBILITY_ID = FRT.RESPONSIBILITY_ID

AND UPPER (fu.user_name) = UPPER ($USERNAME)

No comments: