OraFAQ Forum: Forms » Do anyone help. all of you please

Home » Developer & Programmer » Forms » Do anyone help. all of you please

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Do anyone help. all of you please [message #86351]

Thu, 23 September 2004 03:40

akshay
Messages: 12
Registered: December 2001

Junior Member

I have made a lov based on a record group in a master detail form and this record group query is as follow :

select h.ord_no,d.ord_id,d.it_name,d.rate,(nvl(d.ord_qty,0)-nvl(tot_qty_supp,0)) as pend_qty
from ordheader h, orddetails d
where
d.ord_id=h.ord_id and
h.ord_no= :invdetails.ord_no and
(nvl(d.ord_qty,0)-nvl(tot_qty_supp,0))>0

I need if there are four it_name in this LOV and I select one then next time when I'll call this LOV it should show me 4-1 it_name(items)

It would be very nice if you correct the above query or give any example:

Report message to a moderator

Re: Do anyone help. all of you please [message #86380 is a reply to message #86351]

Mon, 27 September 2004 05:08

magnetic
Messages: 324
Registered: January 2003

Senior Member

you should eliminate the one already selected with

select...
..
.

MINUS
select it_name
from...
where it_name= :block.field

Report message to a moderator

Previous Topic:	User Problem
Next Topic:	who dares to give the solution

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 31 23:46:25 CST 2025