Dear All,
I have LOV column in my form, below is query used . Oracle 10g.
select distinct yy.c_activitypreauthid,member_id,yy.req_date
from prior_authorisation_details xx,xxnmcpos_pbm_request yy
where 1=1
and yy.c_activitypreauthid = xx.preauth_id
and yy.pharmacy_key = (select distinct pharmacy_key from xxnmc_responsibility_pharmacy where responsibility_id = 51338)--fnd_global.resp_id)
and yy.req_date >= sysdate - 10
--and member_id = '123'
--and req_date > '01-DEC-2018'
order by req_date desc --, member_id , req_date desc
The same is created as LOV in form, when i form is not sorting as required. In the toad it is properly sorting in form is not sorting.
Please help me
Thanks,