La Española

categoria concepto y concepto no cumplen con esta condicion

SELECT /*distinct
hd.name as dptonomina,
ct.name AS categoryname,
(case when char_length(trim(coalesce(cb.lastname1,'') ||' '|| coalesce(cb.lastname2,'') ||' '|| coalesce(cb.firstname1,'') ||' '|| coalesce(cb.firstname2,'')))>0
then trim(coalesce(cb.lastname1,'') ||' '|| coalesce(cb.lastname2,'') ||' '|| coalesce(cb.firstname1,'') ||' '|| coalesce(cb.firstname2,'')) else cb.Name end) as nombre,
cb.taxid as cedula,
to_char(e.startdate, 'YYYY-MM-DD'::text) AS fechaingreso,
hj.name as cargo,
m.hr_movement_id,
m.HR_Concept_ID,
coalesce(m.Description,c.name) AS conceptname,
ROUND::numeric AS qty,

round(m.amount,2)::numeric AS amount,
pc.seqno,
c.seqno*/
ct.name AS catConcepto,
c.value as concepto,
m.qty,
ROUND::numeric AS qty
FROM hr_movement m
JOIN HR_Process p ON m.HR_Process_ID=p.HR_Process_ID

LEFT JOIN hr_concept_category ct ON m.hr_concept_category_ID=ct.hr_concept_category_ID
    left join HR_Department hd on hd.HR_Department_id=m.HR_Department_id and hd.isactive='Y'
    JOIN HR_Concept c ON m.HR_Concept_ID=c.HR_Concept_ID
    JOIN C_BPartner cb ON m.C_BPartner_ID=cb.C_BPartner_ID
        JOIN HR_Period pd ON pd.HR_Period_ID = p.HR_Period_ID
    JOIN hr_employee e ON m.C_BPartner_ID=e.C_BPartner_ID AND e.ad_org_id = m.ad_org_id  AND  e.startdate<=pd.enddate AND (e.EndDate isnull or e.EndDate>=pd.startdate)
    left join  HR_Job hj ON hj.HR_Job_ID=m.HR_Job_ID

LEFT JOIN C_BP_BankAccount ba ON cb.C_BPartner_ID=ba.C_BPartner_ID
    LEFT JOIN C_Bank b ON ba.C_Bank_ID=b.C_Bank_ID
    left join hr_agrupador_c_c acc on acc.HR_Concept_id=c.HR_Concept_id and acc.isactive='Y'
    left join hr_agrupador_concepto ac on ac.hr_agrupador_concepto_ID=acc.hr_agrupador_concepto_ID and ac.isactive='Y'
    left join HR_PayrollConcept pc on pc.HR_Concept_ID=c.HR_Concept_ID and pc.isactive='Y'
where p.hr_process_id=1000696 --$P{HR_Process_ID} 
and m.AD_Org_ID=1000003 --$P{AD_Org_ID}
and (case when /*$P{C_BPartner_ID}*/ 1013572 is null then 1=1 else m.C_BPartner_ID=1013572 /*$P{C_BPartner_ID}*/ end)
AND (COALESCE(m.amount,0) <>0  OR COALESCE(m.qty,0)<>0 )
/*AND (upper(ct.name) like '%INGRESOS%'
OR upper(ct.name) LIKE '%INFORMA%' AND c.value='T_TotalIngresos'
OR upper(ct.name) LIKE '%INFORMA%' AND c.value='NI_SobregiroNomina'
OR upper(ct.name) LIKE '%INFORMA%' AND c.value='T_NetoARecibirQuincena')*/
--ORDER BY nombre, pc.seqno