13/07/2020 04:50:51  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <b>CLASE:</b> covensol_sco_c_contratosobras <br><b>METODO:</b> BuscarSpgDocumento <br><b>ERROR->:</b><br>Invalid query: ERROR:  error de sintaxis en o cerca de «AS»
LINE 6:             ELSE dp.subtotpar END AS subtotpar
                                          ^
Whole query:          SELECT dp.spg_cuenta,
								   dp.estcla, dp.codestpro1, dp.codestpro2, dp.codestpro3, dp.codestpro4, dp.codestpro5,
								   sum(
									   CASE WHEN sigafecpar='AU' THEN dp.subtotpar 
											 WHEN sigafecpar='DI' THEN -dp.subtotpar
											 ELSE dp.subtotpar END AS subtotpar
								   ) AS monto
							FROM sco_dt_partidas_contrato dp
							INNER JOIN sco_partidas p ON p.codpartida = dp.codpartida
							INNER JOIN sco_tipo_partida tp ON tp.codtippartida = p.codtippartida
							INNER JOIN sco_unidad_tecnica_medida u ON u.codunitecmed = dp.codunipar
							WHERE dp.codcont='5'
							  AND dp.nrodoccont='4'
							GROUP BY dp.spg_cuenta,
								 dp.estcla, dp.codestpro1, dp.codestpro2, dp.codestpro3, dp.codestpro4, dp.codestpro5
							UNION
							SELECT ac.spg_cuenta,
								   dp.estcla, dp.codestpro1, dp.codestpro2, dp.codestpro3, dp.codestpro4, dp.codestpro5,
								   sum(
									   CASE WHEN sigafecpar='AU' THEN dp.moncarpar 
											 WHEN sigafecpar='DI' THEN -dp.moncarpar
											 ELSE dp.subtotpar END AS moncarpar
								   ) AS monto
							FROM sco_dt_partidas_contrato dp
							INNER JOIN sco_partidas p ON p.codpartida = dp.codpartida
							INNER JOIN sco_tipo_partida tp ON tp.codtippartida = p.codtippartida
							INNER JOIN sco_unidad_tecnica_medida u ON u.codunitecmed = dp.codunipar
							INNER JOIN sigesp_cargos ac ON ac.codcar = dp.codcar AND ac.codemp = '0001'
							INNER JOIN spg_cuentas spga ON spga.spg_cuenta = ac.spg_cuenta
												   AND spga.estcla = dp.estcla																   
										   AND spga.codestpro1 = dp.codestpro1
										   AND spga.codestpro2 = dp.codestpro2
										   AND spga.codestpro3 = dp.codestpro3
										   AND spga.codestpro4 = dp.codestpro4
										   AND spga.codestpro5 = dp.codestpro5
							WHERE dp.codcont='5'
							  AND dp.nrodoccont='4'
							GROUP BY ac.spg_cuenta,
								 dp.estcla, dp.codestpro1, dp.codestpro2, dp.codestpro3, dp.codestpro4, dp.codestpro5
							ORDER BY 1,2,3,4,5,6,7
				  

13/07/2020 04:50:51  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  ERROR->

13/07/2020 04:51:53  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <b>CLASE:</b> covensol_sco_c_contratosobras <br><b>METODO:</b> BuscarSpgDocumento <br><b>ERROR->:</b><br>Invalid query: ERROR:  no existe la columna «sigafecpar»
LINE 4:             CASE WHEN sigafecpar='AU' THEN dp.subtotpar 
                              ^
Whole query:          SELECT dp.spg_cuenta,
								   dp.estcla, dp.codestpro1, dp.codestpro2, dp.codestpro3, dp.codestpro4, dp.codestpro5,
								   sum(
									   CASE WHEN sigafecpar='AU' THEN dp.subtotpar 
											 WHEN sigafecpar='DI' THEN -dp.subtotpar
											 ELSE dp.subtotpar 
										END
								   ) AS monto
							FROM sco_dt_partidas_contrato dp
							INNER JOIN sco_partidas p ON p.codpartida = dp.codpartida
							INNER JOIN sco_tipo_partida tp ON tp.codtippartida = p.codtippartida
							INNER JOIN sco_unidad_tecnica_medida u ON u.codunitecmed = dp.codunipar
							WHERE dp.codcont='5'
							  AND dp.nrodoccont='4'
							GROUP BY dp.spg_cuenta,
								 dp.estcla, dp.codestpro1, dp.codestpro2, dp.codestpro3, dp.codestpro4, dp.codestpro5
							UNION
							SELECT ac.spg_cuenta,
								   dp.estcla, dp.codestpro1, dp.codestpro2, dp.codestpro3, dp.codestpro4, dp.codestpro5,
								   sum(
									   CASE WHEN sigafecpar='AU' THEN dp.moncarpar 
											 WHEN sigafecpar='DI' THEN -dp.moncarpar
											 ELSE dp.subtotpar 
										END
								   ) AS monto
							FROM sco_dt_partidas_contrato dp
							INNER JOIN sco_partidas p ON p.codpartida = dp.codpartida
							INNER JOIN sco_tipo_partida tp ON tp.codtippartida = p.codtippartida
							INNER JOIN sco_unidad_tecnica_medida u ON u.codunitecmed = dp.codunipar
							INNER JOIN sigesp_cargos ac ON ac.codcar = dp.codcar AND ac.codemp = '0001'
							INNER JOIN spg_cuentas spga ON spga.spg_cuenta = ac.spg_cuenta
												   AND spga.estcla = dp.estcla																   
										   AND spga.codestpro1 = dp.codestpro1
										   AND spga.codestpro2 = dp.codestpro2
										   AND spga.codestpro3 = dp.codestpro3
										   AND spga.codestpro4 = dp.codestpro4
										   AND spga.codestpro5 = dp.codestpro5
							WHERE dp.codcont='5'
							  AND dp.nrodoccont='4'
							GROUP BY ac.spg_cuenta,
								 dp.estcla, dp.codestpro1, dp.codestpro2, dp.codestpro3, dp.codestpro4, dp.codestpro5
							ORDER BY 1,2,3,4,5,6,7
				  

13/07/2020 04:51:53  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  ERROR->

13/07/2020 07:37:27  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  ERROR-> Error en valida procedencia del Comprobante

13/07/2020 07:38:14  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->Integración SCO MÉTODO->uf_procesar_comprobante_spg_documento ERROR->

13/07/2020 07:55:40  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  ERROR->No hay operacion asociada al mensaje 

13/07/2020 07:55:40  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  ERROR -> ERROR->No hay operacion asociada al mensaje 

13/07/2020 08:00:49  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  ERROR->No hay operacion asociada al mensaje 

13/07/2020 08:00:49  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  ERROR -> ERROR->No hay operacion asociada al mensaje 

13/07/2020 08:21:55  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->Integración SCO MÉTODO->uf_update_estatus_contabilizado_sco ERROR->Invalid query: ERROR:  error de sintaxis en o cerca de «WHERE»
LINE 4:      WHERE codcont='5'
             ^
Whole query: UPDATE sco_dt_documentos
					SET estdoccont='PROC',
					    doccontab=1,
				 WHERE codcont='5'
				   AND nrodoccont='1' 

13/07/2020 08:47:27  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->Integración SCO MÉTODO->uf_update_estatus_contabilizado_sco ERROR->Invalid query: ERROR:  no existe la columna «sco»
LINE 4:       cmpcontable=SCO-000005-DOCINI-1
                          ^
Whole query: UPDATE sco_dt_documentos
					SET estdoccont='PROC',
					    doccontab=1,
						cmpcontable=SCO-000005-DOCINI-1
				 WHERE codcont='5'
				   AND nrodoccont='1' 

13/07/2020 16:53:08  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->Recepción MÉTODO->uf_load_compromiso_sco ERROR->Invalid query: ERROR:  error de sintaxis en o cerca de «MAX»
LINE 9:            MAX(spg.sc_cuenta) AS sc_cuenta, 
                   ^
Whole query:          SELECT dp.spg_cuenta,
								   dp.estcla, 
								   dp.codestpro1, 
								   dp.codestpro2, 
								   dp.codestpro3, 
								   dp.codestpro4, 
								   dp.codestpro5,
								   MAX('SCO-000005-DOCINI-1') AS comprobante
								   MAX(spg.sc_cuenta) AS sc_cuenta, 
								   MAX(ep1.estint) AS estint,
								   MAX(ep1.sc_cuenta) AS cuentaint,
								   MAX('--') AS codfuefin,
								   MAX(
								        	SELECT count(*)
											FROM (
												SELECT ac.spg_cuenta,
												   dp.estcla, dp.codestpro1, dp.codestpro2, dp.codestpro3, dp.codestpro4, dp.codestpro5,
												   sum(
													   CASE WHEN sigafecpar='AU' THEN dp.moncarpar 
															 WHEN sigafecpar='DI' THEN -dp.moncarpar
															 ELSE dp.moncarpar 
														END
												   ) AS monto
												FROM sco_dt_partidas_contrato dp
												INNER JOIN sco_partidas p ON p.codpartida = dp.codpartida
												INNER JOIN sco_tipo_partida tp ON tp.codtippartida = p.codtippartida
												INNER JOIN sco_unidad_tecnica_medida u ON u.codunitecmed = dp.codunipar
												INNER JOIN sigesp_cargos ac ON ac.codcar = dp.codcar AND ac.codemp = '0001'
												INNER JOIN spg_cuentas spga ON spga.spg_cuenta = ac.spg_cuenta
																   AND spga.estcla = dp.estcla																   
														   AND spga.codestpro1 = dp.codestpro1
														   AND spga.codestpro2 = dp.codestpro2
														   AND spga.codestpro3 = dp.codestpro3
														   AND spga.codestpro4 = dp.codestpro4
														   AND spga.codestpro5 = dp.codestpro5
												INNER JOIN sco_dt_documentos dc ON dc.codcont = dp.codcont
																	           AND dc.nrodoccont = '1'
												INNER JOIN sco_tipo_documento td ON td.tipdoccont = dc.tipdoccont
												WHERE dp.codcont='5'
												AND dp.nrodoccont=0
												GROUP BY ac.spg_cuenta,
												         dp.estcla, dp.codestpro1, dp.codestpro2, dp.codestpro3, dp.codestpro4, dp.codestpro5
												ORDER BY 1,2,3,4,5,6,7
											) AS car								   
								   ) AS cargo 
								   sum(
									   CASE WHEN sigafecpar='AU' THEN dp.subtotpar 
											 WHEN sigafecpar='DI' THEN -dp.subtotpar
											 ELSE dp.subtotpar 
										END
								   ) AS monto
							FROM sco_dt_partidas_contrato dp
							INNER JOIN sco_partidas p ON p.codpartida = dp.codpartida
							INNER JOIN sco_tipo_partida tp ON tp.codtippartida = p.codtippartida
							INNER JOIN sco_unidad_tecnica_medida u ON u.codunitecmed = dp.codunipar
							INNER JOIN spg_cuentas spg ON soc_cuentagasto.codemp = spg.codemp  
													  AND dp.spg_cuenta = spg.spg_cuenta  
													  AND dp.codestpro1 = spg.codestpro1  
													  AND dp.codestpro2 = spg.codestpro2  
													  AND dp.codestpro3 = spg.codestpro3  
													  AND dp.codestpro4 = spg.codestpro4  
													  AND dp.codestpro5 = spg.codestpro5  
													  AND dp.estcla = spg.estcla  
							INNER JOIN spg_ep1 ep1 ON dp.codemp=ep1.codemp 
											      AND dp.codestpro1=ep1.codestpro1 
											      AND dp.estcla=ep1.estcla
							INNER JOIN sco_dt_documentos dc ON dc.codcont = dp.codcont
												           AND dc.nrodoccont = '1'
							INNER JOIN sco_tipo_documento td ON td.tipdoccont = dc.tipdoccont
							WHERE dp.codcont='5'
							  AND dp.nrodoccont='0'
							GROUP BY dp.spg_cuenta,
								 dp.estcla, dp.codestpro1, dp.codestpro2, dp.codestpro3, dp.codestpro4, dp.codestpro5
				  

13/07/2020 16:54:14  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->Recepción MÉTODO->uf_load_compromiso_sco ERROR->Invalid query: ERROR:  error de sintaxis en o cerca de «SELECT»
LINE 14:                  SELECT count(*)
                          ^
Whole query:          SELECT dp.spg_cuenta,
								   dp.estcla, 
								   dp.codestpro1, 
								   dp.codestpro2, 
								   dp.codestpro3, 
								   dp.codestpro4, 
								   dp.codestpro5,
								   MAX('SCO-000005-DOCINI-1') AS comprobante,
								   MAX(spg.sc_cuenta) AS sc_cuenta, 
								   MAX(ep1.estint) AS estint,
								   MAX(ep1.sc_cuenta) AS cuentaint,
								   MAX('--') AS codfuefin,
								   MAX(
								        	SELECT count(*)
											FROM (
												SELECT ac.spg_cuenta,
												   dp.estcla, dp.codestpro1, dp.codestpro2, dp.codestpro3, dp.codestpro4, dp.codestpro5,
												   sum(
													   CASE WHEN sigafecpar='AU' THEN dp.moncarpar 
															 WHEN sigafecpar='DI' THEN -dp.moncarpar
															 ELSE dp.moncarpar 
														END
												   ) AS monto
												FROM sco_dt_partidas_contrato dp
												INNER JOIN sco_partidas p ON p.codpartida = dp.codpartida
												INNER JOIN sco_tipo_partida tp ON tp.codtippartida = p.codtippartida
												INNER JOIN sco_unidad_tecnica_medida u ON u.codunitecmed = dp.codunipar
												INNER JOIN sigesp_cargos ac ON ac.codcar = dp.codcar AND ac.codemp = '0001'
												INNER JOIN spg_cuentas spga ON spga.spg_cuenta = ac.spg_cuenta
																   AND spga.estcla = dp.estcla																   
														   AND spga.codestpro1 = dp.codestpro1
														   AND spga.codestpro2 = dp.codestpro2
														   AND spga.codestpro3 = dp.codestpro3
														   AND spga.codestpro4 = dp.codestpro4
														   AND spga.codestpro5 = dp.codestpro5
												INNER JOIN sco_dt_documentos dc ON dc.codcont = dp.codcont
																	           AND dc.nrodoccont = '1'
												INNER JOIN sco_tipo_documento td ON td.tipdoccont = dc.tipdoccont
												WHERE dp.codcont='5'
												AND dp.nrodoccont=0
												GROUP BY ac.spg_cuenta,
												         dp.estcla, dp.codestpro1, dp.codestpro2, dp.codestpro3, dp.codestpro4, dp.codestpro5
												ORDER BY 1,2,3,4,5,6,7
											) AS car								   
								   ) AS cargo 
								   sum(
									   CASE WHEN sigafecpar='AU' THEN dp.subtotpar 
											 WHEN sigafecpar='DI' THEN -dp.subtotpar
											 ELSE dp.subtotpar 
										END
								   ) AS monto
							FROM sco_dt_partidas_contrato dp
							INNER JOIN sco_partidas p ON p.codpartida = dp.codpartida
							INNER JOIN sco_tipo_partida tp ON tp.codtippartida = p.codtippartida
							INNER JOIN sco_unidad_tecnica_medida u ON u.codunitecmed = dp.codunipar
							INNER JOIN spg_cuentas spg ON soc_cuentagasto.codemp = spg.codemp  
													  AND dp.spg_cuenta = spg.spg_cuenta  
													  AND dp.codestpro1 = spg.codestpro1  
													  AND dp.codestpro2 = spg.codestpro2  
													  AND dp.codestpro3 = spg.codestpro3  
													  AND dp.codestpro4 = spg.codestpro4  
													  AND dp.codestpro5 = spg.codestpro5  
													  AND dp.estcla = spg.estcla  
							INNER JOIN spg_ep1 ep1 ON dp.codemp=ep1.codemp 
											      AND dp.codestpro1=ep1.codestpro1 
											      AND dp.estcla=ep1.estcla
							INNER JOIN sco_dt_documentos dc ON dc.codcont = dp.codcont
												           AND dc.nrodoccont = '1'
							INNER JOIN sco_tipo_documento td ON td.tipdoccont = dc.tipdoccont
							WHERE dp.codcont='5'
							  AND dp.nrodoccont='0'
							GROUP BY dp.spg_cuenta,
								 dp.estcla, dp.codestpro1, dp.codestpro2, dp.codestpro3, dp.codestpro4, dp.codestpro5
				  

13/07/2020 16:54:43  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->Recepción MÉTODO->uf_load_compromiso_sco ERROR->Invalid query: ERROR:  error de sintaxis en o cerca de «SELECT»
LINE 14:                  SELECT count(*)
                          ^
Whole query:          SELECT dp.spg_cuenta,
								   dp.estcla, 
								   dp.codestpro1, 
								   dp.codestpro2, 
								   dp.codestpro3, 
								   dp.codestpro4, 
								   dp.codestpro5,
								   MAX('SCO-000005-DOCINI-1') AS comprobante,
								   MAX(spg.sc_cuenta) AS sc_cuenta, 
								   MAX(ep1.estint) AS estint,
								   MAX(ep1.sc_cuenta) AS cuentaint,
								   MAX('--') AS codfuefin,
								   MAX(
								        	SELECT count(*)
											FROM (
												SELECT ac.spg_cuenta,
												   dp.estcla, dp.codestpro1, dp.codestpro2, dp.codestpro3, dp.codestpro4, dp.codestpro5,
												   sum(
													   CASE WHEN sigafecpar='AU' THEN dp.moncarpar 
															 WHEN sigafecpar='DI' THEN -dp.moncarpar
															 ELSE dp.moncarpar 
														END
												   ) AS monto
												FROM sco_dt_partidas_contrato dp
												INNER JOIN sco_partidas p ON p.codpartida = dp.codpartida
												INNER JOIN sco_tipo_partida tp ON tp.codtippartida = p.codtippartida
												INNER JOIN sco_unidad_tecnica_medida u ON u.codunitecmed = dp.codunipar
												INNER JOIN sigesp_cargos ac ON ac.codcar = dp.codcar AND ac.codemp = '0001'
												INNER JOIN spg_cuentas spga ON spga.spg_cuenta = ac.spg_cuenta
																   AND spga.estcla = dp.estcla																   
														   AND spga.codestpro1 = dp.codestpro1
														   AND spga.codestpro2 = dp.codestpro2
														   AND spga.codestpro3 = dp.codestpro3
														   AND spga.codestpro4 = dp.codestpro4
														   AND spga.codestpro5 = dp.codestpro5
												INNER JOIN sco_dt_documentos dc ON dc.codcont = dp.codcont
																	           AND dc.nrodoccont = '1'
												INNER JOIN sco_tipo_documento td ON td.tipdoccont = dc.tipdoccont
												WHERE dp.codcont='5'
												AND dp.nrodoccont=0
												GROUP BY ac.spg_cuenta,
												         dp.estcla, dp.codestpro1, dp.codestpro2, dp.codestpro3, dp.codestpro4, dp.codestpro5
												ORDER BY 1,2,3,4,5,6,7
											) AS car								   
								   ) AS cargo, 
								   sum(
									   CASE WHEN sigafecpar='AU' THEN dp.subtotpar 
											 WHEN sigafecpar='DI' THEN -dp.subtotpar
											 ELSE dp.subtotpar 
										END
								   ) AS monto
							FROM sco_dt_partidas_contrato dp
							INNER JOIN sco_partidas p ON p.codpartida = dp.codpartida
							INNER JOIN sco_tipo_partida tp ON tp.codtippartida = p.codtippartida
							INNER JOIN sco_unidad_tecnica_medida u ON u.codunitecmed = dp.codunipar
							INNER JOIN spg_cuentas spg ON soc_cuentagasto.codemp = spg.codemp  
													  AND dp.spg_cuenta = spg.spg_cuenta  
													  AND dp.codestpro1 = spg.codestpro1  
													  AND dp.codestpro2 = spg.codestpro2  
													  AND dp.codestpro3 = spg.codestpro3  
													  AND dp.codestpro4 = spg.codestpro4  
													  AND dp.codestpro5 = spg.codestpro5  
													  AND dp.estcla = spg.estcla  
							INNER JOIN spg_ep1 ep1 ON dp.codemp=ep1.codemp 
											      AND dp.codestpro1=ep1.codestpro1 
											      AND dp.estcla=ep1.estcla
							INNER JOIN sco_dt_documentos dc ON dc.codcont = dp.codcont
												           AND dc.nrodoccont = '1'
							INNER JOIN sco_tipo_documento td ON td.tipdoccont = dc.tipdoccont
							WHERE dp.codcont='5'
							  AND dp.nrodoccont='0'
							GROUP BY dp.spg_cuenta,
								 dp.estcla, dp.codestpro1, dp.codestpro2, dp.codestpro3, dp.codestpro4, dp.codestpro5
				  

13/07/2020 16:55:42  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->Recepción MÉTODO->uf_load_compromiso_sco ERROR->Invalid query: ERROR:  error de sintaxis en o cerca de «SELECT»
LINE 14:                  SELECT count(*)
                          ^
Whole query:          SELECT dp.spg_cuenta,
								   dp.estcla, 
								   dp.codestpro1, 
								   dp.codestpro2, 
								   dp.codestpro3, 
								   dp.codestpro4, 
								   dp.codestpro5,
								   MAX('SCO-000005-DOCINI-1') AS comprobante,
								   MAX(spg.sc_cuenta) AS sc_cuenta, 
								   MAX(ep1.estint) AS estint,
								   MAX(ep1.sc_cuenta) AS cuentaint,
								   MAX('--') AS codfuefin,
								   MAX(
								        	SELECT count(*)
											FROM (
												SELECT ac.spg_cuenta,
												   dp.estcla, dp.codestpro1, dp.codestpro2, dp.codestpro3, dp.codestpro4, dp.codestpro5,
												   sum(
													   CASE WHEN sigafecpar='AU' THEN dp.moncarpar 
															 WHEN sigafecpar='DI' THEN -dp.moncarpar
															 ELSE dp.moncarpar 
														END
												   ) AS monto
												FROM sco_dt_partidas_contrato dp
												INNER JOIN sco_partidas p ON p.codpartida = dp.codpartida
												INNER JOIN sco_tipo_partida tp ON tp.codtippartida = p.codtippartida
												INNER JOIN sco_unidad_tecnica_medida u ON u.codunitecmed = dp.codunipar
												INNER JOIN sigesp_cargos ac ON ac.codcar = dp.codcar AND ac.codemp = '0001'
												INNER JOIN spg_cuentas spga ON spga.spg_cuenta = ac.spg_cuenta
																   AND spga.estcla = dp.estcla																   
														   AND spga.codestpro1 = dp.codestpro1
														   AND spga.codestpro2 = dp.codestpro2
														   AND spga.codestpro3 = dp.codestpro3
														   AND spga.codestpro4 = dp.codestpro4
														   AND spga.codestpro5 = dp.codestpro5
												INNER JOIN sco_dt_documentos dc ON dc.codcont = dp.codcont
																	           AND dc.nrodoccont = '1'
												INNER JOIN sco_tipo_documento td ON td.tipdoccont = dc.tipdoccont
												WHERE dp.codcont='5'
												AND dp.nrodoccont=0
												GROUP BY ac.spg_cuenta,
												         dp.estcla, dp.codestpro1, dp.codestpro2, dp.codestpro3, dp.codestpro4, dp.codestpro5
												ORDER BY 1,2,3,4,5,6,7
											) AS car								   
								   ) AS cargo, 
								   sum(
									   CASE WHEN sigafecpar='AU' THEN dp.subtotpar 
											 WHEN sigafecpar='DI' THEN -dp.subtotpar
											 ELSE dp.subtotpar 
										END
								   ) AS monto
							FROM sco_dt_partidas_contrato dp
							INNER JOIN sco_partidas p ON p.codpartida = dp.codpartida
							INNER JOIN sco_tipo_partida tp ON tp.codtippartida = p.codtippartida
							INNER JOIN sco_unidad_tecnica_medida u ON u.codunitecmed = dp.codunipar
							INNER JOIN spg_cuentas spg ON soc_cuentagasto.codemp = spg.codemp  
													  AND dp.spg_cuenta = spg.spg_cuenta  
													  AND dp.codestpro1 = spg.codestpro1  
													  AND dp.codestpro2 = spg.codestpro2  
													  AND dp.codestpro3 = spg.codestpro3  
													  AND dp.codestpro4 = spg.codestpro4  
													  AND dp.codestpro5 = spg.codestpro5  
													  AND dp.estcla = spg.estcla  
							INNER JOIN spg_ep1 ep1 ON dp.codemp=ep1.codemp 
											      AND dp.codestpro1=ep1.codestpro1 
											      AND dp.estcla=ep1.estcla
							INNER JOIN sco_dt_documentos dc ON dc.codcont = dp.codcont
												           AND dc.nrodoccont = '1'
							INNER JOIN sco_tipo_documento td ON td.tipdoccont = dc.tipdoccont
							WHERE dp.codcont='5'
							  AND dp.nrodoccont='0'
							GROUP BY dp.spg_cuenta,
								 dp.estcla, dp.codestpro1, dp.codestpro2, dp.codestpro3, dp.codestpro4, dp.codestpro5
				  

13/07/2020 16:56:11  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->Recepción MÉTODO->uf_load_compromiso_sco ERROR->Invalid query: ERROR:  falta una entrada para la tabla «soc_cuentagasto» en la cláusula FROM
LINE 56:        INNER JOIN spg_cuentas spg ON soc_cuentagasto.codemp ...
                                              ^
Whole query:          SELECT dp.spg_cuenta,
								   dp.estcla, 
								   dp.codestpro1, 
								   dp.codestpro2, 
								   dp.codestpro3, 
								   dp.codestpro4, 
								   dp.codestpro5,
								   MAX('SCO-000005-DOCINI-1') AS comprobante,
								   MAX(spg.sc_cuenta) AS sc_cuenta, 
								   MAX(ep1.estint) AS estint,
								   MAX(ep1.sc_cuenta) AS cuentaint,
								   MAX('--') AS codfuefin,
								   (
								        	SELECT count(*)
											FROM (
												  SELECT ac.spg_cuenta,
												   dp.estcla, dp.codestpro1, dp.codestpro2, dp.codestpro3, dp.codestpro4, dp.codestpro5,
												   sum(
													   CASE WHEN sigafecpar='AU' THEN dp.moncarpar 
															 WHEN sigafecpar='DI' THEN -dp.moncarpar
															 ELSE dp.moncarpar 
														END
												   ) AS monto
												FROM sco_dt_partidas_contrato dp
												INNER JOIN sco_partidas p ON p.codpartida = dp.codpartida
												INNER JOIN sco_tipo_partida tp ON tp.codtippartida = p.codtippartida
												INNER JOIN sco_unidad_tecnica_medida u ON u.codunitecmed = dp.codunipar
												INNER JOIN sigesp_cargos ac ON ac.codcar = dp.codcar AND ac.codemp = '0001'
												INNER JOIN spg_cuentas spga ON spga.spg_cuenta = ac.spg_cuenta
																   AND spga.estcla = dp.estcla																   
														   AND spga.codestpro1 = dp.codestpro1
														   AND spga.codestpro2 = dp.codestpro2
														   AND spga.codestpro3 = dp.codestpro3
														   AND spga.codestpro4 = dp.codestpro4
														   AND spga.codestpro5 = dp.codestpro5
												INNER JOIN sco_dt_documentos dc ON dc.codcont = dp.codcont
																	           AND dc.nrodoccont = '1'
												INNER JOIN sco_tipo_documento td ON td.tipdoccont = dc.tipdoccont
												WHERE dp.codcont='5'
												AND dp.nrodoccont=0
												GROUP BY ac.spg_cuenta,
												         dp.estcla, dp.codestpro1, dp.codestpro2, dp.codestpro3, dp.codestpro4, dp.codestpro5
												ORDER BY 1,2,3,4,5,6,7
											) AS car								   
								   ) AS cargo, 
								   sum(
									   CASE WHEN sigafecpar='AU' THEN dp.subtotpar 
											 WHEN sigafecpar='DI' THEN -dp.subtotpar
											 ELSE dp.subtotpar 
										END
								   ) AS monto
							FROM sco_dt_partidas_contrato dp
							INNER JOIN sco_partidas p ON p.codpartida = dp.codpartida
							INNER JOIN sco_tipo_partida tp ON tp.codtippartida = p.codtippartida
							INNER JOIN sco_unidad_tecnica_medida u ON u.codunitecmed = dp.codunipar
							INNER JOIN spg_cuentas spg ON soc_cuentagasto.codemp = spg.codemp  
													  AND dp.spg_cuenta = spg.spg_cuenta  
													  AND dp.codestpro1 = spg.codestpro1  
													  AND dp.codestpro2 = spg.codestpro2  
													  AND dp.codestpro3 = spg.codestpro3  
													  AND dp.codestpro4 = spg.codestpro4  
													  AND dp.codestpro5 = spg.codestpro5  
													  AND dp.estcla = spg.estcla  
							INNER JOIN spg_ep1 ep1 ON dp.codemp=ep1.codemp 
											      AND dp.codestpro1=ep1.codestpro1 
											      AND dp.estcla=ep1.estcla
							INNER JOIN sco_dt_documentos dc ON dc.codcont = dp.codcont
												           AND dc.nrodoccont = '1'
							INNER JOIN sco_tipo_documento td ON td.tipdoccont = dc.tipdoccont
							WHERE dp.codcont='5'
							  AND dp.nrodoccont='0'
							GROUP BY dp.spg_cuenta,
								 dp.estcla, dp.codestpro1, dp.codestpro2, dp.codestpro3, dp.codestpro4, dp.codestpro5
				  

13/07/2020 16:57:27  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->Recepción MÉTODO->uf_load_compromiso_sco ERROR->Invalid query: ERROR:  no existe la columna dp.codemp
LINE 56:        INNER JOIN spg_cuentas spg ON dp.codemp = spg.codemp ...
                                              ^
Whole query:          SELECT dp.spg_cuenta,
								   dp.estcla, 
								   dp.codestpro1, 
								   dp.codestpro2, 
								   dp.codestpro3, 
								   dp.codestpro4, 
								   dp.codestpro5,
								   MAX('SCO-000005-DOCINI-1') AS comprobante,
								   MAX(spg.sc_cuenta) AS sc_cuenta, 
								   MAX(ep1.estint) AS estint,
								   MAX(ep1.sc_cuenta) AS cuentaint,
								   MAX('--') AS codfuefin,
								   (
								        	SELECT count(*)
											FROM (
												  SELECT ac.spg_cuenta,
												   dp.estcla, dp.codestpro1, dp.codestpro2, dp.codestpro3, dp.codestpro4, dp.codestpro5,
												   sum(
													   CASE WHEN sigafecpar='AU' THEN dp.moncarpar 
															 WHEN sigafecpar='DI' THEN -dp.moncarpar
															 ELSE dp.moncarpar 
														END
												   ) AS monto
												FROM sco_dt_partidas_contrato dp
												INNER JOIN sco_partidas p ON p.codpartida = dp.codpartida
												INNER JOIN sco_tipo_partida tp ON tp.codtippartida = p.codtippartida
												INNER JOIN sco_unidad_tecnica_medida u ON u.codunitecmed = dp.codunipar
												INNER JOIN sigesp_cargos ac ON ac.codcar = dp.codcar AND ac.codemp = '0001'
												INNER JOIN spg_cuentas spga ON spga.spg_cuenta = ac.spg_cuenta
																   AND spga.estcla = dp.estcla																   
																   AND spga.codestpro1 = dp.codestpro1
																   AND spga.codestpro2 = dp.codestpro2
																   AND spga.codestpro3 = dp.codestpro3
																   AND spga.codestpro4 = dp.codestpro4
																   AND spga.codestpro5 = dp.codestpro5
												INNER JOIN sco_dt_documentos dc ON dc.codcont = dp.codcont
																	           AND dc.nrodoccont = '1'
												INNER JOIN sco_tipo_documento td ON td.tipdoccont = dc.tipdoccont
												WHERE dp.codcont='5'
												AND dp.nrodoccont=0
												GROUP BY ac.spg_cuenta,
												         dp.estcla, dp.codestpro1, dp.codestpro2, dp.codestpro3, dp.codestpro4, dp.codestpro5
												ORDER BY 1,2,3,4,5,6,7
											) AS car								   
								   ) AS cargo, 
								   sum(
									   CASE WHEN sigafecpar='AU' THEN dp.subtotpar 
											 WHEN sigafecpar='DI' THEN -dp.subtotpar
											 ELSE dp.subtotpar 
										END
								   ) AS monto
							FROM sco_dt_partidas_contrato dp
							INNER JOIN sco_partidas p ON p.codpartida = dp.codpartida
							INNER JOIN sco_tipo_partida tp ON tp.codtippartida = p.codtippartida
							INNER JOIN sco_unidad_tecnica_medida u ON u.codunitecmed = dp.codunipar
							INNER JOIN spg_cuentas spg ON dp.codemp = spg.codemp  
													  AND dp.spg_cuenta = spg.spg_cuenta  
													  AND dp.codestpro1 = spg.codestpro1  
													  AND dp.codestpro2 = spg.codestpro2  
													  AND dp.codestpro3 = spg.codestpro3  
													  AND dp.codestpro4 = spg.codestpro4  
													  AND dp.codestpro5 = spg.codestpro5  
													  AND dp.estcla = spg.estcla  
							INNER JOIN spg_ep1 ep1 ON dp.codemp=ep1.codemp 
											      AND dp.codestpro1=ep1.codestpro1 
											      AND dp.estcla=ep1.estcla
							INNER JOIN sco_dt_documentos dc ON dc.codcont = dp.codcont
												           AND dc.nrodoccont = '1'
							INNER JOIN sco_tipo_documento td ON td.tipdoccont = dc.tipdoccont
							WHERE dp.codcont='5'
							  AND dp.nrodoccont='0'
							GROUP BY dp.spg_cuenta,
								 dp.estcla, dp.codestpro1, dp.codestpro2, dp.codestpro3, dp.codestpro4, dp.codestpro5
				  

13/07/2020 17:01:36  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->Recepción MÉTODO->uf_load_cargos_compromiso_sep ERROR->Invalid query: ERROR:  la columna «spga.spg_cuenta» debe aparecer en la cláusula GROUP BY o ser usada en una función de agregación
LINE 1:         SELECT  spga.spg_cuenta,
                        ^
Whole query:         SELECT  spga.spg_cuenta,
								   dp.estcla, 
								   dp.codestpro1, 
								   dp.codestpro2, 
								   dp.codestpro3, 
								   dp.codestpro4, 
								   dp.codestpro5,
								   ac.codcar,
								   MAX(spga.sc_cuenta) AS sc_cuenta,
								   MAX(ac.formula) AS formula,	
								   MAX(dp.porcarpar) AS porcar,	
								   MAX(ac.dencar) AS dencar,
								   sum(
									   CASE WHEN sigafecpar='AU' THEN dp.subtotpar 
											 WHEN sigafecpar='DI' THEN -dp.subtotpar
											 ELSE dp.subtotpar 
										END
								   ) AS monobjret,							   
								   sum(
									   CASE WHEN sigafecpar='AU' THEN dp.moncarpar 
											 WHEN sigafecpar='DI' THEN -dp.moncarpar
											 ELSE dp.moncarpar 
										END
								   ) AS monret
							FROM sco_dt_partidas_contrato dp
							INNER JOIN sco_partidas p ON p.codpartida = dp.codpartida
							INNER JOIN sco_tipo_partida tp ON tp.codtippartida = p.codtippartida
							INNER JOIN sco_unidad_tecnica_medida u ON u.codunitecmed = dp.codunipar
							INNER JOIN sigesp_cargos ac ON ac.codcar = dp.codcar AND ac.codemp = '0001'
							INNER JOIN spg_cuentas spga ON spga.codemp = '0001'  
													   AND spga.estcla = dp.estcla																   
													   AND spga.codestpro1 = dp.codestpro1
													   AND spga.codestpro2 = dp.codestpro2
													   AND spga.codestpro3 = dp.codestpro3
													   AND spga.codestpro4 = dp.codestpro4
													   AND spga.codestpro5 = dp.codestpro5
							INNER JOIN sco_dt_documentos dc ON dc.codcont = dp.codcont
												           AND dc.nrodoccont = '1'
							INNER JOIN sco_tipo_documento td ON td.tipdoccont = dc.tipdoccont
							WHERE dp.codcont='5'
							  AND dp.nrodoccont='0'
							  AND dp.moncarpar<>0
							GROUP BY ac.spg_cuenta,
								 dp.estcla, dp.codestpro1, dp.codestpro2, dp.codestpro3, dp.codestpro4, dp.codestpro5,ac.codcar
							ORDER BY 1,2,3,4,5,6,7,8
				  

13/07/2020 17:35:26  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->Recepción MÉTODO->uf_load_compromiso_sco ERROR->Invalid query: ERROR:  error de sintaxis en o cerca de «ORDER»
LINE 149:        ORDER BY 1,2,3,4,5,6,7
                 ^
Whole query:          SELECT dp.spg_cuenta,
								   dp.estcla, 
								   dp.codestpro1, 
								   dp.codestpro2, 
								   dp.codestpro3, 
								   dp.codestpro4, 
								   dp.codestpro5,
								   MAX('SCO-000005-DOCINI-1') AS comprobante,
								   MAX(spg.sc_cuenta) AS sc_cuenta, 
								   MAX(ep1.estint) AS estint,
								   MAX(ep1.sc_cuenta) AS cuentaint,
								   MAX('--') AS codfuefin,
								   (
								        	SELECT count(*)
											FROM (
												  SELECT ac.spg_cuenta,
												   dp.estcla, dp.codestpro1, dp.codestpro2, dp.codestpro3, dp.codestpro4, dp.codestpro5,
												   sum(
													   CASE WHEN sigafecpar='AU' THEN dp.moncarpar 
															 WHEN sigafecpar='DI' THEN -dp.moncarpar
															 ELSE dp.moncarpar 
														END
												   ) AS monto
												FROM sco_dt_partidas_contrato dp
												INNER JOIN sco_partidas p ON p.codpartida = dp.codpartida
												INNER JOIN sco_tipo_partida tp ON tp.codtippartida = p.codtippartida
												INNER JOIN sco_unidad_tecnica_medida u ON u.codunitecmed = dp.codunipar
												INNER JOIN sigesp_cargos ac ON ac.codcar = dp.codcar AND ac.codemp = '0001'
												INNER JOIN spg_cuentas spga ON spga.spg_cuenta = ac.spg_cuenta
																   AND spga.estcla = dp.estcla																   
																   AND spga.codestpro1 = dp.codestpro1
																   AND spga.codestpro2 = dp.codestpro2
																   AND spga.codestpro3 = dp.codestpro3
																   AND spga.codestpro4 = dp.codestpro4
																   AND spga.codestpro5 = dp.codestpro5
												INNER JOIN sco_dt_documentos dc ON dc.codcont = dp.codcont
																	           AND dc.nrodoccont = '1'
												INNER JOIN sco_tipo_documento td ON td.tipdoccont = dc.tipdoccont
												WHERE dp.codcont='5'
							  					  AND dp.nrodoccont='0'
												  AND dp.moncarpar<>0
												GROUP BY ac.spg_cuenta,
												         dp.estcla, dp.codestpro1, dp.codestpro2, dp.codestpro3, dp.codestpro4, dp.codestpro5
												ORDER BY 1,2,3,4,5,6,7
											) AS car								   
								   ) AS cargo, 
								   sum(
									   CASE WHEN sigafecpar='AU' THEN dp.subtotpar 
											 WHEN sigafecpar='DI' THEN -dp.subtotpar
											 ELSE dp.subtotpar 
										END
								   ) AS monto
							FROM sco_dt_partidas_contrato dp
							INNER JOIN sco_partidas p ON p.codpartida = dp.codpartida
							INNER JOIN sco_tipo_partida tp ON tp.codtippartida = p.codtippartida
							INNER JOIN sco_unidad_tecnica_medida u ON u.codunitecmed = dp.codunipar
							INNER JOIN spg_cuentas spg ON spg.codemp = '0001'  
													  AND dp.spg_cuenta = spg.spg_cuenta  
													  AND dp.codestpro1 = spg.codestpro1  
													  AND dp.codestpro2 = spg.codestpro2  
													  AND dp.codestpro3 = spg.codestpro3  
													  AND dp.codestpro4 = spg.codestpro4  
													  AND dp.codestpro5 = spg.codestpro5  
													  AND dp.estcla = spg.estcla  
							INNER JOIN spg_ep1 ep1 ON ep1.codemp='0001' 
											      AND ep1.codestpro1=dp.codestpro1 
											      AND ep1.estcla=dp.estcla
							INNER JOIN sco_dt_documentos dc ON dc.codcont = dp.codcont
												           AND dc.nrodoccont = '1'
							INNER JOIN sco_tipo_documento td ON td.tipdoccont = dc.tipdoccont
							WHERE dp.codcont='5'
							  AND dp.nrodoccont='0'
							GROUP BY dp.spg_cuenta,
								 dp.estcla, dp.codestpro1, dp.codestpro2, dp.codestpro3, dp.codestpro4, dp.codestpro5
							UNION
							SELECT ac.spg_cuenta,
								   dp.estcla, 
								   dp.codestpro1, 
								   dp.codestpro2, 
								   dp.codestpro3, 
								   dp.codestpro4, 
								   dp.codestpro5,
								   MAX('SCO-000005-DOCINI-1') AS comprobante,
								   MAX(spg.sc_cuenta) AS sc_cuenta, 
								   MAX(ep1.estint) AS estint,
								   MAX(ep1.sc_cuenta) AS cuentaint,
								   MAX('--') AS codfuefin,
								   (
								        	SELECT count(*)
											FROM (
												  SELECT ac.spg_cuenta,
												   dp.estcla, dp.codestpro1, dp.codestpro2, dp.codestpro3, dp.codestpro4, dp.codestpro5,
												   sum(
													   CASE WHEN sigafecpar='AU' THEN dp.moncarpar 
															 WHEN sigafecpar='DI' THEN -dp.moncarpar
															 ELSE dp.moncarpar 
														END
												   ) AS monto
												FROM sco_dt_partidas_contrato dp
												INNER JOIN sco_partidas p ON p.codpartida = dp.codpartida
												INNER JOIN sco_tipo_partida tp ON tp.codtippartida = p.codtippartida
												INNER JOIN sco_unidad_tecnica_medida u ON u.codunitecmed = dp.codunipar
												INNER JOIN sigesp_cargos ac ON ac.codcar = dp.codcar AND ac.codemp = '0001'
												INNER JOIN spg_cuentas spga ON spga.spg_cuenta = ac.spg_cuenta
																   AND spga.estcla = dp.estcla																   
																   AND spga.codestpro1 = dp.codestpro1
																   AND spga.codestpro2 = dp.codestpro2
																   AND spga.codestpro3 = dp.codestpro3
																   AND spga.codestpro4 = dp.codestpro4
																   AND spga.codestpro5 = dp.codestpro5
												INNER JOIN sco_dt_documentos dc ON dc.codcont = dp.codcont
																	           AND dc.nrodoccont = '1'
												INNER JOIN sco_tipo_documento td ON td.tipdoccont = dc.tipdoccont
												WHERE dp.codcont='5'
							  					  AND dp.nrodoccont='0'
												  AND dp.moncarpar<>0
												GROUP BY ac.spg_cuenta,
												         dp.estcla, dp.codestpro1, dp.codestpro2, dp.codestpro3, dp.codestpro4, dp.codestpro5
												ORDER BY 1,2,3,4,5,6,7
											) AS car								   
								   ) AS cargo,						   
								   sum(
									   CASE WHEN sigafecpar='AU' THEN dp.moncarpar 
											 WHEN sigafecpar='DI' THEN -dp.moncarpar
											 ELSE dp.moncarpar 
										END
								   ) AS monret
							FROM sco_dt_partidas_contrato dp
							INNER JOIN sco_partidas p ON p.codpartida = dp.codpartida
							INNER JOIN sco_tipo_partida tp ON tp.codtippartida = p.codtippartida
							INNER JOIN sco_unidad_tecnica_medida u ON u.codunitecmed = dp.codunipar
							INNER JOIN sigesp_cargos ac ON ac.codcar = dp.codcar AND ac.codemp = '0001'
							INNER JOIN spg_cuentas spga ON spga.codemp = '0001'  
													   AND spga.estcla = dp.estcla																   
													   AND spga.codestpro1 = dp.codestpro1
													   AND spga.codestpro2 = dp.codestpro2
													   AND spga.codestpro3 = dp.codestpro3
													   AND spga.codestpro4 = dp.codestpro4
													   AND spga.codestpro5 = dp.codestpro5
							INNER JOIN sco_dt_documentos dc ON dc.codcont = dp.codcont
												           AND dc.nrodoccont = '1'
							INNER JOIN sco_tipo_documento td ON td.tipdoccont = dc.tipdoccont
							WHERE dp.codcont='5'
							  AND dp.nrodoccont='0'
							  AND dp.moncarpar<>0
							GROUP BY ac.spg_cuenta,
								     dp.estcla, dp.codestpro1, dp.codestpro2, dp.codestpro3, dp.codestpro4, dp.codestpro5,ac.codcar
							ORDER BY 1,2,3,4,5,6,7,8
							ORDER BY 1,2,3,4,5,6,7
				  

13/07/2020 17:35:58  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->Recepción MÉTODO->uf_load_compromiso_sco ERROR->Invalid query: ERROR:  falta una entrada para la tabla «spg» en la cláusula FROM
LINE 84:            MAX(spg.sc_cuenta) AS sc_cuenta, 
                        ^
Whole query:          SELECT dp.spg_cuenta,
								   dp.estcla, 
								   dp.codestpro1, 
								   dp.codestpro2, 
								   dp.codestpro3, 
								   dp.codestpro4, 
								   dp.codestpro5,
								   MAX('SCO-000005-DOCINI-1') AS comprobante,
								   MAX(spg.sc_cuenta) AS sc_cuenta, 
								   MAX(ep1.estint) AS estint,
								   MAX(ep1.sc_cuenta) AS cuentaint,
								   MAX('--') AS codfuefin,
								   (
								        	SELECT count(*)
											FROM (
												  SELECT ac.spg_cuenta,
												   dp.estcla, dp.codestpro1, dp.codestpro2, dp.codestpro3, dp.codestpro4, dp.codestpro5,
												   sum(
													   CASE WHEN sigafecpar='AU' THEN dp.moncarpar 
															 WHEN sigafecpar='DI' THEN -dp.moncarpar
															 ELSE dp.moncarpar 
														END
												   ) AS monto
												FROM sco_dt_partidas_contrato dp
												INNER JOIN sco_partidas p ON p.codpartida = dp.codpartida
												INNER JOIN sco_tipo_partida tp ON tp.codtippartida = p.codtippartida
												INNER JOIN sco_unidad_tecnica_medida u ON u.codunitecmed = dp.codunipar
												INNER JOIN sigesp_cargos ac ON ac.codcar = dp.codcar AND ac.codemp = '0001'
												INNER JOIN spg_cuentas spga ON spga.spg_cuenta = ac.spg_cuenta
																   AND spga.estcla = dp.estcla																   
																   AND spga.codestpro1 = dp.codestpro1
																   AND spga.codestpro2 = dp.codestpro2
																   AND spga.codestpro3 = dp.codestpro3
																   AND spga.codestpro4 = dp.codestpro4
																   AND spga.codestpro5 = dp.codestpro5
												INNER JOIN sco_dt_documentos dc ON dc.codcont = dp.codcont
																	           AND dc.nrodoccont = '1'
												INNER JOIN sco_tipo_documento td ON td.tipdoccont = dc.tipdoccont
												WHERE dp.codcont='5'
							  					  AND dp.nrodoccont='0'
												  AND dp.moncarpar<>0
												GROUP BY ac.spg_cuenta,
												         dp.estcla, dp.codestpro1, dp.codestpro2, dp.codestpro3, dp.codestpro4, dp.codestpro5
												ORDER BY 1,2,3,4,5,6,7
											) AS car								   
								   ) AS cargo, 
								   sum(
									   CASE WHEN sigafecpar='AU' THEN dp.subtotpar 
											 WHEN sigafecpar='DI' THEN -dp.subtotpar
											 ELSE dp.subtotpar 
										END
								   ) AS monto
							FROM sco_dt_partidas_contrato dp
							INNER JOIN sco_partidas p ON p.codpartida = dp.codpartida
							INNER JOIN sco_tipo_partida tp ON tp.codtippartida = p.codtippartida
							INNER JOIN sco_unidad_tecnica_medida u ON u.codunitecmed = dp.codunipar
							INNER JOIN spg_cuentas spg ON spg.codemp = '0001'  
													  AND dp.spg_cuenta = spg.spg_cuenta  
													  AND dp.codestpro1 = spg.codestpro1  
													  AND dp.codestpro2 = spg.codestpro2  
													  AND dp.codestpro3 = spg.codestpro3  
													  AND dp.codestpro4 = spg.codestpro4  
													  AND dp.codestpro5 = spg.codestpro5  
													  AND dp.estcla = spg.estcla  
							INNER JOIN spg_ep1 ep1 ON ep1.codemp='0001' 
											      AND ep1.codestpro1=dp.codestpro1 
											      AND ep1.estcla=dp.estcla
							INNER JOIN sco_dt_documentos dc ON dc.codcont = dp.codcont
												           AND dc.nrodoccont = '1'
							INNER JOIN sco_tipo_documento td ON td.tipdoccont = dc.tipdoccont
							WHERE dp.codcont='5'
							  AND dp.nrodoccont='0'
							GROUP BY dp.spg_cuenta,
								 dp.estcla, dp.codestpro1, dp.codestpro2, dp.codestpro3, dp.codestpro4, dp.codestpro5
							UNION
							SELECT ac.spg_cuenta,
								   dp.estcla, 
								   dp.codestpro1, 
								   dp.codestpro2, 
								   dp.codestpro3, 
								   dp.codestpro4, 
								   dp.codestpro5,
								   MAX('SCO-000005-DOCINI-1') AS comprobante,
								   MAX(spg.sc_cuenta) AS sc_cuenta, 
								   MAX(ep1.estint) AS estint,
								   MAX(ep1.sc_cuenta) AS cuentaint,
								   MAX('--') AS codfuefin,
								   (
								        	SELECT count(*)
											FROM (
												  SELECT ac.spg_cuenta,
												   dp.estcla, dp.codestpro1, dp.codestpro2, dp.codestpro3, dp.codestpro4, dp.codestpro5,
												   sum(
													   CASE WHEN sigafecpar='AU' THEN dp.moncarpar 
															 WHEN sigafecpar='DI' THEN -dp.moncarpar
															 ELSE dp.moncarpar 
														END
												   ) AS monto
												FROM sco_dt_partidas_contrato dp
												INNER JOIN sco_partidas p ON p.codpartida = dp.codpartida
												INNER JOIN sco_tipo_partida tp ON tp.codtippartida = p.codtippartida
												INNER JOIN sco_unidad_tecnica_medida u ON u.codunitecmed = dp.codunipar
												INNER JOIN sigesp_cargos ac ON ac.codcar = dp.codcar AND ac.codemp = '0001'
												INNER JOIN spg_cuentas spga ON spga.spg_cuenta = ac.spg_cuenta
																   AND spga.estcla = dp.estcla																   
																   AND spga.codestpro1 = dp.codestpro1
																   AND spga.codestpro2 = dp.codestpro2
																   AND spga.codestpro3 = dp.codestpro3
																   AND spga.codestpro4 = dp.codestpro4
																   AND spga.codestpro5 = dp.codestpro5
												INNER JOIN sco_dt_documentos dc ON dc.codcont = dp.codcont
																	           AND dc.nrodoccont = '1'
												INNER JOIN sco_tipo_documento td ON td.tipdoccont = dc.tipdoccont
												WHERE dp.codcont='5'
							  					  AND dp.nrodoccont='0'
												  AND dp.moncarpar<>0
												GROUP BY ac.spg_cuenta,
												         dp.estcla, dp.codestpro1, dp.codestpro2, dp.codestpro3, dp.codestpro4, dp.codestpro5
												ORDER BY 1,2,3,4,5,6,7
											) AS car								   
								   ) AS cargo,						   
								   sum(
									   CASE WHEN sigafecpar='AU' THEN dp.moncarpar 
											 WHEN sigafecpar='DI' THEN -dp.moncarpar
											 ELSE dp.moncarpar 
										END
								   ) AS monret
							FROM sco_dt_partidas_contrato dp
							INNER JOIN sco_partidas p ON p.codpartida = dp.codpartida
							INNER JOIN sco_tipo_partida tp ON tp.codtippartida = p.codtippartida
							INNER JOIN sco_unidad_tecnica_medida u ON u.codunitecmed = dp.codunipar
							INNER JOIN sigesp_cargos ac ON ac.codcar = dp.codcar AND ac.codemp = '0001'
							INNER JOIN spg_cuentas spga ON spga.codemp = '0001'  
													   AND spga.estcla = dp.estcla																   
													   AND spga.codestpro1 = dp.codestpro1
													   AND spga.codestpro2 = dp.codestpro2
													   AND spga.codestpro3 = dp.codestpro3
													   AND spga.codestpro4 = dp.codestpro4
													   AND spga.codestpro5 = dp.codestpro5
							INNER JOIN sco_dt_documentos dc ON dc.codcont = dp.codcont
												           AND dc.nrodoccont = '1'
							INNER JOIN sco_tipo_documento td ON td.tipdoccont = dc.tipdoccont
							WHERE dp.codcont='5'
							  AND dp.nrodoccont='0'
							  AND dp.moncarpar<>0
							GROUP BY ac.spg_cuenta,
								     dp.estcla, dp.codestpro1, dp.codestpro2, dp.codestpro3, dp.codestpro4, dp.codestpro5
							ORDER BY 1,2,3,4,5,6,7
				  

13/07/2020 17:37:02  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->Recepción MÉTODO->uf_load_compromiso_sco ERROR->Invalid query: ERROR:  falta una entrada para la tabla «ep1» en la cláusula FROM
LINE 85:            MAX(ep1.estint) AS estint,
                        ^
Whole query:          SELECT dp.spg_cuenta,
								   dp.estcla, 
								   dp.codestpro1, 
								   dp.codestpro2, 
								   dp.codestpro3, 
								   dp.codestpro4, 
								   dp.codestpro5,
								   MAX('SCO-000005-DOCINI-1') AS comprobante,
								   MAX(spg.sc_cuenta) AS sc_cuenta, 
								   MAX(ep1.estint) AS estint,
								   MAX(ep1.sc_cuenta) AS cuentaint,
								   MAX('--') AS codfuefin,
								   (
								        	SELECT count(*)
											FROM (
												  SELECT ac.spg_cuenta,
												   dp.estcla, dp.codestpro1, dp.codestpro2, dp.codestpro3, dp.codestpro4, dp.codestpro5,
												   sum(
													   CASE WHEN sigafecpar='AU' THEN dp.moncarpar 
															 WHEN sigafecpar='DI' THEN -dp.moncarpar
															 ELSE dp.moncarpar 
														END
												   ) AS monto
												FROM sco_dt_partidas_contrato dp
												INNER JOIN sco_partidas p ON p.codpartida = dp.codpartida
												INNER JOIN sco_tipo_partida tp ON tp.codtippartida = p.codtippartida
												INNER JOIN sco_unidad_tecnica_medida u ON u.codunitecmed = dp.codunipar
												INNER JOIN sigesp_cargos ac ON ac.codcar = dp.codcar AND ac.codemp = '0001'
												INNER JOIN spg_cuentas spga ON spga.spg_cuenta = ac.spg_cuenta
																   AND spga.estcla = dp.estcla																   
																   AND spga.codestpro1 = dp.codestpro1
																   AND spga.codestpro2 = dp.codestpro2
																   AND spga.codestpro3 = dp.codestpro3
																   AND spga.codestpro4 = dp.codestpro4
																   AND spga.codestpro5 = dp.codestpro5
												INNER JOIN sco_dt_documentos dc ON dc.codcont = dp.codcont
																	           AND dc.nrodoccont = '1'
												INNER JOIN sco_tipo_documento td ON td.tipdoccont = dc.tipdoccont
												WHERE dp.codcont='5'
							  					  AND dp.nrodoccont='0'
												  AND dp.moncarpar<>0
												GROUP BY ac.spg_cuenta,
												         dp.estcla, dp.codestpro1, dp.codestpro2, dp.codestpro3, dp.codestpro4, dp.codestpro5
												ORDER BY 1,2,3,4,5,6,7
											) AS car								   
								   ) AS cargo, 
								   sum(
									   CASE WHEN sigafecpar='AU' THEN dp.subtotpar 
											 WHEN sigafecpar='DI' THEN -dp.subtotpar
											 ELSE dp.subtotpar 
										END
								   ) AS monto
							FROM sco_dt_partidas_contrato dp
							INNER JOIN sco_partidas p ON p.codpartida = dp.codpartida
							INNER JOIN sco_tipo_partida tp ON tp.codtippartida = p.codtippartida
							INNER JOIN sco_unidad_tecnica_medida u ON u.codunitecmed = dp.codunipar
							INNER JOIN spg_cuentas spg ON spg.codemp = '0001'  
													  AND dp.spg_cuenta = spg.spg_cuenta  
													  AND dp.codestpro1 = spg.codestpro1  
													  AND dp.codestpro2 = spg.codestpro2  
													  AND dp.codestpro3 = spg.codestpro3  
													  AND dp.codestpro4 = spg.codestpro4  
													  AND dp.codestpro5 = spg.codestpro5  
													  AND dp.estcla = spg.estcla  
							INNER JOIN spg_ep1 ep1 ON ep1.codemp='0001' 
											      AND ep1.codestpro1=dp.codestpro1 
											      AND ep1.estcla=dp.estcla
							INNER JOIN sco_dt_documentos dc ON dc.codcont = dp.codcont
												           AND dc.nrodoccont = '1'
							INNER JOIN sco_tipo_documento td ON td.tipdoccont = dc.tipdoccont
							WHERE dp.codcont='5'
							  AND dp.nrodoccont='0'
							GROUP BY dp.spg_cuenta,
								 dp.estcla, dp.codestpro1, dp.codestpro2, dp.codestpro3, dp.codestpro4, dp.codestpro5
							UNION
							SELECT ac.spg_cuenta,
								   dp.estcla, 
								   dp.codestpro1, 
								   dp.codestpro2, 
								   dp.codestpro3, 
								   dp.codestpro4, 
								   dp.codestpro5,
								   MAX('SCO-000005-DOCINI-1') AS comprobante,
								   MAX(spga.sc_cuenta) AS sc_cuenta, 
								   MAX(ep1.estint) AS estint,
								   MAX(ep1.sc_cuenta) AS cuentaint,
								   MAX('--') AS codfuefin,
								   (
								        	SELECT count(*)
											FROM (
												  SELECT ac.spg_cuenta,
												   dp.estcla, dp.codestpro1, dp.codestpro2, dp.codestpro3, dp.codestpro4, dp.codestpro5,
												   sum(
													   CASE WHEN sigafecpar='AU' THEN dp.moncarpar 
															 WHEN sigafecpar='DI' THEN -dp.moncarpar
															 ELSE dp.moncarpar 
														END
												   ) AS monto
												FROM sco_dt_partidas_contrato dp
												INNER JOIN sco_partidas p ON p.codpartida = dp.codpartida
												INNER JOIN sco_tipo_partida tp ON tp.codtippartida = p.codtippartida
												INNER JOIN sco_unidad_tecnica_medida u ON u.codunitecmed = dp.codunipar
												INNER JOIN sigesp_cargos ac ON ac.codcar = dp.codcar AND ac.codemp = '0001'
												INNER JOIN spg_cuentas spga ON spga.spg_cuenta = ac.spg_cuenta
																   AND spga.estcla = dp.estcla																   
																   AND spga.codestpro1 = dp.codestpro1
																   AND spga.codestpro2 = dp.codestpro2
																   AND spga.codestpro3 = dp.codestpro3
																   AND spga.codestpro4 = dp.codestpro4
																   AND spga.codestpro5 = dp.codestpro5
												INNER JOIN sco_dt_documentos dc ON dc.codcont = dp.codcont
																	           AND dc.nrodoccont = '1'
												INNER JOIN sco_tipo_documento td ON td.tipdoccont = dc.tipdoccont
												WHERE dp.codcont='5'
							  					  AND dp.nrodoccont='0'
												  AND dp.moncarpar<>0
												GROUP BY ac.spg_cuenta,
												         dp.estcla, dp.codestpro1, dp.codestpro2, dp.codestpro3, dp.codestpro4, dp.codestpro5
												ORDER BY 1,2,3,4,5,6,7
											) AS car								   
								   ) AS cargo,						   
								   sum(
									   CASE WHEN sigafecpar='AU' THEN dp.moncarpar 
											 WHEN sigafecpar='DI' THEN -dp.moncarpar
											 ELSE dp.moncarpar 
										END
								   ) AS monret
							FROM sco_dt_partidas_contrato dp
							INNER JOIN sco_partidas p ON p.codpartida = dp.codpartida
							INNER JOIN sco_tipo_partida tp ON tp.codtippartida = p.codtippartida
							INNER JOIN sco_unidad_tecnica_medida u ON u.codunitecmed = dp.codunipar
							INNER JOIN sigesp_cargos ac ON ac.codcar = dp.codcar AND ac.codemp = '0001'
							INNER JOIN spg_cuentas spga ON spga.codemp = '0001'  
													   AND spga.estcla = dp.estcla																   
													   AND spga.codestpro1 = dp.codestpro1
													   AND spga.codestpro2 = dp.codestpro2
													   AND spga.codestpro3 = dp.codestpro3
													   AND spga.codestpro4 = dp.codestpro4
													   AND spga.codestpro5 = dp.codestpro5
							INNER JOIN sco_dt_documentos dc ON dc.codcont = dp.codcont
												           AND dc.nrodoccont = '1'
							INNER JOIN sco_tipo_documento td ON td.tipdoccont = dc.tipdoccont
							WHERE dp.codcont='5'
							  AND dp.nrodoccont='0'
							  AND dp.moncarpar<>0
							GROUP BY ac.spg_cuenta,
								     dp.estcla, dp.codestpro1, dp.codestpro2, dp.codestpro3, dp.codestpro4, dp.codestpro5
							ORDER BY 1,2,3,4,5,6,7
				  

13/07/2020 23:29:22  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  ERROR-> Fecha Invalida.