<?xml version="1.0" encoding="UTF-8"?>
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="caco_inf_base_gest_cartera" language="groovy" pageWidth="2350" pageHeight="612" orientation="Landscape" whenNoDataType="NoDataSection" columnWidth="2310" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
	<property name="ireport.zoom" value="1.464100000000004"/>
	<property name="ireport.x" value="2392"/>
	<property name="ireport.y" value="0"/>
	<property name="ireport.jasperserver.reportUnit" value="/reports/cartera/caco_inf_base_gest_cartera"/>
	<property name="ireport.jasperserver.url" value="http://3.22.202.200:8080/jasperserver/services/repository"/>
	<parameter name="fecha_ini" class="java.lang.String">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="fecha_fin" class="java.lang.String">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="whereTipoContrato" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="whereContrato" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="whereEntidadContrato" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="whereSupervisorCont" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="id_anhos_corte" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="id_meses_corte" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="whereAplicaSalvedad" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="whereSaldoPendiente" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="whereTipoNovCont" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[select

tab0.*

from(

    SELECT
    tab0.id_contrato as id_contrato, tab0.id_tipo_contrato as id_tipo_contrato,
    tab0.descripcion as descripcion,
    tab0.codigo as codigo, tab0.id_anhos as id_anhos,
    tab0.fecha_proceso as fecha_proceso,
    tab0.fecha_inicial as fecha_inicial,
    tab0.fecha_termina as fecha_termina,
    tab0.valor_compania as valor_compania, tab0.valor_entidad as valor_entidad,
    tab0.valor_contrato as valor_contrato, tab0.aplica_salvedad as aplica_salvedad,
    tab0.estado as estado,
    tab0.fecha_log as fecha_log, tab0.usuario_log as usuario_log,
    tab0.fecha_anu as fecha_anu, tab0.motivo_anu as motivo_anu,
    tab0.usuario_anu as usuario_anu,
    tab0.id_supervisor_cont as id_supervisor_cont,

    tab0.codigo_tipcont as codigo_tipcont, tab0.descripcion_tipcont as descripcion_tipcont,
    tab0.id_mae_ter_sup as id_mae_ter_sup, tab0.num_doc_sup as num_doc_sup,
    tab0.dv_sup as dv_sup, tab0.razon_soc_sup as razon_soc_sup, tab0.correo_sup as correo_sup,
    tab0.cargo_sup as cargo_sup, tab0.correo_ter as correo_ter, tab0.codigo_anhos as codigo_anhos,
    tab0.no_completo as no_completo, tab0.completo_sup as completo_sup,
    tab0.id_entidad_contrato as id_entidad_contrato,
    tab0.num_doc_ent as num_doc_ent,
    tab0.dv_ent as dv_ent,
    tab0.num_doc_ent || (case when tab0.dv_ent is not null then '-' || tab0.dv_ent else '' end) as nitocc_ent,
 tab0.razon_soc_ent as razon_soc_ent, tab0.completo_ent as completo_ent,
    tab0.correo_ent as correo_ent, tab0.referencia as referencia,
    tab0.referencia_tipo as referencia_tipo,

    nov.id_tipo_nov_cont,
    nov.descripcion_tipnov as estado_tipo,
    desem.tipos_recurso as recursos,
    '' as convenio,
    nvl( nov.valor_no_ejecutado ,0) as no_ejecutados,
    nvl( nov.valor_no_reconocido ,0) as no_reconocidos,
    nvl( nov.valor_no_ejecutado + nov.valor_no_reconocido ,0) as vlr_reintegrar,
    nvl( nov.indexacion ,0) + nvl( nov.valor_ajuste_indexacion ,0) as vlr_indexacion,
    nvl( nov.valor_intereses_mora ,0) + nvl( nov.valor_ajuste_mora ,0) as vlr_interes_moratorio,
    nvl( nov.valor_intereses_banco ,0) + nvl( nov.valor_ajuste_banco ,0) as vlr_interes_bancario,
    nvl( nov.valor_no_ejecutado + nov.valor_no_reconocido + nov.indexacion + nov.valor_intereses_mora + nov.valor_intereses_banco + nov.valor_ajuste_indexacion + nov.valor_ajuste_mora + nov.valor_ajuste_banco ,0) as valor_total,

    tarein.fecha_novedad as fecha_reintegro,
    nvl( ta.no_ejecutados_rein ,0) as no_ejecutados_rein,
    nvl( ta1.no_aprobados_rein ,0) as no_aprobados_rein,
    nvl( ta2.intereses ,0) as vlr_sum_interes,
    nvl( ta.no_ejecutados_rein ,0) + nvl( ta1.no_aprobados_rein ,0) + nvl( ta2.intereses ,0) as vlr_reintegrado,

    nvl( (nvl( nov.valor_no_ejecutado + nov.valor_no_reconocido + nov.indexacion + nov.valor_intereses_mora + nov.valor_intereses_banco + nov.valor_ajuste_indexacion + nov.valor_ajuste_mora + nov.valor_ajuste_banco ,0))
        - ( nvl( ta.no_ejecutados_rein ,0) + nvl( ta1.no_aprobados_rein ,0) + nvl( ta2.intereses ,0) )
    ,0) as saldo_pendiente

    FROM CACO_CONTRATO_V tab0

    left join (
        select tab22.id_contrato,
        sum(tab22.valor_reintegro)	 as no_ejecutados_rein
         from caco_novedad_reintegro tab22
        where tab22.tipo_valor = 'RE'
        GROUP BY tab22.id_contrato
    )ta ON ta.id_contrato=tab0.id_contrato

    left join (
        select tab21.id_contrato,
        sum(tab21.valor_reintegro)	 as no_aprobados_rein
         from caco_novedad_reintegro tab21
        where tab21.tipo_valor = 'RC'
        GROUP BY tab21.id_contrato
    )ta1 ON ta1.id_contrato=tab0.id_contrato

    left join (
        select tab20.id_contrato,
        sum(tab20.valor_reintegro)	 as intereses
         from caco_novedad_reintegro tab20
        where tab20.tipo_valor = 'IB' or tab20.tipo_valor = 'IM' or tab20.tipo_valor = 'IX'
        GROUP BY tab20.id_contrato
    )ta2 ON ta2.id_contrato=tab0.id_contrato

    left join(

        select
        tipnov.codigo as codigo_tipnov,
        tipnov.descripcion as descripcion_tipnov,
        novcon.*,
        ROW_NUMBER() OVER (
            partition by novcon.id_contrato
            ORDER BY novcon.id_contrato, novcon.fecha_novedad desc
        ) AS rn

        from caco_novedad_contrato_v novcon

        left join caco_tipo_nov_cont tipnov
        on tipnov.id_tipo_nov_cont = novcon.id_tipo_nov_cont

        where
        tipnov.aplica_cartera = 1
        and extract(year from novcon.fecha_novedad) || lpad(extract(month from novcon.fecha_novedad), 2, '0')  <= $P{id_anhos_corte} || lpad($P{id_meses_corte}, 2, '0')
        and novcon.firmado = 1

    )nov
    on nov.id_contrato = tab0.id_contrato
    and nov.rn = 1

    left join (
        select tarein.id_contrato,
        min(tarein.fecha_novedad)	 as fecha_novedad
         from caco_novedad_reintegro tarein
        GROUP BY tarein.id_contrato
    )tarein ON tarein.id_contrato=tab0.id_contrato

    left join(
        select
        tab0.id_contrato,
        sum(tab0.valor_desembolso) as valor_desembolso,
        LISTAGG(tab0.id_tipo_recurso, '; ') WITHIN GROUP (ORDER BY tab0.id_tipo_recurso) as id_tipos,
        to_char(wm_concat(DISTINCT tip.descripcion)) as tipos_recurso
        from caco_novedad_desembolso tab0
        left join caco_tipo_recurso tip
        on tab0.id_tipo_recurso = tip.id_tipo_recurso
        group by
        tab0.id_contrato
    )desem
    on desem.id_contrato = tab0.id_contrato


    WHERE
    tab0.fecha_proceso BETWEEN to_date($P{fecha_ini}, 'dd/mm/yyyy') AND to_date($P{fecha_fin}, 'dd/mm/yyyy')
    $P!{whereTipoContrato}
    $P!{whereContrato}
    $P!{whereEntidadContrato}
    $P!{whereSupervisorCont}

)tab0

where
1 = 1
$P!{whereTipoNovCont}
$P!{whereAplicaSalvedad}
$P!{whereSaldoPendiente}

ORDER BY
tab0.id_anhos,
tab0.codigo,
tab0.fecha_proceso]]>
	</queryString>
	<field name="ID_CONTRATO" class="java.math.BigDecimal"/>
	<field name="ID_TIPO_CONTRATO" class="java.math.BigDecimal"/>
	<field name="DESCRIPCION" class="java.lang.String"/>
	<field name="CODIGO" class="java.lang.String"/>
	<field name="ID_ANHOS" class="java.math.BigDecimal"/>
	<field name="FECHA_PROCESO" class="java.sql.Timestamp"/>
	<field name="FECHA_INICIAL" class="java.sql.Timestamp"/>
	<field name="FECHA_TERMINA" class="java.sql.Timestamp"/>
	<field name="VALOR_COMPANIA" class="java.math.BigDecimal"/>
	<field name="VALOR_ENTIDAD" class="java.math.BigDecimal"/>
	<field name="VALOR_CONTRATO" class="java.math.BigDecimal"/>
	<field name="APLICA_SALVEDAD" class="java.math.BigDecimal"/>
	<field name="ESTADO" class="java.math.BigDecimal"/>
	<field name="FECHA_LOG" class="java.sql.Timestamp"/>
	<field name="USUARIO_LOG" class="java.lang.String"/>
	<field name="FECHA_ANU" class="java.sql.Timestamp"/>
	<field name="MOTIVO_ANU" class="java.lang.String"/>
	<field name="USUARIO_ANU" class="java.lang.String"/>
	<field name="ID_SUPERVISOR_CONT" class="java.math.BigDecimal"/>
	<field name="CODIGO_TIPCONT" class="java.lang.String"/>
	<field name="DESCRIPCION_TIPCONT" class="java.lang.String"/>
	<field name="ID_MAE_TER_SUP" class="java.math.BigDecimal"/>
	<field name="NUM_DOC_SUP" class="java.lang.String"/>
	<field name="DV_SUP" class="java.math.BigDecimal"/>
	<field name="RAZON_SOC_SUP" class="java.lang.String"/>
	<field name="CORREO_SUP" class="java.lang.String"/>
	<field name="CARGO_SUP" class="java.lang.String"/>
	<field name="CORREO_TER" class="java.lang.String"/>
	<field name="CODIGO_ANHOS" class="java.lang.String"/>
	<field name="NO_COMPLETO" class="java.lang.String"/>
	<field name="COMPLETO_SUP" class="java.lang.String"/>
	<field name="ID_ENTIDAD_CONTRATO" class="java.math.BigDecimal"/>
	<field name="NUM_DOC_ENT" class="java.lang.String"/>
	<field name="DV_ENT" class="java.math.BigDecimal"/>
	<field name="NITOCC_ENT" class="java.lang.String"/>
	<field name="RAZON_SOC_ENT" class="java.lang.String"/>
	<field name="COMPLETO_ENT" class="java.lang.String"/>
	<field name="CORREO_ENT" class="java.lang.String"/>
	<field name="REFERENCIA" class="java.lang.String"/>
	<field name="REFERENCIA_TIPO" class="java.lang.String"/>
	<field name="ID_TIPO_NOV_CONT" class="java.math.BigDecimal"/>
	<field name="ESTADO_TIPO" class="java.lang.String"/>
	<field name="RECURSOS" class="java.lang.String"/>
	<field name="CONVENIO" class="java.lang.String"/>
	<field name="NO_EJECUTADOS" class="java.math.BigDecimal"/>
	<field name="NO_RECONOCIDOS" class="java.math.BigDecimal"/>
	<field name="VLR_REINTEGRAR" class="java.math.BigDecimal"/>
	<field name="VLR_INDEXACION" class="java.math.BigDecimal"/>
	<field name="VLR_INTERES_MORATORIO" class="java.math.BigDecimal"/>
	<field name="VLR_INTERES_BANCARIO" class="java.math.BigDecimal"/>
	<field name="VALOR_TOTAL" class="java.math.BigDecimal"/>
	<field name="FECHA_REINTEGRO" class="java.sql.Timestamp"/>
	<field name="NO_EJECUTADOS_REIN" class="java.math.BigDecimal"/>
	<field name="NO_APROBADOS_REIN" class="java.math.BigDecimal"/>
	<field name="VLR_SUM_INTERES" class="java.math.BigDecimal"/>
	<field name="VLR_REINTEGRADO" class="java.math.BigDecimal"/>
	<field name="SALDO_PENDIENTE" class="java.math.BigDecimal"/>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="60" splitType="Stretch">
			<staticText>
				<reportElement x="780" y="0" width="600" height="40"/>
				<textElement textAlignment="Center" verticalAlignment="Bottom" markup="none">
					<font fontName="SansSerif" size="12" isBold="true"/>
				</textElement>
				<text><![CDATA[Sistema de Cartera
Informe Base Gestión Cartera]]></text>
			</staticText>
			<image>
				<reportElement x="0" y="10" width="140" height="40"/>
				<imageExpression class="java.lang.String"><![CDATA["repo:LogoEmpresa003.jpg"]]></imageExpression>
			</image>
			<staticText>
				<reportElement mode="Opaque" x="1580" y="28" width="200" height="12" forecolor="#000000" backcolor="#FFFFFF"/>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Fecha de Impresión:]]></text>
			</staticText>
			<textField>
				<reportElement x="780" y="40" width="600" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle" markup="none">
					<font fontName="SansSerif" size="12" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["BASE GESTION CARTERA "+$P{id_meses_corte}+" - "+$P{id_anhos_corte}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy  hh:mm aaa">
				<reportElement x="1580" y="40" width="200" height="12"/>
				<box rightPadding="3"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[new java.util.Date()]]></textFieldExpression>
			</textField>
		</band>
	</title>
	<pageHeader>
		<band height="20" splitType="Stretch"/>
	</pageHeader>
	<columnHeader>
		<band height="20" splitType="Stretch">
			<staticText>
				<reportElement mode="Opaque" x="0" y="0" width="140" height="20" backcolor="#AED6FB"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Contrato / Convenio]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="140" y="0" width="200" height="20" backcolor="#AED6FB"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Razon Social]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="460" y="0" width="120" height="20" backcolor="#AED6FB"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Estado del CT/CV]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="340" y="0" width="120" height="20" backcolor="#AED6FB"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[NIT]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="580" y="0" width="100" height="20" backcolor="#AED6FB"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Recursos]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="680" y="0" width="100" height="20" backcolor="#AED6FB"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Convenio SENA No.]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="780" y="0" width="100" height="20" backcolor="#AED6FB"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[No Ejecutados]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="880" y="0" width="100" height="20" backcolor="#AED6FB"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[No Reconocidos]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="980" y="0" width="100" height="20" backcolor="#AED6FB"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Vr. por Reintegrar]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1080" y="0" width="100" height="20" backcolor="#AED6FB"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Vr. Indexacion]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1180" y="0" width="100" height="20" backcolor="#AED6FB"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Vr. Interes Moratorio]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1280" y="0" width="100" height="20" backcolor="#AED6FB"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Vr. Interes Bancario]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1380" y="0" width="100" height="20" backcolor="#AED6FB"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[VALOR TOTAL]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1480" y="0" width="100" height="20" backcolor="#AED6FB"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Fecha Reintegro]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1580" y="0" width="100" height="20" backcolor="#AED6FB"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Reint. No Ejecutados]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1680" y="0" width="100" height="20" backcolor="#AED6FB"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Reint. No Aprobados]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1780" y="0" width="100" height="20" backcolor="#AED6FB"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Reint. Interes Banca. - Mora - Index]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1880" y="0" width="100" height="20" backcolor="#AED6FB"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Vr. Reintegrado]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1980" y="0" width="100" height="20" backcolor="#AED6FB"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Saldo Pendiente]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="2110" y="0" width="100" height="20" backcolor="#AED6FB"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Saldo Capital]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="2210" y="0" width="100" height="20" backcolor="#AED6FB"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Interes Banca. - Mora - Index]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Transparent" x="2080" y="0" width="30" height="20" backcolor="#AED6FB"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[ ]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="10" splitType="Stretch">
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="140" y="0" width="200" height="10"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{RAZON_SOC_ENT}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="340" y="0" width="120" height="10"/>
				<box rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NITOCC_ENT}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="460" y="0" width="120" height="10"/>
				<box leftPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{ESTADO_TIPO}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="0" y="0" width="140" height="10"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NO_COMPLETO}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="580" y="0" width="100" height="10"/>
				<box rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{RECURSOS}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="680" y="0" width="100" height="10"/>
				<box leftPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{CONVENIO}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="780" y="0" width="100" height="10"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{NO_EJECUTADOS}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="880" y="0" width="100" height="10"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{NO_RECONOCIDOS}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="980" y="0" width="100" height="10"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VLR_REINTEGRAR}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1080" y="0" width="100" height="10"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VLR_INDEXACION}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1180" y="0" width="100" height="10"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VLR_INTERES_MORATORIO}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1280" y="0" width="100" height="10"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VLR_INTERES_BANCARIO}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1380" y="0" width="100" height="10"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_TOTAL}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1480" y="0" width="100" height="10"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[$F{FECHA_REINTEGRO}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1580" y="0" width="100" height="10"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{NO_EJECUTADOS_REIN}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1680" y="0" width="100" height="10"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{NO_APROBADOS_REIN}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1780" y="0" width="100" height="10"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VLR_SUM_INTERES}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1880" y="0" width="100" height="10"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VLR_REINTEGRADO}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1980" y="0" width="100" height="10"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{SALDO_PENDIENTE}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="2110" y="0" width="100" height="10"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[( $F{NO_EJECUTADOS} + $F{NO_RECONOCIDOS} ) - ( $F{NO_EJECUTADOS_REIN} + $F{NO_APROBADOS_REIN} )]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="2210" y="0" width="100" height="10"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[( $F{VLR_INTERES_MORATORIO}  + $F{VLR_INTERES_BANCARIO} + $F{VLR_INDEXACION}) - $F{VLR_SUM_INTERES}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="2080" y="0" width="30" height="10"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band height="15" splitType="Stretch"/>
	</columnFooter>
	<pageFooter>
		<band height="24" splitType="Stretch">
			<textField>
				<reportElement mode="Opaque" x="880" y="12" width="100" height="12" forecolor="#575757" backcolor="#FFFFFF"/>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Página "+$V{PAGE_NUMBER}+" de "]]></textFieldExpression>
			</textField>
			<textField evaluationTime="Report" pattern="" isBlankWhenNull="false">
				<reportElement mode="Opaque" x="980" y="12" width="100" height="12" forecolor="#575757" backcolor="#FFFFFF"/>
				<textElement verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="880" y="0" width="200" height="12" forecolor="#575757"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<text><![CDATA[Websafi - Cartera]]></text>
			</staticText>
		</band>
	</pageFooter>
	<summary>
		<band height="15" splitType="Stretch"/>
	</summary>
	<noData>
		<band height="20">
			<staticText>
				<reportElement x="0" y="0" width="1780" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[No hay objetos a mostrar.]]></text>
			</staticText>
		</band>
	</noData>
</jasperReport>
