I created a quick report for SHPORD History Log….I ,as admin,can see every user that deleted a shop order, but my user can only see their own data.
How can I make the quick report so that the user can see all data...not just their own.
Important because shop orders have mysteriously been being deleted………………
select a.module,
a.time_stamp,
a.username,
a.history_type,
b.old_value site,
c.old_value part_no,
regexp_substr(a.keys, 'ORDER_NO=([^^]*)', 1, 1, null, 1) as order_no,
a.keys
from ifsapp.history_log a
left join (select old_value,log_id from ifsapp.history_log_attribute where column_name='CONTRACT') b
on a.log_id = b.log_id
left join (select old_value,log_id from ifsapp.history_log_attribute where column_name='PART_NO') c
on a.log_id = c.log_id
where module like 'SHPORD'
and (regexp_substr(a.keys, 'ORDER_NO=([^^]*)', 1, 1, null, 1)) like upper(nvl('&OrderNo','%'))
and (b.old_value like upper(nvl('&Site','%')) or b.old_value is null)
and (c.old_value like upper(nvl('&PartNo','%')) or c.old_value is null)
and time_stamp >= sysdate-30
order by a.time_stamp desc;
