details: /erp/devel/pi/rev/3c404e4f4c33 changeset: 11589:3c404e4f4c33 user: Gorka Ion Damián <gorkaion.damian <at> openbravo.com> date: Mon Apr 18 16:06:13 2011 +0200 summary: Fixed issue 16838.Added a coalesce on the select clause of M_PRODUCT_PRICE_WAREHOUSE_V view.
diffstat: src-db/database/model/views/M_PRODUCT_PRICE_WAREHOUSE_V.xml | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diffs (11 lines): diff -r 0d807cacb88c -r 3c404e4f4c33 src-db/database/model/views/M_PRODUCT_PRICE_WAREHOUSE_V.xml --- a/src-db/database/model/views/M_PRODUCT_PRICE_WAREHOUSE_V.xml Sat Apr 16 10:53:44 2011 +0200 +++ b/src-db/database/model/views/M_PRODUCT_PRICE_WAREHOUSE_V.xml Mon Apr 18 16:06:13 2011 +0200 @@ -1,6 +1,6 @@ <?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 + <view name="M_PRODUCT_PRICE_WAREHOUSE_V"><![CDATA[SELECT COALESCE(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 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> ------------------------------------------------------------------------------ Benefiting from Server Virtualization: Beyond Initial Workload Consolidation -- Increasing the use of server virtualization is a top priority.Virtualization can reduce costs, simplify management, and improve application availability and disaster protection. Learn more about boosting the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev _______________________________________________ Openbravo-commits mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openbravo-commits
