2019-11-06 12:56:42.122 CET [11049] tad@copied12194 DETAIL: parameters: $1 = '42D0EEB1C66F497A90DD526DC597E6F0', $2 = 'W', $3 = 'W', $4 = 'D82D7CC7DFF54365BE48278251E53EE7', $5 = '42D0EEB1C66F497A90DD526DC597E6F0', $6 = 'W', $7 = 'D82D7CC7DFF54365BE48278251E53EE7', $8 = 'D82D7CC7DFF54365BE48278251E53EE7', $9 = 'D82D7CC7DFF54365BE48278251E53EE7', $10 = 'W', $11 = '42D0EEB1C66F497A90DD526DC597E6F0', $12 = 'W', $13 = 'D82D7CC7DFF54365BE48278251E53EE7', $14 = '42D0EEB1C66F497A90DD526DC597E6F0', $15 = 'W', $16 = 'D82D7CC7DFF54365BE48278251E53EE7', $17 = '42D0EEB1C66F497A90DD526DC597E6F0', $18 = 'W', $19 = 'D82D7CC7DFF54365BE48278251E53EE7', $20 = 'W', $21 = 'D82D7CC7DFF54365BE48278251E53EE7' 2019-11-06 12:56:42.123 CET [11049] tad@copied12194 LOG: duration: 0.087 ms bind S_350/C_1266: select adtab0_.AD_Tab_ID as AD1_98_0_, adtab0_.AD_Client_ID as AD2_98_0_, adtab0_.AD_Org_ID as AD3_98_0_, adtab0_.IsActive as IsActive98_0_, adtab0_.Created as Created98_0_, adtab0_.CreatedBy as CreatedBy98_0_, adtab0_.Updated as Updated98_0_, adtab0_.UpdatedBy as UpdatedBy98_0_, adtab0_.Name as Name98_0_, adtab0_.Description as Descrip10_98_0_, adtab0_.Help as Help98_0_, adtab0_.AD_Table_ID as AD12_98_0_, adtab0_.AD_Window_ID as AD13_98_0_, adtab0_.SeqNo as SeqNo98_0_, adtab0_.TabLevel as TabLevel98_0_, adtab0_.IsSingleRow as IsSingl16_98_0_, adtab0_.IsInfoTab as IsInfoTab98_0_, adtab0_.IsTranslationTab as IsTrans18_98_0_, adtab0_.IsReadOnly as IsReadOnly98_0_, adtab0_.AD_Column_ID as AD20_98_0_, adtab0_.HasTree as HasTree98_0_, adtab0_.WhereClause as WhereCl22_98_0_, adtab0_.OrderByClause as OrderBy23_98_0_, adtab0_.CommitWarning as CommitW24_98_0_, adtab0_.AD_Process_ID as AD25_98_0_, adtab0_.Processing as Processing98_0_, adtab0_.AD_Image_ID as AD27_98_0_, adtab0_.ImportFields as ImportF28_98_0_, adtab0_.AD_ColumnSortOrder_ID as AD29_98_0_, adtab0_.AD_ColumnSortYesNo_ID as AD30_98_0_, adtab0_.IsSortTab as IsSortTab98_0_, adtab0_.Included_Tab_ID as Included32_98_0_, adtab0_.FilterClause as FilterC33_98_0_, adtab0_.EditReference as EditRef34_98_0_, adtab0_.AD_Module_ID as AD35_98_0_, adtab0_.UIPattern as UIPattern98_0_, adtab0_.Hqlwhereclause as Hqlwher37_98_0_, adtab0_.Hqlorderbyclause as Hqlorde38_98_0_, adtab0_.Hqlfilterclause as Hqlfilt39_98_0_, adtab0_.FilterName as FilterName98_0_, adtab0_.ShowParentButtons as ShowPar41_98_0_, adtab0_.Displaylogic as Display42_98_0_, adtab0_.AD_Table_Tree_ID as AD43_98_0_, adtab0_.Hqltreewhereclause as Hqltree44_98_0_, adtab0_.Disable_Parent_Key_Property as Disable45_98_0_, adtab0_.IsReadOnlyTree as IsReadO46_98_0_, adtab0_.IsShowTreeNodeIcons as IsShowT47_98_0_, adtab0_.DefaultTreeViewLogic as Default48_98_0_, adtab0_.EM_OBUIAPP_Selection as EM49_98_0_, adtab0_.EM_Obuiapp_Can_Add as EM50_98_0_, adtab0_.EM_Obuiapp_Can_Delete as EM51_98_0_, adtab0_.EM_Obuiapp_Show_Select as EM52_98_0_, adtab0_.EM_Obuiapp_Newfn as EM53_98_0_, adtab0_.EM_Obuiapp_Removefn as EM54_98_0_, adtab0_.EM_Obuiapp_Selection_Type as EM55_98_0_ from AD_Tab adtab0_ where adtab0_.AD_Tab_ID=$1 2019-11-06 12:56:42.123 CET [11049] tad@copied12194 DETAIL: parameters: $1 = 'D82D7CC7DFF54365BE48278251E53EE7' 2019-11-06 12:56:42.123 CET [11049] tad@copied12194 LOG: duration: 0.037 ms execute S_350/C_1266: select adtab0_.AD_Tab_ID as AD1_98_0_, adtab0_.AD_Client_ID as AD2_98_0_, adtab0_.AD_Org_ID as AD3_98_0_, adtab0_.IsActive as IsActive98_0_, adtab0_.Created as Created98_0_, adtab0_.CreatedBy as CreatedBy98_0_, adtab0_.Updated as Updated98_0_, adtab0_.UpdatedBy as UpdatedBy98_0_, adtab0_.Name as Name98_0_, adtab0_.Description as Descrip10_98_0_, adtab0_.Help as Help98_0_, adtab0_.AD_Table_ID as AD12_98_0_, adtab0_.AD_Window_ID as AD13_98_0_, adtab0_.SeqNo as SeqNo98_0_, adtab0_.TabLevel as TabLevel98_0_, adtab0_.IsSingleRow as IsSingl16_98_0_, adtab0_.IsInfoTab as IsInfoTab98_0_, adtab0_.IsTranslationTab as IsTrans18_98_0_, adtab0_.IsReadOnly as IsReadOnly98_0_, adtab0_.AD_Column_ID as AD20_98_0_, adtab0_.HasTree as HasTree98_0_, adtab0_.WhereClause as WhereCl22_98_0_, adtab0_.OrderByClause as OrderBy23_98_0_, adtab0_.CommitWarning as CommitW24_98_0_, adtab0_.AD_Process_ID as AD25_98_0_, adtab0_.Processing as Processing98_0_, adtab0_.AD_Image_ID as AD27_98_0_, adtab0_.ImportFields as ImportF28_98_0_, adtab0_.AD_ColumnSortOrder_ID as AD29_98_0_, adtab0_.AD_ColumnSortYesNo_ID as AD30_98_0_, adtab0_.IsSortTab as IsSortTab98_0_, adtab0_.Included_Tab_ID as Included32_98_0_, adtab0_.FilterClause as FilterC33_98_0_, adtab0_.EditReference as EditRef34_98_0_, adtab0_.AD_Module_ID as AD35_98_0_, adtab0_.UIPattern as UIPattern98_0_, adtab0_.Hqlwhereclause as Hqlwher37_98_0_, adtab0_.Hqlorderbyclause as Hqlorde38_98_0_, adtab0_.Hqlfilterclause as Hqlfilt39_98_0_, adtab0_.FilterName as FilterName98_0_, adtab0_.ShowParentButtons as ShowPar41_98_0_, adtab0_.Displaylogic as Display42_98_0_, adtab0_.AD_Table_Tree_ID as AD43_98_0_, adtab0_.Hqltreewhereclause as Hqltree44_98_0_, adtab0_.Disable_Parent_Key_Property as Disable45_98_0_, adtab0_.IsReadOnlyTree as IsReadO46_98_0_, adtab0_.IsShowTreeNodeIcons as IsShowT47_98_0_, adtab0_.DefaultTreeViewLogic as Default48_98_0_, adtab0_.EM_OBUIAPP_Selection as EM49_98_0_, adtab0_.EM_Obuiapp_Can_Add as EM50_98_0_, adtab0_.EM_Obuiapp_Can_Delete as EM51_98_0_, adtab0_.EM_Obuiapp_Show_Select as EM52_98_0_, adtab0_.EM_Obuiapp_Newfn as EM53_98_0_, adtab0_.EM_Obuiapp_Removefn as EM54_98_0_, adtab0_.EM_Obuiapp_Selection_Type as EM55_98_0_ from AD_Tab adtab0_ where adtab0_.AD_Tab_ID=$1 :::::: NOTA SANTI ::::: EMPIEZA QUERY INVOICEV2, no define parametro $2 que usa previo y coge el $2 anterior ::::::::: 2019-11-06 12:56:42.123 CET [11049] tad@copied12194 DETAIL: parameters: $1 = 'D82D7CC7DFF54365BE48278251E53EE7' 2019-11-06 12:56:42.125 CET [11049] tad@copied12194 LOG: duration: 0.549 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' , 'E443A31992CB4635AFCAEABE7183CE85' , 'B843C30461EA4501935CB1D125C9C25A' , 'BAE22373FEBE4CCCA24517E23F0C8A48' , 'DC206C91AA6A4897B44DA897936E0EC3' , '19404EAD144C49A0AF37D54377CF452D' , '2E60544D37534C0B89E765FE29BC0B43' , '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' , 'E443A31992CB4635AFCAEABE7183CE85' , 'B843C30461EA4501935CB1D125C9C25A' , 'BAE22373FEBE4CCCA24517E23F0C8A48' , 'DC206C91AA6A4897B44DA897936E0EC3' , '19404EAD144C49A0AF37D54377CF452D' , '2E60544D37534C0B89E765FE29BC0B43' , '7BABA5FF80494CAFA54DEBD22EC46F01')) and invoicev2x1_.C_BPartner_ID=$1 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 $2 2019-11-06 12:56:42.126 CET [11049] tad@copied12194 LOG: duration: 1.324 ms bind /C_1267: 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' , 'E443A31992CB4635AFCAEABE7183CE85' , 'B843C30461EA4501935CB1D125C9C25A' , 'BAE22373FEBE4CCCA24517E23F0C8A48' , 'DC206C91AA6A4897B44DA897936E0EC3' , '19404EAD144C49A0AF37D54377CF452D' , '2E60544D37534C0B89E765FE29BC0B43' , '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' , 'E443A31992CB4635AFCAEABE7183CE85' , 'B843C30461EA4501935CB1D125C9C25A' , 'BAE22373FEBE4CCCA24517E23F0C8A48' , 'DC206C91AA6A4897B44DA897936E0EC3' , '19404EAD144C49A0AF37D54377CF452D' , '2E60544D37534C0B89E765FE29BC0B43' , '7BABA5FF80494CAFA54DEBD22EC46F01')) and invoicev2x1_.C_BPartner_ID=$1 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 $2 2019-11-06 12:56:42.126 CET [11049] tad@copied12194 DETAIL: parameters: $1 = '', $2 = '76' 2019-11-06 12:56:42.126 CET [11049] tad@copied12194 LOG: duration: 0.023 ms execute /C_1267: 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' , 'E443A31992CB4635AFCAEABE7183CE85' , 'B843C30461EA4501935CB1D125C9C25A' , 'BAE22373FEBE4CCCA24517E23F0C8A48' , 'DC206C91AA6A4897B44DA897936E0EC3' , '19404EAD144C49A0AF37D54377CF452D' , '2E60544D37534C0B89E765FE29BC0B43' , '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' , 'E443A31992CB4635AFCAEABE7183CE85' , 'B843C30461EA4501935CB1D125C9C25A' , 'BAE22373FEBE4CCCA24517E23F0C8A48' , 'DC206C91AA6A4897B44DA897936E0EC3' , '19404EAD144C49A0AF37D54377CF452D' , '2E60544D37534C0B89E765FE29BC0B43' , '7BABA5FF80494CAFA54DEBD22EC46F01')) and invoicev2x1_.C_BPartner_ID=$1 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 $2 2019-11-06 12:56:42.126 CET [11049] tad@copied12194 DETAIL: parameters: $1 = '', $2 = '76' 2019-11-06 12:56:42.127 CET [11049] tad@copied12194 LOG: duration: 0.025 ms bind S_3: COMMIT 2019-11-06 12:56:42.128 CET [11049] tad@copied12194 LOG: duration: 0.070 ms execute S_3: COMMIT