SELECT DISTINCT FAV.application_name, FCP.user_concurrent_program_name, FCP.concurrent_program_name, FCP.description
FROM fnd_concurrent_programs_vl fcp, FND_EXECUTABLES_FORM_V fef, fnd_application_vl FAV
WHERE fcp.executable_id = fef.executable_id
AND fcp.application_id = FAV.application_id
--AND fcp.concurrent_program_name like 'IHG%'
AND fef.execution_method_code = 'P'
FROM fnd_concurrent_programs_vl fcp, FND_EXECUTABLES_FORM_V fef, fnd_application_vl FAV
WHERE fcp.executable_id = fef.executable_id
AND fcp.application_id = FAV.application_id
--AND fcp.concurrent_program_name like 'IHG%'
AND fef.execution_method_code = 'P'
No comments:
Post a Comment