ERPstuff - Oracle EBS Community

I am creating a report i.e. group above

Table structure and data like

ID CATEGORY1 CATEGORY2 COST
1 LAND ABC LAND 10000
2 LAND XYZ LAND 20000
3 LAND CED LAD 30000
4 VEHICLE TOYATA 800000
5 VEHICLE MAZDA 10000000

I am using two parameter in where clause based on category1,category2
i.e. p_cat1,p_cat2

Report should be like

Category1 : LAND

ID CATEGORY2 COST
1 ABC LAND 10000
2 XYZ LAND 20000
3 CED LAD 30000

Category1 : VEHICLE
ID CATEGORY2 COST
4 TOYATA 800000
5 MAZDA 10000000

TASK: When I use value from cat1 there must be values of cat2 according to cat1 and ID of cat1

Problem : Table structure can not be changed

there is no foreign key relation b/w cat1 and cat2
thanks





Nigar

From your post what I am trying to understand is that you want to have a self join but still a confusion is that in one category you have LAND and in other VERHICLES but what would be the key to join them? So first need we need to identify the key to build relation. Secondly please check lexical references if of any help and sample is already available in the forum here. thanks

I am unable to understand yours requiremnt or problem.... please me in brief, according to me there is no problem in yours requiremnt because you need to run report which based on 2 parameter which are based on each other.....???


takre care

Best regards,
R E H A N M I R Z A
System Analyst / Senior Oracle Developer
Cell: +92-304-2120807

When ever you pray
Please remember me and my family