Finding sid for the concurrent request

SELECT ses.sid, 
            ses.serial# 
       FROM v$session ses, 
            v$process pro 
           WHERE ses.paddr = pro.addr 
                AND pro.spid IN (SELECT oracle_process_id 
                                           FROM apps.fnd_concurrent_requests 
                                        WHERE request_id = &request_id);

Oracle Applications Finding patches applied between dates

SELECT *
FROM (
select ap.patch_name|| decode(ab.baseline_name,null,'','.') || ab.baseline_name, MERGED_DRIVER_FLAG, max(at.name),
l.language, ap.applied_patch_id, pr.appl_top_id, count(*) DRIVERS_APPLIED, max(end_date) COMPLETION_DATE,
max(end_date), pd.patch_driver_id PATCH_DRV_ID, pd.patch_abstract PATCH_DESCRIPTION
from ad_appl_tops at, ad_patch_driver_langs l, ad_patch_runs pr, ad_patch_drivers pd, ad_applied_patches ap, ad_bugs ab
where pr.appl_top_id = at.appl_top_id and
pr.patch_driver_id = pd.patch_driver_id and pd.applied_patch_id = ap.applied_patch_id and pd.patch_driver_id = l.patch_driver_id
and ab.bug_number (+) = ap.patch_name AND ( trunc( pr.start_date ) >= to_date('10/05/2016','MM/DD/YYYY') AND trunc( pr.end_date) <= to_date('12/31/2016','MM/DD/YYYY'))
group by ap.applied_patch_id, ap.patch_name|| decode(ab.baseline_name,null,'','.') || ab.baseline_name, pd.patch_abstract,
pr.appl_top_id, MERGED_DRIVER_FLAG, pd.patch_driver_id, l.language order by 9 desc, 1 desc, 2 desc, 3 desc, 4 desc )
WHERE rownum < 201