Tuesday, 14 July 2015

How to find all request who have attached to a responsibility in Oracle Apps EBS Script

---- How to find  all request who have attached to a responsibility in Oracle Apps EBS Script ----

SELECT responsibility_name , frg.request_group_name,
fcpv.user_concurrent_program_name, fcpv.description
FROM fnd_request_groups frg,
fnd_request_group_units frgu,
fnd_concurrent_programs_vl fcpv,
fnd_responsibility_vl frv
WHERE frgu.request_unit_type = 'P'
AND frgu.request_group_id = frg.request_group_id
AND frgu.request_unit_id = fcpv.concurrent_program_id
AND frv.request_group_id = frg.request_group_id
ORDER BY responsibility_name;

No comments:

Post a Comment

Delete Organization Classification and Organization Using API when BG - Business Group Setup

  Oracle HRMS – Delete Organization Classification and Organization Using API 📘 Overview In Oracle HRMS, each organization is classified ...