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
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
What do you mean by as required? Please post the sample screenshot of the outputs in Toad and in LOV.
Sir got it. thanks