create or replace view v_notscanneditems_outer as
select uq.uniqueitem_id
, finishingmethod.code finishingmethodCode
, (select finishingmethod_desc.description from finishingmethod_desc
where finishingmethod_desc.finishingmethod_id =  finishingmethod.finishingmethod_id
and finishingmethod_desc.language_id = languages.language_id) finishingmethodDescription
, flag.code flagCode, languages.language_id languageLanguageID
from
  uniqueitem uq
   left outer join finishingmethod  on finishingmethod.finishingmethod_id = uq.finishingmethod_id
   left outer join (uniqueitemflag uqf join flag on uqf.flag_id = flag.flag_id    )
                  on uq.uniqueitem_id = uqf.uniqueitem_id
, languages
;
/