Infolinks

Thursday, 21 June 2012

Finding Request Group Query

select         fcp.concurrent_program_name as "SHORT_NAME",    
               fcpt.user_concurrent_program_name name,
               frg.request_group_name,
               frg.description ,
               frv.responsibility_name
from           fnd_concurrent_programs fcp,
               fnd_request_group_units bfrgu,
               fnd_concurrent_programs_tl fcpt,
               fnd_request_groups        frg,
               fnd_responsibility_vl   frv 
where bfrgu.unit_application_id=fcp.application_id
and bfrgu.request_unit_id=fcp.concurrent_program_id
and fcpt.application_id=fcp.application_id
and fcpt.concurrent_program_id=fcp.concurrent_program_id
and bfrgu.request_group_id=frg.request_group_id
and bfrgu.application_id=frg.application_id
AND frg.request_group_id=frv.request_group_id(+)
AND bfrgu.application_id=frv.application_id
AND frv.responsibility_name like 'TN Receivable'
--AND fcp.concurrent_program_name like 'SUG_BBSR'      
AND UPPER(USER_CONCURRENT_PROGRAM_NAME )like 'SUG %'

No comments:

Post a Comment