SQL View Erstellung

create view xx as
select rownum as sorter,  myview.* from (
select *
from
    (select
      ftree.connect_by_root_kc  as BASIS_RUECKMELDE_NR,
      pfsp.RUECKMELDE_NR
     ,pfsp.RUECKMELDE_POSITIONS_NR
     ,pfsp.KOMPONENTEN_ARTIKEL_NR as ARTIKEL_NR
     ,pfsp.ENTNAHME_MENGE
    from cprec_pfak_tree ftree 
    inner join pfsp on pfsp.rueckmelde_nr = ftree.rueckmelde_nr_kc
    where (ftree.basis_rueckmelde_nr_kc = ftree.connect_by_root_kc or ftree.basis_rueckmelde_nr_kc = 0)
    --and ftree.connect_by_root_kc = 30059276
    ) stueckliste
 left join
    (select 
     lagerort
     ,artikel_nr as ARTIKEL_NR
     ,chargen_serien_nr     
     ,null as lagerbereich
     ,null as koordinate_1
     ,null as koordinate_2
     ,null as koordinate_3
     ,null as koordinate_4
     ,'20991231' as letzter_zugang  
     ,menge_1 as bestandsmenge
    from pmlb
    where lagerort = '11002' or lagerort = '11003'  
    
    union
    
    select
      lpbe.lagerort
     ,lpbe.artikel_nr as ARTIKEL_NR
     ,lpbe.chargen_serien_nr
     ,lpbe.lagerbereich
     ,lpbe.koordinate_1
     ,lpbe.koordinate_2
     ,lpbe.koordinate_3
     ,lpbe.koordinate_4
     ,lpbe.letzter_zugang
     ,lpbe.bestandsmenge as bestandsmenge
    from lpbe
    where lpbe.lagerort = '11000'  
    ) lagerplaetze
    
on stueckliste.artikel_nr = lagerplaetze.artikel_nr
--and lagerplaetze.bestandsmenge >= stueckliste.entnahme_menge

order by
  stueckliste.BASIS_RUECKMELDE_NR,
  lagerplaetze.lagerort asc
 ,lagerplaetze.lagerbereich
 ,lagerplaetze.koordinate_1
 ,lagerplaetze.koordinate_2
 ,lagerplaetze.koordinate_3
 ,lagerplaetze.koordinate_4
 ,stueckliste.RUECKMELDE_NR
 ,stueckliste.RUECKMELDE_POSITIONS_NR ) myview
 

 
 ;