Parameter wise Concurrent Program Find

SELECT  v.request_id,  v.program,

    v.requestor,

    (Select FULL_NAME from per_all_people_f where EMPLOYEE_NUMBER =  v.requestor) requestor_name,

    (Select APPLICATION_NAME from fnd_application_tl  where APPLICATION_ID= v.program_application_id)PROg_APPL,

    v.argument_text,

    v.actual_completion_date,

    v.completion_text,

    v.requested_by,

    (Select APPLICATION_NAME from fnd_application_tl  where APPLICATION_ID= v.responsibility_application_id)Respo_APPL,

    (Select RESPONSIBILITY_NAME from FND_RESPONSIBILITY_VL  where RESPONSIBILITY_ID=v.responsibility_id)RESPONSIBILITY_NAME,

    v.controlling_manager,

    v.program_short_name,

    v.priority_request_id,

    v.requested_start_date,

    v.concurrent_program_id,    

    v.enabled,

    v.phase_code,

    v.hold_flag,

    v.status_code

FROM

    fnd_conc_req_summary_v v

WHERE

    argument_text LIKE :Parameter

    AND ( request_date >= trunc(sysdate - 90) )

ORDER BY

    request_id DESC

    /