:::::: QUERY ::::::: 2019-11-06 12:13:39.417 CET [11099] tad@copied12194 DETAIL: parameters: $1 = 'D82D7CC7DFF54365BE48278251E53EE7' 2019-11-06 12:13:39.435 CET [11099] tad@copied12194 LOG: duration: 2.386 ms parse : select businesspa0_.C_BPartner_ID as C1_141_, businesspa0_.AD_Client_ID as AD2_141_, businesspa0_.AD_Org_ID as AD3_141_, businesspa0_.IsActive as IsActive141_, businesspa0_.Created as Created141_, businesspa0_.CreatedBy as CreatedBy141_, businesspa0_.Updated as Updated141_, businesspa0_.UpdatedBy as UpdatedBy141_, businesspa0_.Value as Value141_, businesspa0_.Name as Name141_, businesspa0_.Name2 as Name11_141_, businesspa0_.Description as Descrip12_141_, businesspa0_.IsSummary as IsSummary141_, businesspa0_.C_BP_Group_ID as C14_141_, businesspa0_.IsOneTime as IsOneTime141_, businesspa0_.IsProspect as IsProspect141_, businesspa0_.IsVendor as IsVendor141_, businesspa0_.IsCustomer as IsCustomer141_, businesspa0_.IsEmployee as IsEmployee141_, businesspa0_.IsSalesRep as IsSalesRep141_, businesspa0_.ReferenceNo as Referen21_141_, businesspa0_.DUNS as DUNS141_, businesspa0_.URL as URL141_, businesspa0_.AD_Language as AD24_141_, businesspa0_.TaxID as TaxID141_, businesspa0_.IsTaxExempt as IsTaxEx26_141_, businesspa0_.C_InvoiceSchedule_ID as C27_141_, businesspa0_.Rating as Rating141_, businesspa0_.SalesVolume as SalesVo29_141_, businesspa0_.NumberEmployees as NumberE30_141_, businesspa0_.NAICS as NAICS141_, businesspa0_.FirstSale as FirstSale141_, businesspa0_.AcqusitionCost as Acqusit33_141_, businesspa0_.PotentialLifeTimeValue as Potenti34_141_, businesspa0_.ActualLifeTimeValue as ActualL35_141_, businesspa0_.ShareOfCustomer as ShareOf36_141_, businesspa0_.PaymentRule as Payment37_141_, businesspa0_.SO_CreditLimit as SO38_141_, businesspa0_.SO_CreditUsed as SO39_141_, businesspa0_.C_PaymentTerm_ID as C40_141_, businesspa0_.M_PriceList_ID as M41_141_, businesspa0_.IsDiscountPrinted as IsDisco42_141_, businesspa0_.SO_Description as SO43_141_, businesspa0_.POReference as PORefer44_141_, businesspa0_.PaymentRulePO as Payment45_141_, businesspa0_.PO_PriceList_ID as PO46_141_, businesspa0_.PO_PaymentTerm_ID as PO47_141_, businesspa0_.DocumentCopies as Documen48_141_, businesspa0_.C_Greeting_ID as C49_141_, businesspa0_.InvoiceRule as Invoice50_141_, businesspa0_.DeliveryRule as Deliver51_141_, businesspa0_.DeliveryViaRule as Deliver52_141_, businesspa0_.SalesRep_ID as SalesRep53_141_, businesspa0_.BPartner_Parent_ID as BPartner54_141_, businesspa0_.SOCreditStatus as SOCredi55_141_, businesspa0_.AD_Forced_Org_ID as AD56_141_, businesspa0_.ShowPriceInOrder as ShowPri57_141_, businesspa0_.Invoicegrouping as Invoice58_141_, businesspa0_.FixMonthDay as FixMont59_141_, businesspa0_.FixMonthDay2 as FixMont60_141_, businesspa0_.Fixmonthday3 as Fixmont61_141_, businesspa0_.Isworker as Isworker141_, businesspa0_.UPC as UPC141_, businesspa0_.C_Salary_Category_ID as C64_141_, businesspa0_.Invoice_Printformat as Invoice65_141_, businesspa0_.Last_Days as Last66_141_, businesspa0_.PO_Bankaccount_ID as PO67_141_, businesspa0_.PO_BP_TaxCategory_ID as PO68_141_, businesspa0_.PO_Fixmonthday as PO69_141_, businesspa0_.PO_Fixmonthday2 as PO70_141_, businesspa0_.PO_Fixmonthday3 as PO71_141_, businesspa0_.SO_Bankaccount_ID as SO72_141_, businesspa0_.SO_Bp_Taxcategory_ID as SO73_141_, businesspa0_.Fiscalcode as Fiscalcode141_, businesspa0_.Isofiscalcode as Isofisc75_141_, businesspa0_.PO_C_Incoterms_ID as PO76_141_, businesspa0_.SO_C_Incoterms_ID as SO77_141_, businesspa0_.FIN_Paymentmethod_ID as FIN78_141_, businesspa0_.PO_Paymentmethod_ID as PO79_141_, businesspa0_.FIN_Financial_Account_ID as FIN80_141_, businesspa0_.PO_Financial_Account_ID as PO81_141_, businesspa0_.Customer_Blocking as Customer82_141_, businesspa0_.Vendor_Blocking as Vendor83_141_, businesspa0_.SO_Payment_Blocking as SO84_141_, businesspa0_.PO_Payment_Blocking as PO85_141_, businesspa0_.SO_Invoice_Blocking as SO86_141_, businesspa0_.PO_Invoice_Blocking as PO87_141_, businesspa0_.SO_Order_Blocking as SO88_141_, businesspa0_.PO_Order_Blocking as PO89_141_, businesspa0_.SO_Goods_Blocking as SO90_141_, businesspa0_.PO_Goods_Blocking as PO91_141_, businesspa0_.Iscashvat as Iscashvat141_, businesspa0_.Update_Currency as Update93_141_, businesspa0_.BP_Currency_ID as BP94_141_, businesspa0_.Birthplace as Birthplace141_, businesspa0_.Birthday as Birthday141_ from C_BPartner businesspa0_ where (businesspa0_.AD_Org_ID in ('0' , 'BAE22373FEBE4CCCA24517E23F0C8A48' , '2E60544D37534C0B89E765FE29BC0B43' , '19404EAD144C49A0AF37D54377CF452D' , '7BABA5FF80494CAFA54DEBD22EC46F01')) and (exists (select 1 from C_Invoice_V2 invoicev2x1_ inner join C_BPartner businesspa2_ on invoicev2x1_.C_BPartner_ID=businesspa2_.C_BPartner_ID where (invoicev2x1_.AD_Org_ID in ('0' , 'BAE22373FEBE4CCCA24517E23F0C8A48' , '2E60544D37534C0B89E765FE29BC0B43' , '19404EAD144C49A0AF37D54377CF452D' , '7BABA5FF80494CAFA54DEBD22EC46F01')) and businesspa2_.C_BPartner_ID=businesspa0_.C_BPartner_ID and (invoicev2x1_.AD_Org_ID in ('0' , 'E443A31992CB4635AFCAEABE7183CE85' , 'B843C30461EA4501935CB1D125C9C25A' , 'BAE22373FEBE4CCCA24517E23F0C8A48' , 'DC206C91AA6A4897B44DA897936E0EC3' , '2E60544D37534C0B89E765FE29BC0B43' , '19404EAD144C49A0AF37D54377CF452D' , '7BABA5FF80494CAFA54DEBD22EC46F01')) and (invoicev2x1_.AD_Client_ID in ('23C59575B9CF467C9620760EB255B389' , '0')))) order by businesspa0_.Name limit $1 2019-11-06 12:13:39.439 CET [11099] tad@copied12194 LOG: duration: 3.263 ms bind /C_463: select businesspa0_.C_BPartner_ID as C1_141_, businesspa0_.AD_Client_ID as AD2_141_, businesspa0_.AD_Org_ID as AD3_141_, businesspa0_.IsActive as IsActive141_, businesspa0_.Created as Created141_, businesspa0_.CreatedBy as CreatedBy141_, businesspa0_.Updated as Updated141_, businesspa0_.UpdatedBy as UpdatedBy141_, businesspa0_.Value as Value141_, businesspa0_.Name as Name141_, businesspa0_.Name2 as Name11_141_, businesspa0_.Description as Descrip12_141_, businesspa0_.IsSummary as IsSummary141_, businesspa0_.C_BP_Group_ID as C14_141_, businesspa0_.IsOneTime as IsOneTime141_, businesspa0_.IsProspect as IsProspect141_, businesspa0_.IsVendor as IsVendor141_, businesspa0_.IsCustomer as IsCustomer141_, businesspa0_.IsEmployee as IsEmployee141_, businesspa0_.IsSalesRep as IsSalesRep141_, businesspa0_.ReferenceNo as Referen21_141_, businesspa0_.DUNS as DUNS141_, businesspa0_.URL as URL141_, businesspa0_.AD_Language as AD24_141_, businesspa0_.TaxID as TaxID141_, businesspa0_.IsTaxExempt as IsTaxEx26_141_, businesspa0_.C_InvoiceSchedule_ID as C27_141_, businesspa0_.Rating as Rating141_, businesspa0_.SalesVolume as SalesVo29_141_, businesspa0_.NumberEmployees as NumberE30_141_, businesspa0_.NAICS as NAICS141_, businesspa0_.FirstSale as FirstSale141_, businesspa0_.AcqusitionCost as Acqusit33_141_, businesspa0_.PotentialLifeTimeValue as Potenti34_141_, businesspa0_.ActualLifeTimeValue as ActualL35_141_, businesspa0_.ShareOfCustomer as ShareOf36_141_, businesspa0_.PaymentRule as Payment37_141_, businesspa0_.SO_CreditLimit as SO38_141_, businesspa0_.SO_CreditUsed as SO39_141_, businesspa0_.C_PaymentTerm_ID as C40_141_, businesspa0_.M_PriceList_ID as M41_141_, businesspa0_.IsDiscountPrinted as IsDisco42_141_, businesspa0_.SO_Description as SO43_141_, businesspa0_.POReference as PORefer44_141_, businesspa0_.PaymentRulePO as Payment45_141_, businesspa0_.PO_PriceList_ID as PO46_141_, businesspa0_.PO_PaymentTerm_ID as PO47_141_, businesspa0_.DocumentCopies as Documen48_141_, businesspa0_.C_Greeting_ID as C49_141_, businesspa0_.InvoiceRule as Invoice50_141_, businesspa0_.DeliveryRule as Deliver51_141_, businesspa0_.DeliveryViaRule as Deliver52_141_, businesspa0_.SalesRep_ID as SalesRep53_141_, businesspa0_.BPartner_Parent_ID as BPartner54_141_, businesspa0_.SOCreditStatus as SOCredi55_141_, businesspa0_.AD_Forced_Org_ID as AD56_141_, businesspa0_.ShowPriceInOrder as ShowPri57_141_, businesspa0_.Invoicegrouping as Invoice58_141_, businesspa0_.FixMonthDay as FixMont59_141_, businesspa0_.FixMonthDay2 as FixMont60_141_, businesspa0_.Fixmonthday3 as Fixmont61_141_, businesspa0_.Isworker as Isworker141_, businesspa0_.UPC as UPC141_, businesspa0_.C_Salary_Category_ID as C64_141_, businesspa0_.Invoice_Printformat as Invoice65_141_, businesspa0_.Last_Days as Last66_141_, businesspa0_.PO_Bankaccount_ID as PO67_141_, businesspa0_.PO_BP_TaxCategory_ID as PO68_141_, businesspa0_.PO_Fixmonthday as PO69_141_, businesspa0_.PO_Fixmonthday2 as PO70_141_, businesspa0_.PO_Fixmonthday3 as PO71_141_, businesspa0_.SO_Bankaccount_ID as SO72_141_, businesspa0_.SO_Bp_Taxcategory_ID as SO73_141_, businesspa0_.Fiscalcode as Fiscalcode141_, businesspa0_.Isofiscalcode as Isofisc75_141_, businesspa0_.PO_C_Incoterms_ID as PO76_141_, businesspa0_.SO_C_Incoterms_ID as SO77_141_, businesspa0_.FIN_Paymentmethod_ID as FIN78_141_, businesspa0_.PO_Paymentmethod_ID as PO79_141_, businesspa0_.FIN_Financial_Account_ID as FIN80_141_, businesspa0_.PO_Financial_Account_ID as PO81_141_, businesspa0_.Customer_Blocking as Customer82_141_, businesspa0_.Vendor_Blocking as Vendor83_141_, businesspa0_.SO_Payment_Blocking as SO84_141_, businesspa0_.PO_Payment_Blocking as PO85_141_, businesspa0_.SO_Invoice_Blocking as SO86_141_, businesspa0_.PO_Invoice_Blocking as PO87_141_, businesspa0_.SO_Order_Blocking as SO88_141_, businesspa0_.PO_Order_Blocking as PO89_141_, businesspa0_.SO_Goods_Blocking as SO90_141_, businesspa0_.PO_Goods_Blocking as PO91_141_, businesspa0_.Iscashvat as Iscashvat141_, businesspa0_.Update_Currency as Update93_141_, businesspa0_.BP_Currency_ID as BP94_141_, businesspa0_.Birthplace as Birthplace141_, businesspa0_.Birthday as Birthday141_ from C_BPartner businesspa0_ where (businesspa0_.AD_Org_ID in ('0' , 'BAE22373FEBE4CCCA24517E23F0C8A48' , '2E60544D37534C0B89E765FE29BC0B43' , '19404EAD144C49A0AF37D54377CF452D' , '7BABA5FF80494CAFA54DEBD22EC46F01')) and (exists (select 1 from C_Invoice_V2 invoicev2x1_ inner join C_BPartner businesspa2_ on invoicev2x1_.C_BPartner_ID=businesspa2_.C_BPartner_ID where (invoicev2x1_.AD_Org_ID in ('0' , 'BAE22373FEBE4CCCA24517E23F0C8A48' , '2E60544D37534C0B89E765FE29BC0B43' , '19404EAD144C49A0AF37D54377CF452D' , '7BABA5FF80494CAFA54DEBD22EC46F01')) and businesspa2_.C_BPartner_ID=businesspa0_.C_BPartner_ID and (invoicev2x1_.AD_Org_ID in ('0' , 'E443A31992CB4635AFCAEABE7183CE85' , 'B843C30461EA4501935CB1D125C9C25A' , 'BAE22373FEBE4CCCA24517E23F0C8A48' , 'DC206C91AA6A4897B44DA897936E0EC3' , '2E60544D37534C0B89E765FE29BC0B43' , '19404EAD144C49A0AF37D54377CF452D' , '7BABA5FF80494CAFA54DEBD22EC46F01')) and (invoicev2x1_.AD_Client_ID in ('23C59575B9CF467C9620760EB255B389' , '0')))) order by businesspa0_.Name limit $1 2019-11-06 12:13:39.439 CET [11099] tad@copied12194 DETAIL: parameters: $1 = '76' 2019-11-06 12:13:39.585 CET [11099] tad@copied12194 LOG: duration: 145.507 ms execute /C_463: select businesspa0_.C_BPartner_ID as C1_141_, businesspa0_.AD_Client_ID as AD2_141_, businesspa0_.AD_Org_ID as AD3_141_, businesspa0_.IsActive as IsActive141_, businesspa0_.Created as Created141_, businesspa0_.CreatedBy as CreatedBy141_, businesspa0_.Updated as Updated141_, businesspa0_.UpdatedBy as UpdatedBy141_, businesspa0_.Value as Value141_, businesspa0_.Name as Name141_, businesspa0_.Name2 as Name11_141_, businesspa0_.Description as Descrip12_141_, businesspa0_.IsSummary as IsSummary141_, businesspa0_.C_BP_Group_ID as C14_141_, businesspa0_.IsOneTime as IsOneTime141_, businesspa0_.IsProspect as IsProspect141_, businesspa0_.IsVendor as IsVendor141_, businesspa0_.IsCustomer as IsCustomer141_, businesspa0_.IsEmployee as IsEmployee141_, businesspa0_.IsSalesRep as IsSalesRep141_, businesspa0_.ReferenceNo as Referen21_141_, businesspa0_.DUNS as DUNS141_, businesspa0_.URL as URL141_, businesspa0_.AD_Language as AD24_141_, businesspa0_.TaxID as TaxID141_, businesspa0_.IsTaxExempt as IsTaxEx26_141_, businesspa0_.C_InvoiceSchedule_ID as C27_141_, businesspa0_.Rating as Rating141_, businesspa0_.SalesVolume as SalesVo29_141_, businesspa0_.NumberEmployees as NumberE30_141_, businesspa0_.NAICS as NAICS141_, businesspa0_.FirstSale as FirstSale141_, businesspa0_.AcqusitionCost as Acqusit33_141_, businesspa0_.PotentialLifeTimeValue as Potenti34_141_, businesspa0_.ActualLifeTimeValue as ActualL35_141_, businesspa0_.ShareOfCustomer as ShareOf36_141_, businesspa0_.PaymentRule as Payment37_141_, businesspa0_.SO_CreditLimit as SO38_141_, businesspa0_.SO_CreditUsed as SO39_141_, businesspa0_.C_PaymentTerm_ID as C40_141_, businesspa0_.M_PriceList_ID as M41_141_, businesspa0_.IsDiscountPrinted as IsDisco42_141_, businesspa0_.SO_Description as SO43_141_, businesspa0_.POReference as PORefer44_141_, businesspa0_.PaymentRulePO as Payment45_141_, businesspa0_.PO_PriceList_ID as PO46_141_, businesspa0_.PO_PaymentTerm_ID as PO47_141_, businesspa0_.DocumentCopies as Documen48_141_, businesspa0_.C_Greeting_ID as C49_141_, businesspa0_.InvoiceRule as Invoice50_141_, businesspa0_.DeliveryRule as Deliver51_141_, businesspa0_.DeliveryViaRule as Deliver52_141_, businesspa0_.SalesRep_ID as SalesRep53_141_, businesspa0_.BPartner_Parent_ID as BPartner54_141_, businesspa0_.SOCreditStatus as SOCredi55_141_, businesspa0_.AD_Forced_Org_ID as AD56_141_, businesspa0_.ShowPriceInOrder as ShowPri57_141_, businesspa0_.Invoicegrouping as Invoice58_141_, businesspa0_.FixMonthDay as FixMont59_141_, businesspa0_.FixMonthDay2 as FixMont60_141_, businesspa0_.Fixmonthday3 as Fixmont61_141_, businesspa0_.Isworker as Isworker141_, businesspa0_.UPC as UPC141_, businesspa0_.C_Salary_Category_ID as C64_141_, businesspa0_.Invoice_Printformat as Invoice65_141_, businesspa0_.Last_Days as Last66_141_, businesspa0_.PO_Bankaccount_ID as PO67_141_, businesspa0_.PO_BP_TaxCategory_ID as PO68_141_, businesspa0_.PO_Fixmonthday as PO69_141_, businesspa0_.PO_Fixmonthday2 as PO70_141_, businesspa0_.PO_Fixmonthday3 as PO71_141_, businesspa0_.SO_Bankaccount_ID as SO72_141_, businesspa0_.SO_Bp_Taxcategory_ID as SO73_141_, businesspa0_.Fiscalcode as Fiscalcode141_, businesspa0_.Isofiscalcode as Isofisc75_141_, businesspa0_.PO_C_Incoterms_ID as PO76_141_, businesspa0_.SO_C_Incoterms_ID as SO77_141_, businesspa0_.FIN_Paymentmethod_ID as FIN78_141_, businesspa0_.PO_Paymentmethod_ID as PO79_141_, businesspa0_.FIN_Financial_Account_ID as FIN80_141_, businesspa0_.PO_Financial_Account_ID as PO81_141_, businesspa0_.Customer_Blocking as Customer82_141_, businesspa0_.Vendor_Blocking as Vendor83_141_, businesspa0_.SO_Payment_Blocking as SO84_141_, businesspa0_.PO_Payment_Blocking as PO85_141_, businesspa0_.SO_Invoice_Blocking as SO86_141_, businesspa0_.PO_Invoice_Blocking as PO87_141_, businesspa0_.SO_Order_Blocking as SO88_141_, businesspa0_.PO_Order_Blocking as PO89_141_, businesspa0_.SO_Goods_Blocking as SO90_141_, businesspa0_.PO_Goods_Blocking as PO91_141_, businesspa0_.Iscashvat as Iscashvat141_, businesspa0_.Update_Currency as Update93_141_, businesspa0_.BP_Currency_ID as BP94_141_, businesspa0_.Birthplace as Birthplace141_, businesspa0_.Birthday as Birthday141_ from C_BPartner businesspa0_ where (businesspa0_.AD_Org_ID in ('0' , 'BAE22373FEBE4CCCA24517E23F0C8A48' , '2E60544D37534C0B89E765FE29BC0B43' , '19404EAD144C49A0AF37D54377CF452D' , '7BABA5FF80494CAFA54DEBD22EC46F01')) and (exists (select 1 from C_Invoice_V2 invoicev2x1_ inner join C_BPartner businesspa2_ on invoicev2x1_.C_BPartner_ID=businesspa2_.C_BPartner_ID where (invoicev2x1_.AD_Org_ID in ('0' , 'BAE22373FEBE4CCCA24517E23F0C8A48' , '2E60544D37534C0B89E765FE29BC0B43' , '19404EAD144C49A0AF37D54377CF452D' , '7BABA5FF80494CAFA54DEBD22EC46F01')) and businesspa2_.C_BPartner_ID=businesspa0_.C_BPartner_ID and (invoicev2x1_.AD_Org_ID in ('0' , 'E443A31992CB4635AFCAEABE7183CE85' , 'B843C30461EA4501935CB1D125C9C25A' , 'BAE22373FEBE4CCCA24517E23F0C8A48' , 'DC206C91AA6A4897B44DA897936E0EC3' , '2E60544D37534C0B89E765FE29BC0B43' , '19404EAD144C49A0AF37D54377CF452D' , '7BABA5FF80494CAFA54DEBD22EC46F01')) and (invoicev2x1_.AD_Client_ID in ('23C59575B9CF467C9620760EB255B389' , '0')))) order by businesspa0_.Name limit $1 2019-11-06 12:13:39.585 CET [11099] tad@copied12194 DETAIL: parameters: $1 = '76'