Oracle Applications - Query to get incompatible programs

SELECT fat.APPLICATION_NAME,

         fctl.user_concurrent_program_name,

         DECODE (TO_RUN_TYPE, 'S', 'Set', 'Program') TYPE,

         DECODE (INCOMPATIBILITY_TYPE, 'G', 'Global', 'Domain')

            "Incompatibilty Type"

    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 = 32045) -- 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;