Home » Developer & Programmer » Forms » Master-Details
Master-Details [message #78187] Fri, 25 January 2002 01:42 Go to next message
chandrakanth
Messages: 16
Registered: October 2001
Junior Member
THERE ARE TWO TABLES

A. P_ORDER 1. PO_NO - MASTER
2. PO_DT
3. PARTY
4. BASIC_AMT
5. SALESTAX_AMT
6. EXCISEAMT
7. TRANSPORT CHARGES
8. DISCOUNT AMT
9. NET_AMT

B. PORDER_ITEMS - DETAILS
1. PO_NO
2. PO_DT
3. ITEM
4. RATE
5. QUANTITY
6. AMOUNT

Details is having mulitiple rows. In detail block amount =
rate * quantity.

Sum of the detailblock.amount = masterblock.basic_amt.

Salestax and excise is according to the percentage given
by the users.

Net_amt = basic_amt+salestax_amt+exciseamt+transport
charges-discount_amt

How to calculate the gross and net amount automatically.

Chandrakanth
Re: Master-Details [message #78189 is a reply to message #78187] Fri, 25 January 2002 04:24 Go to previous message
dinakar shetty
Messages: 29
Registered: January 2002
Junior Member
Sum up the req columns in the Sql statement
and user rollup
cube of
feature of oracle 8i
Previous Topic: Trapping typed key
Next Topic: Re: free material for oracle
Goto Forum:
  


Current Time: Fri Mar 29 03:25:58 CDT 2024