select distinct fcfi.sfactura,
       ltrim(to_char(fcfi.caea_ptovta,'0000'))||'-'||
                fcfi.ctiplet ||'-'||
                ltrim(to_char(fcfi.nfactura,'00000000')) nro_fac,
    	fcfi.fhemision,
      	fcfi.dnomyap cliente,
        LTRIM(TO_CHAR(fcfi.scli_responsable,'0000000000')) nro_Cliente,
    	fcfi.ddomic domicilio,
    	fcfi.dloca localidad,
    	fcfi.cpostal,
	ctdc.dtpdocu,
    	fcfi.ncuit,
	fcfi.ndoc,
    	fcfi.dnomyap_despachante despachante,
        fcfi.ctpcomprobante,
        fcfi.cconvta,
        fcfi.nfactura,
        ccli.dnomyap,
	civa.d_iva,
	(nvl(fcfi.ineto,0)+nvl(fcfi.iib,0)-nvl(fcfi.ilibib,0)+nvl(fcfi.iiva,0)-nvl(fcfi.ilibiva,0)+nvl(fcfi.iivaper,0)-nvl(fcfi.ilibivaper,0)+nvl(fcfi.iivanoins,0)) * case fcfi.ctpcomprobante when 'FA' then 1 else fcfi.icotiza end total,
	fcfi.cconvta,
	sddt.nanio||'-'||ltrim(to_char(sddt.caduana,'0000'))||'-'||sddt.cdctodestinacion||'-'||ltrim(to_char(sddt.ndcto,'000000'))||'-'||sddt.dletra doc_aduana,
	stcg.dtpcarga,
	stin.dtipoingreso,
	sgui.cprefijo||'-'||sgui.nguia guia,
	sddt.qbuldest bul_des,
	sddt.qpesdest pes_des,
      ltrim(to_char(fcfi.caea_ptovta,'0000'))||'-'||
     fcfi.ctiplet ||'-'||
      decode(fcfi.ctpcomprobante, 'FA', ( ltrim(to_char((select remito.nfactura from fcfi remito where remito.sfactura_padre = fcfi.sfactura),'00000000'))),   ltrim(to_char((fcfi.nfactura ),'00000000'))) NRO_REMITO
from    CLI_CLIENTES ccli,
        FAC_CABECERAS_FACTURAS_INTERNA fcfi,
	CLI_IVA civa,
	CLI_TP_DOCUMENTOS ctdc,
        FAC_SECCIONES_ITEMS fsei,
	STK_TP_INGRESOS stin,
        STK_TP_CARGA stcg,
        STK_GUIAS sgui,
        STK_DCTOS_DESTINACIONES sddt,
        STK_DESTINACIONES sdes
where   
fcfi.sfactura = 14941668 and
 	fcfi.sfactura = fsei.sfactura
and	fsei.sdctodest = sddt.sdctodest
and	sdes.sguia = fsei.sguia
and	sdes.sdctoing =	fsei.sdctoing
and	sdes.sdctodest = fsei.sdctodest
and	stcg.ctpcarga =	sdes.ctpcarga
and	stin.ctipoingreso = sdes.ctipoingreso
and	sgui.sguia = fsei.sguia
and 	fcfi.ctpdocu = ctdc.ctpdocu
and     civa.c_iva = fcfi.civa
and     fcfi.ctpcomprobante IN( 'FA','RE')
and     fcfi.nfactura is not null
and     fcfi.scli_xctayorden = ccli.scli(+)