details: /erp/devel/pi/rev/eaa560589fc6
changeset: 10849:eaa560589fc6
user: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
date: Wed Feb 23 16:48:15 2011 +0100
summary: Fixed issue in view, warehouse is optional.
diffstat:
src-db/database/model/views/M_PRODUCT_PRICE_WAREHOUSE_V.xml | 5 +++--
1 files changed, 3 insertions(+), 2 deletions(-)
diffs (13 lines):
diff -r c5cc31628ba3 -r eaa560589fc6
src-db/database/model/views/M_PRODUCT_PRICE_WAREHOUSE_V.xml
--- a/src-db/database/model/views/M_PRODUCT_PRICE_WAREHOUSE_V.xml Wed Feb
23 16:12:52 2011 +0100
+++ b/src-db/database/model/views/M_PRODUCT_PRICE_WAREHOUSE_V.xml Wed Feb
23 16:48:15 2011 +0100
@@ -1,6 +1,7 @@
<?xml version="1.0"?>
<database name="VIEW M_PRODUCT_PRICE_WAREHOUSE_V">
<view name="M_PRODUCT_PRICE_WAREHOUSE_V"><![CDATA[SELECT w.m_warehouse_id
|| pp.m_productprice_id AS m_product_price_warehouse_v_id, p.ad_client_id,
p.ad_org_id, p.isactive, p.updated, p.updatedby, p.created, p.createdby,
p.m_product_id, w.m_warehouse_id, pp.m_productprice_id,
m_bom_qty_available(p.m_product_id, w.m_warehouse_id, NULL) AS qty_available,
m_bom_qty_onhand(p.m_product_id, w.m_warehouse_id, NULL) AS qty_onhand,
m_bom_qty_reserved(p.m_product_id, w.m_warehouse_id, NULL) AS qty_reserved,
m_bom_qty_ordered(p.m_product_id, w.m_warehouse_id, NULL) AS qty_ordered,
m_bom_pricelist(p.m_product_id, pp.m_pricelist_version_id) AS pricelist,
m_bom_pricestd(p.m_product_id, pp.m_pricelist_version_id) AS pricestd,
m_bom_pricelimit(p.m_product_id, pp.m_pricelist_version_id) AS pricelimit
-FROM m_product p, m_warehouse w, m_productprice pp
-WHERE p.m_product_id = pp.m_product_id AND p.ad_client_id = w.ad_client_id AND
(ad_isorgincluded(p.ad_org_id, w.ad_org_id, p.ad_client_id) > 0 OR
ad_isorgincluded(w.ad_org_id, p.ad_org_id, p.ad_client_id) > 0)]]></view>
+FROM m_product p
+JOIN m_productprice pp ON p.m_product_id = pp.m_product_id
+LEFT JOIN m_warehouse w ON p.ad_client_id = w.ad_client_id]]></view>
</database>
------------------------------------------------------------------------------
Free Software Download: Index, Search & Analyze Logs and other IT data in
Real-Time with Splunk. Collect, index and harness all the fast moving IT data
generated by your applications, servers and devices whether physical, virtual
or in the cloud. Deliver compliance at lower cost and gain new business
insights. http://p.sf.net/sfu/splunk-dev2dev
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
