Select fcr.request_id,fcp .*
FROM apps.fnd_concurrent_requests fcr ,
apps.fnd_user fu ,
apps.fnd_concurrent_programs fcp ,
apps.fnd_concurrent_programs_tl fcpt ,
apps.fnd_printer_styles_tl fpst ,
apps.fnd_conc_release_classes fcrc ,
apps.fnd_responsibility_tl frt ,
apps.fnd_lookups fl
WHERE fcp.application_id = fcpt.application_id
AND fcr.requested_by = fu.user_id
AND fcr.concurrent_program_id = fcp.concurrent_program_id
AND fcr.program_application_id = fcp.application_id
AND fcr.concurrent_program_id = fcpt.concurrent_program_id
AND fcr.responsibility_id = frt.responsibility_id
AND fcr.print_style = fpst.printer_style_name(+)
AND fcr.release_class_id = fcrc.release_class_id(+)
AND fcr.status_code = fl.lookup_code
AND fl.lookup_type = 'CP_STATUS_CODE'
AND fcr.phase_code = 'P'
AND frt.language = 'US'
AND fpst.language = 'US'
AND fcpt.language = 'US'