Hi all,

Need to get desired output as mentioned below
Let me explain :-

I got table A in which material from different vendors with sub-code is
coming but I want to post their total amount to their sub code category in
which they are coming like given in as given below.

Pls help me to resolve this issue t earliest.

Like table as showed

Table: - A (I got this)

CCode    Sub-Code   Type    Vrno    Sr   Debit       Amount

1810      2701     Purchase  1       1     1          100

1810      2703     Purchase  1       2     1          300

1810      2704     Purchase  1       3     1          500

1810      2707     Purchase  1       4     1          200
-----------------------------------------------------------
1810      2702     Purchase  1       5     1          400

1810      2706     Purchase  1       6     1          200

1810      2709     Purchase  1       7     1          300

1810      2708     Purchase  1       8     1          900


Ccode same 1810
Sub-Code (2701, 2703, 2704, and 2707) comes under 2501 sub code whose total
is 1100
Sub-code (2702, 2706, 2709, and 2708) comes under 2502 sub code whose total
is 1800

Table: - A Desired Output

Total amount of sub-codes to be posted under their sub-code category

CCode     Sub-Code     Type        Vrno   Credit      Amount

1810       2501        Bank         1       2           1100

1810       2502        Bank         1       2           1800
.
.
.
.

I need to do it as early as possible. (PL/SQL block)

rgds,

Sunidhi

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to Oracle-PLSQL@googlegroups.com
To unsubscribe from this group, send email to
oracle-plsql-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to