<?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="gen_cer_obj_igu_list" language="groovy" pageWidth="2150" pageHeight="612" orientation="Landscape" whenNoDataType="NoDataSection" columnWidth="2110" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
	<property name="ireport.zoom" value="1.2100000000000035"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<property name="ireport.jasperserver.reportUnit" value="/reports/contratacion/gen_cer_obj_igu_list"/>
	<property name="ireport.jasperserver.url" value="http://release.sofhouse.net:8080/jasperserver/services/repository"/>
	<parameter name="whereAnhos" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="id_username" class="java.lang.String">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="whereEstadoObjetoIguales" class="java.lang.String">
		<defaultValueExpression><![CDATA[' ']]></defaultValueExpression>
	</parameter>
	<parameter name="whereSupervisor" class="java.lang.String">
		<defaultValueExpression><![CDATA[' ']]></defaultValueExpression>
	</parameter>
	<parameter name="whereResponsable" class="java.lang.String">
		<defaultValueExpression><![CDATA[' ']]></defaultValueExpression>
	</parameter>
	<parameter name="id_anhos" class="java.lang.String">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[SELECT tab0.* from (
SELECT
tab0.id_estudios_previos as id_estudios_previos,
tab0.no_estudios_previos as no_estudios_previos,
tab0.id_anhos as id_anhos,
to_char(tab0.no_proceso) as no_proceso,
tab0.responsable as responsable,
tab0.id_abogado as id_abogado,
to_char(tab0.fecha_creacion, 'YYYY-MM-DD') as fecha_creacion,
tab0.id_modalidad_sel as id_modalidad_sel,
tab0.estado as estado,
tab0.activo as activo,
to_char(tab0.fecha_anu, 'YYYY-MM-DD') as fecha_anu,
tab0.motivo_anu as motivo_anu,
tab0.id_cen_op as id_cen_op,
to_char(tab21.vigencia) as id_anhos_s,
tab0.version as version,
tab0.id_area as id_area,
tab0.valor as valor,
tab0.id_supervisor as id_supervisor,
to_char(tab0.fecha_cierre, 'YYYY-MM-DD') as fecha_cierre,
tab0.descripcion as descripcion,
tab0.id_legaliza as id_legaliza,
tab0.id_mesa_ayuda as id_mesa_ayuda,
tab0.id_soporte as id_soporte,
tab0.estado_general as estado_general,
tab0.estado_general_desc as estado_general_desc,
tab0.estado_objeto_iguales as estado_objeto_iguales,
CASE WHEN tab0.estado_objeto_iguales = 1 THEN 'VoBo'
	WHEN tab0.estado_objeto_iguales = 2 THEN 'Aprobado'
		WHEN tab0.estado_objeto_iguales = 3 THEN 'Rechazado'
			WHEN tab0.estado_objeto_iguales = 0 THEN 'Pendiente'
END AS estado_objeto_igualess,
tab0.fec_est_obj_igu_pen as fec_est_obj_igu_pen,
tab0.fec_est_obj_igu_vob as fec_est_obj_igu_vob,
to_char(tab0.fec_est_obj_igu_apr) as fec_est_obj_igu_apr,
tab0.fec_est_obj_igu_rec as fec_est_obj_igu_rec,
tab0.estado_ep_general as estado_ep_general,
tab0.fec_est_ep_gen_pen as fec_est_ep_gen_pen,
tab0.fec_est_ep_gen_vob as fec_est_ep_gen_vob,
tab0.fec_est_ep_gen_aut as fec_est_ep_gen_aut,
tab0.fec_est_ep_gen_rec as fec_est_ep_gen_rec,
tab0.codigopaa as codigopaa,
tab0.autorizado_extra as autorizado_extra,
tab0.fec_est_ep_gen_autextra as fec_est_ep_gen_autextra,
tab0.tipobolsa as tipobolsa,
tab0.usuario_est_obj_igu_pen as usuario_est_obj_igu_pen,
tab0.usuario_est_obj_igu_vob as usuario_est_obj_igu_vob,
tab0.usuario_est_obj_igu_apr as usuario_est_obj_igu_apr,
tab0.usuario_est_obj_igu_rec as usuario_est_obj_igu_rec,
tab3.num_doc as num_doc_resp,
tab3.razon_soc as razon_soc_resp,
tab2.num_doc as num_doc_abogado,
tab2.razon_soc as razon_soc_abogado,
tab4.descripcion as descripcion_modal,
tab4.prefijo as prefijo_modal,
to_char(tab5.fecha_creacion, 'YYYY-MM-DD') as fecha_version,
tab5.razon_soc as usuario_version,
tab6.descripcion as descripcion_area,
tab7.num_doc as num_doc_sup,
tab7.pnombre||' '||tab7.snombre||' '||tab7.papellido||' '||tab7.sapellido as razon_soc_sup,
tab8.id_tipo_proceso as id_tipo_proceso,
tab8.descripcion as modalidad,
tab10.id as id_a,
tab10.est as est_a,
tab10.id_estudios_previos as id_estudios_previos_a,
to_char(tab10.fecha, 'YYYY-MM-DD') as fecha_a,
tab10.observaciones as observaciones_a,
tab10.no_comite as no_comite_a,
tab11.id as id_na,
tab11.est as est_na,
tab11.id_estudios_previos as id_estudios_previos_na,
to_char(tab11.fecha, 'YYYY-MM-DD') as fecha_na,
tab11.observaciones as observaciones_na,
tab11.no_comite as no_comite_na,
to_char(tab28.no_contrato) as no_contrato,
to_char(tab25.rp) as rps,
to_char(tab26.cdp) as cdp_sgr,
to_char(tab27.cdp) as cdp_pgn,
CASE WHEN tab21.id_co_ep > 0 THEN 'Si'
ELSE 'No'
END AS objeto_igu

FROM CO_ESTUDIOS_PREVIOS_V tab0
JOIN INTERCEROS_V tab3 ON tab0.responsable = tab3.id_mae_ter
JOIN CO_MODALIDAD_SEL tab4 ON tab0.id_modalidad_sel = tab4.id_modalidad_sel
JOIN CO_TIPO_PROCESO tab8 ON tab4.id_tipo_proceso = tab8.id_tipo_proceso
LEFT JOIN CO_ABOGADO_V tab2 ON tab0.id_abogado = tab2.id_abogado
LEFT JOIN CO_VERSIONES_EP_V tab5 ON tab0.id_estudios_previos = tab5.id_version_hijo
JOIN AREA tab6 ON tab0.id_area = tab6.id_area
JOIN INTERCEROS tab7 ON tab0.id_supervisor = tab7.id_mae_ter
LEFT JOIN CO_PARAM_GEN tab9 ON tab9.id_param_gen = tab9.id_param_gen
LEFT JOIN ESTADO_APROB_COMITE_V tab10 ON tab0.id_estudios_previos = tab10.id_estudios_previos
LEFT JOIN ESTADO_NO_APROB_COMITE_V tab11 ON tab0.id_estudios_previos = tab11.id_estudios_previos
LEFT JOIN (SELECT id_estudios_previos,max(id_co_ep) as id_co_ep, max(vigencia) as vigencia FROM CO_EP_OBJETOS_IGUALES group by id_estudios_previos ) tab21 ON tab21.id_estudios_previos = tab0.id_estudios_previos

LEFT JOIN (SELECT
tab9.id_estudios_previos,
LISTAGG(tab24.rp, ', ') WITHIN GROUP (ORDER BY tab24.id) as rp
 FROM CO_LEGALIZA_CONTRATO tab23
JOIN CO_CONTRATO_V tab9 ON tab9.id_contrato= tab23.id_contrato
LEFT JOIN RPS_CONTRATO_V tab24 ON tab23.id_rp=tab24.id and tab23.vigencia_rp = tab24.vigencia and tab23.rp_sgr=tab24.sgr
group by tab9.id_estudios_previos) tab25 ON tab25.id_estudios_previos = tab0.id_estudios_previos

left join(SELECT
     max(aut.id_estudios_previos) as id_estudios_previos,
     LISTAGG(aut.id_cdp, ', ') WITHIN GROUP (ORDER BY id_cdp) as cdp,
     LISTAGG(aut.fecha_cdp, ', ') WITHIN GROUP (ORDER BY id_cdp) as fecha_cdp_anm,
     LISTAGG(aut.valor, ', ') WITHIN GROUP (ORDER BY id_cdp) as valor_cdp_anm
     from co_cdps_ep aut
     where 1=1
	and aut.sgr=1
     group by
     aut.id_estudios_previos,aut.id_cdp
)tab26 on tab26.id_estudios_previos = tab0.id_estudios_previos

left join(SELECT
     max(aut.id_estudios_previos) as id_estudios_previos,
     LISTAGG(aut.id_cdp, ', ') WITHIN GROUP (ORDER BY id_cdp) as cdp,
     LISTAGG(aut.fecha_cdp, ', ') WITHIN GROUP (ORDER BY id_cdp) as fecha_cdp_anm,
     LISTAGG(aut.valor, ', ') WITHIN GROUP (ORDER BY id_cdp) as valor_cdp_anm
     from co_cdps_ep aut
     where 1=1
	and aut.sgr=0
     group by
     aut.id_estudios_previos,aut.id_cdp
)tab27 on tab27.id_estudios_previos = tab0.id_estudios_previos

left join (
	SELECT
		CASE WHEN tab.fuente_financiamiento = 'NACION' THEN 'ANM'|| '-' ||LPAD(tab.no_contrato, 3, '0')|| '-' || tab.id_anhos
			ELSE 'SGR' || '-' ||LPAD(tab.no_contrato, 3, '0')|| '-' || tab.id_anhos
				END AS no_contrato,
		tab.id_estudios_previos,
		tab.id_anhos
	from co_contrato_v tab
	where 1=1
)tab28 on tab28.id_estudios_previos = tab0.id_estudios_previos and tab28.id_anhos = tab0.id_anhos


)tab0
WHERE 1=1
AND tab0.id_anhos = $P{id_anhos}
$P!{whereSupervisor}
$P!{whereResponsable}
$P!{whereEstadoObjetoIguales}
AND  tab0.id_estudios_previos != '-1' and tab0.estado = '1'

 ORDER BY tab0.no_proceso , tab0.version , tab0.id_modalidad_sel , tab0.id_estudios_previos]]>
	</queryString>
	<field name="ID_ESTUDIOS_PREVIOS" class="java.math.BigDecimal"/>
	<field name="NO_ESTUDIOS_PREVIOS" class="java.lang.String"/>
	<field name="ID_ANHOS" class="java.math.BigDecimal"/>
	<field name="NO_PROCESO" class="java.lang.String"/>
	<field name="RESPONSABLE" class="java.math.BigDecimal"/>
	<field name="ID_ABOGADO" class="java.math.BigDecimal"/>
	<field name="FECHA_CREACION" class="java.lang.String"/>
	<field name="ID_MODALIDAD_SEL" class="java.math.BigDecimal"/>
	<field name="ESTADO" class="java.math.BigDecimal"/>
	<field name="ACTIVO" class="java.math.BigDecimal"/>
	<field name="FECHA_ANU" class="java.lang.String"/>
	<field name="MOTIVO_ANU" class="java.lang.String"/>
	<field name="ID_CEN_OP" class="java.math.BigDecimal"/>
	<field name="ID_ANHOS_S" class="java.lang.String"/>
	<field name="VERSION" class="java.math.BigDecimal"/>
	<field name="ID_AREA" class="java.math.BigDecimal"/>
	<field name="VALOR" class="java.math.BigDecimal"/>
	<field name="ID_SUPERVISOR" class="java.math.BigDecimal"/>
	<field name="FECHA_CIERRE" class="java.lang.String"/>
	<field name="DESCRIPCION" class="java.lang.String"/>
	<field name="ID_LEGALIZA" class="java.math.BigDecimal"/>
	<field name="ID_MESA_AYUDA" class="java.math.BigDecimal"/>
	<field name="ID_SOPORTE" class="java.math.BigDecimal"/>
	<field name="ESTADO_GENERAL" class="java.math.BigDecimal"/>
	<field name="ESTADO_GENERAL_DESC" class="java.lang.String"/>
	<field name="ESTADO_OBJETO_IGUALES" class="java.math.BigDecimal"/>
	<field name="ESTADO_OBJETO_IGUALESS" class="java.lang.String"/>
	<field name="FEC_EST_OBJ_IGU_PEN" class="java.lang.String"/>
	<field name="FEC_EST_OBJ_IGU_VOB" class="java.lang.String"/>
	<field name="FEC_EST_OBJ_IGU_APR" class="java.lang.String"/>
	<field name="FEC_EST_OBJ_IGU_REC" class="java.lang.String"/>
	<field name="ESTADO_EP_GENERAL" class="java.math.BigDecimal"/>
	<field name="FEC_EST_EP_GEN_PEN" class="java.lang.String"/>
	<field name="FEC_EST_EP_GEN_VOB" class="java.lang.String"/>
	<field name="FEC_EST_EP_GEN_AUT" class="java.lang.String"/>
	<field name="FEC_EST_EP_GEN_REC" class="java.lang.String"/>
	<field name="CODIGOPAA" class="java.lang.String"/>
	<field name="AUTORIZADO_EXTRA" class="java.math.BigDecimal"/>
	<field name="FEC_EST_EP_GEN_AUTEXTRA" class="java.sql.Timestamp"/>
	<field name="TIPOBOLSA" class="java.lang.String"/>
	<field name="USUARIO_EST_OBJ_IGU_PEN" class="java.math.BigDecimal"/>
	<field name="USUARIO_EST_OBJ_IGU_VOB" class="java.math.BigDecimal"/>
	<field name="USUARIO_EST_OBJ_IGU_APR" class="java.math.BigDecimal"/>
	<field name="USUARIO_EST_OBJ_IGU_REC" class="java.math.BigDecimal"/>
	<field name="NUM_DOC_RESP" class="java.lang.String"/>
	<field name="RAZON_SOC_RESP" class="java.lang.String"/>
	<field name="NUM_DOC_ABOGADO" class="java.lang.String"/>
	<field name="RAZON_SOC_ABOGADO" class="java.lang.String"/>
	<field name="DESCRIPCION_MODAL" class="java.lang.String"/>
	<field name="PREFIJO_MODAL" class="java.lang.String"/>
	<field name="FECHA_VERSION" class="java.lang.String"/>
	<field name="USUARIO_VERSION" class="java.lang.String"/>
	<field name="DESCRIPCION_AREA" class="java.lang.String"/>
	<field name="NUM_DOC_SUP" class="java.lang.String"/>
	<field name="RAZON_SOC_SUP" class="java.lang.String"/>
	<field name="ID_TIPO_PROCESO" class="java.math.BigDecimal"/>
	<field name="MODALIDAD" class="java.lang.String"/>
	<field name="ID_A" class="java.math.BigDecimal"/>
	<field name="EST_A" class="java.math.BigDecimal"/>
	<field name="ID_ESTUDIOS_PREVIOS_A" class="java.math.BigDecimal"/>
	<field name="FECHA_A" class="java.lang.String"/>
	<field name="OBSERVACIONES_A" class="java.lang.String"/>
	<field name="NO_COMITE_A" class="java.math.BigDecimal"/>
	<field name="ID_NA" class="java.math.BigDecimal"/>
	<field name="EST_NA" class="java.math.BigDecimal"/>
	<field name="ID_ESTUDIOS_PREVIOS_NA" class="java.math.BigDecimal"/>
	<field name="FECHA_NA" class="java.lang.String"/>
	<field name="OBSERVACIONES_NA" class="java.lang.String"/>
	<field name="NO_COMITE_NA" class="java.math.BigDecimal"/>
	<field name="NO_CONTRATO" class="java.lang.String"/>
	<field name="RPS" class="java.lang.String"/>
	<field name="CDP_SGR" class="java.lang.String"/>
	<field name="CDP_PGN" class="java.lang.String"/>
	<field name="OBJETO_IGU" class="java.lang.String"/>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="60" splitType="Stretch">
			<textField pattern="dd-MMM-yyyy   hh:mm aaa">
				<reportElement mode="Opaque" x="1762" y="33" width="348" height="12" forecolor="#000000" backcolor="#FFFFFF"/>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[new java.util.Date()]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="140" y="0" width="1622" height="50"/>
				<textElement textAlignment="Center" verticalAlignment="Bottom" markup="none">
					<font fontName="SansSerif" size="12" isBold="true"/>
				</textElement>
				<text><![CDATA[Sistema de Contratación
Informe Certificado Objetos Iguales]]></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="1762" y="21" width="348" 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>
		</band>
	</title>
	<pageHeader>
		<band height="20" splitType="Stretch"/>
	</pageHeader>
	<columnHeader>
		<band height="10" splitType="Stretch">
			<staticText>
				<reportElement mode="Opaque" x="402" y="0" width="180" height="10" forecolor="#000000" backcolor="#88C2F9"/>
				<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" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Identificación del Objeto o Contratista]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="280" y="0" width="122" height="10" forecolor="#000000" backcolor="#88C2F9"/>
				<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" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Número de Contrato]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="582" y="0" width="140" height="10" forecolor="#000000" backcolor="#88C2F9"/>
				<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" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Area Solicitante]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="822" y="0" width="120" height="10" forecolor="#000000" backcolor="#88C2F9"/>
				<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" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Causal de Modalidad]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="722" y="0" width="100" height="10" forecolor="#000000" backcolor="#88C2F9"/>
				<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" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Modalidad]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="140" y="0" width="140" height="10" forecolor="#000000" backcolor="#88C2F9"/>
				<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" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Número de proceso]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="0" y="0" width="140" height="10" forecolor="#000000" backcolor="#88C2F9"/>
				<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" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Número de Estudio Previo]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="942" y="0" width="120" height="10" forecolor="#000000" backcolor="#88C2F9"/>
				<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" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Abogado del proceso]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1062" y="0" width="120" height="10" forecolor="#000000" backcolor="#88C2F9"/>
				<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" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Responsable del proceso]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1182" y="0" width="100" height="10" forecolor="#000000" backcolor="#88C2F9"/>
				<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" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[CDP SGR]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1382" y="0" width="140" height="10" forecolor="#000000" backcolor="#88C2F9"/>
				<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" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[RPS]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1522" y="0" width="120" height="10" forecolor="#000000" backcolor="#88C2F9"/>
				<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" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Objeto Igual]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1642" y="0" width="120" height="10" forecolor="#000000" backcolor="#88C2F9"/>
				<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" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Año]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1762" y="0" width="222" height="10" forecolor="#000000" backcolor="#88C2F9"/>
				<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" 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 Aprobación del documento objeto igual]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1984" y="0" width="126" height="10" forecolor="#000000" backcolor="#88C2F9"/>
				<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" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Estado Certificado Objeto Igual]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1282" y="0" width="100" height="10" forecolor="#000000" backcolor="#88C2F9"/>
				<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" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[CDP PGN]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="10" splitType="Stretch">
			<textField pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="280" y="0" width="122" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<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" 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[( $F{NO_CONTRATO}.equals("null")
    ? ""
    : $F{NO_CONTRATO}
)]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="402" y="0" width="180" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<box leftPadding="2" rightPadding="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" 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[$F{DESCRIPCION}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="582" y="0" width="140" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<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" 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[$F{DESCRIPCION_AREA}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="822" y="0" width="120" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<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" 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[$F{DESCRIPCION_MODAL}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="722" y="0" width="100" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<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" 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[$F{MODALIDAD}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="140" y="0" width="140" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<box leftPadding="2" 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" 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[$F{NO_PROCESO}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="0" y="0" width="140" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<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" 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[$F{NO_ESTUDIOS_PREVIOS}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="942" y="0" width="120" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<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" 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[$F{RAZON_SOC_ABOGADO}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="1062" y="0" width="120" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<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" 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[$F{RAZON_SOC_RESP}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="1182" y="0" width="100" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<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" 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[$F{CDP_SGR}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="1382" y="0" width="140" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<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" 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[$F{RPS}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="1522" y="0" width="120" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<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" 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[$F{OBJETO_IGU}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="1642" y="0" width="120" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<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" 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[$F{ID_ANHOS}.toString()]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="1762" y="0" width="222" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<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" 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[$F{FEC_EST_OBJ_IGU_APR}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="1984" y="0" width="126" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<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" 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[$F{ESTADO_OBJETO_IGUALESS}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="1282" y="0" width="100" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<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" 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[$F{CDP_PGN}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band height="11" splitType="Stretch"/>
	</columnFooter>
	<pageFooter>
		<band height="24" splitType="Stretch">
			<textField>
				<reportElement mode="Opaque" x="942" y="12" width="120" 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="1062" y="12" width="120" height="12" forecolor="#575757" backcolor="#FFFFFF"/>
				<box leftPadding="2"/>
				<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="942" y="0" width="240" height="12" forecolor="#575757"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<text><![CDATA[Websafi - Contratación]]></text>
			</staticText>
		</band>
	</pageFooter>
	<summary>
		<band height="12" splitType="Stretch"/>
	</summary>
	<noData>
		<band height="20">
			<staticText>
				<reportElement x="0" y="0" width="2110" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[No hay objetos a mostrar.]]></text>
			</staticText>
		</band>
	</noData>
</jasperReport>
