01/03/2021 01:24:50  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <b>CLASE:</b> covensol_soa_c_aero <br><b>METODO:</b> ConsultaSaldosMonedaEmisores <br><b>ERROR-></b><br>Invalid query: ERROR:  subquery uses ungrouped column "m.fectranage" from outer query
LINE 14:                AND m.fectranage>='2020-03-25'  AND m.fectran...
                            ^
Whole query:  
						    SELECT m.codmon,
								   m.codemisor,
								   (CASE WHEN MAX(e.ref_kiu)!='' THEN m.codemisor||' - '||MAX(e.ref_kiu)||' - '||MAX(e.denemisor)
										  ELSE m.codemisor||' - '||MAX(e.denemisor)
									END) AS infoemisor,
								    
						        COALESCE((		
											SELECT sum(ma.montransage)
											  FROM aero_ctlage_dt_transacciones ma							
											 WHERE ma.codemisor=m.codemisor	
											   AND ma.codmon=m.codmon	
											   AND ma.codtipdocage IN ('DEB','REVCRE','REVAND')											  	
											    AND m.fectranage>='2020-03-25'  AND m.fectranage<='2021-02-28' 
											GROUP BY ma.codmon,ma.codemisor
											ORDER BY ma.codmon,ma.codemisor
								),0) AS debitos,
								COALESCE((		
											SELECT sum(ma.montransage)
											  FROM aero_ctlage_dt_transacciones ma							
											 WHERE ma.codemisor=m.codemisor	
											   AND ma.codmon=m.codmon	
											   AND ma.codtipdocage IN ('CRE','REVDEB','REVANC')											  	
											    AND m.fectranage>='2020-03-25'  AND m.fectranage<='2021-02-28' 
											GROUP BY ma.codmon,ma.codemisor
											ORDER BY ma.codmon,ma.codemisor
								),0) AS creditos,
											 
					  
								   
											COALESCE((		
												SELECT sum(ma.montransage)
												  FROM aero_ctlage_dt_transacciones ma							
												 WHERE ma.codemisor=m.codemisor	
												   AND ma.codmon=m.codmon	
												   AND ma.fectranage<'2020-03-25'					  
												GROUP BY ma.codmon,ma.codemisor
												ORDER BY ma.codmon,ma.codemisor
											 ),0) AS saldo_anterior,
									  
									     
								   COALESCE((
										SELECT sum(ma.montransage)
										  FROM aero_ctlage_dt_transacciones ma							
										 WHERE ma.codemisor=m.codemisor	
										   AND ma.codmon=m.codmon	
										 AND ma.fectranage<='2021-02-28' 
										GROUP BY ma.codmon,ma.codemisor
										ORDER BY ma.codmon,ma.codemisor
									),0) AS saldo
							FROM aero_ctlage_dt_transacciones m
							INNER JOIN aero_emisores e ON e.codemisor=m.codemisor
							WHERE m.codemp='0001'
							
							GROUP BY 1,2		
							
					  

01/03/2021 03:33:01  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <b>CLASE:</b> covensol_soa_c_aero <br><b>METODO:</b> ConsultaSaldosMonedaAbonos <br><b>ERROR-></b><br>Invalid query: ERROR:  column "ma.cod_pro" must appear in the GROUP BY clause or be used in an aggregate function
LINE 51:             ORDER BY ma.codmon,ma.tipo_destino,ma.cod_pro,ma...
                                                        ^
Whole query:  
						    SELECT m.codmon,
								   m.tipo_destino AS tipo_destino,
								   m.cod_pro AS cod_pro,
								   m.ced_bene AS ced_bene,
								   MAX(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 MAX(nompro)
										 WHEN m.tipo_destino='B' THEN MAX(nombene)
									ELSE ''
									END) AS nomproben,
								    
						        COALESCE((		
											SELECT sum(ma.montransage)
											  FROM aero_ctlage_dt_transacciones ma							
											 WHERE ma.tipo_destino=m.tipo_destino	
											   AND ma.cod_pro=m.cod_pro
											   AND ma.ced_bene=m.ced_bene
											   AND ma.codmon=m.codmon	
											   AND ma.codtipdocage IN ('DEB','REVCRE','REVAND')											  	
											    AND ma.fectranage>='2019-12-01'  AND ma.fectranage<='2020-07-28' 
											GROUP BY ma.codmon,ma.tipo_destino,ma.cod_pro,ma.ced_bene
											ORDER BY ma.codmon,ma.tipo_destino,ma.cod_pro,ma.ced_bene
								),0) AS debitos,
								COALESCE((		
											SELECT sum(ma.montransage)
											  FROM aero_ctlage_dt_transacciones ma							
											 WHERE ma.tipo_destino=m.tipo_destino	
											   AND ma.cod_pro=m.cod_pro
											   AND ma.ced_bene=m.ced_bene
											   AND ma.codmon=m.codmon	
											   AND ma.codtipdocage IN ('CRE','REVDEB','REVANC')											  	
											    AND ma.fectranage>='2019-12-01'  AND ma.fectranage<='2020-07-28' 
											GROUP BY ma.codmon,ma.tipo_destino,ma.cod_pro,ma.ced_bene
											ORDER BY ma.codmon,ma.tipo_destino,ma.cod_pro,ma.ced_bene
								),0) AS creditos,
											 
					  
								   
											COALESCE((		
												SELECT sum(ma.montransage)
												  FROM aero_ctlage_dt_transacciones ma							
												 WHERE ma.tipo_destino=m.tipo_destino	
											       AND ma.cod_pro=m.cod_pro
											       AND ma.ced_bene=m.ced_bene
												   AND ma.codmon=m.codmon	
												   AND ma.fectranage<'2019-12-01'					  
												GROUP BY ma.codmon,ma.tipo_destino
												ORDER BY ma.codmon,ma.tipo_destino,ma.cod_pro,ma.ced_bene
											 ),0) AS saldo_anterior,
									  
									     
								   COALESCE((
										SELECT sum(ma.montransage)
										  FROM aero_ctlage_dt_transacciones ma							
										 WHERE ma.tipo_destino=m.tipo_destino	
										   AND ma.cod_pro=m.cod_pro
										   AND ma.ced_bene=m.ced_bene
										   AND ma.codmon=m.codmon	
										 AND ma.fectranage<='2020-07-28' 
										GROUP BY ma.codmon,ma.tipo_destino,ma.cod_pro,ma.ced_bene
										ORDER BY ma.codmon,ma.tipo_destino,ma.cod_pro,ma.ced_bene
									),0) AS saldo
							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 m.abonodeuda=1
							
							GROUP BY 1,2,3,4		
							
					  

01/03/2021 03:33:05  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <b>CLASE:</b> covensol_soa_c_aero <br><b>METODO:</b> ConsultaSaldosMonedaAbonos <br><b>ERROR-></b><br>Invalid query: ERROR:  column "ma.cod_pro" must appear in the GROUP BY clause or be used in an aggregate function
LINE 51:             ORDER BY ma.codmon,ma.tipo_destino,ma.cod_pro,ma...
                                                        ^
Whole query:  
						    SELECT m.codmon,
								   m.tipo_destino AS tipo_destino,
								   m.cod_pro AS cod_pro,
								   m.ced_bene AS ced_bene,
								   MAX(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 MAX(nompro)
										 WHEN m.tipo_destino='B' THEN MAX(nombene)
									ELSE ''
									END) AS nomproben,
								    
						        COALESCE((		
											SELECT sum(ma.montransage)
											  FROM aero_ctlage_dt_transacciones ma							
											 WHERE ma.tipo_destino=m.tipo_destino	
											   AND ma.cod_pro=m.cod_pro
											   AND ma.ced_bene=m.ced_bene
											   AND ma.codmon=m.codmon	
											   AND ma.codtipdocage IN ('DEB','REVCRE','REVAND')											  	
											    AND ma.fectranage>='2019-12-01'  AND ma.fectranage<='2021-02-28' 
											GROUP BY ma.codmon,ma.tipo_destino,ma.cod_pro,ma.ced_bene
											ORDER BY ma.codmon,ma.tipo_destino,ma.cod_pro,ma.ced_bene
								),0) AS debitos,
								COALESCE((		
											SELECT sum(ma.montransage)
											  FROM aero_ctlage_dt_transacciones ma							
											 WHERE ma.tipo_destino=m.tipo_destino	
											   AND ma.cod_pro=m.cod_pro
											   AND ma.ced_bene=m.ced_bene
											   AND ma.codmon=m.codmon	
											   AND ma.codtipdocage IN ('CRE','REVDEB','REVANC')											  	
											    AND ma.fectranage>='2019-12-01'  AND ma.fectranage<='2021-02-28' 
											GROUP BY ma.codmon,ma.tipo_destino,ma.cod_pro,ma.ced_bene
											ORDER BY ma.codmon,ma.tipo_destino,ma.cod_pro,ma.ced_bene
								),0) AS creditos,
											 
					  
								   
											COALESCE((		
												SELECT sum(ma.montransage)
												  FROM aero_ctlage_dt_transacciones ma							
												 WHERE ma.tipo_destino=m.tipo_destino	
											       AND ma.cod_pro=m.cod_pro
											       AND ma.ced_bene=m.ced_bene
												   AND ma.codmon=m.codmon	
												   AND ma.fectranage<'2019-12-01'					  
												GROUP BY ma.codmon,ma.tipo_destino
												ORDER BY ma.codmon,ma.tipo_destino,ma.cod_pro,ma.ced_bene
											 ),0) AS saldo_anterior,
									  
									     
								   COALESCE((
										SELECT sum(ma.montransage)
										  FROM aero_ctlage_dt_transacciones ma							
										 WHERE ma.tipo_destino=m.tipo_destino	
										   AND ma.cod_pro=m.cod_pro
										   AND ma.ced_bene=m.ced_bene
										   AND ma.codmon=m.codmon	
										 AND ma.fectranage<='2021-02-28' 
										GROUP BY ma.codmon,ma.tipo_destino,ma.cod_pro,ma.ced_bene
										ORDER BY ma.codmon,ma.tipo_destino,ma.cod_pro,ma.ced_bene
									),0) AS saldo
							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 m.abonodeuda=1
							
							GROUP BY 1,2,3,4		
							
					  

01/03/2021 03:33:07  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <b>CLASE:</b> covensol_soa_c_aero <br><b>METODO:</b> ConsultaSaldosMonedaAbonos <br><b>ERROR-></b><br>Invalid query: ERROR:  column "ma.cod_pro" must appear in the GROUP BY clause or be used in an aggregate function
LINE 51:             ORDER BY ma.codmon,ma.tipo_destino,ma.cod_pro,ma...
                                                        ^
Whole query:  
						    SELECT m.codmon,
								   m.tipo_destino AS tipo_destino,
								   m.cod_pro AS cod_pro,
								   m.ced_bene AS ced_bene,
								   MAX(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 MAX(nompro)
										 WHEN m.tipo_destino='B' THEN MAX(nombene)
									ELSE ''
									END) AS nomproben,
								    
						        COALESCE((		
											SELECT sum(ma.montransage)
											  FROM aero_ctlage_dt_transacciones ma							
											 WHERE ma.tipo_destino=m.tipo_destino	
											   AND ma.cod_pro=m.cod_pro
											   AND ma.ced_bene=m.ced_bene
											   AND ma.codmon=m.codmon	
											   AND ma.codtipdocage IN ('DEB','REVCRE','REVAND')											  	
											    AND ma.fectranage>='2019-12-01'  AND ma.fectranage<='2021-02-28' 
											GROUP BY ma.codmon,ma.tipo_destino,ma.cod_pro,ma.ced_bene
											ORDER BY ma.codmon,ma.tipo_destino,ma.cod_pro,ma.ced_bene
								),0) AS debitos,
								COALESCE((		
											SELECT sum(ma.montransage)
											  FROM aero_ctlage_dt_transacciones ma							
											 WHERE ma.tipo_destino=m.tipo_destino	
											   AND ma.cod_pro=m.cod_pro
											   AND ma.ced_bene=m.ced_bene
											   AND ma.codmon=m.codmon	
											   AND ma.codtipdocage IN ('CRE','REVDEB','REVANC')											  	
											    AND ma.fectranage>='2019-12-01'  AND ma.fectranage<='2021-02-28' 
											GROUP BY ma.codmon,ma.tipo_destino,ma.cod_pro,ma.ced_bene
											ORDER BY ma.codmon,ma.tipo_destino,ma.cod_pro,ma.ced_bene
								),0) AS creditos,
											 
					  
								   
											COALESCE((		
												SELECT sum(ma.montransage)
												  FROM aero_ctlage_dt_transacciones ma							
												 WHERE ma.tipo_destino=m.tipo_destino	
											       AND ma.cod_pro=m.cod_pro
											       AND ma.ced_bene=m.ced_bene
												   AND ma.codmon=m.codmon	
												   AND ma.fectranage<'2019-12-01'					  
												GROUP BY ma.codmon,ma.tipo_destino
												ORDER BY ma.codmon,ma.tipo_destino,ma.cod_pro,ma.ced_bene
											 ),0) AS saldo_anterior,
									  
									     
								   COALESCE((
										SELECT sum(ma.montransage)
										  FROM aero_ctlage_dt_transacciones ma							
										 WHERE ma.tipo_destino=m.tipo_destino	
										   AND ma.cod_pro=m.cod_pro
										   AND ma.ced_bene=m.ced_bene
										   AND ma.codmon=m.codmon	
										 AND ma.fectranage<='2021-02-28' 
										GROUP BY ma.codmon,ma.tipo_destino,ma.cod_pro,ma.ced_bene
										ORDER BY ma.codmon,ma.tipo_destino,ma.cod_pro,ma.ced_bene
									),0) AS saldo
							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 m.abonodeuda=1
							
							GROUP BY 1,2,3,4