Stay at Home!! Be Safe!! Take Care!!

For Any queries, please mail us at support@funoracleapps.com

Query to find Concurrent Program Details based on Program Name

No comments

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('%%');

No comments :

Post a Comment