create or replace view v_notscanneditems as
select vl.customernumber, vl.customerName, vl.wearernumber, vl.wearerName, vl.departmentnumber
, vl.departmentDescription, vl.distributionpointnumber, vl.distributionpointDescription
, vl.customerLanguageID, vl.businessunit_id
, vx.productCode, vx.productDescription, vx.sizedefinitionCode, vx.sizedefinitionDescription, vx.primaryid
, vx.lastscandate, vx.issuedate, vx.statusCode, vx.statusdescription, vx.stayNumber, vx.StayDescription
, vx.languageLanguageID, vx.languageCode
, vo.finishingmethodCode, vo.finishingmethodDescription, vo.flagCode
, vl.bank, vl.locker, vl.reportparam_id, vl.ResidualValue, vl.chain_code, vl.linetype
from v_notscanneditems_line vl, v_notscanneditems_aux vx,  v_notscanneditems_outer vo
 where
    vl.uniqueitem_id = vx.uniqueitem_id
and vx.uniqueitem_id = vo.uniqueitem_id
    and vx.languageLanguageID = vo.languageLanguageID
and vo.uniqueitem_id = vl.uniqueitem_id
and vl.routefilter = 1
;
/