optimize a query

Hi,

I try to optimize this query that takes 5 minutes to bring 1 row. Sql Tuning Advisor gives nothing because of >= symbole and expressions.

Do you see any way to optimize it ?

Thank you.

NAME                                ;TYPE       ;VALUE

------------------------------------;-----------;-----------

optimizer_dynamic_sampling          ;integer    ;1

optimizer_features_enable           ;string     ;9.2.0

optimizer_index_caching             ;integer    ;0

optimizer_index_cost_adj            ;integer    ;100

optimizer_max_permutations          ;integer    ;2000

optimizer_mode                      ;string     ;CHOOSE

SELECT PV_REQ_NAME, BUSINESS_UNIT, REQ_ID, REQ_STATUS, PV_REQ_STATUS, HOLD_STATUS, TO_CHAR(REQ_DT,'YYYY-MM-DD'), ORIGIN, REQUESTOR_ID, OPRID_ENTERED_BY,

OPRID_MODIFIED_BY, OPRID_APPROVED_BY, TO_CHAR(ENTERED_DT,'YYYY-MM-DD'), TO_CHAR(APPROVAL_DT,'YYYY-MM-DD'), PO_POST_STATUS, APPL_JRNL_ID_ENC, POST_DOC,