sql performance issue

 Hello,

We are using orcle JDE edwards as a erp sysetm and one of the application has strange behaviours from last few days.

scenarios:  Application is working fine in Devlopement environment(PY environment)  but not working in Production. It is Jde standard application.

Scenarios: from backend if i extract same sql  query and run from toad  it goes fine and showsusing index PRODDTA.F1307_3

and display result withing few seconds. but same quey going infinite loop when running from application.

 SELECT * FROM PRODDTA.F1307 WHERE ( F1TREC = :KEY1 AND F1DOCO = :KEY2 ) ORDER BY F1TREC ASC,F1DOCO ASC,F1EFTB DESC,F1BEGT DESC