Query to find Concurrent Program Details based on Program Name

Query to find Concurrent Program Details based on Program Name

Scripts:

SELECT

    fcp.concurrent_program_id,

    fcp.concurrent_program_name,

    fcpt.user_concurrent_program_name,

    fcpt.description,

    fe.executable_name,

    fet.user_executable_name,

    fe.execution_file_name

FROM

    apps.fnd_concurrent_programs fcp,

    apps.fnd_concurrent_programs_tl fcpt,

    apps.fnd_executables fe,

    apps.fnd_executables_tl fet

WHERE

        fe.executable_id = fet.executable_id

    AND

        fcp.concurrent_program_id = fcpt.concurrent_program_id

    AND

        fcpt.language = fet.language

    AND

        fcp.executable_id = fe.executable_id

    AND

        fcp.executable_application_id = fe.application_id

    AND

        fcpt.language = 'US'

  AND

    upper(fcpt.user_concurrent_program_name) LIKE  upper('%%')

      -- and upper(fcp.concurrent_program_name) LIKE  upper('%%');