APEX

Hi,

I am preparing an analysis report where same query works on SQL developer but it doesn't work on APEX. Database link was granted earlier to following workspace and schema:

APEX WorkSpace: OIEDEV
APEX Schema: OIEDEV

Error States:
========

ORA-00942: table or view does not exist

Question:
======
Is that schema to which database link was created doesnt have access to these tables - 'rpthead_history' and 'bug_user'. So in that case, what to be done ?

SQL Query:
=======

select r.programmer "Assignee",
r.rptno "Bug Number",
r.status "Bug Status",
r.cs_priority "Priority",
r.upd_by "Last Updated By" from rpthead@bugdb r, rpthead_history@bugdb h,bug_user@bugdb u
where product_id = 397 and
r.rptd_by <> 'ARU' and
r.cs_priority < 3 and
r.programmer = u.bug_username and
r.upd_date > sysdate-7 and
r.status > 30 and
r.status not in (11,10,30,40,51) and
h.old_status in (11,30,40,10,51) and h.new_status > 30 and
h.new_status not in (33,40,51) and h.upd_date > sysdate-7 and r.rptno = h.rptno and not exists (select null from rpthead_history h1 where h1.rptno = h.rptno and h1.upd_date > h.upd_date and h1.new_status in (11,40,51)) order by 1

Thanks,
Ramesh