| 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:
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
