select fin_paymen0_.FIN_Payment_Scheduledetail_ID as col_0_0_, (select adlist17_.Seqno from AD_Ref_List adlist17_ where adlist17_.AD_Reference_ID='575BCB88A4694C27BC013DE9C73E6FE7' and adlist17_.Value=coalesce(fin_paymen2_.Status, 'RPAP')) as col_1_0_, fin_paymen0_.FIN_Payment_Scheduledetail_ID as FIN1_223_, fin_paymen0_.AD_Client_ID as AD2_223_, fin_paymen0_.AD_Org_ID as AD3_223_, fin_paymen0_.Created as Created223_, fin_paymen0_.Createdby as Createdby223_, fin_paymen0_.Updated as Updated223_, fin_paymen0_.Updatedby as Updatedby223_, fin_paymen0_.FIN_Payment_Detail_ID as FIN8_223_, fin_paymen0_.FIN_Payment_Schedule_Order as FIN9_223_, fin_paymen0_.FIN_Payment_Schedule_Invoice as FIN10_223_, fin_paymen0_.Amount as Amount223_, fin_paymen0_.Isactive as Isactive223_, fin_paymen0_.Writeoffamt as Writeof13_223_, fin_paymen0_.Iscanceled as Iscanceled223_, fin_paymen0_.C_Bpartner_ID as C15_223_, fin_paymen0_.C_Activity_ID as C16_223_, fin_paymen0_.M_Product_ID as M17_223_, fin_paymen0_.C_Campaign_ID as C18_223_, fin_paymen0_.C_Project_ID as C19_223_, fin_paymen0_.C_Salesregion_ID as C20_223_, fin_paymen0_.C_Costcenter_ID as C21_223_, fin_paymen0_.User1_ID as User22_223_, fin_paymen0_.User2_ID as User23_223_, fin_paymen0_.DoubtfulDebt_Amount as Doubtfu24_223_, fin_paymen0_.Isinvoicepaid as Isinvoi25_223_ from FIN_Payment_ScheduleDetail fin_paymen0_ left outer join FIN_Payment_Detail fin_paymen1_ on fin_paymen0_.FIN_Payment_Detail_ID=fin_paymen1_.Fin_Payment_Detail_ID left outer join FIN_Payment fin_paymen2_ on fin_paymen1_.Fin_Payment_ID=fin_paymen2_.Fin_Payment_ID left outer join C_BPartner businesspa3_ on fin_paymen2_.C_Bpartner_ID=businesspa3_.C_BPartner_ID left outer join C_BP_Group businesspa4_ on businesspa3_.C_BP_Group_ID=businesspa4_.C_BP_Group_ID left outer join C_Project project15_ on fin_paymen2_.C_Project_ID=project15_.C_Project_ID left outer join FIN_Payment fin_paymen10_ on fin_paymen1_.Fin_Payment_ID=fin_paymen10_.Fin_Payment_ID left outer join C_Currency currency11_ on fin_paymen10_.C_Currency_ID=currency11_.C_Currency_ID left outer join FIN_Payment_Schedule fin_paymen5_ on fin_paymen0_.FIN_Payment_Schedule_Invoice=fin_paymen5_.Fin_Payment_Schedule_ID left outer join C_Invoice invoice6_ on fin_paymen5_.C_Invoice_ID=invoice6_.C_Invoice_ID left outer join C_BPartner businesspa7_ on invoice6_.C_BPartner_ID=businesspa7_.C_BPartner_ID left outer join C_BP_Group businesspa8_ on businesspa7_.C_BP_Group_ID=businesspa8_.C_BP_Group_ID left outer join C_Project project16_ on invoice6_.C_Project_ID=project16_.C_Project_ID left outer join FIN_Payment_Schedule fin_paymen12_ on fin_paymen0_.FIN_Payment_Schedule_Invoice=fin_paymen12_.Fin_Payment_Schedule_ID left outer join C_Invoice invoice13_ on fin_paymen12_.C_Invoice_ID=invoice13_.C_Invoice_ID left outer join C_Currency currency14_ on invoice13_.C_Currency_ID=currency14_.C_Currency_ID where (fin_paymen0_.FIN_Payment_Detail_ID is not null or fin_paymen5_.Fin_Payment_Schedule_ID is not null) and (fin_paymen0_.AD_Org_ID in ('9EA95F70D201418DBAE5AB252BE25C80' , 'B08C55E0521A456AB57BEBBFC8F3359D' , '451631AD2163463B8BB90B9EE8D98C0F' , '5A4120FCEEB440ADB75167D33DBC8A04' , '36875D56E8C84A69A467153448A0D45E' , '44BBB5EEA2294679AE78113B77D86C7A' , 'BB2A3DE989DA443A8623E6A2ADA0E8F5' , '5EF3C82D89A0476B85574BD024127005' , '59ABBA6B9E5A4517B91E6B5E3AF8CF56' , '23A270192CE840C88A0A29ECC9458B7E' , '605F5A85AE3D4A9788C4B2E65BDF4A51' , 'D54B415CAB694634B84BF428A80A4996' , '0' , 'B58A6F2EB3014402A59C9BD0F5AB8CA3' , 'E5197FBFDD2341C0B677FDC7FC0D849F' , 'C851B33533624C9080D32E9829211F14' , 'D8FB85462A2B4333AA69EF2A0CAEEBE2' , '344605BE465049068634804172F4C9BA' , '6B2DBB0FBCD8445FBC829EC54F54C636' , 'F6859E902EC34244A4D73744F44C28E2' , 'CF099278955D4C9CB001256CE33AB8A1' , 'AFC6749FD1D74928822E41A319E141CF')) and (fin_paymen0_.AD_Org_ID in ('9EA95F70D201418DBAE5AB252BE25C80' , 'B08C55E0521A456AB57BEBBFC8F3359D' , '451631AD2163463B8BB90B9EE8D98C0F' , '36875D56E8C84A69A467153448A0D45E' , '44BBB5EEA2294679AE78113B77D86C7A' , 'BB2A3DE989DA443A8623E6A2ADA0E8F5' , '5EF3C82D89A0476B85574BD024127005' , '23A270192CE840C88A0A29ECC9458B7E' , '59ABBA6B9E5A4517B91E6B5E3AF8CF56' , '605F5A85AE3D4A9788C4B2E65BDF4A51' , 'D54B415CAB694634B84BF428A80A4996' , 'B58A6F2EB3014402A59C9BD0F5AB8CA3' , 'E5197FBFDD2341C0B677FDC7FC0D849F' , 'D8FB85462A2B4333AA69EF2A0CAEEBE2' , '344605BE465049068634804172F4C9BA' , 'CF099278955D4C9CB001256CE33AB8A1')) and fin_paymen5_.Duedate>=$1 and fin_paymen5_.Duedate<=$2 order by col_1_0_, coalesce(fin_paymen2_.Status, 'RPAP'), fin_paymen0_.FIN_Payment_Schedule_Invoic