Query for Scheduled request set detail

Queries

 Request set schedule details 

        SELECT

            rs.user_request_set_name                                                                                           "Request Set Name",

            to_char(req.requested_start_date, 'DD-MON-YYYY HH24:mm:ss')                                                         requested_start_date,

            req.request_id                                                                                                     request_id,

            cp_param.column_seq_num                                                                                            "Param Seq",

            nvl2(req.resubmit_interval, 'PERIODICALLY', nvl2(req.release_class_id, 'ON SPECIFIC DAYS', 'ONCE')) prog_schedule_type,

            decode(nvl2(req.resubmit_interval, 'PERIODICALLY', nvl2(req.release_class_id, 'ON SPECIFIC DAYS', 'ONCE')),

                   'PERIODICALLY',

                   'EVERY '

                   || req.resubmit_interval

                   || ' '

                   || req.resubmit_interval_unit_code

                   || ' FROM '

                   || req.resubmit_interval_type_code

                   || ' OF PREV RUN',

                   'ONCE',

                   'AT :'

                   || to_char(req.requested_start_date, 'DD-MON-RR HH24:MI'),

                   'EVERY: ' || fcrc.class_info)                                                                               prog_schedule

        FROM

            apps.fnd_request_sets_vl            rs,

            apps.fnd_req_set_stages_form_v      rss,

            applsys.fnd_request_set_programs    rsp,

            apps.fnd_conc_release_classes       fcrc,

            apps.fnd_concurrent_programs_vl     cp,

            apps.fnd_descr_flex_col_usage_vl    cp_param,

            fnd_concurrent_requests             req,

            fnd_concurrent_programs             rset_prog

        WHERE

            rs.user_request_set_name LIKE '<user request set name>'

            AND rs.application_id = rss.set_application_id

            AND rs.request_set_id = rss.request_set_id

            AND rss.set_application_id = rsp.set_application_id

            AND rss.request_set_id = rsp.request_set_id

            AND rss.request_set_stage_id = rsp.request_set_stage_id

            AND rsp.program_application_id = cp.application_id

            AND rsp.concurrent_program_id = cp.concurrent_program_id

            AND rs.end_date_active IS NULL

            AND fcrc.release_class_id (+) = req.release_class_id

            AND fcrc.application_id (+) = req.release_class_app_id

            AND cp_param.descriptive_flexfield_name (+) = '$SRS$.' || cp.concurrent_program_name

            AND cp_param.application_id (+) = cp.application_id

            AND cp_param.enabled_flag (+) = 'Y'

            AND req.concurrent_program_id = rset_prog.concurrent_program_id

            AND req.program_application_id = rset_prog.application_id

            AND req.phase_code = 'P'

            AND req.argument1 = to_char(rs.application_id)

            AND req.argument2 = to_char(rs.request_set_id)

        ORDER BY

            req.request_id,

            rss.display_sequence,

            rsp.sequence,

            cp_param.column_seq_num

    

Concurrent programs in a request set

SELECT

    rs.user_request_set_name           "Set Name",

    rs.request_set_name                "Set code",

    rs.description                     "Description",

    rss.display_sequence               seq,

    cp.user_concurrent_program_name    "Concurrent Program",

    ap.application_name                "Application",

    e.executable_name                  "Executable",

    e.execution_file_name              "Executable File",

    lv.meaning                         "Executable Type"

FROM

    apps.fnd_request_sets_vl            rs,

    apps.fnd_req_set_stages_form_v      rss,

    applsys.fnd_request_set_programs    rsp,

    apps.fnd_concurrent_programs_vl     cp,

    apps.fnd_executables                e,

    apps.fnd_lookup_values              lv,

    apps.fnd_application_vl             ap

WHERE

        rs.application_id = rss.set_application_id

    AND rs.request_set_id = rss.request_set_id

    AND rss.set_application_id = rsp.set_application_id

    AND rss.request_set_id = rsp.request_set_id

    AND rss.request_set_stage_id = rsp.request_set_stage_id

    AND rsp.program_application_id = cp.application_id

    AND rsp.concurrent_program_id = cp.concurrent_program_id

    AND cp.executable_id = e.executable_id

    AND cp.executable_application_id = e.application_id

    AND e.application_id = ap.application_id

    AND lv.lookup_type = 'CP_EXECUTION_METHOD_CODE'

    AND lv.lookup_code = e.execution_method_code

    AND rs.user_request_set_name LIKE '<User request set name>'

    AND lv.language = 'US'

ORDER BY

    rss.display_sequence