Responsibilities Listing

Purpose To get list of responsibilities.

Description Query useful when user wants to get application wise responsibility list

Parameters None

Query

SELECT (SELECT application_short_name

FROM fnd_application fa

WHERE fa.application_id = frt.application_id) application,

frt.responsibility_id, frt.responsibility_name

FROM apps.fnd_responsibility_tl frt;