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 %'
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