details: https://code.openbravo.com/erp/devel/pi/rev/724c0ebfbd0b
changeset: 13675:724c0ebfbd0b
user: Xabier Merino <xabier.merino <at> openbravo.com>
date: Wed Sep 07 11:36:48 2011 +0200
summary: Fixed issue 18449. 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 53760e719fc5 -r 724c0ebfbd0b
src-db/database/model/functions/M_INVENTORY_LISTCREATE.xml
--- a/src-db/database/model/functions/M_INVENTORY_LISTCREATE.xml Wed Sep
07 11:26:45 2011 +0200
+++ b/src-db/database/model/functions/M_INVENTORY_LISTCREATE.xml Wed Sep
07 11:36:48 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))
------------------------------------------------------------------------------
Using storage to extend the benefits of virtualization and iSCSI
Virtualization increases hardware utilization and delivers a new level of
agility. Learn what those decisions are and how to modernize your storage
and backup environments for virtualization.
http://www.accelacomm.com/jaw/sfnl/114/51434361/
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
