OraFAQ Forum: Forms » Please help. Its urgent.

Home » Developer & Programmer » Forms » Please help. Its urgent.

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

Please help. Its urgent. [message #86318]

Tue, 21 September 2004 03:55

akshay
Messages: 12
Registered: December 2001

Junior Member

Hi, My name is akshay, I m new to oracle.
I have made a lov based on a record group in a master detail block 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 record group and I select one then next time it should show me 4-1.

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

thanks

Report message to a moderator

Previous Topic:	How to relate 2 fields of a same table
Next Topic:	Passing Forms parameters to Reports - Step by Step

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 09 17:12:15 CDT 2024