in the log appear the next error: -------------------------------
22:29:41.276===========> MLookupFactory.getLookup_TableDirEmbed: No Identifier records found: c_orderline_m_shipper_id [101] -------------------------------
22:29:41.566===========> MLookupFactory.getLookup_TableDirEmbed: No Identifier records found: c_orderline_user1_id [101] -------------------------------
22:29:41.617===========> MLookupFactory.getLookup_TableDirEmbed: No Identifier records found: c_order_m_shipper_id [101] -------------------------------
22:29:41.774===========> DataEngine.loadPrintData: null - ERROR: syntax error at or near ")" Position: 6551 SQL=SELECT RV_OrderDetail.IsApproved,(SELECT NVL(M_AttributeSet.Name,'1') FROM M_AttributeSet WHERE RV_OrderDetail.M_AttributeSet_ID=M_AttributeSet.M_AttributeSet_ID) AS AM_AttributeSet_ID,RV_OrderDetail.M_AttributeSet_ID AS M_AttributeSet_ID,(SELECT NVL(CAST (M_AttributeSetInstance.M_AttributeSetInstance_ID AS Text),'-1') FROM M_AttributeSetInstance WHERE RV_OrderDetail.M_AttributeSetInstance_ID=M_AttributeSetInstance.M_AttributeSetInstance_ID) AS BM_AttributeSetInstance_ID,RV_OrderDetail.M_AttributeSetInstance_ID AS M_AttributeSetInstance_ID,(SELECT NVL(C_BPartner.Name,'-1') FROM C_BPartner WHERE RV_OrderDetail.C_BPartner_ID=C_BPartner.C_BPartner_ID) AS CC_BPartner_ID,RV_OrderDetail.C_BPartner_ID AS C_BPartner_ID,RV_OrderDetail.IsCreditApproved,(SELECT NVL(C_Currency.ISO_Code,'-1') FROM C_Currency WHERE RV_OrderDetail.C_Currency_ID=C_Currency.C_Currency_ID) AS DC_Currency_ID,RV_OrderDetail.C_Currency_ID AS C_Currency_ID,RV_OrderDetail.DateOrdered,RV_OrderDetail.DatePromised,RV_OrderDetail.QtyDelivered,E.Name AS EName,RV_OrderDetail.DocAction AS DocAction,F.Name AS FName,RV_OrderDetail.DocStatus AS DocStatus,(SELECT NVL(C_DocType.Name,'-1') FROM C_DocType WHERE RV_OrderDetail.C_DocType_ID=C_DocType.C_DocType_ID) AS GC_DocType_ID,RV_OrderDetail.C_DocType_ID AS C_DocType_ID,RV_OrderDetail.IsDropShip,RV_OrderDetail.GuaranteeDate,H.Name AS HName,RV_OrderDetail.Bill_User_ID AS Bill_User_ID,I.Name AS IName,RV_OrderDetail.Bill_Location_ID AS Bill_Location_ID,RV_OrderDetail.NetAmtToInvoice,J.Value||''||J.Name AS JName,RV_OrderDetail.Bill_BPartner_ID AS Bill_BPartner_ID,(SELECT NVL((SELECT NVL(M_Product.Value,'1') ||''|| NVL(M_Product.Name,'-1') FROM M_Product WHERE M_Lot.M_Product_ID=M_Product.M_Product_ID),'-1') ||''|| NVL(M_Lot.Name,'-1') FROM M_Lot WHERE RV_OrderDetail.M_Lot_ID=M_Lot.M_Lot_ID) AS KM_Lot_ID,RV_OrderDetail.M_Lot_ID AS M_Lot_ID,RV_OrderDetail.Lot,(SELECT NVL(C_Order.DocumentNo,'-1') ||''|| NVL(CAST (C_Order.DateOrdered AS Text),'-1') FROM C_Order WHERE RV_OrderDetail.C_Order_ID=C_Order.C_Order_ID) AS LC_Order_ID,RV_OrderDetail.C_Order_ID AS C_Order_ID,RV_OrderDetail.QtyOrdered,RV_OrderDetail.POReference,(SELECT NVL(C_BPartner_Location.Name,'-1') FROM C_BPartner_Location WHERE RV_OrderDetail.C_BPartner_Location_ID=C_BPartner_Location.C_BPartner_Location_ID) AS MC_BPartner_Location_ID,RV_OrderDetail.C_BPartner_Location_ID AS C_BPartner_Location_ID,RV_OrderDetail.PriceEntered,(SELECT NVL(M_Product.Value,'-1') ||''|| NVL(M_Product.Name,'-1') FROM M_Product WHERE RV_OrderDetail.M_Product_ID=M_Product.M_Product_ID) AS NM_Product_ID,RV_OrderDetail.M_Product_ID AS M_Product_ID,RV_OrderDetail.ProductAttribute,RV_OrderDetail.QtyToDeliver,RV_OrderDetail.QtyToInvoice,RV_OrderDetail.QtyEntered,RV_OrderDetail.QtyInvoiced,RV_OrderDetail.QtyReserved,(SELECT NVL((SELECT NVL(C_Order.DocumentNo,'-1') ||''|| NVL(CAST (C_Order.DateOrdered AS Text),'-1') FROM C_Order WHERE C_OrderLine.C_Order_ID=C_Order.C_Order_ID),'-1') ||''|| NVL(CAST (C_OrderLine.Line AS Text),'-1') ||''|| NVL(CAST (C_OrderLine.LineNetAmt AS Text),'-1') FROM C_OrderLine WHERE RV_OrderDetail.C_OrderLine_ID=C_OrderLine.C_OrderLine_ID) AS OC_OrderLine_ID,RV_OrderDetail.C_OrderLine_ID AS C_OrderLine_ID,P.Name AS PName,RV_OrderDetail.SalesRep_ID AS SalesRep_ID,RV_OrderDetail.IsSOTrx,RV_OrderDetail.SerNo,RV_OrderDetail.PriceActual,(SELECT NVL(C_UOM.Name,'-1') FROM C_UOM WHERE RV_OrderDetail.C_UOM_ID=C_UOM.C_UOM_ID) AS QC_UOM_ID,RV_OrderDetail.C_UOM_ID AS C_UOM_ID,(SELECT NVL(AD_User.Name,'-1') FROM AD_User WHERE RV_OrderDetail.AD_User_ID=AD_User.AD_User_ID) AS RAD_User_ID,RV_OrderDetail.AD_User_ID AS AD_User_ID,(SELECT NVL(M_Warehouse.Name,'-1') FROM M_Warehouse WHERE RV_OrderDetail.M_Warehouse_ID=M_Warehouse.M_Warehouse_ID) AS SM_Warehouse_ID,RV_OrderDetail.M_Warehouse_ID AS M_Warehouse_ID,RV_OrderDetail.DateAcct,(SELECT NVL(C_Activity.Name,'-1') FROM C_Activity WHERE RV_OrderDetail.C_Activity_ID=C_Activity.C_Activity_ID) AS TC_Activity_ID,RV_OrderDetail.C_Activity_ID AS C_Activity_ID,RV_OrderDetail.AmountRefunded,RV_OrderDetail.AmountTendered,(SELECT NVL(C_Campaign.Name,'-1') FROM C_Campaign WHERE RV_OrderDetail.C_Campaign_ID=C_Campaign.C_Campaign_ID) AS UC_Campaign_ID,RV_OrderDetail.C_Campaign_ID AS C_Campaign_ID,(SELECT NVL((SELECT NVL(C_Cash.Name,'-1') FROM C_Cash WHERE C_CashLine.C_Cash_ID=C_Cash.C_Cash_ID),'-1') ||''|| NVL(CAST (C_CashLine.Line AS Text),'-1') ||''|| NVL(CAST (C_CashLine.Amount AS Text),'-1') FROM C_CashLine WHERE RV_OrderDetail.C_CashLine_ID=C_CashLine.C_CashLine_ID) AS VC_CashLine_ID,RV_OrderDetail.C_CashLine_ID AS C_CashLine_ID,(SELECT NVL((SELECT NVL(C_CashPlan.DocumentNo,'-1') FROM C_CashPlan WHERE C_CashPlanLine.C_CashPlan_ID=C_CashPlan.C_CashPlan_ID),'-1') ||''|| NVL(CAST (C_CashPlanLine.Line AS Text),'-1') ||'_'|| NVL(CAST (C_CashPlanLine.DateTrx AS Text),'-1') FROM C_CashPlanLine WHERE RV_OrderDetail.C_CashPlanLine_ID=C_CashPlanLine.C_CashPlanLine_ID) AS WC_CashPlanLine_ID,RV_OrderDetail.C_CashPlanLine_ID AS C_CashPlanLine_ID,RV_OrderDetail.ChargeAmt,RV_OrderDetail.CopyFrom,X.Value||''||X.Name AS XName,RV_OrderDetail.c_order_ad_org_id AS c_order_ad_org_id,Y.Value||''||Y.Name AS YName,RV_OrderDetail.c_order_ad_orgtrx_id AS c_order_ad_orgtrx_id,Z.Name AS ZName,RV_OrderDetail.c_order_c_activity_id AS c_order_c_activity_id,AA.Value||''||AA.Name AS AAName,RV_OrderDetail.c_order_c_bpartner_id AS c_order_c_bpartner_id,BB.Name AS BBName,RV_OrderDetail.c_order_c_bpartner_location_i AS c_order_c_bpartner_location_i,CC.Name AS CCName,RV_OrderDetail.c_order_c_charge_id AS c_order_c_charge_id,DD.Value||''||DD.Name AS DDName,RV_OrderDetail.c_order_c_compaign_id AS c_order_c_compaign_id,EE.Value||''||EE.Name AS EEName,RV_OrderDetail.c_order_c_project_id AS c_order_c_project_id,RV_OrderDetail.c_order_created,RV_OrderDetail.c_order_createdby,RV_OrderDetail.c_order_dateordered,RV_OrderDetail.c_order_datepromised,RV_OrderDetail.c_order_description,RV_OrderDetail.c_order_freightamt,RV_OrderDetail.c_order_isactive,FF.Value||''||FF.Name AS FFName,RV_OrderDetail.c_orderline_ad_orgtrx_id AS c_orderline_ad_orgtrx_id,GG.Name AS GGName,RV_OrderDetail.c_orderline_c_charge_id AS c_orderline_c_charge_id,HH.ISO_Code AS HHISO_Code,RV_OrderDetail.c_orderline_c_currency_id AS c_orderline_c_currency_id,RV_OrderDetail.c_orderline_description,RV_OrderDetail.c_orderline_discount,RV_OrderDetail.c_orderline_freightamt,() AS IIc_orderline_m_shipper_id,RV_OrderDetail.c_orderline_m_shipper_id AS c_orderline_m_shipper_id,RV_OrderDetail.c_orderline_processed,() AS JJc_orderline_user1_id,RV_OrderDetail.c_orderline_user1_id AS c_orderline_user1_id,KK.Value||''||KK.Name AS KKName,RV_OrderDetail.c_orderline_user2_id AS c_orderline_user2_id,() AS LLc_order_m_shipper_id,RV_OrderDetail.c_order_m_shipper_id AS c_order_m_shipper_id,MM.Name AS MMName,RV_OrderDetail.c_order_m_warehouse_id AS c_order_m_warehouse_id,RV_OrderDetail.c_order_processed,RV_OrderDetail.c_order_updated,RV_OrderDetail.c_order_updatedby,NN.Value||''||NN.Name AS NNName,RV_OrderDetail.c_order_user1_id AS c_order_user1_id,OO.Value||''||OO.Name AS OOName,RV_OrderDetail.c_order_user2_id AS c_order_user2_id,RV_OrderDetail.PriceCost,(SELECT NVL(C_ConversionType.Name,'1') FROM C_ConversionType WHERE RV_OrderDetail.C_ConversionType_ID=C_ConversionType.C_ConversionType_ID) AS PPC_ConversionType_ID,RV_OrderDetail.C_ConversionType_ID AS C_ConversionType_ID,RV_OrderDetail.DateDelivered,RV_OrderDetail.DateInvoiced,RV_OrderDetail.DatePrinted,RV_OrderDetail.IsDelivered,RV_OrderDetail.DeliveryRule,RV_OrderDetail.DeliveryViaRule,RV_OrderDetail.IsDescription,RV_OrderDetail.Discount,RV_OrderDetail.IsDiscountPrinted,RV_OrderDetail.DocumentNo,QQ.Name AS QQName,RV_OrderDetail.DropShip_User_ID AS DropShip_User_ID,RR.Name AS RRName,RV_OrderDetail.DropShip_Location_ID AS DropShip_Location_ID,SS.Value||''||SS.Name AS SSName,RV_OrderDetail.DropShip_BPartner_ID AS DropShip_BPartner_ID,(SELECT NVL(M_FreightCategory.Name,'1') FROM M_FreightCategory WHERE RV_OrderDetail.M_FreightCategory_ID=M_FreightCategory.M_FreightCategory_ID) AS TTM_FreightCategory_ID,RV_OrderDetail.M_FreightCategory_ID AS M_FreightCategory_ID,RV_OrderDetail.FreightCostRule,RV_OrderDetail.GrandTotal,RV_OrderDetail.IsInvoiced,RV_OrderDetail.InvoiceRule,RV_OrderDetail.PriceLimit,RV_OrderDetail.LineNetAmt,RV_OrderDetail.Line,UU.DocumentNo AS UUDocumentNo,RV_OrderDetail.Link_Order_ID AS Link_Order_ID,VV.Line AS VVLine,RV_OrderDetail.Link_OrderLine_ID AS Link_OrderLine_ID,RV_OrderDetail.PriceList,RV_OrderDetail.AmtLostSales,RV_OrderDetail.QtyLostSales,RV_OrderDetail.Margin,RV_OrderDetail.MarginAmt,RV_OrderDetail.m_asi_created,RV_OrderDetail.M_ASI_CreatedBy,RV_OrderDetail.m_asi_isactive,RV_OrderDetail.m_asi_updated,WW.Value||''||WW.Name AS WWName,RV_OrderDetail.M_ASI_AD_Org_ID AS M_ASI_AD_Org_ID,RV_OrderDetail.M_ASI_Description,RV_OrderDetail.M_ASI_UpdatedBy,RV_OrderDetail.OrderType,(SELECT NVL(C_Payment.DocumentNo,'-1') ||''|| NVL(CAST (C_Payment.DateTrx AS Text),'-1') ||''|| NVL(CAST (C_Payment.PayAmt AS Text),'-1') ||''|| NVL(C_Payment.A_Name,'-1') FROM C_Payment WHERE RV_OrderDetail.C_Payment_ID=C_Payment.C_Payment_ID) AS XXC_Payment_ID,RV_OrderDetail.C_Payment_ID AS C_Payment_ID,RV_OrderDetail.Pay_BPartner_ID,RV_OrderDetail.Pay_Location_ID,RV_OrderDetail.PaymentRule,(SELECT NVL(C_PaymentTerm.Name,'-1') FROM C_PaymentTerm WHERE RV_OrderDetail.C_PaymentTerm_ID=C_PaymentTerm.C_PaymentTerm_ID) AS YYC_PaymentTerm_ID,RV_OrderDetail.C_PaymentTerm_ID AS C_PaymentTerm_ID,RV_OrderDetail.IsPayScheduleValid,RV_OrderDetail.Posted,(SELECT NVL(C_POS.Name,'-1') FROM C_POS WHERE RV_OrderDetail.C_POS_ID=C_POS.C_POS_ID) AS ZZC_POS_ID,RV_OrderDetail.C_POS_ID AS C_POS_ID,RV_OrderDetail.IsTaxIncluded,(SELECT NVL(M_PriceList.Name,'-1') FROM M_PriceList WHERE RV_OrderDetail.M_PriceList_ID=M_PriceList.M_PriceList_ID) AS AAAM_PriceList_ID,RV_OrderDetail.M_PriceList_ID AS M_PriceList_ID,RV_OrderDetail.IsPrinted,RV_OrderDetail.PriorityRule,RV_OrderDetail.ProcessedOn,(SELECT NVL(C_Project.Value,'-1') ||''|| NVL(C_Project.Name,'-1') FROM C_Project WHERE RV_OrderDetail.C_Project_ID=C_Project.C_Project_ID) AS BBBC_Project_ID,RV_OrderDetail.C_Project_ID AS C_Project_ID,(SELECT NVL(CAST (C_ProjectPhase.SeqNo AS Text),'-1') ||''|| NVL(C_ProjectPhase.Name,'-1') FROM C_ProjectPhase WHERE RV_OrderDetail.C_ProjectPhase_ID=C_ProjectPhase.C_ProjectPhase_ID) AS CCCC_ProjectPhase_ID,RV_OrderDetail.C_ProjectPhase_ID AS C_ProjectPhase_ID,(SELECT NVL(CAST (C_ProjectTask.SeqNo AS Text),'-1') ||''|| NVL(C_ProjectTask.Name,'-1') FROM C_ProjectTask WHERE RV_OrderDetail.C_ProjectTask_ID=C_ProjectTask.C_ProjectTask_ID) AS DDDC_ProjectTask_ID,RV_OrderDetail.C_ProjectTask_ID AS C_ProjectTask_ID,(SELECT NVL(M_Promotion.Name,'-1') FROM M_Promotion WHERE RV_OrderDetail.M_Promotion_ID=M_Promotion.M_Promotion_ID) AS EEEM_Promotion_ID,RV_OrderDetail.M_Promotion_ID AS M_Promotion_ID,RV_OrderDetail.PromotionCode,FFF.DocumentNo AS FFFDocumentNo,RV_OrderDetail.Ref_Order_ID AS Ref_Order_ID,GGG.Line AS GGGLine,RV_OrderDetail.Ref_OrderLine_ID AS Ref_OrderLine_ID,RV_OrderDetail.S_ResourceAssignment_ID,RV_OrderDetail.RRAmt,RV_OrderDetail.RRStartDate,RV_OrderDetail.IsSelected,RV_OrderDetail.IsSelfService,RV_OrderDetail.SendEMail,HHH.Name AS HHHName,RV_OrderDetail.C_DocTypeTarget_ID AS C_DocTypeTarget_ID,(SELECT NVL(C_Tax.Name,'-1') FROM C_Tax WHERE RV_OrderDetail.C_Tax_ID=C_Tax.C_Tax_ID) AS IIIC_Tax_ID,RV_OrderDetail.C_Tax_ID AS C_Tax_ID,RV_OrderDetail.TotalLines,RV_OrderDetail.IsTransferred,RV_OrderDetail.Volume,RV_OrderDetail.Weight FROM RV_OrderDetail INNER JOIN AD_Ref_List E ON (RV_OrderDetail.DocAction=E.Value AND E.AD_Reference_ID=135) INNER JOIN AD_Ref_List F ON (RV_OrderDetail.DocStatus=F.Value AND F.AD_Reference_ID=131) LEFT OUTER JOIN AD_User H ON (RV_OrderDetail.Bill_User_ID=H.AD_User_ID) LEFT OUTER JOIN C_BPartner_Location I ON (RV_OrderDetail.Bill_Location_ID=I.C_BPartner_Location_ID) LEFT OUTER JOIN C_BPartner J ON (RV_OrderDetail.Bill_BPartner_ID=J.C_BPartner_ID) LEFT OUTER JOIN AD_User P ON (RV_OrderDetail.SalesRep_ID=P.AD_User_ID) LEFT OUTER JOIN AD_Org X ON (RV_OrderDetail.c_order_ad_org_id=X.AD_Org_ID) LEFT OUTER JOIN AD_Org Y ON (RV_OrderDetail.c_order_ad_orgtrx_id=Y.AD_Org_ID) LEFT OUTER JOIN C_Activity Z ON (RV_OrderDetail.c_order_c_activity_id=Z.C_Activity_ID) LEFT OUTER JOIN C_BPartner AA ON (RV_OrderDetail.c_order_c_bpartner_id=AA.C_BPartner_ID) LEFT OUTER JOIN C_BPartner_Location BB ON (RV_OrderDetail.c_order_c_bpartner_location_i=BB.C_BPartner_Location_ID) LEFT OUTER JOIN C_Charge CC ON (RV_OrderDetail.c_order_c_charge_id=CC.C_Charge_ID) LEFT OUTER JOIN C_Campaign DD ON (RV_OrderDetail.c_order_c_compaign_id=DD.C_Campaign_ID) LEFT OUTER JOIN C_Project EE ON (RV_OrderDetail.c_order_c_project_id=EE.C_Project_ID) LEFT OUTER JOIN AD_Org FF ON (RV_OrderDetail.c_orderline_ad_orgtrx_id=FF.AD_Org_ID) LEFT OUTER JOIN C_Charge GG ON (RV_OrderDetail.c_orderline_c_charge_id=GG.C_Charge_ID) LEFT OUTER JOIN C_Currency HH ON (RV_OrderDetail.c_orderline_c_currency_id=HH.C_Currency_ID) LEFT OUTER JOIN C_ElementValue KK ON (RV_OrderDetail.c_orderline_user2_id=KK.C_ElementValue_ID) LEFT OUTER JOIN M_Warehouse MM ON (RV_OrderDetail.c_order_m_warehouse_id=MM.M_Warehouse_ID) LEFT OUTER JOIN C_ElementValue NN ON (RV_OrderDetail.c_order_user1_id=NN.C_ElementValue_ID) LEFT OUTER JOIN C_ElementValue OO ON (RV_OrderDetail.c_order_user2_id=OO.C_ElementValue_ID) LEFT OUTER JOIN AD_User QQ ON (RV_OrderDetail.DropShip_User_ID=QQ.AD_User_ID) LEFT OUTER JOIN C_BPartner_Location RR ON (RV_OrderDetail.DropShip_Location_ID=RR.C_BPartner_Location_ID) LEFT OUTER JOIN C_BPartner SS ON (RV_OrderDetail.DropShip_BPartner_ID=SS.C_BPartner_ID) LEFT OUTER JOIN C_Order UU ON (RV_OrderDetail.Link_Order_ID=UU.C_Order_ID) LEFT OUTER JOIN C_OrderLine VV ON (RV_OrderDetail.Link_OrderLine_ID=VV.C_OrderLine_ID) LEFT OUTER JOIN AD_Org WW ON (RV_OrderDetail.M_ASI_AD_Org_ID=WW.AD_Org_ID) LEFT OUTER JOIN C_Order FFF ON (RV_OrderDetail.Ref_Order_ID=FFF.C_Order_ID) LEFT OUTER JOIN C_OrderLine GGG ON (RV_OrderDetail.Ref_OrderLine_ID=GGG.C_OrderLine_ID) LEFT OUTER JOIN C_DocType HHH ON (RV_OrderDetail.C_DocTypeTarget_ID=HHH.C_DocType_ID) WHERE RV_OrderDetail.AD_Client_ID IN(0,11) AND RV_OrderDetail.AD_Org_ID IN(50007,0,50004,50005,50006,50000,50001,50002,11,12) AND (E.AD_Ref_List_ID IS NULL OR E.AD_Ref_List_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 104 AND AD_User_ID <> 100 AND IsActive = 'Y' )) AND (F.AD_Ref_List_ID IS NULL OR F.AD_Ref_List_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 104 AND AD_User_ID <> 100 AND IsActive = 'Y' )) AND (H.AD_User_ID IS NULL OR H.AD_User_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 114 AND AD_User_ID <> 100 AND IsActive = 'Y' )) AND (I.C_BPartner_Location_ID IS NULL OR I.C_BPartner_Location_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 293 AND AD_User_ID <> 100 AND IsActive = 'Y' )) AND (J.C_BPartner_ID IS NULL OR J.C_BPartner_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 291 AND AD_User_ID <> 100 AND IsActive = 'Y' )) AND (P.AD_User_ID IS NULL OR P.AD_User_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 114 AND AD_User_ID <> 100 AND IsActive = 'Y' )) AND (X.AD_Org_ID IS NULL OR X.AD_Org_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 155 AND AD_User_ID <> 100 AND IsActive = 'Y' )) AND (Y.AD_Org_ID IS NULL OR Y.AD_Org_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 155 AND AD_User_ID <> 100 AND IsActive = 'Y' )) AND (Z.C_Activity_ID IS NULL OR Z.C_Activity_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 316 AND AD_User_ID <> 100 AND IsActive = 'Y' )) AND (AA.C_BPartner_ID IS NULL OR AA.C_BPartner_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 291 AND AD_User_ID <> 100 AND IsActive = 'Y' )) AND (BB.C_BPartner_Location_ID IS NULL OR BB.C_BPartner_Location_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 293 AND AD_User_ID <> 100 AND IsActive = 'Y' )) AND (CC.C_Charge_ID IS NULL OR CC.C_Charge_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 313 AND AD_User_ID <> 100 AND IsActive = 'Y' )) AND (DD.C_Campaign_ID IS NULL OR DD.C_Campaign_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 274 AND AD_User_ID <> 100 AND IsActive = 'Y' )) AND (EE.C_Project_ID IS NULL OR EE.C_Project_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 203 AND AD_User_ID <> 100 AND IsActive = 'Y' )) AND (FF.AD_Org_ID IS NULL OR FF.AD_Org_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 155 AND AD_User_ID <> 100 AND IsActive = 'Y' )) AND (GG.C_Charge_ID IS NULL OR GG.C_Charge_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 313 AND AD_User_ID <> 100 AND IsActive = 'Y' )) AND (HH.C_Currency_ID IS NULL OR HH.C_Currency_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 141 AND AD_User_ID <> 100 AND IsActive = 'Y' )) AND (KK.C_ElementValue_ID IS NULL OR KK.C_ElementValue_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 188 AND AD_User_ID <> 100 AND IsActive = 'Y' )) AND (MM.M_Warehouse_ID IS NULL OR MM.M_Warehouse_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 190 AND AD_User_ID <> 100 AND IsActive = 'Y' )) AND (NN.C_ElementValue_ID IS NULL OR NN.C_ElementValue_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 188 AND AD_User_ID <> 100 AND IsActive = 'Y' )) AND (OO.C_ElementValue_ID IS NULL OR OO.C_ElementValue_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 188 AND AD_User_ID <> 100 AND IsActive = 'Y' )) AND (QQ.AD_User_ID IS NULL OR QQ.AD_User_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 114 AND AD_User_ID <> 100 AND IsActive = 'Y' )) AND (RR.C_BPartner_Location_ID IS NULL OR RR.C_BPartner_Location_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 293 AND AD_User_ID <> 100 AND IsActive = 'Y' )) AND (SS.C_BPartner_ID IS NULL OR SS.C_BPartner_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 291 AND AD_User_ID <> 100 AND IsActive = 'Y' )) AND (UU.C_Order_ID IS NULL OR UU.C_Order_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 259 AND AD_User_ID <> 100 AND IsActive = 'Y' )) AND (VV.C_OrderLine_ID IS NULL OR VV.C_OrderLine_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 260 AND AD_User_ID <> 100 AND IsActive = 'Y' )) AND (WW.AD_Org_ID IS NULL OR WW.AD_Org_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 155 AND AD_User_ID <> 100 AND IsActive = 'Y' )) AND (FFF.C_Order_ID IS NULL OR FFF.C_Order_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 259 AND AD_User_ID <> 100 AND IsActive = 'Y' )) AND (GGG.C_OrderLine_ID IS NULL OR GGG.C_OrderLine_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 260 AND AD_User_ID <> 100 AND IsActive = 'Y' )) AND (HHH.C_DocType_ID IS NULL OR HHH.C_DocType_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 217 AND AD_User_ID <> 100 AND IsActive = 'Y' )) [101]
1. exceute report without any parameters
2. report doesnt show any information
in the log appear the next error:
------------------------------- 22:29:41.276===========> MLookupFactory.getLookup_TableDirEmbed: No Identifier records found: c_orderline_m_shipper_id [101]
------------------------------- 22:29:41.566===========> MLookupFactory.getLookup_TableDirEmbed: No Identifier records found: c_orderline_user1_id [101]
------------------------------- 22:29:41.617===========> MLookupFactory.getLookup_TableDirEmbed: No Identifier records found: c_order_m_shipper_id [101]
------------------------------- 22:29:41.774===========> DataEngine.loadPrintData: null - ERROR: syntax error at or near ")"
Position: 6551
SQL=SELECT RV_OrderDetail.IsApproved,(SELECT NVL(M_AttributeSet.Name,'1') FROM M_AttributeSet WHERE RV_OrderDetail.M_AttributeSet_ID=M_AttributeSet.M_AttributeSet_ID) AS AM_AttributeSet_ID,RV_OrderDetail.M_AttributeSet_ID AS M_AttributeSet_ID,(SELECT NVL(CAST (M_AttributeSetInstance.M_AttributeSetInstance_ID AS Text),'-1') FROM M_AttributeSetInstance WHERE RV_OrderDetail.M_AttributeSetInstance_ID=M_AttributeSetInstance.M_AttributeSetInstance_ID) AS BM_AttributeSetInstance_ID,RV_OrderDetail.M_AttributeSetInstance_ID AS M_AttributeSetInstance_ID,(SELECT NVL(C_BPartner.Name,'-1') FROM C_BPartner WHERE RV_OrderDetail.C_BPartner_ID=C_BPartner.C_BPartner_ID) AS CC_BPartner_ID,RV_OrderDetail.C_BPartner_ID AS C_BPartner_ID,RV_OrderDetail.IsCreditApproved,(SELECT NVL(C_Currency.ISO_Code,'-1') FROM C_Currency WHERE RV_OrderDetail.C_Currency_ID=C_Currency.C_Currency_ID) AS DC_Currency_ID,RV_OrderDetail.C_Currency_ID AS C_Currency_ID,RV_OrderDetail.DateOrdered,RV_OrderDetail.DatePromised,RV_OrderDetail.QtyDelivered,E.Name AS EName,RV_OrderDetail.DocAction AS DocAction,F.Name AS FName,RV_OrderDetail.DocStatus AS DocStatus,(SELECT NVL(C_DocType.Name,'-1') FROM C_DocType WHERE RV_OrderDetail.C_DocType_ID=C_DocType.C_DocType_ID) AS GC_DocType_ID,RV_OrderDetail.C_DocType_ID AS C_DocType_ID,RV_OrderDetail.IsDropShip,RV_OrderDetail.GuaranteeDate,H.Name AS HName,RV_OrderDetail.Bill_User_ID AS Bill_User_ID,I.Name AS IName,RV_OrderDetail.Bill_Location_ID AS Bill_Location_ID,RV_OrderDetail.NetAmtToInvoice,J.Value||''||J.Name AS JName,RV_OrderDetail.Bill_BPartner_ID AS Bill_BPartner_ID,(SELECT NVL((SELECT NVL(M_Product.Value,'1') ||''|| NVL(M_Product.Name,'-1') FROM M_Product WHERE M_Lot.M_Product_ID=M_Product.M_Product_ID),'-1') ||''|| NVL(M_Lot.Name,'-1') FROM M_Lot WHERE RV_OrderDetail.M_Lot_ID=M_Lot.M_Lot_ID) AS KM_Lot_ID,RV_OrderDetail.M_Lot_ID AS M_Lot_ID,RV_OrderDetail.Lot,(SELECT NVL(C_Order.DocumentNo,'-1') ||''|| NVL(CAST (C_Order.DateOrdered AS Text),'-1') FROM C_Order WHERE RV_OrderDetail.C_Order_ID=C_Order.C_Order_ID) AS LC_Order_ID,RV_OrderDetail.C_Order_ID AS C_Order_ID,RV_OrderDetail.QtyOrdered,RV_OrderDetail.POReference,(SELECT NVL(C_BPartner_Location.Name,'-1') FROM C_BPartner_Location WHERE RV_OrderDetail.C_BPartner_Location_ID=C_BPartner_Location.C_BPartner_Location_ID) AS MC_BPartner_Location_ID,RV_OrderDetail.C_BPartner_Location_ID AS C_BPartner_Location_ID,RV_OrderDetail.PriceEntered,(SELECT NVL(M_Product.Value,'-1') ||''|| NVL(M_Product.Name,'-1') FROM M_Product WHERE RV_OrderDetail.M_Product_ID=M_Product.M_Product_ID) AS NM_Product_ID,RV_OrderDetail.M_Product_ID AS M_Product_ID,RV_OrderDetail.ProductAttribute,RV_OrderDetail.QtyToDeliver,RV_OrderDetail.QtyToInvoice,RV_OrderDetail.QtyEntered,RV_OrderDetail.QtyInvoiced,RV_OrderDetail.QtyReserved,(SELECT NVL((SELECT NVL(C_Order.DocumentNo,'-1') ||''|| NVL(CAST (C_Order.DateOrdered AS Text),'-1') FROM C_Order WHERE C_OrderLine.C_Order_ID=C_Order.C_Order_ID),'-1') ||''|| NVL(CAST (C_OrderLine.Line AS Text),'-1') ||''|| NVL(CAST (C_OrderLine.LineNetAmt AS Text),'-1') FROM C_OrderLine WHERE RV_OrderDetail.C_OrderLine_ID=C_OrderLine.C_OrderLine_ID) AS OC_OrderLine_ID,RV_OrderDetail.C_OrderLine_ID AS C_OrderLine_ID,P.Name AS PName,RV_OrderDetail.SalesRep_ID AS SalesRep_ID,RV_OrderDetail.IsSOTrx,RV_OrderDetail.SerNo,RV_OrderDetail.PriceActual,(SELECT NVL(C_UOM.Name,'-1') FROM C_UOM WHERE RV_OrderDetail.C_UOM_ID=C_UOM.C_UOM_ID) AS QC_UOM_ID,RV_OrderDetail.C_UOM_ID AS C_UOM_ID,(SELECT NVL(AD_User.Name,'-1') FROM AD_User WHERE RV_OrderDetail.AD_User_ID=AD_User.AD_User_ID) AS RAD_User_ID,RV_OrderDetail.AD_User_ID AS AD_User_ID,(SELECT NVL(M_Warehouse.Name,'-1') FROM M_Warehouse WHERE RV_OrderDetail.M_Warehouse_ID=M_Warehouse.M_Warehouse_ID) AS SM_Warehouse_ID,RV_OrderDetail.M_Warehouse_ID AS M_Warehouse_ID,RV_OrderDetail.DateAcct,(SELECT NVL(C_Activity.Name,'-1') FROM C_Activity WHERE RV_OrderDetail.C_Activity_ID=C_Activity.C_Activity_ID) AS TC_Activity_ID,RV_OrderDetail.C_Activity_ID AS C_Activity_ID,RV_OrderDetail.AmountRefunded,RV_OrderDetail.AmountTendered,(SELECT NVL(C_Campaign.Name,'-1') FROM C_Campaign WHERE RV_OrderDetail.C_Campaign_ID=C_Campaign.C_Campaign_ID) AS UC_Campaign_ID,RV_OrderDetail.C_Campaign_ID AS C_Campaign_ID,(SELECT NVL((SELECT NVL(C_Cash.Name,'-1') FROM C_Cash WHERE C_CashLine.C_Cash_ID=C_Cash.C_Cash_ID),'-1') ||''|| NVL(CAST (C_CashLine.Line AS Text),'-1') ||''|| NVL(CAST (C_CashLine.Amount AS Text),'-1') FROM C_CashLine WHERE RV_OrderDetail.C_CashLine_ID=C_CashLine.C_CashLine_ID) AS VC_CashLine_ID,RV_OrderDetail.C_CashLine_ID AS C_CashLine_ID,(SELECT NVL((SELECT NVL(C_CashPlan.DocumentNo,'-1') FROM C_CashPlan WHERE C_CashPlanLine.C_CashPlan_ID=C_CashPlan.C_CashPlan_ID),'-1') ||''|| NVL(CAST (C_CashPlanLine.Line AS Text),'-1') ||'_'|| NVL(CAST (C_CashPlanLine.DateTrx AS Text),'-1') FROM C_CashPlanLine WHERE RV_OrderDetail.C_CashPlanLine_ID=C_CashPlanLine.C_CashPlanLine_ID) AS WC_CashPlanLine_ID,RV_OrderDetail.C_CashPlanLine_ID AS C_CashPlanLine_ID,RV_OrderDetail.ChargeAmt,RV_OrderDetail.CopyFrom,X.Value||''||X.Name AS XName,RV_OrderDetail.c_order_ad_org_id AS c_order_ad_org_id,Y.Value||''||Y.Name AS YName,RV_OrderDetail.c_order_ad_orgtrx_id AS c_order_ad_orgtrx_id,Z.Name AS ZName,RV_OrderDetail.c_order_c_activity_id AS c_order_c_activity_id,AA.Value||''||AA.Name AS AAName,RV_OrderDetail.c_order_c_bpartner_id AS c_order_c_bpartner_id,BB.Name AS BBName,RV_OrderDetail.c_order_c_bpartner_location_i AS c_order_c_bpartner_location_i,CC.Name AS CCName,RV_OrderDetail.c_order_c_charge_id AS c_order_c_charge_id,DD.Value||''||DD.Name AS DDName,RV_OrderDetail.c_order_c_compaign_id AS c_order_c_compaign_id,EE.Value||''||EE.Name AS EEName,RV_OrderDetail.c_order_c_project_id AS c_order_c_project_id,RV_OrderDetail.c_order_created,RV_OrderDetail.c_order_createdby,RV_OrderDetail.c_order_dateordered,RV_OrderDetail.c_order_datepromised,RV_OrderDetail.c_order_description,RV_OrderDetail.c_order_freightamt,RV_OrderDetail.c_order_isactive,FF.Value||''||FF.Name AS FFName,RV_OrderDetail.c_orderline_ad_orgtrx_id AS c_orderline_ad_orgtrx_id,GG.Name AS GGName,RV_OrderDetail.c_orderline_c_charge_id AS c_orderline_c_charge_id,HH.ISO_Code AS HHISO_Code,RV_OrderDetail.c_orderline_c_currency_id AS c_orderline_c_currency_id,RV_OrderDetail.c_orderline_description,RV_OrderDetail.c_orderline_discount,RV_OrderDetail.c_orderline_freightamt,() AS IIc_orderline_m_shipper_id,RV_OrderDetail.c_orderline_m_shipper_id AS c_orderline_m_shipper_id,RV_OrderDetail.c_orderline_processed,() AS JJc_orderline_user1_id,RV_OrderDetail.c_orderline_user1_id AS c_orderline_user1_id,KK.Value||''||KK.Name AS KKName,RV_OrderDetail.c_orderline_user2_id AS c_orderline_user2_id,() AS LLc_order_m_shipper_id,RV_OrderDetail.c_order_m_shipper_id AS c_order_m_shipper_id,MM.Name AS MMName,RV_OrderDetail.c_order_m_warehouse_id AS c_order_m_warehouse_id,RV_OrderDetail.c_order_processed,RV_OrderDetail.c_order_updated,RV_OrderDetail.c_order_updatedby,NN.Value||''||NN.Name AS NNName,RV_OrderDetail.c_order_user1_id AS c_order_user1_id,OO.Value||''||OO.Name AS OOName,RV_OrderDetail.c_order_user2_id AS c_order_user2_id,RV_OrderDetail.PriceCost,(SELECT NVL(C_ConversionType.Name,'1') FROM C_ConversionType WHERE RV_OrderDetail.C_ConversionType_ID=C_ConversionType.C_ConversionType_ID) AS PPC_ConversionType_ID,RV_OrderDetail.C_ConversionType_ID AS C_ConversionType_ID,RV_OrderDetail.DateDelivered,RV_OrderDetail.DateInvoiced,RV_OrderDetail.DatePrinted,RV_OrderDetail.IsDelivered,RV_OrderDetail.DeliveryRule,RV_OrderDetail.DeliveryViaRule,RV_OrderDetail.IsDescription,RV_OrderDetail.Discount,RV_OrderDetail.IsDiscountPrinted,RV_OrderDetail.DocumentNo,QQ.Name AS QQName,RV_OrderDetail.DropShip_User_ID AS DropShip_User_ID,RR.Name AS RRName,RV_OrderDetail.DropShip_Location_ID AS DropShip_Location_ID,SS.Value||''||SS.Name AS SSName,RV_OrderDetail.DropShip_BPartner_ID AS DropShip_BPartner_ID,(SELECT NVL(M_FreightCategory.Name,'1') FROM M_FreightCategory WHERE RV_OrderDetail.M_FreightCategory_ID=M_FreightCategory.M_FreightCategory_ID) AS TTM_FreightCategory_ID,RV_OrderDetail.M_FreightCategory_ID AS M_FreightCategory_ID,RV_OrderDetail.FreightCostRule,RV_OrderDetail.GrandTotal,RV_OrderDetail.IsInvoiced,RV_OrderDetail.InvoiceRule,RV_OrderDetail.PriceLimit,RV_OrderDetail.LineNetAmt,RV_OrderDetail.Line,UU.DocumentNo AS UUDocumentNo,RV_OrderDetail.Link_Order_ID AS Link_Order_ID,VV.Line AS VVLine,RV_OrderDetail.Link_OrderLine_ID AS Link_OrderLine_ID,RV_OrderDetail.PriceList,RV_OrderDetail.AmtLostSales,RV_OrderDetail.QtyLostSales,RV_OrderDetail.Margin,RV_OrderDetail.MarginAmt,RV_OrderDetail.m_asi_created,RV_OrderDetail.M_ASI_CreatedBy,RV_OrderDetail.m_asi_isactive,RV_OrderDetail.m_asi_updated,WW.Value||''||WW.Name AS WWName,RV_OrderDetail.M_ASI_AD_Org_ID AS M_ASI_AD_Org_ID,RV_OrderDetail.M_ASI_Description,RV_OrderDetail.M_ASI_UpdatedBy,RV_OrderDetail.OrderType,(SELECT NVL(C_Payment.DocumentNo,'-1') ||''|| NVL(CAST (C_Payment.DateTrx AS Text),'-1') ||''|| NVL(CAST (C_Payment.PayAmt AS Text),'-1') ||''|| NVL(C_Payment.A_Name,'-1') FROM C_Payment WHERE RV_OrderDetail.C_Payment_ID=C_Payment.C_Payment_ID) AS XXC_Payment_ID,RV_OrderDetail.C_Payment_ID AS C_Payment_ID,RV_OrderDetail.Pay_BPartner_ID,RV_OrderDetail.Pay_Location_ID,RV_OrderDetail.PaymentRule,(SELECT NVL(C_PaymentTerm.Name,'-1') FROM C_PaymentTerm WHERE RV_OrderDetail.C_PaymentTerm_ID=C_PaymentTerm.C_PaymentTerm_ID) AS YYC_PaymentTerm_ID,RV_OrderDetail.C_PaymentTerm_ID AS C_PaymentTerm_ID,RV_OrderDetail.IsPayScheduleValid,RV_OrderDetail.Posted,(SELECT NVL(C_POS.Name,'-1') FROM C_POS WHERE RV_OrderDetail.C_POS_ID=C_POS.C_POS_ID) AS ZZC_POS_ID,RV_OrderDetail.C_POS_ID AS C_POS_ID,RV_OrderDetail.IsTaxIncluded,(SELECT NVL(M_PriceList.Name,'-1') FROM M_PriceList WHERE RV_OrderDetail.M_PriceList_ID=M_PriceList.M_PriceList_ID) AS AAAM_PriceList_ID,RV_OrderDetail.M_PriceList_ID AS M_PriceList_ID,RV_OrderDetail.IsPrinted,RV_OrderDetail.PriorityRule,RV_OrderDetail.ProcessedOn,(SELECT NVL(C_Project.Value,'-1') ||''|| NVL(C_Project.Name,'-1') FROM C_Project WHERE RV_OrderDetail.C_Project_ID=C_Project.C_Project_ID) AS BBBC_Project_ID,RV_OrderDetail.C_Project_ID AS C_Project_ID,(SELECT NVL(CAST (C_ProjectPhase.SeqNo AS Text),'-1') ||''|| NVL(C_ProjectPhase.Name,'-1') FROM C_ProjectPhase WHERE RV_OrderDetail.C_ProjectPhase_ID=C_ProjectPhase.C_ProjectPhase_ID) AS CCCC_ProjectPhase_ID,RV_OrderDetail.C_ProjectPhase_ID AS C_ProjectPhase_ID,(SELECT NVL(CAST (C_ProjectTask.SeqNo AS Text),'-1') ||''|| NVL(C_ProjectTask.Name,'-1') FROM C_ProjectTask WHERE RV_OrderDetail.C_ProjectTask_ID=C_ProjectTask.C_ProjectTask_ID) AS DDDC_ProjectTask_ID,RV_OrderDetail.C_ProjectTask_ID AS C_ProjectTask_ID,(SELECT NVL(M_Promotion.Name,'-1') FROM M_Promotion WHERE RV_OrderDetail.M_Promotion_ID=M_Promotion.M_Promotion_ID) AS EEEM_Promotion_ID,RV_OrderDetail.M_Promotion_ID AS M_Promotion_ID,RV_OrderDetail.PromotionCode,FFF.DocumentNo AS FFFDocumentNo,RV_OrderDetail.Ref_Order_ID AS Ref_Order_ID,GGG.Line AS GGGLine,RV_OrderDetail.Ref_OrderLine_ID AS Ref_OrderLine_ID,RV_OrderDetail.S_ResourceAssignment_ID,RV_OrderDetail.RRAmt,RV_OrderDetail.RRStartDate,RV_OrderDetail.IsSelected,RV_OrderDetail.IsSelfService,RV_OrderDetail.SendEMail,HHH.Name AS HHHName,RV_OrderDetail.C_DocTypeTarget_ID AS C_DocTypeTarget_ID,(SELECT NVL(C_Tax.Name,'-1') FROM C_Tax WHERE RV_OrderDetail.C_Tax_ID=C_Tax.C_Tax_ID) AS IIIC_Tax_ID,RV_OrderDetail.C_Tax_ID AS C_Tax_ID,RV_OrderDetail.TotalLines,RV_OrderDetail.IsTransferred,RV_OrderDetail.Volume,RV_OrderDetail.Weight FROM RV_OrderDetail INNER JOIN AD_Ref_List E ON (RV_OrderDetail.DocAction=E.Value AND E.AD_Reference_ID=135) INNER JOIN AD_Ref_List F ON (RV_OrderDetail.DocStatus=F.Value AND F.AD_Reference_ID=131) LEFT OUTER JOIN AD_User H ON (RV_OrderDetail.Bill_User_ID=H.AD_User_ID) LEFT OUTER JOIN C_BPartner_Location I ON (RV_OrderDetail.Bill_Location_ID=I.C_BPartner_Location_ID) LEFT OUTER JOIN C_BPartner J ON (RV_OrderDetail.Bill_BPartner_ID=J.C_BPartner_ID) LEFT OUTER JOIN AD_User P ON (RV_OrderDetail.SalesRep_ID=P.AD_User_ID) LEFT OUTER JOIN AD_Org X ON (RV_OrderDetail.c_order_ad_org_id=X.AD_Org_ID) LEFT OUTER JOIN AD_Org Y ON (RV_OrderDetail.c_order_ad_orgtrx_id=Y.AD_Org_ID) LEFT OUTER JOIN C_Activity Z ON (RV_OrderDetail.c_order_c_activity_id=Z.C_Activity_ID) LEFT OUTER JOIN C_BPartner AA ON (RV_OrderDetail.c_order_c_bpartner_id=AA.C_BPartner_ID) LEFT OUTER JOIN C_BPartner_Location BB ON (RV_OrderDetail.c_order_c_bpartner_location_i=BB.C_BPartner_Location_ID) LEFT OUTER JOIN C_Charge CC ON (RV_OrderDetail.c_order_c_charge_id=CC.C_Charge_ID) LEFT OUTER JOIN C_Campaign DD ON (RV_OrderDetail.c_order_c_compaign_id=DD.C_Campaign_ID) LEFT OUTER JOIN C_Project EE ON (RV_OrderDetail.c_order_c_project_id=EE.C_Project_ID) LEFT OUTER JOIN AD_Org FF ON (RV_OrderDetail.c_orderline_ad_orgtrx_id=FF.AD_Org_ID) LEFT OUTER JOIN C_Charge GG ON (RV_OrderDetail.c_orderline_c_charge_id=GG.C_Charge_ID) LEFT OUTER JOIN C_Currency HH ON (RV_OrderDetail.c_orderline_c_currency_id=HH.C_Currency_ID) LEFT OUTER JOIN C_ElementValue KK ON (RV_OrderDetail.c_orderline_user2_id=KK.C_ElementValue_ID) LEFT OUTER JOIN M_Warehouse MM ON (RV_OrderDetail.c_order_m_warehouse_id=MM.M_Warehouse_ID) LEFT OUTER JOIN C_ElementValue NN ON (RV_OrderDetail.c_order_user1_id=NN.C_ElementValue_ID) LEFT OUTER JOIN C_ElementValue OO ON (RV_OrderDetail.c_order_user2_id=OO.C_ElementValue_ID) LEFT OUTER JOIN AD_User QQ ON (RV_OrderDetail.DropShip_User_ID=QQ.AD_User_ID) LEFT OUTER JOIN C_BPartner_Location RR ON (RV_OrderDetail.DropShip_Location_ID=RR.C_BPartner_Location_ID) LEFT OUTER JOIN C_BPartner SS ON (RV_OrderDetail.DropShip_BPartner_ID=SS.C_BPartner_ID) LEFT OUTER JOIN C_Order UU ON (RV_OrderDetail.Link_Order_ID=UU.C_Order_ID) LEFT OUTER JOIN C_OrderLine VV ON (RV_OrderDetail.Link_OrderLine_ID=VV.C_OrderLine_ID) LEFT OUTER JOIN AD_Org WW ON (RV_OrderDetail.M_ASI_AD_Org_ID=WW.AD_Org_ID) LEFT OUTER JOIN C_Order FFF ON (RV_OrderDetail.Ref_Order_ID=FFF.C_Order_ID) LEFT OUTER JOIN C_OrderLine GGG ON (RV_OrderDetail.Ref_OrderLine_ID=GGG.C_OrderLine_ID) LEFT OUTER JOIN C_DocType HHH ON (RV_OrderDetail.C_DocTypeTarget_ID=HHH.C_DocType_ID) WHERE RV_OrderDetail.AD_Client_ID IN(0,11) AND RV_OrderDetail.AD_Org_ID IN(50007,0,50004,50005,50006,50000,50001,50002,11,12) AND (E.AD_Ref_List_ID IS NULL OR E.AD_Ref_List_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 104 AND AD_User_ID <> 100 AND IsActive = 'Y' )) AND (F.AD_Ref_List_ID IS NULL OR F.AD_Ref_List_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 104 AND AD_User_ID <> 100 AND IsActive = 'Y' )) AND (H.AD_User_ID IS NULL OR H.AD_User_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 114 AND AD_User_ID <> 100 AND IsActive = 'Y' )) AND (I.C_BPartner_Location_ID IS NULL OR I.C_BPartner_Location_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 293 AND AD_User_ID <> 100 AND IsActive = 'Y' )) AND (J.C_BPartner_ID IS NULL OR J.C_BPartner_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 291 AND AD_User_ID <> 100 AND IsActive = 'Y' )) AND (P.AD_User_ID IS NULL OR P.AD_User_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 114 AND AD_User_ID <> 100 AND IsActive = 'Y' )) AND (X.AD_Org_ID IS NULL OR X.AD_Org_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 155 AND AD_User_ID <> 100 AND IsActive = 'Y' )) AND (Y.AD_Org_ID IS NULL OR Y.AD_Org_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 155 AND AD_User_ID <> 100 AND IsActive = 'Y' )) AND (Z.C_Activity_ID IS NULL OR Z.C_Activity_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 316 AND AD_User_ID <> 100 AND IsActive = 'Y' )) AND (AA.C_BPartner_ID IS NULL OR AA.C_BPartner_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 291 AND AD_User_ID <> 100 AND IsActive = 'Y' )) AND (BB.C_BPartner_Location_ID IS NULL OR BB.C_BPartner_Location_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 293 AND AD_User_ID <> 100 AND IsActive = 'Y' )) AND (CC.C_Charge_ID IS NULL OR CC.C_Charge_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 313 AND AD_User_ID <> 100 AND IsActive = 'Y' )) AND (DD.C_Campaign_ID IS NULL OR DD.C_Campaign_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 274 AND AD_User_ID <> 100 AND IsActive = 'Y' )) AND (EE.C_Project_ID IS NULL OR EE.C_Project_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 203 AND AD_User_ID <> 100 AND IsActive = 'Y' )) AND (FF.AD_Org_ID IS NULL OR FF.AD_Org_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 155 AND AD_User_ID <> 100 AND IsActive = 'Y' )) AND (GG.C_Charge_ID IS NULL OR GG.C_Charge_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 313 AND AD_User_ID <> 100 AND IsActive = 'Y' )) AND (HH.C_Currency_ID IS NULL OR HH.C_Currency_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 141 AND AD_User_ID <> 100 AND IsActive = 'Y' )) AND (KK.C_ElementValue_ID IS NULL OR KK.C_ElementValue_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 188 AND AD_User_ID <> 100 AND IsActive = 'Y' )) AND (MM.M_Warehouse_ID IS NULL OR MM.M_Warehouse_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 190 AND AD_User_ID <> 100 AND IsActive = 'Y' )) AND (NN.C_ElementValue_ID IS NULL OR NN.C_ElementValue_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 188 AND AD_User_ID <> 100 AND IsActive = 'Y' )) AND (OO.C_ElementValue_ID IS NULL OR OO.C_ElementValue_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 188 AND AD_User_ID <> 100 AND IsActive = 'Y' )) AND (QQ.AD_User_ID IS NULL OR QQ.AD_User_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 114 AND AD_User_ID <> 100 AND IsActive = 'Y' )) AND (RR.C_BPartner_Location_ID IS NULL OR RR.C_BPartner_Location_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 293 AND AD_User_ID <> 100 AND IsActive = 'Y' )) AND (SS.C_BPartner_ID IS NULL OR SS.C_BPartner_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 291 AND AD_User_ID <> 100 AND IsActive = 'Y' )) AND (UU.C_Order_ID IS NULL OR UU.C_Order_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 259 AND AD_User_ID <> 100 AND IsActive = 'Y' )) AND (VV.C_OrderLine_ID IS NULL OR VV.C_OrderLine_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 260 AND AD_User_ID <> 100 AND IsActive = 'Y' )) AND (WW.AD_Org_ID IS NULL OR WW.AD_Org_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 155 AND AD_User_ID <> 100 AND IsActive = 'Y' )) AND (FFF.C_Order_ID IS NULL OR FFF.C_Order_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 259 AND AD_User_ID <> 100 AND IsActive = 'Y' )) AND (GGG.C_OrderLine_ID IS NULL OR GGG.C_OrderLine_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 260 AND AD_User_ID <> 100 AND IsActive = 'Y' )) AND (HHH.C_DocType_ID IS NULL OR HHH.C_DocType_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 217 AND AD_User_ID <> 100 AND IsActive = 'Y' )) [101]