strange output of SQL query in EBS
Hello ,
i have a report retrieves data according to entered parameters criteria in Toad and Report builder environment
and does not retrieve any data when i run it from EBS environment !
in the where clause in the query there are 4 parameters as following :
- ORGANIZATION_ID=:org
- 2.and to_date(f_trx_dt(l.ORGANIZATION_ID,h.HEADER_ID),'dd/mm/yyyy') between nvl(to_date(:dt1,'dd/mm/yyyy'),to_date('1/1/2010','dd/mm/yyyy'))
and nvl(to_date(:dt2,'dd/mm/yyyy'),to_date('1/1/2050','dd/mm/yyyy'))
- h.REQUEST_NUMBER = nvl(:mov_ord, h.REQUEST_NUMBER)