SQL script to find Scheduled Concurrent Programs

Run the following script to find Scheduled Concurrent Programs and its frequency

  SELECT *

    FROM apps.FND_CONC_REQ_SUMMARY_V

   WHERE     phase_code = 'P'

         AND status_code IN ('I', 'Q')

         AND (NVL (request_type, 'X') != 'S')

         AND requested_start_date >= SYSDATE

ORDER BY program_short_name DESC;

• PHASE_CODE status P stands for Pending
• STATUS_CODE status I stands for Normal & status Q stands of Standby
• Request_type != 'S' condition is to disallow Request Set Stage programs