details: https://code.openbravo.com/erp/devel/pi/rev/dfffc79d0876
changeset: 17585:dfffc79d0876
user: Javier Etxarri <javier.echarri <at> openbravo.com>
date: Wed Aug 01 12:11:25 2012 +0200
summary: issue 21264: Module script DeleteInventoryLines is incomplete and
the processes related
diffstat:
src-db/database/model/functions/M_INVENTORY_LISTCREATE.xml | 20 ++++++-------
1 files changed, 9 insertions(+), 11 deletions(-)
diffs (37 lines):
diff -r f8f8c7f0b83c -r dfffc79d0876
src-db/database/model/functions/M_INVENTORY_LISTCREATE.xml
--- a/src-db/database/model/functions/M_INVENTORY_LISTCREATE.xml Wed Aug
01 11:43:33 2012 +0200
+++ b/src-db/database/model/functions/M_INVENTORY_LISTCREATE.xml Wed Aug
01 12:11:25 2012 +0200
@@ -213,8 +213,8 @@
s.M_Product_UOM_ID,
s.M_AttributeSetInstance_ID
FROM M_Product p
- INNER JOIN M_Storage_Detail s
- ON(s.M_Product_ID=p.M_Product_ID)
+ INNER JOIN M_Storage_Detail s ON(s.M_Product_ID=p.M_Product_ID)
+ LEFT JOIN m_attributeset aset ON p.m_attributeset_id =
aset.m_attributeset_id
WHERE p.AD_Client_ID=v_Client_ID -- only ..
AND(v_ProductValue IS NULL
OR UPPER(p.Value) LIKE v_ProductValue)
@@ -233,15 +233,13 @@
AND l.M_Product_ID=s.M_Product_ID
AND l.M_Locator_ID=s.M_Locator_ID
)
- AND NOT EXISTS (SELECT 1
- FROM M_STORAGE_DETAIL MS
- WHERE m_product_id IN (SELECT po.m_product_id
- FROM m_product po JOIN m_attributeset
aset ON po.m_attributeset_id = aset.m_attributeset_id
- WHERE coalesce(po.attrsetvaluetype, '-')
<> 'F'
- AND aset.isoneattrsetvalrequired = 'Y'
- AND po.M_PRODUCT_ID = p.m_product_id)
- AND COALESCE(m_attributesetinstance_id, '0') = '0'
- )
+ AND NOT (coalesce(p.attrsetvaluetype, '-') <> 'F'
+ AND aset.isoneattrsetvalrequired = 'Y'
+ AND COALESCE(s.m_attributesetinstance_id, '0') = '0'
+ AND QTYONHAND = 0
+ AND COALESCE(QTYORDERONHAND,0) = 0
+ AND PREQTYONHAND=0
+ AND COALESCE(PREQTYORDERONHAND,0) = 0)
ORDER BY s.M_Locator_ID,
p.Value,
s.Created
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
