details: https://code.openbravo.com/erp/devel/pi/rev/6d62caf89ace changeset: 15929:6d62caf89ace user: David Miguelez <david.miguelez <at> openbravo.com> date: Tue Mar 27 09:39:19 2012 +0200 summary: Fixes issue 19370: Changed the ID's of the Views Plus added extra lenght to the definition of an ID.
diffstat: src-db/database/model/views/C_RM_ORDER_PICK_EDIT_LINES.xml | 2 +- src-db/database/model/views/M_RM_RECEIPT_PICK_EDIT.xml | 3 +-- src-db/database/model/views/M_RM_SHIPMENT_PICK_EDIT.xml | 2 +- src-db/database/sourcedata/AD_COLUMN.xml | 2 +- 4 files changed, 4 insertions(+), 5 deletions(-) diffs (52 lines): diff -r 541a4becfc84 -r 6d62caf89ace src-db/database/model/views/C_RM_ORDER_PICK_EDIT_LINES.xml --- a/src-db/database/model/views/C_RM_ORDER_PICK_EDIT_LINES.xml Wed Mar 28 12:55:28 2012 +0200 +++ b/src-db/database/model/views/C_RM_ORDER_PICK_EDIT_LINES.xml Tue Mar 27 09:39:19 2012 +0200 @@ -1,6 +1,6 @@ <?xml version="1.0"?> <database name="VIEW C_RM_ORDER_PICK_EDIT_LINES"> - <view name="C_RM_ORDER_PICK_EDIT_LINES"><![CDATA[SELECT get_uuid() AS c_rm_order_pick_edit_lines_id, il.ad_client_id, COALESCE(rol.ad_org_id, il.ad_org_id) AS ad_org_id, COALESCE(rol.isactive, il.isactive) AS isactive, COALESCE(rol.createdby, il.createdby) AS createdby, COALESCE(rol.updatedby, il.updatedby) AS updatedby, COALESCE(rol.created, il.created) AS created, COALESCE(rol.updated, il.updated) AS updated, + <view name="C_RM_ORDER_PICK_EDIT_LINES"><![CDATA[SELECT il.m_inoutline_id AS c_rm_order_pick_edit_lines_id, il.ad_client_id, COALESCE(rol.ad_org_id, il.ad_org_id) AS ad_org_id, COALESCE(rol.isactive, il.isactive) AS isactive, COALESCE(rol.createdby, il.createdby) AS createdby, COALESCE(rol.updatedby, il.updatedby) AS updatedby, COALESCE(rol.created, il.created) AS created, COALESCE(rol.updated, il.updated) AS updated, CASE WHEN rol.c_orderline_id IS NOT NULL THEN 'Y' ELSE 'N' diff -r 541a4becfc84 -r 6d62caf89ace src-db/database/model/views/M_RM_RECEIPT_PICK_EDIT.xml --- a/src-db/database/model/views/M_RM_RECEIPT_PICK_EDIT.xml Wed Mar 28 12:55:28 2012 +0200 +++ b/src-db/database/model/views/M_RM_RECEIPT_PICK_EDIT.xml Tue Mar 27 09:39:19 2012 +0200 @@ -1,6 +1,6 @@ <?xml version="1.0"?> <database name="VIEW M_RM_RECEIPT_PICK_EDIT"> - <view name="M_RM_RECEIPT_PICK_EDIT"><![CDATA[SELECT get_uuid() AS m_rm_receipt_pick_edit_id, ol.ad_client_id, COALESCE(iol.ad_org_id, ol.ad_org_id) AS ad_org_id, ol.isactive, ol.created, ol.createdby, COALESCE(iol.updated, ol.updated) AS updated, ol.updatedby, iol.m_inout_id, + <view name="M_RM_RECEIPT_PICK_EDIT"><![CDATA[SELECT ol.c_orderline_id AS m_rm_receipt_pick_edit_id, ol.ad_client_id, COALESCE(iol.ad_org_id, ol.ad_org_id) AS ad_org_id, ol.isactive, ol.created, ol.createdby, COALESCE(iol.updated, ol.updated) AS updated, ol.updatedby, iol.m_inout_id, CASE WHEN iol.m_inoutline_id IS NOT NULL THEN 'Y' ELSE 'N' @@ -12,6 +12,5 @@ LEFT JOIN (SELECT il2.m_inoutline_id, il2.ad_client_id, il2.ad_org_id, il2.isactive, il2.created, il2.createdby, il2.updated, il2.updatedby, il2.line, il2.description, il2.m_inout_id, il2.c_orderline_id, il2.m_locator_id, il2.m_product_id, il2.c_uom_id, il2.movementqty, il2.isinvoiced, il2.m_attributesetinstance_id, il2.isdescription, il2.quantityorder, il2.m_product_uom_id, il2.m_condition_goods_id FROM m_inoutline il2 JOIN m_inout i2 ON il2.m_inout_id = i2.m_inout_id AND i2.processed = 'N') iol ON iol.c_orderline_id = ol.c_orderline_id -LEFT JOIN m_inout io ON io.m_inout_id = iol.m_inout_id AND io.processed = 'N' WHERE (ol.qtyordered - ol.qtydelivered) <> 0]]></view> </database> diff -r 541a4becfc84 -r 6d62caf89ace src-db/database/model/views/M_RM_SHIPMENT_PICK_EDIT.xml --- a/src-db/database/model/views/M_RM_SHIPMENT_PICK_EDIT.xml Wed Mar 28 12:55:28 2012 +0200 +++ b/src-db/database/model/views/M_RM_SHIPMENT_PICK_EDIT.xml Tue Mar 27 09:39:19 2012 +0200 @@ -1,6 +1,6 @@ <?xml version="1.0"?> <database name="VIEW M_RM_SHIPMENT_PICK_EDIT"> - <view name="M_RM_SHIPMENT_PICK_EDIT"><![CDATA[SELECT get_uuid() AS m_rm_shipment_pick_edit_id, ol.ad_client_id, COALESCE(iol.ad_org_id, ol.ad_org_id) AS ad_org_id, ol.isactive, ol.createdby, ol.created, ol.updatedby, ol.updated, o.documentno AS returnorderno, ol.m_product_id, ol.m_attributesetinstance_id, ol.c_uom_id, (-1) * ol.qtyordered AS returned, (-1) * iol.movementqty AS movementqty, sd.m_locator_id, COALESCE(sd.qtyonhand, 0) AS availableqty, (-1) * (ol.qtyordered - COALESCE((SELECT sum(iol3.movementqty) AS sum + <view name="M_RM_SHIPMENT_PICK_EDIT"><![CDATA[SELECT sd.m_storage_detail_id || ol.c_orderline_id AS m_rm_shipment_pick_edit_id, ol.ad_client_id, COALESCE(iol.ad_org_id, ol.ad_org_id) AS ad_org_id, ol.isactive, ol.createdby, ol.created, ol.updatedby, ol.updated, o.documentno AS returnorderno, ol.m_product_id, ol.m_attributesetinstance_id, ol.c_uom_id, (-1) * ol.qtyordered AS returned, (-1) * iol.movementqty AS movementqty, sd.m_locator_id, COALESCE(sd.qtyonhand, 0) AS availableqty, (-1) * (ol.qtyordered - COALESCE((SELECT sum(iol3.movementqty) AS sum FROM m_inoutline iol3 JOIN m_inout io3 ON iol3.m_inout_id = io3.m_inout_id AND io3.processed = 'Y' WHERE iol3.c_orderline_id = ol.c_orderline_id), 0)) AS pendingqty, iol.m_inout_id, diff -r 541a4becfc84 -r 6d62caf89ace src-db/database/sourcedata/AD_COLUMN.xml --- a/src-db/database/sourcedata/AD_COLUMN.xml Wed Mar 28 12:55:28 2012 +0200 +++ b/src-db/database/sourcedata/AD_COLUMN.xml Tue Mar 27 09:39:19 2012 +0200 @@ -282999,7 +282999,7 @@ <!--B151560F625C3082E040007F01002081--> <COLUMNNAME><![CDATA[M_Rm_Shipment_Pick_Edit_ID]]></COLUMNNAME> <!--B151560F625C3082E040007F01002081--> <AD_TABLE_ID><![CDATA[347B0AA5C3CD4D18910D2FE4990B790E]]></AD_TABLE_ID> <!--B151560F625C3082E040007F01002081--> <AD_REFERENCE_ID><![CDATA[13]]></AD_REFERENCE_ID> -<!--B151560F625C3082E040007F01002081--> <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH> +<!--B151560F625C3082E040007F01002081--> <FIELDLENGTH><![CDATA[64]]></FIELDLENGTH> <!--B151560F625C3082E040007F01002081--> <ISKEY><![CDATA[Y]]></ISKEY> <!--B151560F625C3082E040007F01002081--> <ISPARENT><![CDATA[N]]></ISPARENT> <!--B151560F625C3082E040007F01002081--> <ISMANDATORY><![CDATA[N]]></ISMANDATORY> ------------------------------------------------------------------------------ This SF email is sponsosred by: Try Windows Azure free for 90 days Click Here http://p.sf.net/sfu/sfd2d-msazure _______________________________________________ Openbravo-commits mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openbravo-commits
