Investeam

filtro proy etapa

opcional grupo constructivo ( left join)

estado contrato issotrx Y

filtro de no entregado no depende de si hay grupo constructivo

where
cp.AD_Client_ID=$P{AD_Client_ID}
and (cp.ad_org_id=$P{AD_Org_ID} or $P{AD_Org_ID} is null )
and cp.isActive='Y'
and es.isValid='Y' and es.isActive='Y'
and (cc.tb_comiteConstruccion_ID=$P{tb_comiteConstruccion_ID} OR $P{tb_comiteConstruccion_ID} is null)

and case when $P{noEntregados}='Y' then cp.real_datepromised is null else cp.real_datepromised::date>=COALESCE
and cp.real_datepromised::date<=COALESCE end
order by 1,2,fechaEntregaReal