details: https://code.openbravo.com/erp/stable/2.50/rev/40494049b883
changeset: 9653:40494049b883
user: Xabier Merino <xabier.merino <at> openbravo.com>
date: Wed Sep 07 13:06:17 2011 +0200
summary: Fixed issue 18350. M_Inventory_listcreate does not work properly II
diffstat:
src-db/database/model/functions/M_INVENTORY_LISTCREATE.xml | 5 +----
1 files changed, 1 insertions(+), 4 deletions(-)
diffs (20 lines):
diff -r 90e1bc45cb11 -r 40494049b883
src-db/database/model/functions/M_INVENTORY_LISTCREATE.xml
--- a/src-db/database/model/functions/M_INVENTORY_LISTCREATE.xml Wed Sep
07 16:37:53 2011 +0200
+++ b/src-db/database/model/functions/M_INVENTORY_LISTCREATE.xml Wed Sep
07 13:06:17 2011 +0200
@@ -215,15 +215,12 @@
FROM M_Product p
INNER JOIN M_Storage_Detail s
ON(s.M_Product_ID=p.M_Product_ID)
- LEFT JOIN M_Product_org o
- ON(o.M_Product_ID=p.M_Product_ID)
WHERE p.AD_Client_ID=v_Client_ID -- only ..
AND(v_ProductValue IS NULL
OR UPPER(p.Value) LIKE v_ProductValue)
AND(v_Locator_ID IS NULL
OR s.M_Locator_ID=v_Locator_ID)
- AND(v_ABC IS NULL
- OR o.ABC=v_ABC AND o.AD_Org_ID = v_Org_ID)
+ AND(v_ABC IS NULL OR v_ABC in (select abc from m_product_org po where
po.m_product_id = s.m_product_id ))
AND(v_Warehouse_ID IS NULL
OR s.M_Locator_ID IN
(SELECT M_Locator_ID FROM M_Locator WHERE
M_Warehouse_ID=v_Warehouse_ID))
------------------------------------------------------------------------------
Doing More with Less: The Next Generation Virtual Desktop
What are the key obstacles that have prevented many mid-market businesses
from deploying virtual desktops? How do next-generation virtual desktops
provide companies an easier-to-deploy, easier-to-manage and more affordable
virtual desktop model.http://www.accelacomm.com/jaw/sfnl/114/51426474/
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
