details: /erp/stable/2.50/rev/98d3b02cdc49
changeset: 9220:98d3b02cdc49
user: Adrián Romero <adrianromero <at> openbravo.com>
date: Thu Feb 17 17:46:38 2011 +0100
summary: Fixes issue 0015741: Inactive process plans are used when running
manufacturing plan
It has been modified the view MA_PROCESSPLAN_TOTALIZED to take only into
account active records
diffstat:
src-db/database/model/views/MA_PROCESSPLAN_TOTALIZED.xml | 8 ++++----
1 files changed, 4 insertions(+), 4 deletions(-)
diffs (30 lines):
diff -r 05c4871d6346 -r 98d3b02cdc49
src-db/database/model/views/MA_PROCESSPLAN_TOTALIZED.xml
--- a/src-db/database/model/views/MA_PROCESSPLAN_TOTALIZED.xml Thu Feb 17
16:18:48 2011 +0100
+++ b/src-db/database/model/views/MA_PROCESSPLAN_TOTALIZED.xml Thu Feb 17
17:46:38 2011 +0100
@@ -1,14 +1,14 @@
<?xml version="1.0"?>
<database name="VIEW MA_PROCESSPLAN_TOTALIZED">
<view name="MA_PROCESSPLAN_TOTALIZED"><![CDATA[SELECT
ma_processplan_version.ma_processplan_id,
ma_processplan_version.ma_processplan_version_id, m_product.m_product_id AS
produced, sp1.qty AS proqty, sp2.m_product_id AS dependantproduct, sp2.qty AS
depqty
-FROM m_product, ma_processplan_version, (SELECT
ma_sequence.ma_processplan_version_id, ma_sequenceproduct.m_product_id, sum(
+FROM m_product, ma_processplan, ma_processplan_version, (SELECT
ma_sequence.ma_processplan_version_id, ma_sequenceproduct.m_product_id, sum(
CASE ma_sequenceproduct.productiontype
WHEN '+' THEN ma_sequenceproduct.quantity * ma_sequence.multiplier
WHEN '-' THEN ma_sequenceproduct.quantity * ma_sequence.multiplier * (-1)
ELSE NULL
END) AS qty
FROM ma_sequence, ma_sequenceproduct
-WHERE ma_sequence.ma_sequence_id = ma_sequenceproduct.ma_sequence_id
+WHERE ma_sequence.ma_sequence_id = ma_sequenceproduct.ma_sequence_id AND
ma_sequence.isactive = 'Y' AND ma_sequenceproduct.isactive = 'Y'
GROUP BY ma_sequence.ma_processplan_version_id,
ma_sequenceproduct.m_product_id) sp1, (SELECT
ma_sequence.ma_processplan_version_id, ma_sequenceproduct.m_product_id, sum(
CASE ma_sequenceproduct.productiontype
WHEN '+' THEN ma_sequenceproduct.quantity * ma_sequence.multiplier
@@ -16,7 +16,7 @@
ELSE NULL
END) AS qty
FROM ma_sequence, ma_sequenceproduct
-WHERE ma_sequence.ma_sequence_id = ma_sequenceproduct.ma_sequence_id
+WHERE ma_sequence.ma_sequence_id = ma_sequenceproduct.ma_sequence_id AND
ma_sequence.isactive = 'Y' AND ma_sequenceproduct.isactive = 'Y'
GROUP BY ma_sequence.ma_processplan_version_id,
ma_sequenceproduct.m_product_id) sp2
-WHERE m_product.ma_processplan_id = ma_processplan_version.ma_processplan_id
AND ma_processplan_version.datefrom <= now() AND ma_processplan_version.dateto
> now() AND ma_processplan_version.ma_processplan_version_id =
sp1.ma_processplan_version_id AND
ma_processplan_version.ma_processplan_version_id =
sp2.ma_processplan_version_id AND sp1.m_product_id = m_product.m_product_id AND
sp2.m_product_id <> m_product.m_product_id AND sp1.qty > 0 AND sp2.qty <>
0]]></view>
+WHERE ma_processplan.ma_processplan_id =
ma_processplan_version.ma_processplan_id AND m_product.ma_processplan_id =
ma_processplan_version.ma_processplan_id AND ma_processplan.isactive = 'Y' AND
ma_processplan_version.isactive = 'Y' AND ma_processplan_version.datefrom <=
now() AND ma_processplan_version.dateto > now() AND
ma_processplan_version.ma_processplan_version_id =
sp1.ma_processplan_version_id AND
ma_processplan_version.ma_processplan_version_id =
sp2.ma_processplan_version_id AND sp1.m_product_id = m_product.m_product_id AND
sp2.m_product_id <> m_product.m_product_id AND sp1.qty > 0 AND sp2.qty <>
0]]></view>
</database>
------------------------------------------------------------------------------
The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
Pinpoint memory and threading errors before they happen.
Find and fix more than 250 security defects in the development cycle.
Locate bottlenecks in serial and parallel code that limit performance.
http://p.sf.net/sfu/intel-dev2devfeb
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
