Query to findout scheduled requests set with stages & parameters

SELECT
fcr.priority_request_id,
 fcr.request_id,
 fcr.phase_code  status ,
  frt.responsibility_name,
  DECODE(fcpt.user_concurrent_program_name, 'Report Set', 'Report Set:'
  || fcr.description, fcpt.user_concurrent_program_name) CONC_PROG_NAME,
  argument_text PARAMETERS,
  NVL2(fcr.resubmit_interval, 'PERIODICALLY', NVL2(fcr.release_class_id, 'ON SPECIFIC DAYS', 'ONCE')) PROG_SCHEDULE_TYPE,
  DECODE(NVL2(fcr.resubmit_interval, 'PERIODICALLY', NVL2(fcr.release_class_id, 'ON SPECIFIC DAYS', 'ONCE')), 'PERIODICALLY', 'EVERY '
  || fcr.resubmit_interval
  || ' '
  || fcr.resubmit_interval_unit_code
  || ' FROM '
  || fcr.resubmit_interval_type_code
  || ' OF PREV RUN', 'ONCE', 'AT :'
  || TO_CHAR(fcr.requested_start_date, 'DD-MON-RR HH24:MI'), 'EVERY: '
  || fcrc.class_info) PROG_SCHEDULE,
  fu.user_name USER_NAME,
  requested_start_date START_DATE
FROM apps.fnd_concurrent_programs_tl fcpt,
  apps.fnd_concurrent_requests fcr,
  apps.fnd_user fu,
  apps.fnd_conc_release_classes fcrc,
  apps.fnd_Responsibility fr,
  apps.fnd_responsibility_tl frt
WHERE fcpt.application_id             = fcr.program_application_id
AND fcpt.concurrent_program_id        = fcr.concurrent_program_id
AND fcr.requested_by                  = fu.user_id
AND fcr.responsibility_id             = fr.responsibility_id
AND fcr.responsibility_application_id = fr.application_id
AND frt.responsibility_id             = fr.responsibility_id
AND frt.application_id                = fr.application_id
--AND fcr.phase_code                    = 'P'
--AND fcr.requested_start_date          > SYSDATE
AND fcpt.LANGUAGE                     = 'US'
AND fcrc.release_class_id(+)          = fcr.release_class_id
AND fcrc.application_id(+)            = fcr.release_class_app_id
and fcr.priority_request_id in (35447243,
35436519,
35433223,
35434249,
35433224,
35433712,
35433735,
35433737,
35434760,
35434259)
order by fcr.priority_request_id;