SQL Script to find Oracle eBS concurrent program details based on partial cp name

–query to get concurrent programs and executable_details in one step… SELECT cp.user_concurrent_program_name, cp.concurrent_program_name, cp.concurrent_program_id, exe.executable_name, exe.execution_file_Name, exe.user_executable_name, lkp.meaning Execution_Method, app.application_short_name, listagg(‘RG=’ ||rgrps.request_group_name || ‘|CODE=’ || rgrps.request_group_code || ‘|’ ||chr(10) ||'(‘ || rgrps.resp_list || ‘)’, ‘, ‘) within GROUP ( ORDER BY rgrps.request_unit_id) rg_list FROM fnd_executables_vl exe, fnd_lookups lkp, fnd_application_vl app, fnd_concurrent_programs_vl cp, (SELECT DISTINCT gu.request_group_id, […]