details: https://code.openbravo.com/erp/devel/pi/rev/b89b81a6f0f9
changeset: 19843:b89b81a6f0f9
user: Naiara Martinez <naiara.martinez <at> openbravo.com>
date: Mon Mar 04 09:55:23 2013 +0100
summary: Related to issue 23008: fix 'Column AS alias' to work in pgsql 8.3
diffstat:
src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Invoice_data.xsql | 8
++++----
src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Shipment_data.xsql | 8
++++----
2 files changed, 8 insertions(+), 8 deletions(-)
diffs (78 lines):
diff -r a673838983f4 -r b89b81a6f0f9
src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Invoice_data.xsql
--- a/src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Invoice_data.xsql
Sat Mar 02 05:47:29 2013 +0100
+++ b/src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Invoice_data.xsql
Mon Mar 04 09:55:23 2013 +0100
@@ -40,7 +40,7 @@
l.taxbaseamt, l.CancelPriceAD, '' AS Rate, '' AS gross_unit_price, ''
AS grosspricelist, '' AS grosspricestd,
COALESCE(l.A_Asset_ID, o.A_Asset_ID) AS A_Asset_ID,
COALESCE(l.C_Project_ID, o.C_Project_ID) AS C_Project_ID,
COALESCE(l.C_Costcenter_ID, o.C_Costcenter_ID) AS C_Costcenter_ID,
- COALESCE(l.User1_ID, o.User1_ID) AS User1_ID, COALESCE(l.User2_ID,
o.User2_ID) AS User2_ID, l.explode, '' as isOrder, CASE WHEN l.Bom_parent_id is
null then 'Y' else 'N' END isparent, l.bom_parent_id
+ COALESCE(l.User1_ID, o.User1_ID) AS User1_ID, COALESCE(l.User2_ID,
o.User2_ID) AS User2_ID, l.explode, '' as isOrder, CASE WHEN l.Bom_parent_id is
null then 'Y' else 'N' END as isparent, l.bom_parent_id
FROM C_ORDERLINE l left join M_MATCHPO m on
l.C_OrderLine_ID=m.C_OrderLine_ID
AND m.C_InvoiceLine_ID IS NOT
NULL,
C_ORDER o, C_UOM uom, M_PRODUCT p
@@ -112,7 +112,7 @@
l.C_OrderLine_ID,l.Line, l.ad_Org_id, l.taxbaseamt,
COALESCE(l.A_Asset_ID, o.A_Asset_ID) AS A_Asset_ID,
COALESCE(l.C_Project_ID, o.C_Project_ID) AS C_Project_ID,
COALESCE(l.C_Costcenter_ID, o.C_Costcenter_ID) AS C_Costcenter_ID,
COALESCE(l.User1_ID, o.User1_ID) AS User1_ID, COALESCE(l.User2_ID,
o.User2_ID) AS User2_ID, l.explode, l.Bom_parent_id,
- CASE WHEN l.Bom_parent_id is null then 'Y' else 'N' END isparent
+ CASE WHEN l.Bom_parent_id is null then 'Y' else 'N' END as isparent
FROM C_INVOICE_CANDIDATE_V ic, C_UOM uom, C_ORDER o, C_ORDERLINE l,
M_PRODUCT p
WHERE l.C_UOM_ID=uom.C_UOM_ID
AND o.C_ORDER_ID = ic.C_ORDER_ID
@@ -336,7 +336,7 @@
COALESCE(l.A_Asset_ID, s.A_Asset_ID) AS A_Asset_ID,
COALESCE(l.C_Project_ID, s.C_Project_ID) AS C_Project_ID,
COALESCE(l.C_Costcenter_ID, s.C_Costcenter_ID) AS C_Costcenter_ID,
COALESCE(l.User1_ID, s.User1_ID) AS User1_ID, COALESCE(l.User2_ID,
s.User2_ID) AS User2_ID, l.explode, l.Bom_parent_id,
- CASE WHEN l.Bom_parent_id is null then 'Y' else 'N' END isparent
+ CASE WHEN l.Bom_parent_id is null then 'Y' else 'N' END as isparent
FROM M_INOUTLINE l left join M_ATTRIBUTESETINSTANCE ma on
l.M_ATTRIBUTESETINSTANCE_ID = ma.M_ATTRIBUTESETINSTANCE_ID
left join M_MATCHINV mi on
l.M_InOutLine_ID=mi.M_InOutLine_ID
left join c_orderline ol on l.c_orderline_id =
ol.c_orderline_id
@@ -412,7 +412,7 @@
COALESCE(l.A_Asset_ID, s.A_Asset_ID) AS A_Asset_ID,
COALESCE(l.C_Project_ID, s.C_Project_ID) AS C_Project_ID,
COALESCE(l.C_Costcenter_ID, s.C_Costcenter_ID) AS C_Costcenter_ID,
COALESCE(l.User1_ID, s.User1_ID) AS User1_ID, COALESCE(l.User2_ID,
s.User2_ID) AS User2_ID, l.explode, l.Bom_parent_id,
- CASE WHEN l.Bom_parent_id is null then 'Y' else 'N' END isparent
+ CASE WHEN l.Bom_parent_id is null then 'Y' else 'N' END as isparent
FROM M_INOUTLINE l
left join M_ATTRIBUTESETINSTANCE ma on
l.M_ATTRIBUTESETINSTANCE_ID = ma.M_ATTRIBUTESETINSTANCE_ID
left join c_orderline ol on l.c_orderline_id =
ol.c_orderline_id
diff -r a673838983f4 -r b89b81a6f0f9
src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Shipment_data.xsql
--- a/src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Shipment_data.xsql
Sat Mar 02 05:47:29 2013 +0100
+++ b/src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Shipment_data.xsql
Mon Mar 04 09:55:23 2013 +0100
@@ -42,7 +42,7 @@
coalesce(l.a_asset_id,o.a_asset_id) as a_asset_id,
coalesce(l.c_project_id,o.c_project_id) as c_project_id,
coalesce(l.c_costcenter_id, o.c_costcenter_id) as c_costcenter_id,
coalesce(l.user1_id,o.user1_id) as user1_id,
coalesce(l.user2_id,o.user2_id) as user2_id,
- coalesce (l.c_bpartner_id,o.c_bpartner_id) as c_bpartner_id,
l.explode, l.bom_parent_id, CASE WHEN l.Bom_parent_id is null then 'Y' else 'N'
END isparent,
+ coalesce (l.c_bpartner_id,o.c_bpartner_id) as c_bpartner_id,
l.explode, l.bom_parent_id, CASE WHEN l.Bom_parent_id is null then 'Y' else 'N'
END as isparent,
'' as isorder
FROM C_ORDERLINE l left join M_MATCHPO m on
l.C_OrderLine_ID=m.C_OrderLine_ID
and m.M_InOutLine_ID IS NOT
NULL
@@ -110,7 +110,7 @@
coalesce(l.a_asset_id,o.a_asset_id) as a_asset_id,
coalesce(l.c_project_id,o.c_project_id) as c_project_id,
coalesce(l.c_costcenter_id,o.c_costcenter_id) as
c_costcenter_id,
coalesce(l.user1_id,o.user1_id) as user1_id ,coalesce(
l.user2_id ,o.user2_id) as user2_id,
- coalesce (l.c_bpartner_id,o.c_bpartner_id) as c_bpartner_id,
l.Bom_parent_id, CASE WHEN l.Bom_parent_id is null then 'Y' else 'N' END
isparent
+ coalesce (l.c_bpartner_id,o.c_bpartner_id) as c_bpartner_id,
l.Bom_parent_id, CASE WHEN l.Bom_parent_id is null then 'Y' else 'N' END as
isparent
FROM M_INOUT_CANDIDATE_V ic, C_ORDER o, C_UOM uom, C_ORDERLINE l,
M_PRODUCT p
WHERE o.C_ORDER_ID = l.C_ORDER_ID
AND o.C_ORDER_ID = ic.C_ORDER_ID
@@ -314,7 +314,7 @@
(SELECT C_UOM.NAME FROM M_PRODUCT_UOM, C_UOM WHERE M_PRODUCT_UOM_ID =
l.M_PRODUCT_UOM_ID AND M_PRODUCT_UOM.C_UOM_ID = C_UOM.C_UOM_ID) as SECUOMSYMBOL,
COALESCE(l.M_PRODUCT_UOM_ID,null,'0') as HAVESEC,'' as HAVESECUOM,''
AS LOCATOR,l.M_ATTRIBUTESETINSTANCE_ID AS M_ATTRIBUTESETINSTANCE_ID,
(SELECT M_ATTRIBUTESETINSTANCE.DESCRIPTION FROM M_ATTRIBUTESETINSTANCE
WHERE l.M_ATTRIBUTESETINSTANCE_ID =
M_ATTRIBUTESETINSTANCE.M_ATTRIBUTESETINSTANCE_ID) as ATTRIBUTESETINSTANCENAME,
l.explode, l.Bom_parent_id,
- CASE WHEN l.Bom_parent_id is null then 'Y' else 'N' END isparent
+ CASE WHEN l.Bom_parent_id is null then 'Y' else 'N' END as isparent
FROM C_INVOICELINE l left join M_MATCHINV mi on
l.C_InvoiceLine_ID=mi.C_InvoiceLine_ID,
C_INVOICE i, C_UOM uom, M_PRODUCT p
WHERE i.C_INVOICE_ID = l.C_INVOICE_ID
@@ -352,7 +352,7 @@
l.DESCRIPTION AS DESCRIPTION,
coalesce(l.a_asset_id,i.a_asset_id) as a_asset_id,
coalesce(l.c_project_id,i.c_project_id) as
c_project_id,coalesce(l.c_costcenter_id,i.c_costcenter_id)
as c_costcenter_id, coalesce(l.user1_id,i.user1_id) as user1_id ,
coalesce(l.user2_id,i.user2_id) as user2_id , l.c_bpartner_id, l.explode,
l.Bom_parent_id,
- CASE WHEN l.Bom_parent_id is null then 'Y' else 'N' END isparent
+ CASE WHEN l.Bom_parent_id is null then 'Y' else 'N' END as isparent
FROM C_INVOICELINE l left join M_INOUTLINE mi on l.M_INOUTLINE_ID =
mi.M_INOUTLINE_ID,
C_INVOICE i, C_UOM uom, M_PRODUCT p
WHERE i.C_INVOICE_ID = l.C_INVOICE_ID
------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
