Setting up JDeveloper

While setting up the jdeveloper we require some values.

Application Short Name and Responsibility Key:
This Query will take the user_name as input and will return the application short name and responsibility key.

SELECT fa.application_short_name, fu.responsibility_key,
fu.responsibility_name
FROM fnd_application fa,
fnd_responsibility fr,
(SELECT resp.responsibility_key, resp.responsibility_name
FROM apps.fnd_responsibility_vl resp
WHERE responsibility_id IN (
SELECT responsibility_id
FROM apps.fnd_user_resp_groups_direct
WHERE (responsibility_id, responsibility_application_id) IN (
SELECT responsibility_id, application_id
FROM apps.fnd_responsibility
WHERE ( VERSION = '4'
OR VERSION = 'W'
OR VERSION = 'M'
))
AND (user_id IN (SELECT user_id
FROM apps.fnd_user
WHERE user_name = :user_name)))) fu
WHERE fa.application_id = fr.application_id
AND fr.responsibility_key = fu.responsibility_key
**********************************************************************