select     
  m.codinref,              -- +BDoEPgQ0- +BDIENA-
  m.nminref,               -- +BDIENA-        
  m.whl_retl,              -- 1 - +BEAEPgQ3BD0EOARGBDA-, 0 - +BD4EPwRC-
  m.flagserv,              -- +BEQEOwQwBDM- +BEMEQQQ7BEMEMwQ4-
  m.codgdsrv,              -- +BDoEPgQ0- +BEIEPgQyBDAEQAQw-/+BEMEQQQ7BEMEMwQ4-
  m.nmgdsrv,               -- +BEIEPgQyBDAEQA-/+BEMEQQQ7BEMEMwQw-  
  m.qtywrtdcmsm,           -- +BDoEPgQ7BDgERwQ1BEEEQgQyBD4-
  m.prcwrtmaincur,         -- +BEEEQgQ+BDgEPAQ+BEEEQgRM- +BEE- +BD0EMAQ7BD4EMwQwBDwEOA- stock
  m.cstmgtmaincur,         -- +BEEEQgQ+BDgEPAQ+BEEEQgRM- +BDEENQQ3- +BD0EMAQ7BD4EMwQ+BDI-
  
  t.qtybsmsm,              -- +BDoEPgQ7BDgERwQ1BEEEQgQyBD4- +BD8EPg- +BEEEPwQ4BEEEMAQ9BDgETg-
  gd2.cstaccmaincur,       -- +BEEEQwQ8BDwEMA- +BD8EPg- +BEEEPwQ4BEEEMAQ9BDgETg- +BDEENQQ3- +BD0ENARB-
  
  m.coddoc,                -- +BDoEPgQ0- +BDQEPgQ6BEMEPAQ1BD0EQgQw-
  m.numdoc,                -- +BDQEPgQ6BEMEPAQ1BD0EQg-         
  m.codctrec,              -- +BDoEPgQ9BEIEQAQwBDMENQQ9BEI- 
  t.codinvin               -- +BDoEPgQ0- +BD8EPQ- +BD8EPg- +BEEEPwQ4BEEEMAQ9BDgETg-  

from                
  stkdocsgdsandsrv gd2
   inner join 
  StkOffTable t
   inner join (
  select 
    v.codinref,              -- +BDoEPgQ0- +BDIENA-
    u.nminref,               -- +BDIENA-        
    decode(s.codctrec,
      1908501,               -- +BEAEPgQ3BD0EOARGBDA-
      1,                     -- 1 - +BEAEPgQ3BD0EOARGBDA-, 0 - +BD4EPwRC-
      0) whl_retl,           -- +BD4EPwRC- +BDgEOwQ4- +BEAEPgQ3BD0EOARGBDA-
    c.flagserv,              -- +BEQEOwQwBDM- +BEMEQQQ7BEMEMwQ4-
    gd1.codgdsrv,            -- +BDoEPgQ0- +BEIEPgQyBDAEQAQw-/+BEMEQQQ7BEMEMwQ4-
    c.nmgdsrv,               -- +BEIEPgQyBDAEQA-/+BEMEQQQ7BEMEMwQw-  
    gd1.qtywrtdcmsm,         -- +BDoEPgQ7BDgERwQ1BEEEQgQyBD4-
    gd1.prcwrtmaincur,       -- +BEEEQgQ+BDgEPAQ+BEEEQgRM- +BEE- +BD0EMAQ7BD4EMwQwBDwEOA-  
    gd1.cstmgtmaincur,       -- +BEEEQgQ+BDgEPAQ+BEEEQgRM- +BDEENQQ3- +BD0EMAQ7BD4EMwQ+BDI-
    s.coddoc,                -- +BDoEPgQ0- +BDQEPgQ6BEMEPAQ1BD0EQgQw-
    s.numdoc,                -- +BDQEPgQ6BEMEPAQ1BD0EQg-         
    s.codctrec               -- +BDoEPgQ9BEIEQAQwBDMENQQ9BEI- 
  from stkdocs s, refuser u, stkdocsref v, stkdocsgdsandsrv gd1, gdsandsrv c
  where s.dateexec >= to_date('01.03.2006', 'dd.mm.yyyy') -- +BDQEMARCBDA- +BD0EMARHBDAEOwQw- +BD8ENQRABDgEPgQ0BDA-
    and s.dateexec <= to_date('31.03.2006', 'dd.mm.yyyy') -- +BDQEMARCBDA- +BDoEPgQ9BEYEMA- +BD8ENQRABDgEPgQ0BDA-
    and s.codbr = 4201                                    -- +BDoEPgQ0- +BEQEOAQ7BDgEMAQ7BDA-
    and s.flaginout = 1                                   -- +BEAEMARBBEUEPgQ0BD0EMARP-
    and s.typdoc = 3                                      -- +BD0EMAQ6BDsEMAQ0BD0EMARP-
    and s.subtypdoc = 1                                   -- +BDI- +BEEEPgQxBEEEQgQyBDUEPQQ9BD4EQQRCBEw-   
    and s.flagfactura = 1                                 -- +BEE- +BD8EQAQ4BDcEPQQwBDoEPgQ8- +BEEERw-. +BEQEMAQ6BEIEQwRABEs-
    and v.coddoc = s.coddoc                               -- +BDAEPQQwBDsEOARCBDgEOgQw-
    and v.codref = 2501                                   -- +BBIEGAQUBCs- +BBQEFQQvBCIEFQQbBCwEHQQeBCEEIgQY-/+BB8EIAQVBBQEHAQVBCI- +BBQEFQQvBCIEFQQbBCwEHQQeBCEEIgQY-
    and v.codinref = u.codinref
    
    and gd1.coddoc =  s.coddoc                            -- +BEEEMgRPBDcETA- +BEE- +BEIEPgQyBDAEQAQ+BDw-/+BEMEQQQ7BEMEMwQ+BDk-
    and c.codgdsrv = gd1.codgdsrv   
  ) m
  on t.codinvot = m.coddoc                               -- +BEEEPgQ+BEIEMgQ1BEIEQQRCBDIEOAQ1- +BD8EPg- +BEEEPwQ4BEEEMAQ9BDgETg-
  on gd2.codgdsrv = m.codgdsrv                           -- +BEEEPgQ+BEIEMgQ1BEIEQQRCBDIEOAQ1- +BEIEPgQyBDAEQAQw- +BDgENw- +BEAEPQ- +BEE- +BEIEPgQyBDAEQAQ+BDw- +BDI- +BD8EPQ-
  and t.codinvin = gd2.coddoc                             -- +BDoEPgQ0- +BD8EPQ-
  and m.coddoc = 24509901