Thursday, February 6, 2020

Query to find Responsibilit and its Request group

SELECT DISTINCT frt.responsibility_name, frg.request_group_name,fr.application_id
    FROM fnd_Responsibility fr, fnd_responsibility_tl frt,
    fnd_request_groups frg
    WHERE frt.responsibility_id = fr.responsibility_id
    AND frg.request_group_id = fr.request_group_id
    AND frt.LANGUAGE = USERENV('LANG');

No comments:

Post a Comment