Standard - Concurrent Programs

  SELECT   fav.application_name "Application Name",
           DECODE (fav.application_short_name,
                   'SQLAP', 'AP',
                   'SQLGL', 'GL',
                   'OFA', 'FA',
                   fav.application_short_name)
              "ApplCode",
           fcpv.user_concurrent_program_name "Name",
           fcpv.concurrent_program_name "Short Name",
           fl1.meaning "Execution Method"-- ,   fl2.meaning                                          ,
           TO_CHAR (fu.user_name) "Created By",
           TO_CHAR (fcpv.creation_date) "Creation Date",
           fu2.user_name "Last Updated By",
           TO_CHAR (fcpv.last_update_date) "Last Updated Date"
    FROM   fnd_concurrent_programs_vl fcpv,
           fnd_lookups fl1-- ,         fnd_lookups                               fl2
           ,
           fnd_concurrent_request_class fcrc,
           fnd_application_vl fav,
           fnd_user fu,
           fnd_user fu2
   WHERE       fcpv.execution_method_code = fl1.lookup_code(+)
           AND fl1.lookup_type = 'CP_EXECUTION_METHOD_CODE'
           AND fcpv.concurrent_class_id = fcrc.request_class_id(+)
           AND fcpv.enabled_flag = 'Y'
           AND fcpv.application_id = fav.application_id
           AND (fcpv.created_by NOT IN (-1, 1, 0, 2)
                OR fcpv.last_updated_by NOT IN (-1, 1, 0, 2))
           AND fu.user_id = fcpv.created_by
           AND fu2.user_id = fcpv.last_updated_by
ORDER BY   fav.application_name,
           fcpv.concurrent_program_name,
           fcpv.creation_date