Gopneg

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