SELECT td0.C_Orderline_ID AS ID, (COALESCE(TO_CHAR(COALESCE(TO_CHAR(td1.DocumentNo),'')),'') || ' - ' || COALESCE(TO_CHAR(TO_CHAR(td1.DateOrdered, 'DD-MM-YYYY')),'') || ' - ' || COALESCE(TO_CHAR(TO_NUMBER(td1.GrandTotal)),'') || ' - ' || COALESCE(TO_CHAR(CAST(td0.Line AS INTEGER)),'') || ' - ' || COALESCE(TO_CHAR(TO_NUMBER(td0.LineNetAmt)),'')) AS NAME, '' AS DESCRIPTION 
FROM C_Orderline td0 
left join C_Order td1 on td0.C_Order_ID = td1.C_Order_ID
AND td1.AD_Client_ID IN ('0','23C59575B9CF467C9620760EB255B389') 
AND td1.AD_Org_ID IN ('E443A31992CB4635AFCAEABE7183CE85','B843C30461EA4501935CB1D125C9C25A','19404EAD144C49A0AF37D54377CF452D','0') 
WHERE td0.AD_Client_ID IN ('0','23C59575B9CF467C9620760EB255B389') 
AND td0.AD_Org_ID IN ('E443A31992CB4635AFCAEABE7183CE85','B843C30461EA4501935CB1D125C9C25A','19404EAD144C49A0AF37D54377CF452D','0') 
AND (td0.isActive = 'Y' OR td0.C_Orderline_ID = ('0D996003B71D45628E82BA39ECDC39F1') ) 
AND td0.C_Orderline_ID=('0D996003B71D45628E82BA39ECDC39F1') ORDER BY 2, 2;