queries FE

----queryINTERBFindIdResponsableFacturados----

SELECT DISTINCT
decode(ccta_responsable,NULL,scli_despachante,scli_responsable) AS scli_cliente,
ccli.email AS email,
decode(fcfi.ccta_responsable,NULL,fcfi.dnomyap_despachante,fcfi.dnomyap) AS dnomyap
FROM
ccli INNER JOIN
fcfi ON
ccli.scli = fcfi.scli_responsable
WHERE
ctpcomprobante IN('FA','NC','ND')
AND cconvta = 4
AND fhemision>=:fechaMinima
AND caea_estado = 2
AND ccli.email IS NOT NULL

----queryINTERBFindFacturasAprobadasByCliente----

SELECT sfactura AS idFactura,
ctpcomprobante AS tipoComprobante,
ctpcomprobante||'-'||caea_ptovta||'-'||ctiplet||'-'||nfactura AS nroFactura,
dnomyap_despachante AS despachante,
dnomyap AS importador,
fhemision AS fechaEmision
FROM fcfi
WHERE
caea_estado = 2
AND fhemision >=:fechaMinima AND
cconvta = 4
AND ctpcomprobante IN('FA','NC','ND')
AND ((scli_despachante = idCliente AND ccta_despachante IS NOT NULL)
OR (scli_responsable = idCliente AND ccta_responsable IS NOT NULL));

----findFacturasAprobadasByClientePortal----

SELECT DISTINCT fcfi.sfactura AS idFactura,
fcfi.ctpcomprobante AS tipoComprobante,
fcfi.ctpcomprobante||'-'||fcfi.caea_ptovta||'-'||fcfi.ctiplet||'-'||fcfi.nfactura AS nroFactura,
fcfi.dnomyap_despachante AS despachante,
fcfi.dnomyap AS importador,
'IMPO' AS sucursal,
fcfi.fhemision AS fechaEmision
FROM fcfi
WHERE fcfi.caea_estado IN (2,4)
AND fcfi.fhemision >= :fechaMinima
AND fcfi.fhemision <= :fechaMaxima
AND fcfi.cconvta = 4
AND fcfi.ctpcomprobante IN('FA','NC','ND')

#En caso de ser !=NULL

AND ((fcfi.scli_despachante = idCliente
AND fcfi.ccta_despachante IS NOT NULL)
OR (fcfi.scli_responsable = idCliente
AND fcfi.ccta_responsable IS NOT NULL));