Incompatibilities

 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 apps.FND_CONCURRENT_PROGRAM_SERIAL fcrs,

         apps.FND_CONCURRENT_PROGRAMS_TL fctl,

         apps.FND_APPLICATION_TL fat

   WHERE     fcrs.RUNNING_APPLICATION_ID = fat.application_id

         and fctl.user_concurrent_program_name in ('Accounting Program','Create Accounting') -- 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