29/05/2021 17:23:39  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <b>CLASE:</b> covensol_soa_c_aero <br><b>METODO:</b> ConsultaMovimientosCta <br><b>ERROR-></b><br>Invalid query: ERROR:  missing FROM-clause entry for table "ma"
LINE 25:             AND ma.fectranage>='2021-01-01'  AND ma.fectrana...
                         ^
Whole query: SELECT  m.*,							 
							  tc.*,
							  c.denconcepage, c.codtipconcepage, c.sigconcepage, c.codmon AS codmonconcep, 
      						  c.monconcepage, c.recargacred, c.abonodeuda,
							  e.codemisor, e.denemisor, e.tipemisor, e.localidad, e.ref_kiu, e.rptagt, 
							  e.ref_interfaz, e.codcencostemi, e.id_tipemisor, e.canal_emisor, e.id_periodicidad, e.ageemi, 
							  e.estage, e.codmoncreage, e.limitecredage, e.diascredage, e.id_loc,
							  (CASE WHEN m.tipo_destino='P' THEN m.cod_pro
						  			WHEN m.tipo_destino='B' THEN m.ced_bene
							   ELSE ''
							   END) AS codproben,
						      (CASE WHEN m.tipo_destino='P' THEN nompro
								    WHEN m.tipo_destino='B' THEN nombene
							   ELSE ''
							   END) AS nomproben,
							   e.codemisor||' - '||e.denemisor AS infoemisor
							
		           FROM aero_ctlage_dt_transacciones m 
				    INNER JOIN aero_emisores e ON e.codemisor=m.codemisor
					                  INNER JOIN aero_ctlage_concepto c ON c.codconcepage=m.codconcepage
					                  INNER JOIN aero_ctlage_tipconcepto tc ON tc.codtipconcepage=c.codtipconcepage	
									  LEFT JOIN rpc_proveedor pro ON pro.cod_pro = m.cod_pro AND m.tipo_destino='P'
						   			  LEFT JOIN rpc_beneficiario ben ON ben.ced_bene = m.ced_bene AND m.tipo_destino='B'
					                  WHERE  m.codemp='0001'									   
									   AND ma.fectranage>='2021-01-01'  AND ma.fectranage<='2021-05-29'  AND m.codemisor = '89500375' 
									  ORDER BY m.codmon,m.fectranage,m.codemisor,m.nrotransage

29/05/2021 17:23:43  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <b>CLASE:</b> covensol_soa_c_aero <br><b>METODO:</b> ConsultaMovimientosCta <br><b>ERROR-></b><br>Invalid query: ERROR:  missing FROM-clause entry for table "ma"
LINE 25:             AND ma.fectranage>='2021-01-01'  AND ma.fectrana...
                         ^
Whole query: SELECT  m.*,							 
							  tc.*,
							  c.denconcepage, c.codtipconcepage, c.sigconcepage, c.codmon AS codmonconcep, 
      						  c.monconcepage, c.recargacred, c.abonodeuda,
							  e.codemisor, e.denemisor, e.tipemisor, e.localidad, e.ref_kiu, e.rptagt, 
							  e.ref_interfaz, e.codcencostemi, e.id_tipemisor, e.canal_emisor, e.id_periodicidad, e.ageemi, 
							  e.estage, e.codmoncreage, e.limitecredage, e.diascredage, e.id_loc,
							  (CASE WHEN m.tipo_destino='P' THEN m.cod_pro
						  			WHEN m.tipo_destino='B' THEN m.ced_bene
							   ELSE ''
							   END) AS codproben,
						      (CASE WHEN m.tipo_destino='P' THEN nompro
								    WHEN m.tipo_destino='B' THEN nombene
							   ELSE ''
							   END) AS nomproben,
							   e.codemisor||' - '||e.denemisor AS infoemisor
							
		           FROM aero_ctlage_dt_transacciones m 
				    INNER JOIN aero_emisores e ON e.codemisor=m.codemisor
					                  INNER JOIN aero_ctlage_concepto c ON c.codconcepage=m.codconcepage
					                  INNER JOIN aero_ctlage_tipconcepto tc ON tc.codtipconcepage=c.codtipconcepage	
									  LEFT JOIN rpc_proveedor pro ON pro.cod_pro = m.cod_pro AND m.tipo_destino='P'
						   			  LEFT JOIN rpc_beneficiario ben ON ben.ced_bene = m.ced_bene AND m.tipo_destino='B'
					                  WHERE  m.codemp='0001'									   
									   AND ma.fectranage>='2021-01-01'  AND ma.fectranage<='2021-05-29'  AND m.codemisor = '89500375' 
									  ORDER BY m.codmon,m.fectranage,m.codemisor,m.nrotransage

29/05/2021 17:24:10  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <b>CLASE:</b> covensol_soa_c_aero <br><b>METODO:</b> ConsultaMovimientosCta <br><b>ERROR-></b><br>Invalid query: ERROR:  missing FROM-clause entry for table "ma"
LINE 25:             AND ma.fectranage>='2021-01-01'  AND ma.fectrana...
                         ^
Whole query: SELECT  m.*,							 
							  tc.*,
							  c.denconcepage, c.codtipconcepage, c.sigconcepage, c.codmon AS codmonconcep, 
      						  c.monconcepage, c.recargacred, c.abonodeuda,
							  e.codemisor, e.denemisor, e.tipemisor, e.localidad, e.ref_kiu, e.rptagt, 
							  e.ref_interfaz, e.codcencostemi, e.id_tipemisor, e.canal_emisor, e.id_periodicidad, e.ageemi, 
							  e.estage, e.codmoncreage, e.limitecredage, e.diascredage, e.id_loc,
							  (CASE WHEN m.tipo_destino='P' THEN m.cod_pro
						  			WHEN m.tipo_destino='B' THEN m.ced_bene
							   ELSE ''
							   END) AS codproben,
						      (CASE WHEN m.tipo_destino='P' THEN nompro
								    WHEN m.tipo_destino='B' THEN nombene
							   ELSE ''
							   END) AS nomproben,
							   e.codemisor||' - '||e.denemisor AS infoemisor
							
		           FROM aero_ctlage_dt_transacciones m 
				    INNER JOIN aero_emisores e ON e.codemisor=m.codemisor
					                  INNER JOIN aero_ctlage_concepto c ON c.codconcepage=m.codconcepage
					                  INNER JOIN aero_ctlage_tipconcepto tc ON tc.codtipconcepage=c.codtipconcepage	
									  LEFT JOIN rpc_proveedor pro ON pro.cod_pro = m.cod_pro AND m.tipo_destino='P'
						   			  LEFT JOIN rpc_beneficiario ben ON ben.ced_bene = m.ced_bene AND m.tipo_destino='B'
					                  WHERE  m.codemp='0001'									   
									   AND ma.fectranage>='2021-01-01'  AND ma.fectranage<='2021-05-29'  AND m.codemisor = '89500375' 
									  ORDER BY m.codmon,m.fectranage,m.codemisor,m.nrotransage

29/05/2021 17:26:45  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <b>CLASE:</b> covensol_soa_c_aero <br><b>METODO:</b> ConsultaMovimientosCta <br><b>ERROR-></b><br>Invalid query: ERROR:  missing FROM-clause entry for table "ma"
LINE 25:             AND ma.fectranage>='2021-01-01'  AND ma.fectrana...
                         ^
Whole query: SELECT  m.*,							 
							  tc.*,
							  c.denconcepage, c.codtipconcepage, c.sigconcepage, c.codmon AS codmonconcep, 
      						  c.monconcepage, c.recargacred, c.abonodeuda,
							  e.codemisor, e.denemisor, e.tipemisor, e.localidad, e.ref_kiu, e.rptagt, 
							  e.ref_interfaz, e.codcencostemi, e.id_tipemisor, e.canal_emisor, e.id_periodicidad, e.ageemi, 
							  e.estage, e.codmoncreage, e.limitecredage, e.diascredage, e.id_loc,
							  (CASE WHEN m.tipo_destino='P' THEN m.cod_pro
						  			WHEN m.tipo_destino='B' THEN m.ced_bene
							   ELSE ''
							   END) AS codproben,
						      (CASE WHEN m.tipo_destino='P' THEN nompro
								    WHEN m.tipo_destino='B' THEN nombene
							   ELSE ''
							   END) AS nomproben,
							   e.codemisor||' - '||e.denemisor AS infoemisor
							
		           FROM aero_ctlage_dt_transacciones m 
				    INNER JOIN aero_emisores e ON e.codemisor=m.codemisor
					                  INNER JOIN aero_ctlage_concepto c ON c.codconcepage=m.codconcepage
					                  INNER JOIN aero_ctlage_tipconcepto tc ON tc.codtipconcepage=c.codtipconcepage	
									  LEFT JOIN rpc_proveedor pro ON pro.cod_pro = m.cod_pro AND m.tipo_destino='P'
						   			  LEFT JOIN rpc_beneficiario ben ON ben.ced_bene = m.ced_bene AND m.tipo_destino='B'
					                  WHERE  m.codemp='0001'									   
									   AND ma.fectranage>='2021-01-01'  AND ma.fectranage<='2021-05-29'  AND m.codemisor = '89500375' 
									  ORDER BY m.codmon,m.fectranage,m.codemisor,m.nrotransage

29/05/2021 17:26:51  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <b>CLASE:</b> covensol_soa_c_aero <br><b>METODO:</b> ConsultaMovimientosCta <br><b>ERROR-></b><br>Invalid query: ERROR:  missing FROM-clause entry for table "ma"
LINE 25:             AND ma.fectranage>='2021-01-01'  AND ma.fectrana...
                         ^
Whole query: SELECT  m.*,							 
							  tc.*,
							  c.denconcepage, c.codtipconcepage, c.sigconcepage, c.codmon AS codmonconcep, 
      						  c.monconcepage, c.recargacred, c.abonodeuda,
							  e.codemisor, e.denemisor, e.tipemisor, e.localidad, e.ref_kiu, e.rptagt, 
							  e.ref_interfaz, e.codcencostemi, e.id_tipemisor, e.canal_emisor, e.id_periodicidad, e.ageemi, 
							  e.estage, e.codmoncreage, e.limitecredage, e.diascredage, e.id_loc,
							  (CASE WHEN m.tipo_destino='P' THEN m.cod_pro
						  			WHEN m.tipo_destino='B' THEN m.ced_bene
							   ELSE ''
							   END) AS codproben,
						      (CASE WHEN m.tipo_destino='P' THEN nompro
								    WHEN m.tipo_destino='B' THEN nombene
							   ELSE ''
							   END) AS nomproben,
							   e.codemisor||' - '||e.denemisor AS infoemisor
							
		           FROM aero_ctlage_dt_transacciones m 
				    INNER JOIN aero_emisores e ON e.codemisor=m.codemisor
					                  INNER JOIN aero_ctlage_concepto c ON c.codconcepage=m.codconcepage
					                  INNER JOIN aero_ctlage_tipconcepto tc ON tc.codtipconcepage=c.codtipconcepage	
									  LEFT JOIN rpc_proveedor pro ON pro.cod_pro = m.cod_pro AND m.tipo_destino='P'
						   			  LEFT JOIN rpc_beneficiario ben ON ben.ced_bene = m.ced_bene AND m.tipo_destino='B'
					                  WHERE  m.codemp='0001'									   
									   AND ma.fectranage>='2021-01-01'  AND ma.fectranage<='2021-05-29'  AND m.codemisor = '89500375' 
									  ORDER BY m.codmon,m.fectranage,m.codemisor,m.nrotransage