create or replace view v_notscanneditemsrv as
select distinct vx.customernumber, vx.customerName, vx.wearernumber, vx.wearerName, vx.departmentnumber
, vx.departmentDescription, vx.distributionpointnumber, vx.distributionpointDescription
, vx.customerLanguageID, vx.businessunit_id, vx.BU_code, vx.BU_desc
, 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, vx.washestotal
, vo.finishingmethodCode, vo.finishingmethodDescription--, vo.flagCode
, vx.bank, vx.locker, vx.reportparam_id
, vx.residualvalue,vx.rvpercentage, vx.SizeSequenceNr,
vx.chain_code
from  v_notscanneditems_auxRV vx,  v_notscanneditems_outerRV vo
 where vx.languageLanguageID = vo.languageLanguageID
and vo.uniqueitem_id = vx.uniqueitem_id
and vo.reportparam_id = vx.reportparam_id;
/
