SELECT [Link], [Link], [Link], [Link], [Link], L.
NMLOJA,
[Link], [Link], [Link], [Link], [Link], [Link],
[Link], [Link], [Link], [Link], [Link] -
[Link] AS VRGTINIREDZ, [Link],
[Link], [Link], [Link], [Link], [Link],
[Link], [Link], [Link], [Link], [Link],
[Link], DECODE([Link], 'S', [Link]) AS
IDLIBERAPROV, [Link], NVL(( SELECT 'S' FROM TURCAIXA TU WHERE ( [Link] IS
NULL ) AND [Link] = [Link] AND [Link] = [Link] AND [Link] =
[Link] AND TRUNC([Link]) = TRUNC([Link]) ),'N') AS
IDCAIXAABERTO FROM REDUCAOZ RZ JOIN FILIAL F ON [Link] = [Link] AND
[Link] = [Link] JOIN PARAVEND P ON [Link] = [Link] AND [Link] =
[Link] JOIN CAIXA C ON [Link] = [Link] AND [Link] = [Link] AND
[Link] = [Link] JOIN LOJA L ON [Link] = [Link] AND [Link] =
[Link] AND [Link] = [Link] WHERE ( ( INSTR(:CDFILIAL, '_' || [Link] ||
'_') > 0 ) OR (:CDFILIAL = 'T' ) ) AND EXISTS ( SELECT CDFILIAL FROM FILIOPER FO
WHERE [Link] = [Link] AND [Link] = :CDOPERADOR ) AND
( ( INSTR(:CDCAIXA, '_' || [Link] || [Link] || '_') > 0 ) OR (:CDCAIXA =
'T' ) ) AND ( TRUNC([Link]) BETWEEN :DATAINI AND :DATAFIN ) AND
( ( INSTR(:STATUS, '_' || [Link] || '_') > 0 ) OR (:STATUS = 'T' ) ) AND
( ( INSTR(:IDORIGEMREDZ, '_' || [Link] || '_') > 0 ) OR (:IDORIGEMREDZ =
'T' ) ) AND [Link] = :NRORG AND VRVENBRUREDZ <> 0 AND VRVENLIQREDZ <> 0 AND
[Link] = :IDFECHLOJA UNION ALL SELECT [Link], [Link],
[Link], [Link], [Link], [Link], [Link], [Link],
[Link], '' AS NRREINIREDZ, '' AS NRREDREDZ, '' AS NRLEITREDZ, '' AS
NRGERCNFREDZ, '' AS NRCANCFREDZ, '' AS NRPRIMCFREDZ, '' AS NRULTCFREDZ, 0 AS
VRGTREDZ, 0 AS VRGTINIREDZ, [Link], 0 AS VRISSREDZ, 0 AS
VRTOTCANREDZ, 0 AS VRTOTDESREDZ, [Link], 0 AS VRTOTACRREDZ, '' AS
NRECFREDZ, [Link], '' AS NRSERIEREDZ, '' AS CDOPERADOR,
[Link], [Link], [Link], [Link] FROM ( SELECT
[Link], SUM([Link] *([Link] + NVL([Link], 0)))
AS VRVENBRUREDZ, SUM(([Link] *([Link] + NVL([Link], 0))) -
NVL([Link], 0) + NVL([Link], 0)) AS
VRVENLIQREDZ, [Link]
AS IDSTATUS, [Link], [Link], [Link], [Link], [Link], [Link],
TRUNC([Link])
AS DTREDUCAOZ, DECODE([Link], 'N', 'NFCE', 'S', 'SAT')
AS IDORIGEMREDZ, [Link], [Link], DECODE([Link], 'S',
[Link])
AS IDLIBERAPROV, MAX(NVL((SELECT 'S' FROM TURCAIXA TU WHERE [Link] IS NULL
AND [Link] = [Link] AND [Link] = [Link] AND [Link] = [Link] AND
TRUNC([Link]) = TRUNC([Link])),'N')) AS IDCAIXABERTO FROM VENDA
V, ITEMVENDA IT, FILIAL F, CAIXA C, PARAVEND P, LOJA L WHERE
[Link] = [Link] AND [Link] = [Link] AND [Link] =
[Link] AND [Link] = [Link] AND [Link] = [Link] AND EXISTS ( SELECT
CDFILIAL FROM FILIOPER FO WHERE [Link] = [Link] AND [Link]
= :CDOPERADOR ) AND [Link] = [Link] AND [Link] = [Link] AND [Link] =
[Link] AND [Link] = [Link] AND [Link] = [Link] AND [Link] = [Link]
AND [Link] = [Link] AND [Link] = [Link] AND [Link] = [Link] AND
[Link] IN ( 'N', 'S' ) AND ( ( INSTR(:CDFILIAL, '_' || [Link] || '_') >
0 ) OR ( :CDFILIAL = 'T' ) ) AND ( ( INSTR(:CDCAIXA, '_' || [Link] || [Link]
|| '_') > 0 ) OR ( :CDCAIXA = 'T' ) ) AND ( TRUNC([Link]) BETWEEN :DATAINI
AND :DATAFIN ) AND ( ( INSTR(:STATUS, '_' || [Link] || '_') > 0 ) OR
( :STATUS = 'T' ) ) AND ( ( ( INSTR(:IDORIGEMREDZ, 'NFCE') > 0 ) AND
( [Link] = 'N' ) ) OR ( ( INSTR(:IDORIGEMREDZ, 'SAT') > 0 ) AND
( [Link] = 'S' ) ) OR ( :IDORIGEMREDZ = 'T' ) ) AND [Link] = '1' AND
[Link] = 'A' AND [Link] = :NRORG AND [Link] = :IDFECHLOJA GROUP BY
[Link], [Link], [Link], [Link], [Link], [Link], [Link],
[Link], TRUNC([Link]), DECODE([Link], 'N', 'NFCE', 'S', 'SAT'),
[Link], [Link], IDLIBERAPROV ) VE WHERE VRVENBRUREDZ <> 0 AND
VRVENLIQREDZ <> 0 ORDER BY DTREDUCAOZ, CDFILIAL, NRECFREDZ , CDCAIXA"