Hi All,
I have a table
named--->m_1_table;
when a user submits a form named "form1" data will be inserted into this "m_1_table"
columns:
plant, --------------->it has values like Chicago,Newyork,Detroit,LA
,Miami,Tam
pa etc..
center,---------------->it
has values like Body,Paint etc...
status --------------->it has values like 16,17,18,19,20,21(all are varchar2 type) etc..
title --------------->title of the submitting record,given by submitter
some more columns
This document at first will have a status of"16" , then it will be changed to 17 or 18 or 19 or 20
Each plant will have more than one "center"
and
a view
named --->m_10_view;
now submitter and users will update this view by filling another form named "form2"
This form is like a status tracking form
submitter will give 19480 as their I_STATUS when they are submitting this form2
other users will give 19481,19482 and 19483 as their I_STATUS on that document when they submit this form.
columns:
plant,
center,
I_STATUS----------->it has values like 19480,19481,19482 and 19483(all are varchar2 type) etc..
status --------------->it has values like 16,17,18,19,20,21(all are varchar2 type) etc..
BP ---------------> same name as "title" from table "m_1_table"
somre more columns
now:
----
lets take a ex : from table 1 by doing search on "center==body" and "status =20"
I got "100" records
now coming to mbp_10_view by doing search by "plant=Chicago" & center="Body" and I_STATUS as "19480" 0r "19481" or "19482" on STATUS=20
I got 70 records
so I want to see for the above case as shown below , by creating view from above table and view:
--------------------------
----------
----------
----------
----------
----------
----------
----------
id plant center perc
--- ----- ---------- ----
1. Chicago Body 70%
2. Chicago Paint 50%
3. Newyork Paint 65%
I hope I am clear , and this is very important for me right now.
please help me out with this.
Start Free Trial
