Monday, June 20, 2011

Purpose To get all Request attached to a responsibility

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

Best Blogger TipsGet Flower Effect