Localizar package pelo nome do concurrent

SELECT a.user_concurrent_program_name, b.executable_name,

b.execution_file_name package_name

FROM fnd_concurrent_programs_vl a, fnd_executables_vl b

WHERE a.executable_id = b.executable_id

AND UPPER(user_concurrent_program_name like)    ‘%NOME_CONCORRENTE%’

Deixe uma resposta

Pular para a barra de ferramentas