| LOV / RG [message #86314] |
Tue, 21 September 2004 01:44 |
akshay
Messages: 12
Registered: December 2001
|
Junior Member |
|
|
Hi, I m akshay new to oracle, would be very happy if somebody helps me.
I have a lov based on record group and what I want is if there are four it_name in this record group and I select one then next time it should show me 4-1. I m using this record group in Invoice form.
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
if anybody can change this query accordingly, then I'll really apreciate him.
thanks & regards
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
