SELECT fa.application_short_name
, frg.request_group_name
, frt.responsibility_name
FROM fnd_concurrent_programs_vl fcpv
, fnd_request_group_units frgu
, fnd_request_groups frg
, fnd_application fa
, fnd_responsibility fr
, fnd_responsibility_tl frt
WHERE 1 = 1
AND fcpv.concurrent_program_id = frgu.request_unit_id
AND frg.request_group_id = frgu.request_group_id
AND fa.application_id = frg.application_id
AND frg.request_group_id = fr.request_group_id
AND NVL(fr.end_date,SYSDATE + 1) > SYSDATE
AND fr.responsibility_id = frt.responsibility_id
AND fcpv.user_concurrent_program_name = 'Aged Creditors Report'
;
Like this:
Like Loading...
Related