Cancellation of Concurrent Programs, concurrent request sets and Alert scheduling



UPDATE fnd_concurrent_requests
           SET phase_code = 'C', status_code = 'X'
         WHERE status_code IN ('Q','I')
           AND requested_start_date > SYSDATE
           AND hold_flag = 'N'
           and (description like 'XX%' or DESCRIPTION is NULL)
         AND concurrent_program_id in (51742,53741,79775,93775,91775,67771,126779,55759,98779,86775,87775,69771,121780,31659,20392);

Request set concurrent program id - 31659 and description column will not be null for request sets.