APEX

I posted a thread earlier but I think I was little amibiguous about my problem and posted too much info. on the background of the problem maybe I can clarify.

I have a report on a view TRK_CALLS_VIEW. This is dblinked to a table. Columns include
User_
Assigned_to
Problem
Solution
Status

Here is my region source code:

SELECT webb.TRK_CALLS_VIEW.ID, webb.TRK_CALLS_VIEW.USER_, webb.TRK_CALLS_VIEW.ASSIGNED_TO, webb.TRK_CALLS_VIEW.PROBLEM, webb.TRK_CALLS_VIEW.SOLUTION, webb.TRK_CALLS_VIEW.STATUS
FROM webb.TRK_CALLS_VIEW
WHERE

( STATUS = 'Open' and :P2_REPORT_SEARCH is null )
or
( regexp_like( USER_ || '#' || ASSIGNED_TO || '#' || PROBLEM || '#' ||
SOLUTION || '#' || STATUS, :P2_REPORT_SEARCH, 'i' ) )


I want to include columns from another view in the report. TRK_USER_VIEW.
Columns include:
id
lname
fname

User_ from TRK_CALLS_VIEW contains the same number as id in TRK_USER_VIEW.
How would I add this to my existing code and have the names corespond to the correct id
Thanks