Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

LOV Sorting in Form

user5345Apr 21 2019 — edited Apr 21 2019

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,

This post has been answered by Manu. on Apr 21 2019
Jump to Answer

Comments

Manu.
Answer

Dear,

What do you mean by as required? Please post the sample screenshot of the outputs in Toad and in LOV.

Manu.

Marked as Answer by user5345 · Sep 27 2020
user5345

Sir got it. thanks

1 - 2

Post Details

Added on Apr 21 2019
2 comments
367 views