'' THEN 'Y' ELSE 'N' END AS useperiod, COALESCE( (SELECT MIN(io.movementdate) FROM c_invoiceline il2 JOIN m_inoutline iol ON iol.m_inoutline_id = il2.m_inoutline_id JOIN m_inout io ON io.m_inout_id = iol.m_inout_id WHERE il2.c_invoice_id = ih.c_invoice_id AND io.docstatus IN ('CO','CL')), (SELECT MIN(io.movementdate) FROM m_inout io WHERE io.c_order_id = ih.c_order_id AND io.movementtype = 'C-' AND io.docstatus IN ('CO','CL')) ) AS delivery_from, COALESCE( (SELECT MAX(io.movementdate) FROM c_invoiceline il2 JOIN m_inoutline iol ON iol.m_inoutline_id = il2.m_inoutline_id JOIN m_inout io ON io.m_inout_id = iol.m_inout_id WHERE il2.c_invoice_id = ih.c_invoice_id AND io.docstatus IN ('CO','CL')), (SELECT MAX(io.movementdate) FROM m_inout io WHERE io.c_order_id = ih.c_order_id AND io.movementtype = 'C-' AND io.docstatus IN ('CO','CL')) ) AS delivery_to FROM c_invoice_header_v ih LEFT JOIN c_invoice_header_vt iht ON iht.C_Invoice_ID=ih.C_Invoice_ID AND iht.AD_Language = $P{CURRENT_LANG} JOIN C_DocType dt ON dt.C_DocType_ID = ih.C_DocTypeTarget_ID LEFT JOIN C_DocType_Trl dtt ON dtt.C_DocType_ID = dt.C_DocType_ID AND dtt.AD_Language = $P{CURRENT_LANG} JOIN AD_Org org ON org.AD_Org_ID = ih.AD_Org_ID JOIN AD_Client cl ON cl.AD_Client_ID = org.AD_Client_ID JOIN ad_language lang ON lang.ad_language = COALESCE(ih.bp_ad_language, cl.ad_language) JOIN c_currency cur ON cur.c_currency_ID = ih.c_currency_id LEFT JOIN c_bp_group bpgrp ON bpgrp.c_bp_group_id = ih.bp_c_bp_group_id JOIN c_BPartner bp ON bp.c_bpartner_id = ih.c_bpartner_id LEFT JOIN c_order o ON o.c_order_id = ih.c_order_id LEFT JOIN c_invoice i ON i.c_invoice_id = ih.c_invoice_id LEFT JOIN ad_image img ON img.ad_image_id = ih.logo_id WHERE ih.c_invoice_id = $P{RECORD_ID}]]> 1440546523000L*/ false]]> 1]]>