Where 0

Where 0=1

WITH
	Payments_tmp(srvc_ptn_id,
	payment_sum) AS 
	(	SELECT
			p.srvc_ptn_id,
			SUM(p.payment_sum) AS payment_sum 
		FROM
			clinic.payment p 
		GROUP BY
			p.srvc_ptn_id ) 
SELECT
	srvc_ptn.srvc_ptn_id,
	srvc_ptn.clcase_id,
	CASE 
		WHEN contract.cntr_id IS NOT NULL 
		THEN cntr.name_short 
		WHEN contract.ptn_id IS NOT NULL 
		THEN ptn_contract.ptn_fio 
		ELSE '' 
	END,
	CASE 
		WHEN srvc_ptn.contract_id IS NOT NULL 
		THEN '№ '||coalesce(contract.contract_num,
		'')||' от '|| 
		CASE 
			WHEN contract.contract_date IS NULL 
			THEN '' 
			ELSE CHAR(contract.contract_date,LOCAL) 
		END 
		ELSE '' 
	END,
	patient.ptn_fio,
	cliniccase.clcase_num,
	dprt.dprt_name,
	prsn.prsn_fio,
	service.service_name,
	srvc_ptn.pay_count,
	srvc_ptn.EXEC_DATE,
	srvc_ptn.sum,
	klsCurrency.ELEMENT_KLS_NAME,
	srvc_ptn.sum*srvc_ptn.pay_count,
	pt.payment_sum,
	kiPaymentkind.ELEMENT_KLS_NAME AS paymentkind_name ,
	CASE 
		WHEN pt.payment_sum < 0.00 
		THEN 1 
		WHEN COALESCE(srvc_ptn.reject_sign, 0) = 1 
		THEN 103 
		ELSE 0 
	END 
FROM
	clinic.srvc_ptn srvc_ptn 
		LEFT OUTER JOIN clinic.contract contract 
		ON contract.contract_id = srvc_ptn.contract_id 
		LEFT OUTER JOIN clinic.contractor cntr 
		ON cntr.cntr_id = contract.cntr_id 
		LEFT OUTER JOIN clinic.ptn_main ptn_contract 
		ON ptn_contract.ptn_id = contract.ptn_id 
		LEFT OUTER JOIN clinic.ptn_main patient 
		ON patient.ptn_id = srvc_ptn.ptn_id 
		LEFT OUTER JOIN clinic.cliniccase cliniccase 
		ON cliniccase.clcase_id = srvc_ptn.clcase_id 
		LEFT OUTER JOIN clinic.department dprt 
		ON dprt.dprt_id = srvc_ptn.exec_dprt_id 
		LEFT OUTER JOIN clinic.person prsn 
		ON prsn.prsn_id = srvc_ptn.exec_prsn_id 
		LEFT OUTER JOIN clinic.service service 
		ON service.service_id = srvc_ptn.service_id 
		LEFT OUTER JOIN clsdata.KLS_ITEM klsCurrency 
		ON klsCurrency.ELEMENT_KLS_ID = srvc_ptn.currency_id 
		LEFT OUTER JOIN clsdata.paymentkind klsPaymentkind 
		ON klsPaymentkind.ELEMENT_KLS_ID = srvc_ptn.paymentkind 
		LEFT OUTER JOIN clsdata.KLS_ITEM kiPaymentkind 
		ON kiPaymentkind.ELEMENT_KLS_ID = srvc_ptn.paymentkind 
		LEFT OUTER JOIN Payments_Tmp pt 
		ON pt.srvc_ptn_id = srvc_ptn.srvc_ptn_id 
WHERE  0=1