You are likely going to have better luck in the EBS forum.
Unless you can distil your problem down into something that is pure SQL / PLSQL and show us what you are working with.
This is the (generic) SQL and PL/SQL forum.
If this problem is all about some Oracle application. such as Business Intelligence, then post it it a forum that deals with that application, not the generic SQL and PL/SQL Forum.
If this problem does not assume familiarity with any application, then this is probably the right forum for it. Post CREATE TABLE and INSERT statements (relevant tables and columns only) for a little sample data, and the exact results you want from that sample data. Explain, in general terms, how you get those specific results from that specific data.
See the Forum FAQ: Re: 2. How do I ask a question on the forums?
It sounds like you have 15 pairs of columns on each row, and you want to display them as one column on 30 rows. In SQL, that can be done using the SELECT ... UNPIVOT feature.
Thank you. I'll move it to Oracle EBS section.