2016-09-20 04:54:19 EDT 2016-09-19 16:13:52 EDT 86856 58/14805 324828579 LOG: duration: 499231.550 ms execute S_179802/C_179803: select materialmg0_.M_InOutLine_ID as col_0_0_, materialmg0_.AD_Org_ID as col_1_0_, materialmg0_.AD_Client_ID as col_2_0_, materialmg0_.M_Product_ID as col_3_0_, materialmg0_.C_UOM_ID as col_4_0_, materialmg0_.M_InOutLine_ID as col_5_0_, materialmg0_.MovementQty as col_6_0_, materialmg8_.C_BPartner_ID as col_7_0_, materialmg8_.DocumentNo as col_8_0_, materialmg8_.MovementDate as col_9_0_, attributes1_.M_AttributeSetInstance_ID as col_10_0_, coalesce((select sum(orderline12_.QtyOrdered) from C_OrderLine orderline12_ inner join C_Order order13_ on orderline12_.C_Order_ID=order13_.C_Order_ID where orderline12_.M_Inoutline_ID=materialmg0_.M_InOutLine_ID and order13_.Processed='Y' and order13_.DocStatus<>'VO'), 0)*-1 as col_11_0_, case when (select 'Y' from C_OrderLine orderline14_, M_InOutLine materialmg15_ where orderline14_.M_Inoutline_ID=materialmg15_.M_InOutLine_ID and orderline14_.C_Order_ID=$1 and orderline14_.M_Inoutline_ID=materialmg0_.M_InOutLine_ID) is null then false else true end as col_12_0_, materialmg0_.MovementQty-(coalesce((select orderline16_.QtyOrdered from C_OrderLine orderline16_ where orderline16_.C_Order_ID=$2 and orderline16_.M_Inoutline_ID=materialmg0_.M_InOutLine_ID), 0)*-1) as col_13_0_, (select orderline17_.C_Return_Reason_ID from C_OrderLine orderline17_, C_Return_Reason returnreas18_, M_InOutLine materialmg19_ where orderline17_.C_Return_Reason_ID=returnreas18_.C_Return_Reason_ID and orderline17_.M_Inoutline_ID=materialmg19_.M_InOutLine_ID and orderline17_.C_Order_ID=$3 and orderline17_.M_Inoutline_ID=materialmg0_.M_InOutLine_ID) as col_14_0_, coalesce((select orderline20_.C_Tax_ID from C_OrderLine orderline20_, C_Tax financialm21_, M_InOutLine materialmg22_ where orderline20_.C_Tax_ID=financialm21_.C_Tax_ID and orderline20_.M_Inoutline_ID=materialmg22_.M_InOutLine_ID and orderline20_.C_Order_ID=$4 and orderline20_.M_Inoutline_ID=materialmg0_.M_InOutLine_ID), (select orderline24_.C_Tax_ID from M_InOutLine materialmg23_, C_OrderLine orderline24_ where materialmg23_.C_OrderLine_ID=orderline24_.C_OrderLine_ID and materialmg23_.M_InOutLine_ID=materialmg0_.M_InOutLine_ID)) as col_15_0_, case when (select pricingpri26_.IsTaxIncluded from C_Order order25_, M_PriceList pricingpri26_ where order25_.M_PriceList_ID=pricingpri26_.M_PriceList_ID and order25_.C_Order_ID=$5)='Y' then coalesce((select orderline27_.PriceActual from C_OrderLine orderline27_, M_InOutLine materialmg28_ where orderline27_.M_Inoutline_ID=materialmg28_.M_InOutLine_ID and orderline27_.C_Order_ID=$6 and orderline27_.M_Inoutline_ID=materialmg0_.M_InOutLine_ID), (select orderline30_.Gross_Unit_Price from M_InOutLine materialmg29_, C_OrderLine orderline30_ where materialmg29_.C_OrderLine_ID=orderline30_.C_OrderLine_ID and materialmg29_.M_InOutLine_ID=materialmg0_.M_InOutLine_ID)) else coalesce((select orderline31_.PriceActual from C_OrderLine orderline31_, M_InOutLine materialmg32_ where orderline31_.M_Inoutline_ID=materialmg32_.M_InOutLine_ID and orderline31_.C_Order_ID=$7 and orderline31_.M_Inoutline_ID=materialmg0_.M_InOutLine_ID), (select orderline34_.PriceActual from M_InOutLine materialmg33_, C_OrderLine orderline34_ where materialmg33_.C_OrderLine_ID=orderline34_.C_OrderLine_ID and materialmg33_.M_InOutLine_ID=materialmg0_.M_InOutLine_ID)) end as col_16_0_, (select order37_.DocumentNo from M_InOutLine materialmg35_, C_OrderLine orderline36_, C_Order order37_ where materialmg35_.C_OrderLine_ID=orderline36_.C_OrderLine_ID and orderline36_.C_Order_ID=order37_.C_Order_ID and materialmg35_.M_InOutLine_ID=materialmg0_.M_InOutLine_ID) as col_17_0_, organizati4_.AD_Org_ID as AD1_558_0_, adclient5_.AD_Client_ID as AD1_30_1_, product6_.M_Product_ID as M1_601_2_, uom7_.C_UOM_ID as C1_666_3_, businesspa9_.C_BPartner_ID as C1_138_4_, attributes1_.M_AttributeSetInstance_ID as M1_131_5_, organizati4_.AD_Client_ID as AD2_558_0_, organizati4_.IsActive as IsActive558_0_, organizati4_.Created as Created558_0_, organizati4_.CreatedBy as CreatedBy558_0_, organizati4_.Updated as Updated558_0_, organizati4_.UpdatedBy as UpdatedBy558_0_, organizati4_.Value as Value558_0_, organizati4_.Name as Name558_0_, organizati4_.Description as Descrip10_558_0_, organizati4_.IsSummary as IsSummary558_0_, organizati4_.AD_Orgtype_ID as AD12_558_0_, organizati4_.IsPeriodControlAllowed as IsPerio13_558_0_, organizati4_.C_Calendar_ID as C14_558_0_, organizati4_.IsReady as IsReady558_0_, organizati4_.EM_Oez_Createfiscalcalendar as EM16_558_0_, organizati4_.Social_Name as Social17_558_0_, organizati4_.C_Currency_ID as C18_558_0_, organizati4_.EM_Oez_Ficalcalendarname as EM19_558_0_, organizati4_.EM_Oez_Assigncaltoorg as EM20_558_0_, organizati4_.C_Acctschema_ID as C21_558_0_, organizati4_.EM_Oez_Setreadyorg as EM22_558_0_, organizati4_.EM_Oez_Createobperiod as EM23_558_0_, organizati4_.EM_Oez_Intialobdate as EM24_558_0_, organizati4_.EM_Oez_Createdefacctperiod as EM25_558_0_, organizati4_.EM_Oez_Opendefacctperiod as EM26_558_0_, organizati4_.EM_Oez_Activateallacctdoc as EM27_558_0_, organizati4_.EM_Oez_Acctschema as EM28_558_0_, organizati4_.EM_Obanaly_Treeordinal as EM29_558_0_, organizati4_.EM_Obanaly_Treeparentid as EM30_558_0_, organizati4_.EM_Oez_Createwarehouse as EM31_558_0_, organizati4_.EM_Oez_Warehousekey as EM32_558_0_, organizati4_.EM_Oez_Warehousename as EM33_558_0_, organizati4_.EM_Oez_Warehouseaddress as EM34_558_0_, organizati4_.EM_Oez_Createbalancesheet as EM35_558_0_, organizati4_.EM_Oez_Balancesheetname as EM36_558_0_, organizati4_.EM_Oez_Createincomestatement as EM37_558_0_, organizati4_.EM_Oez_Incomestatementname as EM38_558_0_, organizati4_.EM_Md_Defaultbp_Orgid as EM39_558_0_, organizati4_.EM_Oez_Runconfigwizard as EM40_558_0_, organizati4_.EM_Cdms_Marketarea as EM41_558_0_, organizati4_.EM_Oez_Controldigit as EM42_558_0_, organizati4_.EM_Oez_Cash_Currency_ID as EM43_558_0_, organizati4_.Timezone as Timezone558_0_, organizati4_.EM_Oez_Bs_Acctschme_ID as EM45_558_0_, organizati4_.EM_Oez_Is_Acctschema_ID as EM46_558_0_, adclient5_.AD_Org_ID as AD2_30_1_, adclient5_.IsActive as IsActive30_1_, adclient5_.Created as Created30_1_, adclient5_.CreatedBy as CreatedBy30_1_, adclient5_.Updated as Updated30_1_, adclient5_.UpdatedBy as UpdatedBy30_1_, adclient5_.Value as Value30_1_, adclient5_.Name as Name30_1_, adclient5_.Description as Descrip10_30_1_, adclient5_.SMTPHost as SMTPHost30_1_, adclient5_.RequestEMail as Request12_30_1_, adclient5_.RequestUser as Request13_30_1_, adclient5_.RequestUserPW as Request14_30_1_, adclient5_.RequestFolder as Request15_30_1_, adclient5_.AD_Language as AD16_30_1_, adclient5_.IsMultiLingualDocument as IsMulti17_30_1_, adclient5_.IsSmtpAuthorization as IsSmtpA18_30_1_, adclient5_.C_Currency_ID as C19_30_1_, adclient5_.Acctdim_Centrally_Maintained as Acctdim20_30_1_, adclient5_.Project_Acctdim_Isenable as Project21_30_1_, adclient5_.Project_Acctdim_Header as Project22_30_1_, adclient5_.Project_Acctdim_Lines as Project23_30_1_, adclient5_.Project_Acctdim_Breakdown as Project24_30_1_, adclient5_.Bpartner_Acctdim_Isenable as Bpartner25_30_1_, adclient5_.Bpartner_Acctdim_Header as Bpartner26_30_1_, adclient5_.Bpartner_Acctdim_Lines as Bpartner27_30_1_, adclient5_.Bpartner_Acctdim_Breakdown as Bpartner28_30_1_, adclient5_.Product_Acctdim_Isenable as Product29_30_1_, adclient5_.Product_Acctdim_Header as Product30_30_1_, adclient5_.Product_Acctdim_Lines as Product31_30_1_, adclient5_.Product_Acctdim_Breakdown as Product32_30_1_, adclient5_.Costcenter_Acctdim_Header as Costcenter33_30_1_, adclient5_.Costcenter_Acctdim_Lines as Costcenter34_30_1_, adclient5_.Costcenter_Acctdim_Breakdown as Costcenter35_30_1_, adclient5_.User1_Acctdim_Isenable as User36_30_1_, adclient5_.User1_Acctdim_Header as User37_30_1_, adclient5_.User1_Acctdim_Lines as User38_30_1_, adclient5_.User1_Acctdim_Breakdown as User39_30_1_, adclient5_.User2_Acctdim_Isenable as User40_30_1_, adclient5_.User2_Acctdim_Header as User41_30_1_, adclient5_.User2_Acctdim_Lines as User42_30_1_, adclient5_.User2_Acctdim_Breakdown as User43_30_1_, adclient5_.Costcenter_Acctdim_Isenable as Costcenter44_30_1_, adclient5_.Org_Acctdim_Isenable as Org45_30_1_, adclient5_.Org_Acctdim_Header as Org46_30_1_, adclient5_.Org_Acctdim_Lines as Org47_30_1_, adclient5_.Org_Acctdim_Breakdown as Org48_30_1_, adclient5_.EM_Opcrm_Clientid_Btn as EM49_30_1_, adclient5_.EM_Opmark_Email_Treshold as EM50_30_1_, product6_.AD_Client_ID as AD2_601_2_, product6_.AD_Org_ID as AD3_601_2_, product6_.IsActive as IsActive601_2_, product6_.Created as Created601_2_, product6_.CreatedBy as CreatedBy601_2_, product6_.Updated as Updated601_2_, product6_.UpdatedBy as UpdatedBy601_2_, product6_.Value as Value601_2_, product6_.Name as Name601_2_, product6_.Description as Descrip11_601_2_, product6_.DocumentNote as Documen12_601_2_, product6_.Help as Help601_2_, product6_.UPC as UPC601_2_, product6_.SKU as SKU601_2_, product6_.C_UOM_ID as C16_601_2_, product6_.SalesRep_ID as SalesRep17_601_2_, product6_.IsSummary as IsSummary601_2_, product6_.IsStocked as IsStocked601_2_, product6_.IsPurchased as IsPurch20_601_2_, product6_.IsSold as IsSold601_2_, product6_.IsBOM as IsBOM601_2_, product6_.IsInvoicePrintDetails as IsInvoi23_601_2_, product6_.IsPickListPrintDetails as IsPickL24_601_2_, product6_.IsVerified as IsVerified601_2_, product6_.M_Product_Category_ID as M26_601_2_, product6_.Classification as Classif27_601_2_, product6_.Volume as Volume601_2_, product6_.Weight as Weight601_2_, product6_.ShelfWidth as ShelfWidth601_2_, product6_.ShelfHeight as ShelfHe31_601_2_, product6_.ShelfDepth as ShelfDepth601_2_, product6_.UnitsPerPallet as UnitsPe33_601_2_, product6_.C_TaxCategory_ID as C34_601_2_, product6_.S_Resource_ID as S35_601_2_, product6_.Discontinued as Discont36_601_2_, product6_.DiscontinuedBy as Discont37_601_2_, product6_.Processing as Processing601_2_, product6_.S_ExpenseType_ID as S39_601_2_, product6_.ProductType as Product40_601_2_, product6_.ImageURL as ImageURL601_2_, product6_.DescriptionURL as Descrip42_601_2_, product6_.GuaranteeDays as Guarant43_601_2_, product6_.VersionNo as VersionNo601_2_, product6_.M_AttributeSet_ID as M45_601_2_, product6_.M_AttributeSetInstance_ID as M46_601_2_, product6_.DownloadURL as Downloa47_601_2_, product6_.M_FreightCategory_ID as M48_601_2_, product6_.M_Locator_ID as M49_601_2_, product6_.AD_Image_ID as AD50_601_2_, product6_.C_BPartner_ID as C51_601_2_, product6_.Ispriceprinted as Isprice52_601_2_, product6_.Name2 as Name53_601_2_, product6_.Costtype as Costtype601_2_, product6_.Coststd as Coststd601_2_, product6_.Stock_Min as Stock56_601_2_, product6_.Enforce_Attribute as Enforce57_601_2_, product6_.Calculated as Calculated601_2_, product6_.MA_Processplan_ID as MA59_601_2_, product6_.Production as Production601_2_, product6_.Capacity as Capacity601_2_, product6_.Delaymin as Delaymin601_2_, product6_.MRP_Planner_ID as MRP63_601_2_, product6_.MRP_Planningmethod_ID as MRP64_601_2_, product6_.Qtymax as Qtymax601_2_, product6_.Qtymin as Qtymin601_2_, product6_.Qtystd as Qtystd601_2_, product6_.Qtytype as Qtytype601_2_, product6_.Stockmin as Stockmin601_2_, product6_.Attrsetvaluetype as Attrset70_601_2_, product6_.Isquantityvariable as Isquant71_601_2_, product6_.Isdeferredrevenue as Isdefer72_601_2_, product6_.Revplantype as Revplan73_601_2_, product6_.Periodnumber as Periodn74_601_2_, product6_.Isdeferredexpense as Isdefer75_601_2_, product6_.Expplantype as Expplan76_601_2_, product6_.Periodnumber_Exp as Periodn77_601_2_, product6_.DefaultPeriod as Default78_601_2_, product6_.DefaultPeriod_Exp as Default79_601_2_, product6_.Bookusingpoprice as Bookusi80_601_2_, product6_.M_Brand_ID as M81_601_2_, product6_.IsGeneric as IsGeneric601_2_, product6_.C_Uom_Weight_ID as C83_601_2_, product6_.Generic_Product_ID as Generic84_601_2_, product6_.CreateVariants as CreateV85_601_2_, product6_.Characteristic_Desc as Charact86_601_2_, product6_.Updateinvariants as Updatei87_601_2_, product6_.EM_Mspcp_Shape as EM88_601_2_, product6_.EM_Opcrm_Upc2 as EM89_601_2_, product6_.EM_Mspcp_Grade as EM90_601_2_, product6_.EM_Opcrm_Upc3 as EM91_601_2_, product6_.EM_Mspcp_Size1 as EM92_601_2_, product6_.EM_Opcrm_Duration as EM93_601_2_, product6_.EM_Mspcp_Size2 as EM94_601_2_, product6_.EM_Opcrm_Poname as EM95_601_2_, product6_.EM_Mspcp_Weighconvfactor as EM96_601_2_, product6_.EM_Opcrm_Pobp_ID as EM97_601_2_, product6_.EM_Mspcp_Manualpricingqty as EM98_601_2_, product6_.ManageVariants as ManageV99_601_2_, product6_.EM_Mspcp_Config as EM100_601_2_, product6_.EM_Mspcp_Size3 as EM101_601_2_, product6_.EM_Mspcp_Activateproduct as EM102_601_2_, product6_.EM_Mspcp_Addcost as EM103_601_2_, uom7_.AD_Client_ID as AD2_666_3_, uom7_.AD_Org_ID as AD3_666_3_, uom7_.IsActive as IsActive666_3_, uom7_.Created as Created666_3_, uom7_.Updated as Updated666_3_, uom7_.CreatedBy as CreatedBy666_3_, uom7_.UpdatedBy as UpdatedBy666_3_, uom7_.X12DE355 as X9_666_3_, uom7_.UOMSymbol as UOMSymbol666_3_, uom7_.Name as Name666_3_, uom7_.Description as Descrip12_666_3_, uom7_.StdPrecision as StdPrec13_666_3_, uom7_.CostingPrecision as Costing14_666_3_, uom7_.IsDefault as IsDefault666_3_, uom7_.Breakdown as Breakdown666_3_, uom7_.UOM_Type as UOM17_666_3_, uom7_.Useinproduction as Useinpr18_666_3_, businesspa9_.AD_Client_ID as AD2_138_4_, businesspa9_.AD_Org_ID as AD3_138_4_, businesspa9_.IsActive as IsActive138_4_, businesspa9_.Created as Created138_4_, businesspa9_.CreatedBy as CreatedBy138_4_, businesspa9_.Updated as Updated138_4_, businesspa9_.UpdatedBy as UpdatedBy138_4_, businesspa9_.Value as Value138_4_, businesspa9_.Name as Name138_4_, businesspa9_.Name2 as Name11_138_4_, businesspa9_.Description as Descrip12_138_4_, businesspa9_.IsSummary as IsSummary138_4_, businesspa9_.C_BP_Group_ID as C14_138_4_, businesspa9_.IsOneTime as IsOneTime138_4_, businesspa9_.IsProspect as IsProspect138_4_, businesspa9_.IsVendor as IsVendor138_4_, businesspa9_.IsCustomer as IsCustomer138_4_, businesspa9_.IsEmployee as IsEmployee138_4_, businesspa9_.IsSalesRep as IsSalesRep138_4_, businesspa9_.ReferenceNo as Referen21_138_4_, businesspa9_.DUNS as DUNS138_4_, businesspa9_.URL as URL138_4_, businesspa9_.AD_Language as AD24_138_4_, businesspa9_.TaxID as TaxID138_4_, businesspa9_.IsTaxExempt as IsTaxEx26_138_4_, businesspa9_.C_InvoiceSchedule_ID as C27_138_4_, businesspa9_.Rating as Rating138_4_, businesspa9_.SalesVolume as SalesVo29_138_4_, businesspa9_.NumberEmployees as NumberE30_138_4_, businesspa9_.NAICS as NAICS138_4_, businesspa9_.FirstSale as FirstSale138_4_, businesspa9_.AcqusitionCost as Acqusit33_138_4_, businesspa9_.PotentialLifeTimeValue as Potenti34_138_4_, businesspa9_.ActualLifeTimeValue as ActualL35_138_4_, businesspa9_.ShareOfCustomer as ShareOf36_138_4_, businesspa9_.PaymentRule as Payment37_138_4_, businesspa9_.SO_CreditLimit as SO38_138_4_, businesspa9_.SO_CreditUsed as SO39_138_4_, businesspa9_.C_PaymentTerm_ID as C40_138_4_, businesspa9_.M_PriceList_ID as M41_138_4_, businesspa9_.IsDiscountPrinted as IsDisco42_138_4_, businesspa9_.SO_Description as SO43_138_4_, businesspa9_.POReference as PORefer44_138_4_, businesspa9_.PaymentRulePO as Payment45_138_4_, businesspa9_.PO_PriceList_ID as PO46_138_4_, businesspa9_.PO_PaymentTerm_ID as PO47_138_4_, businesspa9_.DocumentCopies as Documen48_138_4_, businesspa9_.C_Greeting_ID as C49_138_4_, businesspa9_.InvoiceRule as Invoice50_138_4_, businesspa9_.DeliveryRule as Deliver51_138_4_, businesspa9_.DeliveryViaRule as Deliver52_138_4_, businesspa9_.SalesRep_ID as SalesRep53_138_4_, businesspa9_.BPartner_Parent_ID as BPartner54_138_4_, businesspa9_.SOCreditStatus as SOCredi55_138_4_, businesspa9_.AD_Forced_Org_ID as AD56_138_4_, businesspa9_.ShowPriceInOrder as ShowPri57_138_4_, businesspa9_.Invoicegrouping as Invoice58_138_4_, businesspa9_.FixMonthDay as FixMont59_138_4_, businesspa9_.FixMonthDay2 as FixMont60_138_4_, businesspa9_.Fixmonthday3 as Fixmont61_138_4_, businesspa9_.Isworker as Isworker138_4_, businesspa9_.UPC as UPC138_4_, businesspa9_.C_Salary_Category_ID as C64_138_4_, businesspa9_.Invoice_Printformat as Invoice65_138_4_, businesspa9_.Last_Days as Last66_138_4_, businesspa9_.PO_Bankaccount_ID as PO67_138_4_, businesspa9_.PO_BP_TaxCategory_ID as PO68_138_4_, businesspa9_.PO_Fixmonthday as PO69_138_4_, businesspa9_.PO_Fixmonthday2 as PO70_138_4_, businesspa9_.PO_Fixmonthday3 as PO71_138_4_, businesspa9_.SO_Bankaccount_ID as SO72_138_4_, businesspa9_.SO_Bp_Taxcategory_ID as SO73_138_4_, businesspa9_.Fiscalcode as Fiscalcode138_4_, businesspa9_.Isofiscalcode as Isofisc75_138_4_, businesspa9_.PO_C_Incoterms_ID as PO76_138_4_, businesspa9_.SO_C_Incoterms_ID as SO77_138_4_, businesspa9_.FIN_Paymentmethod_ID as FIN78_138_4_, businesspa9_.PO_Paymentmethod_ID as PO79_138_4_, businesspa9_.FIN_Financial_Account_ID as FIN80_138_4_, businesspa9_.PO_Financial_Account_ID as PO81_138_4_, businesspa9_.Customer_Blocking as Customer82_138_4_, businesspa9_.Vendor_Blocking as Vendor83_138_4_, businesspa9_.SO_Payment_Blocking as SO84_138_4_, businesspa9_.PO_Payment_Blocking as PO85_138_4_, businesspa9_.SO_Invoice_Blocking as SO86_138_4_, businesspa9_.PO_Invoice_Blocking as PO87_138_4_, businesspa9_.SO_Order_Blocking as SO88_138_4_, businesspa9_.PO_Order_Blocking as PO89_138_4_, businesspa9_.SO_Goods_Blocking as SO90_138_4_, businesspa9_.PO_Goods_Blocking as PO91_138_4_, businesspa9_.Iscashvat as Iscashvat138_4_, businesspa9_.EM_Opcrm_Bp_Email as EM93_138_4_, businesspa9_.EM_Opcrm_Bp_Type as EM94_138_4_, businesspa9_.EM_Opcrm_Bp_Industry as EM95_138_4_, businesspa9_.BP_Currency_ID as BP96_138_4_, businesspa9_.EM_Cdai_Autorderquote as EM97_138_4_, businesspa9_.EM_Opcrm_Bp_Annual_Revenue as EM98_138_4_, businesspa9_.EM_Cdai_Autinvoice as EM99_138_4_, businesspa9_.EM_Opcrm_Bp_Employees as EM100_138_4_, businesspa9_.EM_Opcrm_Bp_Sic_Code as EM101_138_4_, businesspa9_.EM_Opcrm_Bp_Ticker_Symbol as EM102_138_4_, businesspa9_.EM_Opcrm_Bp_Ownership as EM103_138_4_, businesspa9_.EM_Opcrm_Bp_Rating as EM104_138_4_, businesspa9_.EM_Opcrm_Bp_C_Campaign as EM105_138_4_, businesspa9_.EM_Opcrm_Bp_Assigned_To as EM106_138_4_, businesspa9_.EM_Opcrm_Btn_Createopp as EM107_138_4_, businesspa9_.EM_Opcrm_Btn_Createact as EM108_138_4_, businesspa9_.EM_Opcrm_Doctype_ID as EM109_138_4_, businesspa9_.EM_Opcrm_Isposdefault as EM110_138_4_, businesspa9_.EM_Opcrm_Isdealer as EM111_138_4_, businesspa9_.em_cdms_printsummary as em112_138_4_, businesspa9_.EM_Cdcom_Idlcreation as EM113_138_4_, businesspa9_.EM_CDMS_PricingMulti as EM114_138_4_, businesspa9_.EM_CDMS_CuttingMulti as EM115_138_4_, businesspa9_.EM_CDMS_DeliveryMulti as EM116_138_4_, businesspa9_.EM_CDMS_InServicesMulti as EM117_138_4_, businesspa9_.EM_CDMS_OutServicesMulti as EM118_138_4_, businesspa9_.EM_CDMS_TaxExemptExpiryDate as EM119_138_4_, businesspa9_.EM_Cdcom_Refmandatory as EM120_138_4_, businesspa9_.EM_MSCF_AutoStatement as EM121_138_4_, businesspa9_.EM_Cdms_Keymessage as EM122_138_4_, businesspa9_.Update_Currency as Update123_138_4_, attributes1_.AD_Client_ID as AD2_131_5_, attributes1_.AD_Org_ID as AD3_131_5_, attributes1_.IsActive as IsActive131_5_, attributes1_.Created as Created131_5_, attributes1_.CreatedBy as CreatedBy131_5_, attributes1_.Updated as Updated131_5_, attributes1_.UpdatedBy as UpdatedBy131_5_, attributes1_.M_AttributeSet_ID as M9_131_5_, attributes1_.SerNo as SerNo131_5_, attributes1_.Lot as Lot131_5_, attributes1_.GuaranteeDate as Guarant12_131_5_, attributes1_.Description as Descrip13_131_5_, attributes1_.M_Lot_ID as M14_131_5_, attributes1_.Islocked as Islocked131_5_, attributes1_.Lock_Description as Lock16_131_5_ from M_InOutLine materialmg0_ left outer join M_AttributeSetInstance attributes1_ on materialmg0_.M_AttributeSetInstance_ID=attributes1_.M_AttributeSetInstance_ID inner join M_InOut materialmg2_ on materialmg0_.M_InOut_ID=materialmg2_.M_InOut_ID inner join C_DocType documentty3_ on materialmg2_.C_DocType_ID=documentty3_.C_DocType_ID inner join AD_Org organizati4_ on materialmg0_.AD_Org_ID=organizati4_.AD_Org_ID inner join AD_Client adclient5_ on materialmg0_.AD_Client_ID=adclient5_.AD_Client_ID inner join M_Product product6_ on materialmg0_.M_Product_ID=product6_.M_Product_ID inner join C_UOM uom7_ on materialmg0_.C_UOM_ID=uom7_.C_UOM_ID, M_InOut materialmg8_ inner join C_BPartner businesspa9_ on materialmg8_.C_BPartner_ID=businesspa9_.C_BPartner_ID where materialmg0_.M_InOut_ID=materialmg8_.M_InOut_ID and materialmg2_.C_BPartner_ID=$8 and documentty3_.IsReturn='N' and materialmg2_.Processed='Y' and materialmg2_.DocStatus<>'VO' and materialmg2_.IsSOTrx='Y' and materialmg0_.MovementQty+coalesce((select sum(orderline38_.QtyOrdered) from C_OrderLine orderline38_ inner join C_Order order39_ on orderline38_.C_Order_ID=order39_.C_Order_ID where orderline38_.M_Inoutline_ID=materialmg0_.M_InOutLine_ID and order39_.Processed='Y' and order39_.DocStatus<>'VO'), 0)<>0 and ((select orderline41_.C_Order_Discount_ID from M_InOutLine materialmg40_ cross join C_OrderLine orderline41_, C_Order_Discount orderdisco42_ where materialmg0_.C_OrderLine_ID=orderline41_.C_OrderLine_ID and orderline41_.C_Order_Discount_ID=orderdisco42_.C_Order_Discount_ID and materialmg40_.M_InOutLine_ID=materialmg0_.M_InOutLine_ID) is null) and (materialmg0_.AD_Client_ID in ('0' , '101C8C9C4A8D4C84857E3F5FBD722757')) and (materialmg0_.AD_Org_ID in ('985325E1C95542EF91D2EA2CB46A2F76' , '442CE337BA84424CB75E0840E7DC6FEA' , '7456B6F6A691495DBE169C888CBB0244' , '0' , '8FDCADB63F5A4947A802C8281B7C4438' , '09CE37B9867B42DB8ADA553B8B5A67B4')) and (materialmg2_.MovementDate>=now()-90 or case when (select 'Y' from C_OrderLine orderline43_ where orderline43_.C_Order_ID=$9 and orderline43_.M_Inoutline_ID=materialmg0_.M_InOutLine_ID) is null then false else true end=true) order by col_12_0_ desc, col_12_0_ desc, materialmg2_.MovementDate desc, materialmg2_.DocumentNo desc, materialmg0_.Line limit $10 2016-09-20 04:54:19 EDT 2016-09-19 16:13:52 EDT 86856 58/14805 324828579 DETAIL: parameters: $1 = 'AF66C73A4DDD4580B3945162B26174BC', $2 = 'AF66C73A4DDD4580B3945162B26174BC', $3 = 'AF66C73A4DDD4580B3945162B26174BC', $4 = 'AF66C73A4DDD4580B3945162B26174BC', $5 = 'AF66C73A4DDD4580B3945162B26174BC', $6 = 'AF66C73A4DDD4580B3945162B26174BC', $7 = 'AF66C73A4DDD4580B3945162B26174BC', $8 = '48316DBD451241A091AF7022E5E57470', $9 = 'AF66C73A4DDD4580B3945162B26174BC', $10 = '101' 2016-09-20 04:55:01 EDT 2016-09-20 04:55:01 EDT