RE: Is it possible to create Matrix FORMs

Hi,
Check out the following link. It is not exactly what you want but it may give you some ideas.

http://www.oracle.com/oramag/code/cod09308.html

-
Chris J. Guidry P.Eng.
ATCO Electric, Metering Services
Phone: (780) 420-4142
Fax: (780) 420-3854
Email: chris.guidry_at_atcoelectric.com

> -----Original Message-----
> From: prashasta gujrati [SMTP:gujrati_at_TUBES.TATASTEEL.COM]
> Sent: Thursday, September 14, 2000 1:11 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Is it possible to create Matrix FORMs
>
>
> Hi Elkins,
>
> Thanks for your interest.
>
> I'll briefly tell about the application for which I'm looking for
> such a solution.
>
> This is a Demand allocation application where there is demand for
> certain products from various regions. This demand is in form of
> Orders placed on manufacturing unit. Allocation is to be done
> manually keeping in mind the proper distribution of products to
> various regions.
>
> Table structures are like this :
>
> region_codes
> --------------
> region_code
> description
>
> part_master
> -------------
> part_no
> description
>
> oeorder_release
> -----------------
> order_no
> part_no
> region_code
> demand_qty
> allocated_qty
> (order_no + part_no is the primary key)
>
> The screen layout which I have in mind is :
>
> region1
> region2 region3
> region4
>
> Order1 demand allocation Order4 demand
> allocation Order7 demand allocation .......
> Part_no1 Order2 demand allocation Order5 demand
> allocation Order8 demand allocation .......
> Order3 demand allocation Order6 demand
> allocation Order9 demand allocation .......
>
> Order11 demand allocation Order14 demand
> allocation Order17 demand allocation .......
> Part_no2 Order12 demand allocation Order15 demand
> allocation Order18 demand allocation .......
> Order13 demand allocation Order16 demand
> allocation Order19 demand allocation .......
>
> Order21 demand allocation Order24 demand
> allocation Order27 demand allocation .......
> Part_no3 Order22 demand allocation Order25 demand
> allocation Order28 demand allocation .......
> Order23 demand allocation Order26 demand
> allocation Order29 demand allocation .......
>
> and so on...
>
> Then there are totals as well which have to be shown at various levels.
>
> It is as if we are trying to get Excel spreadsheet kind of functionality
> out of
>
> forms.
>
> Any ideas will be greatly appreciated. I've tried checking metalink but it
> did
> not help. Looking for ideas from you guys...
>
> TIA,
>
> LGE wrote:
>
> > Can you give a little more info on what you mean? Maybe a high level
> > description of the tables, some sample data, and a rough diagram of how
> you
> > expect the data to be presented. I have a couple of ideas of what you
> might
> > mean; but, I don't want to waste time working up an answer that isn't
> > relevant to what you need.
> >
> > Regards,
> >
> > L. Elkins
> >
> > Author: LGE
> > INET: elkinsl_at_flash.net
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
>
> --
> Author: prashasta gujrati
> INET: gujrati_at_tubes.tatasteel.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Fri Sep 15 2000 - 12:00:33 CDT