Query to find incompatible program of a concurrent

Query to find incompatible program of a concurrent

In this post , We will be discuss about Query to find incompatible program of a concurrent.This query will help to extract the list of incompatible programs against one concurrent program in oracle apps.This will help to extract the list of complete detail of incompatible concurrent programs. This is one of the important sql regarding incompatible program. Here below is the detail about Query to find incompatible program of a concurrent.

Important Table used by Query to find incompatible program of a concurrent

1.FND_CONCURRENT_PROGRAM_SERIAL

2.FND_CONCURRENT_PROGRAMS_TL

3.FND_APPLICATION_TL

Detail SQL Query to find incompatible program of a concurrent

SELECT
         fctl.user_concurrent_program_name,
         DECODE (TO_RUN_TYPE, 'S', 'Set', 'Program') TYPE,
         DECODE (INCOMPATIBILITY_TYPE, 'G', 'Global', 'Domain')
            "Incompatibilty Type",
            fat.APPLICATION_NAME
            FROM FND_CONCURRENT_PROGRAM_SERIAL fcrs,
         FND_CONCURRENT_PROGRAMS_TL fctl,
         FND_APPLICATION_TL fat
   WHERE     fcrs.RUNNING_APPLICATION_ID = fat.application_id
         AND (RUNNING_CONCURRENT_PROGRAM_ID = :CONCURRENT_PROGRAM_ID) -- CP id of the program in question
         AND fctl.CONCURRENT_PROGRAM_ID = fcrs.TO_RUN_CONCURRENT_PROGRAM_ID
         AND fctl.LANGUAGE = 'US'
         AND fat.LANGUAGE = 'US'
ORDER BY to_run_application_id, to_run_concurrent_program_id;

Query to find incompatible program of a concurrent