CREATE VIEW asset_report_change_request AS
SELECT x.ar_id, x.ar_barcode, y.il_description, y.il_group, y.il_priloc, y.il_secloc, y.il_terloc, x.ar_userid, x.ar_scandt, y.il_ts, x.ar_ts FROM asset_report x
LEFT JOIN item_list y ON x.ar_barcode=y.il_barcode
WHERE ar_checkrqd=”Yes”;