Related to issue 12786. Slightly modified views so that they don't change in Oracle too.
authorAntonio Moreno <antonio.moreno@openbravo.com>
Wed, 14 Apr 2010 11:56:39 +0200
changeset 7031 2aac4501bbd5
parent 7030 3ca2714ac0ef
child 7032 f6069809175e
Related to issue 12786. Slightly modified views so that they don't change in Oracle too.
src-db/database/model/views/AD_AUDIT_TRAIL_V.xml
src-db/database/model/views/AD_FIELD_V.xml
src-db/database/model/views/AD_FIELD_VT.xml
src-db/database/model/views/AD_PROCESS_EXECUTION_V.xml
src-db/database/model/views/AD_REF_LIST_V.xml
src-db/database/model/views/AD_TABLE_POST_V.xml
src-db/database/model/views/AD_TAB_V.xml
src-db/database/model/views/AD_TAB_VT.xml
src-db/database/model/views/AD_USER_ROLES_V.xml
src-db/database/model/views/AD_WINDOW_VT.xml
src-db/database/model/views/A_ASSET_AMORTIZATION.xml
src-db/database/model/views/C_BPARTNER_V.xml
src-db/database/model/views/C_CASH_DETAIL.xml
src-db/database/model/views/C_DEBT_PAYMENT_CANCEL.xml
src-db/database/model/views/C_DEBT_PAYMENT_GENERATE.xml
src-db/database/model/views/C_DEBT_PAYMENT_V.xml
src-db/database/model/views/C_INVOICELINE_V.xml
src-db/database/model/views/C_INVOICELINE_V2.xml
src-db/database/model/views/C_INVOICE_CANDIDATE_V.xml
src-db/database/model/views/C_INVOICE_CUSTOMERPRODQTR.xml
src-db/database/model/views/C_INVOICE_CUSTOMERVENDQTR.xml
src-db/database/model/views/C_INVOICE_DAY.xml
src-db/database/model/views/C_INVOICE_HEADER_V.xml
src-db/database/model/views/C_INVOICE_HEADER_VT.xml
src-db/database/model/views/C_INVOICE_LINETAX_V.xml
src-db/database/model/views/C_INVOICE_LINETAX_VT.xml
src-db/database/model/views/C_INVOICE_MONTH.xml
src-db/database/model/views/C_INVOICE_PRODMONTH.xml
src-db/database/model/views/C_INVOICE_PRODWEEK.xml
src-db/database/model/views/C_INVOICE_V.xml
src-db/database/model/views/C_INVOICE_V2.xml
src-db/database/model/views/C_INVOICE_VENDORMONTH.xml
src-db/database/model/views/C_INVOICE_WEEK.xml
src-db/database/model/views/C_ORDER_HEADER_V.xml
src-db/database/model/views/C_ORDER_HEADER_VT.xml
src-db/database/model/views/C_ORDER_LINETAX_V.xml
src-db/database/model/views/C_ORDER_LINETAX_VT.xml
src-db/database/model/views/C_ORDER_OPEN.xml
src-db/database/model/views/C_PERIODCONTROL_V.xml
src-db/database/model/views/C_PROJECTPROPOSAL_V.xml
src-db/database/model/views/C_PROJECT_DETAILS_V.xml
src-db/database/model/views/C_PROJECT_DETAILS_VT.xml
src-db/database/model/views/C_PROJECT_HEADER_V.xml
src-db/database/model/views/C_PROJECT_HEADER_VT.xml
src-db/database/model/views/FIN_PAYMENT_DETAIL_V.xml
src-db/database/model/views/FIN_PAYMENT_PROP_DETAIL_V.xml
src-db/database/model/views/FIN_PAYMENT_SCHED_INV_V.xml
src-db/database/model/views/FIN_PAYMENT_SCHED_ORD_V.xml
src-db/database/model/views/FIN_RECONCILIATIONLINE_V.xml
src-db/database/model/views/GL_JOURNALLINE_ACCT_V.xml
src-db/database/model/views/MA_PROCESSPLAN_TOTALIZED.xml
src-db/database/model/views/MA_SEQUENCE_EMPLOYEE_COST.xml
src-db/database/model/views/MA_SEQUENCE_INDIRECT_COST_COST.xml
src-db/database/model/views/MA_SEQUENCE_MACHINE_COST.xml
src-db/database/model/views/M_INOUT_CANDIDATE_V.xml
src-db/database/model/views/M_INOUT_HEADER_V.xml
src-db/database/model/views/M_INOUT_HEADER_VT.xml
src-db/database/model/views/M_INOUT_LINE_V.xml
src-db/database/model/views/M_INOUT_LINE_VT.xml
src-db/database/model/views/M_TRANSACTION_SUM.xml
src-db/database/model/views/M_TRANSACTION_V.xml
src-db/database/model/views/R_REQUEST_V.xml
src-db/database/model/views/S_TIMEEXPENSELINE_V.xml
--- a/src-db/database/model/views/AD_AUDIT_TRAIL_V.xml	Wed Apr 14 09:41:50 2010 +0200
+++ b/src-db/database/model/views/AD_AUDIT_TRAIL_V.xml	Wed Apr 14 11:56:39 2010 +0200
@@ -13,6 +13,5 @@
 WHERE f.ad_form_id = at.process_id)
 ELSE ''
 END AS process_desc, COALESCE(at.old_char, to_char(at.old_nchar), to_char(at.old_date), to_char(at.old_number)) AS old_value, COALESCE(at.new_char, to_char(at.new_nchar), to_char(at.new_date), to_char(at.new_number)) AS new_value
-FROM ad_audit_trail at
-]]></view>
+FROM ad_audit_trail at]]></view>
   </database>
--- a/src-db/database/model/views/AD_FIELD_V.xml	Wed Apr 14 09:41:50 2010 +0200
+++ b/src-db/database/model/views/AD_FIELD_V.xml	Wed Apr 14 11:56:39 2010 +0200
@@ -8,6 +8,5 @@
 JOIN ad_table tbl ON c.ad_table_id = tbl.ad_table_id
 JOIN ad_reference r ON c.ad_reference_id = r.ad_reference_id
 LEFT JOIN ad_val_rule vr ON c.ad_val_rule_id = vr.ad_val_rule_id
-WHERE f.isactive = 'Y' AND c.isactive = 'Y'
-]]></view>
+WHERE f.isactive = 'Y' AND c.isactive = 'Y']]></view>
   </database>
--- a/src-db/database/model/views/AD_FIELD_VT.xml	Wed Apr 14 09:41:50 2010 +0200
+++ b/src-db/database/model/views/AD_FIELD_VT.xml	Wed Apr 14 11:56:39 2010 +0200
@@ -9,6 +9,5 @@
 JOIN ad_table tbl ON c.ad_table_id = tbl.ad_table_id
 JOIN ad_reference r ON c.ad_reference_id = r.ad_reference_id
 LEFT JOIN ad_val_rule vr ON c.ad_val_rule_id = vr.ad_val_rule_id
-WHERE f.isactive = 'Y' AND c.isactive = 'Y'
-]]></view>
+WHERE f.isactive = 'Y' AND c.isactive = 'Y']]></view>
   </database>
--- a/src-db/database/model/views/AD_PROCESS_EXECUTION_V.xml	Wed Apr 14 09:41:50 2010 +0200
+++ b/src-db/database/model/views/AD_PROCESS_EXECUTION_V.xml	Wed Apr 14 11:56:39 2010 +0200
@@ -2,6 +2,5 @@
   <database name="VIEW AD_PROCESS_EXECUTION_V">
     <view name="AD_PROCESS_EXECUTION_V"><![CDATA[SELECT rn.ad_process_run_id, rn.ad_client_id, rn.ad_org_id, rn.isactive, rn.created, rn.createdby, rn.updated, rn.updatedby, rq.ad_user_id, rn.status, rn.start_time, rn.end_time, rn.runtime, rn.log, rn.result, rq.params, rn.report, rq.channel, rq.isrolesecurity, rq.ad_process_id, rn.ad_process_request_id
 FROM ad_process_run rn
-LEFT JOIN ad_process_request rq ON rn.ad_process_request_id = rq.ad_process_request_id
-]]></view>
+LEFT JOIN ad_process_request rq ON rn.ad_process_request_id = rq.ad_process_request_id]]></view>
   </database>
--- a/src-db/database/model/views/AD_REF_LIST_V.xml	Wed Apr 14 09:41:50 2010 +0200
+++ b/src-db/database/model/views/AD_REF_LIST_V.xml	Wed Apr 14 11:56:39 2010 +0200
@@ -9,6 +9,5 @@
 WHERE ad_ref_list.ad_ref_list_id = ad_ref_list_trl.ad_ref_list_id) v1, (SELECT ad_ref_list.ad_ref_list_id, ad_ref_list.value, to_char(ad_ref_list.name) AS name, ad_language.ad_language, ad_ref_list.ad_reference_id
 FROM ad_ref_list, ad_language
 WHERE ad_language.issystemlanguage = 'Y') v2
-WHERE v1.ad_ref_list_id = v2.ad_ref_list_id AND v1.ad_reference_id = v2.ad_reference_id
-]]></view>
+WHERE v1.ad_ref_list_id = v2.ad_ref_list_id AND v1.ad_reference_id = v2.ad_reference_id]]></view>
   </database>
--- a/src-db/database/model/views/AD_TABLE_POST_V.xml	Wed Apr 14 09:41:50 2010 +0200
+++ b/src-db/database/model/views/AD_TABLE_POST_V.xml	Wed Apr 14 11:56:39 2010 +0200
@@ -22,6 +22,5 @@
 LEFT JOIN ad_window w2 ON ad_table.po_window_id = w2.ad_window_id
 WHERE (EXISTS (SELECT c.ad_column_id, c.ad_client_id, c.ad_org_id, c.isactive, c.created, c.updated, c.createdby, c.updatedby, c.name, c.description, c.help, c.columnname, c.ad_table_id, c.ad_reference_id, c.ad_reference_value_id, c.ad_val_rule_id, c.fieldlength, c.defaultvalue, c.iskey, c.isparent, c.ismandatory, c.isupdateable, c.readonlylogic, c.isidentifier, c.seqno, c.istranslated, c.isencrypted, c.callout, c.vformat, c.valuemin, c.valuemax, c.isselectioncolumn, c.ad_element_id, c.ad_process_id, c.issessionattr, c.issecondarykey, c.isdesencryptable, c.ad_callout_id, c.developmentstatus
 FROM ad_column c
-WHERE ad_table.ad_table_id = c.ad_table_id AND c.columnname = 'Posted')) AND ad_table.isactive = 'Y'
-]]></view>
+WHERE ad_table.ad_table_id = c.ad_table_id AND c.columnname = 'Posted')) AND ad_table.isactive = 'Y']]></view>
   </database>
--- a/src-db/database/model/views/AD_TAB_V.xml	Wed Apr 14 09:41:50 2010 +0200
+++ b/src-db/database/model/views/AD_TAB_V.xml	Wed Apr 14 11:56:39 2010 +0200
@@ -3,6 +3,5 @@
     <view name="AD_TAB_V"><![CDATA[SELECT t.ad_tab_id, t.ad_window_id, t.ad_table_id, t.name, t.description, t.help, t.seqno, t.issinglerow, t.hastree, t.isinfotab, tbl.tablename, tbl.accesslevel, tbl.issecurityenabled, tbl.isdeleteable, tbl.ishighvolume, tbl.isview, to_char('N') AS hasassociation, t.istranslationtab, t.isreadonly, t.ad_image_id, t.tablevel, t.whereclause, t.orderbyclause, t.commitwarning, t.ad_column_id, t.ad_process_id, t.issorttab, t.ad_columnsortorder_id, t.ad_columnsortyesno_id, t.included_tab_id
 FROM ad_tab t
 JOIN ad_table tbl ON t.ad_table_id = tbl.ad_table_id
-WHERE t.isactive = 'Y' AND tbl.isactive = 'Y'
-]]></view>
+WHERE t.isactive = 'Y' AND tbl.isactive = 'Y']]></view>
   </database>
--- a/src-db/database/model/views/AD_TAB_VT.xml	Wed Apr 14 09:41:50 2010 +0200
+++ b/src-db/database/model/views/AD_TAB_VT.xml	Wed Apr 14 11:56:39 2010 +0200
@@ -4,6 +4,5 @@
 FROM ad_tab t
 JOIN ad_table tbl ON t.ad_table_id = tbl.ad_table_id
 JOIN ad_tab_trl trl ON t.ad_tab_id = trl.ad_tab_id
-WHERE t.isactive = 'Y' AND tbl.isactive = 'Y'
-]]></view>
+WHERE t.isactive = 'Y' AND tbl.isactive = 'Y']]></view>
   </database>
--- a/src-db/database/model/views/AD_USER_ROLES_V.xml	Wed Apr 14 09:41:50 2010 +0200
+++ b/src-db/database/model/views/AD_USER_ROLES_V.xml	Wed Apr 14 11:56:39 2010 +0200
@@ -3,6 +3,5 @@
     <view name="AD_USER_ROLES_V"><![CDATA[SELECT u.name, r.name AS rolename
 FROM ad_user_roles ur
 JOIN ad_user u ON ur.ad_user_id = u.ad_user_id
-JOIN ad_role r ON ur.ad_role_id = r.ad_role_id
-]]></view>
+JOIN ad_role r ON ur.ad_role_id = r.ad_role_id]]></view>
   </database>
--- a/src-db/database/model/views/AD_WINDOW_VT.xml	Wed Apr 14 09:41:50 2010 +0200
+++ b/src-db/database/model/views/AD_WINDOW_VT.xml	Wed Apr 14 11:56:39 2010 +0200
@@ -3,6 +3,5 @@
     <view name="AD_WINDOW_VT"><![CDATA[SELECT trl.ad_language, bt.ad_window_id, trl.name, trl.description, trl.help, bt.windowtype, bt.ad_image_id, bt.isactive
 FROM ad_window bt
 JOIN ad_window_trl trl ON bt.ad_window_id = trl.ad_window_id
-WHERE bt.isactive = 'Y'
-]]></view>
+WHERE bt.isactive = 'Y']]></view>
   </database>
--- a/src-db/database/model/views/A_ASSET_AMORTIZATION.xml	Wed Apr 14 09:41:50 2010 +0200
+++ b/src-db/database/model/views/A_ASSET_AMORTIZATION.xml	Wed Apr 14 11:56:39 2010 +0200
@@ -2,6 +2,5 @@
   <database name="VIEW A_ASSET_AMORTIZATION">
     <view name="A_ASSET_AMORTIZATION"><![CDATA[SELECT a_asset.ad_client_id, a_asset.ad_org_id, a_asset.isactive, a_asset.created, a_asset.createdby, a_asset.updated, a_asset.updatedby, a_asset.a_asset_id, a_amortization.a_amortization_id, a_amortization.startdate, a_amortization.enddate, a_amortizationline.amortization_percentage, a_amortizationline.amortizationamt
 FROM a_asset, a_amortization, a_amortizationline
-WHERE a_asset.a_asset_id = a_amortizationline.a_asset_id AND a_amortizationline.a_amortization_id = a_amortization.a_amortization_id
-]]></view>
+WHERE a_asset.a_asset_id = a_amortizationline.a_asset_id AND a_amortizationline.a_amortization_id = a_amortization.a_amortization_id]]></view>
   </database>
--- a/src-db/database/model/views/C_BPARTNER_V.xml	Wed Apr 14 09:41:50 2010 +0200
+++ b/src-db/database/model/views/C_BPARTNER_V.xml	Wed Apr 14 11:56:39 2010 +0200
@@ -4,6 +4,5 @@
 FROM c_bpartner p
 LEFT JOIN ad_user c ON p.c_bpartner_id = c.c_bpartner_id
 LEFT JOIN c_bpartner_location l ON p.c_bpartner_id = l.c_bpartner_id
-LEFT JOIN c_location a ON l.c_location_id = a.c_location_id
-]]></view>
+LEFT JOIN c_location a ON l.c_location_id = a.c_location_id]]></view>
   </database>
--- a/src-db/database/model/views/C_CASH_DETAIL.xml	Wed Apr 14 09:41:50 2010 +0200
+++ b/src-db/database/model/views/C_CASH_DETAIL.xml	Wed Apr 14 11:56:39 2010 +0200
@@ -2,6 +2,5 @@
   <database name="VIEW C_CASH_DETAIL">
     <view name="C_CASH_DETAIL"><![CDATA[SELECT cl.c_cash_id, cl.c_cashline_id, c.ad_client_id, c.ad_org_id, cl.isactive, cl.created, cl.createdby, cl.updated, cl.updatedby, c.c_cashbook_id, c.name, c.statementdate, c.dateacct, c.processed, c.posted, cl.line, cl.description, cl.cashtype, cl.c_currency_id, cl.amount, c_currency_convert(cl.amount, cl.c_currency_id, cb.c_currency_id, c.statementdate, NULL, c.ad_client_id, c.ad_org_id) AS convertedamt, cl.c_debt_payment_id, cl.c_charge_id
 FROM c_cash c, c_cashline cl, c_cashbook cb
-WHERE c.c_cash_id = cl.c_cash_id AND c.c_cashbook_id = cb.c_cashbook_id
-]]></view>
+WHERE c.c_cash_id = cl.c_cash_id AND c.c_cashbook_id = cb.c_cashbook_id]]></view>
   </database>
--- a/src-db/database/model/views/C_DEBT_PAYMENT_CANCEL.xml	Wed Apr 14 09:41:50 2010 +0200
+++ b/src-db/database/model/views/C_DEBT_PAYMENT_CANCEL.xml	Wed Apr 14 11:56:39 2010 +0200
@@ -2,6 +2,5 @@
   <database name="VIEW C_DEBT_PAYMENT_CANCEL">
     <view name="C_DEBT_PAYMENT_CANCEL"><![CDATA[SELECT c_debt_payment.c_debt_payment_id, c_debt_payment.ad_client_id, c_debt_payment.ad_org_id, c_debt_payment.isactive, c_debt_payment.created, c_debt_payment.createdby, c_debt_payment.updated, c_debt_payment.updatedby, c_debt_payment.isreceipt, c_debt_payment.c_settlement_cancel_id AS c_settlement_id, c_debt_payment.description, c_debt_payment.c_invoice_id, c_debt_payment.c_bpartner_id, c_debt_payment.c_currency_id, c_debt_payment.c_cashline_id, c_debt_payment.c_bankstatementline_id, c_debt_payment.c_bankaccount_id, c_debt_payment.c_cashbook_id, c_debt_payment.paymentrule, c_debt_payment.ispaid, c_debt_payment.amount, c_debt_payment.writeoffamt, c_debt_payment.dateplanned, c_debt_payment.ismanual, c_debt_payment.isvalid, c_debt_payment.changesettlementcancel, c_debt_payment.cancel_processed, c_debt_payment.status, c_debt_payment.c_withholding_id, c_debt_payment.withholdingamount
 FROM c_debt_payment
-WHERE c_debt_payment.c_settlement_cancel_id IS NOT NULL
-]]></view>
+WHERE c_debt_payment.c_settlement_cancel_id IS NOT NULL]]></view>
   </database>
--- a/src-db/database/model/views/C_DEBT_PAYMENT_GENERATE.xml	Wed Apr 14 09:41:50 2010 +0200
+++ b/src-db/database/model/views/C_DEBT_PAYMENT_GENERATE.xml	Wed Apr 14 11:56:39 2010 +0200
@@ -2,6 +2,5 @@
   <database name="VIEW C_DEBT_PAYMENT_GENERATE">
     <view name="C_DEBT_PAYMENT_GENERATE"><![CDATA[SELECT c_debt_payment.c_debt_payment_id, c_debt_payment.ad_client_id, c_debt_payment.ad_org_id, c_debt_payment.isactive, c_debt_payment.created, c_debt_payment.createdby, c_debt_payment.updated, c_debt_payment.updatedby, c_debt_payment.isreceipt, c_debt_payment.c_settlement_generate_id AS c_settlement_id, c_debt_payment.description, c_debt_payment.c_invoice_id, c_debt_payment.c_bpartner_id, c_debt_payment.c_currency_id, c_debt_payment.c_cashline_id, c_debt_payment.c_bankstatementline_id, c_debt_payment.c_bankaccount_id, c_debt_payment.c_cashbook_id, c_debt_payment.paymentrule, c_debt_payment.ispaid, c_debt_payment.amount, c_debt_payment.writeoffamt, c_debt_payment.dateplanned, c_debt_payment.ismanual, c_debt_payment.isvalid, c_debt_payment.generate_processed, c_debt_payment.glitemamt, c_debt_payment.c_settlement_cancel_id, c_debt_payment.c_glitem_id, c_debt_payment.isdirectposting, c_debt_payment.status_initial AS status, c_debt_payment.c_project_id, c_debt_payment.c_withholding_id, c_debt_payment.withholdingamount
 FROM c_debt_payment
-WHERE c_debt_payment.c_settlement_generate_id IS NOT NULL
-]]></view>
+WHERE c_debt_payment.c_settlement_generate_id IS NOT NULL]]></view>
   </database>
--- a/src-db/database/model/views/C_DEBT_PAYMENT_V.xml	Wed Apr 14 09:41:50 2010 +0200
+++ b/src-db/database/model/views/C_DEBT_PAYMENT_V.xml	Wed Apr 14 11:56:39 2010 +0200
@@ -20,6 +20,5 @@
 END AS docdate, c_debt_payment.glitemamt, c_debt_payment.c_order_id, c_debt_payment.status
 FROM c_debt_payment
 LEFT JOIN c_invoice ON c_debt_payment.c_invoice_id = c_invoice.c_invoice_id
-LEFT JOIN c_settlement ON c_debt_payment.c_settlement_generate_id = c_settlement.c_settlement_id
-]]></view>
+LEFT JOIN c_settlement ON c_debt_payment.c_settlement_generate_id = c_settlement.c_settlement_id]]></view>
   </database>
--- a/src-db/database/model/views/C_INVOICELINE_V.xml	Wed Apr 14 09:41:50 2010 +0200
+++ b/src-db/database/model/views/C_INVOICELINE_V.xml	Wed Apr 14 11:56:39 2010 +0200
@@ -10,6 +10,5 @@
 ELSE round(i.multiplier * il.linenetamt - il.pricelimit * il.qtyinvoiced, 2)
 END AS lineoverlimitamt, il.qtyinvoiced, il.line, il.c_orderline_id, il.c_uom_id
 FROM c_invoice_v i, c_invoiceline il
-WHERE i.c_invoice_id = il.c_invoice_id
-]]></view>
+WHERE i.c_invoice_id = il.c_invoice_id]]></view>
   </database>
--- a/src-db/database/model/views/C_INVOICELINE_V2.xml	Wed Apr 14 09:41:50 2010 +0200
+++ b/src-db/database/model/views/C_INVOICELINE_V2.xml	Wed Apr 14 11:56:39 2010 +0200
@@ -18,6 +18,5 @@
 ELSE round(i.multiplier * il.linenetamt - il.pricelimit * il.qtyinvoiced, 2)
 END AS lineoverlimitamt
 FROM c_invoice_v2 i, c_invoiceline il, m_product p
-WHERE i.c_invoice_id = il.c_invoice_id AND il.m_product_id = p.m_product_id
-]]></view>
+WHERE i.c_invoice_id = il.c_invoice_id AND il.m_product_id = p.m_product_id]]></view>
   </database>
--- a/src-db/database/model/views/C_INVOICE_CANDIDATE_V.xml	Wed Apr 14 09:41:50 2010 +0200
+++ b/src-db/database/model/views/C_INVOICE_CANDIDATE_V.xml	Wed Apr 14 11:56:39 2010 +0200
@@ -15,6 +15,5 @@
 GROUP BY o.ad_client_id, o.ad_org_id, o.c_bpartner_id, o.c_order_id, o.documentno, o.dateordered, o.c_doctype_id, o.totallines, o.grandtotal, l.c_tax_id, o.invoicerule, o.m_pricelist_id, c.c_currency_id
 HAVING sum((l.qtyordered - l.qtyinvoiced) * l.priceactual) <> 0 OR sum((l.qtydelivered - l.qtyinvoiced) * l.priceactual) <> 0) sq
 JOIN m_pricelist p ON sq.m_pricelist_id = p.m_pricelist_id
-JOIN c_currency c ON sq.c_currency_id = c.c_currency_id
-]]></view>
+JOIN c_currency c ON sq.c_currency_id = c.c_currency_id]]></view>
   </database>
--- a/src-db/database/model/views/C_INVOICE_CUSTOMERPRODQTR.xml	Wed Apr 14 09:41:50 2010 +0200
+++ b/src-db/database/model/views/C_INVOICE_CUSTOMERPRODQTR.xml	Wed Apr 14 11:56:39 2010 +0200
@@ -10,6 +10,5 @@
 ELSE 100 - round((sum(il.linenetamt) - sum(il.lineoverlimitamt)) / sum(il.linenetamt) * 100, 2)
 END AS lineoverlimit, sum(il.qtyinvoiced) AS qtyinvoiced
 FROM c_invoiceline_v2 il
-GROUP BY il.ad_client_id, il.ad_org_id, il.c_bpartner_id, il.m_product_category_id, TRUNC(il.dateinvoiced, 'Q')
-]]></view>
+GROUP BY il.ad_client_id, il.ad_org_id, il.c_bpartner_id, il.m_product_category_id, TRUNC(il.dateinvoiced, 'Q')]]></view>
   </database>
--- a/src-db/database/model/views/C_INVOICE_CUSTOMERVENDQTR.xml	Wed Apr 14 09:41:50 2010 +0200
+++ b/src-db/database/model/views/C_INVOICE_CUSTOMERVENDQTR.xml	Wed Apr 14 11:56:39 2010 +0200
@@ -11,6 +11,5 @@
 END AS lineoverlimit, sum(il.qtyinvoiced) AS qtyinvoiced
 FROM c_invoiceline_v2 il, m_product_po po
 WHERE il.m_product_id = po.m_product_id
-GROUP BY il.ad_client_id, il.ad_org_id, il.c_bpartner_id, po.c_bpartner_id, TRUNC(il.dateinvoiced, 'Q')
-]]></view>
+GROUP BY il.ad_client_id, il.ad_org_id, il.c_bpartner_id, po.c_bpartner_id, TRUNC(il.dateinvoiced, 'Q')]]></view>
   </database>
--- a/src-db/database/model/views/C_INVOICE_DAY.xml	Wed Apr 14 09:41:50 2010 +0200
+++ b/src-db/database/model/views/C_INVOICE_DAY.xml	Wed Apr 14 11:56:39 2010 +0200
@@ -10,6 +10,5 @@
 ELSE 100 - round((sum(c_invoiceline_v2.linenetamt) - sum(c_invoiceline_v2.lineoverlimitamt)) / sum(c_invoiceline_v2.linenetamt) * 100, 2)
 END AS lineoverlimit
 FROM c_invoiceline_v2
-GROUP BY c_invoiceline_v2.ad_client_id, c_invoiceline_v2.ad_org_id, c_invoiceline_v2.salesrep_id, TRUNC(c_invoiceline_v2.dateinvoiced, 'DD')
-]]></view>
+GROUP BY c_invoiceline_v2.ad_client_id, c_invoiceline_v2.ad_org_id, c_invoiceline_v2.salesrep_id, TRUNC(c_invoiceline_v2.dateinvoiced, 'DD')]]></view>
   </database>
--- a/src-db/database/model/views/C_INVOICE_HEADER_V.xml	Wed Apr 14 09:41:50 2010 +0200
+++ b/src-db/database/model/views/C_INVOICE_HEADER_V.xml	Wed Apr 14 11:56:39 2010 +0200
@@ -11,6 +11,5 @@
 LEFT JOIN c_greeting bpcg ON bpc.c_greeting_id = bpcg.c_greeting_id
 JOIN ad_orginfo oi ON i.ad_org_id = oi.ad_org_id
 LEFT JOIN ad_user u ON i.salesrep_id = u.ad_user_id
-LEFT JOIN c_bpartner ubp ON u.c_bpartner_id = ubp.c_bpartner_id
-]]></view>
+LEFT JOIN c_bpartner ubp ON u.c_bpartner_id = ubp.c_bpartner_id]]></view>
   </database>
--- a/src-db/database/model/views/C_INVOICE_HEADER_VT.xml	Wed Apr 14 09:41:50 2010 +0200
+++ b/src-db/database/model/views/C_INVOICE_HEADER_VT.xml	Wed Apr 14 11:56:39 2010 +0200
@@ -11,6 +11,5 @@
 LEFT JOIN c_greeting_trl bpcg ON bpc.c_greeting_id = bpcg.c_greeting_id AND dt.ad_language = bpcg.ad_language
 JOIN ad_orginfo oi ON i.ad_org_id = oi.ad_org_id
 LEFT JOIN ad_user u ON i.salesrep_id = u.ad_user_id
-LEFT JOIN c_bpartner ubp ON u.c_bpartner_id = ubp.c_bpartner_id
-]]></view>
+LEFT JOIN c_bpartner ubp ON u.c_bpartner_id = ubp.c_bpartner_id]]></view>
   </database>
--- a/src-db/database/model/views/C_INVOICE_LINETAX_V.xml	Wed Apr 14 09:41:50 2010 +0200
+++ b/src-db/database/model/views/C_INVOICE_LINETAX_V.xml	Wed Apr 14 11:56:39 2010 +0200
@@ -51,6 +51,5 @@
 UNION 
 SELECT it.ad_client_id, it.ad_org_id, it.isactive, it.created, it.createdby, it.updated, it.updatedby, 'en_US' AS ad_language, it.c_invoice_id, NULL AS c_invoiceline_id, it.c_tax_id, 9999 AS line, NULL AS qtyinvoiced, NULL AS uomsymbol, t.name, NULL AS description, NULL AS documentnote, NULL AS upc, NULL AS sku, NULL AS productvalue, NULL AS resourcedescription, NULL AS pricelist, NULL AS discount, it.taxbaseamt AS priceactual, it.taxamt AS linenetamt
 FROM c_invoicetax it
-JOIN c_tax t ON it.c_tax_id = t.c_tax_id
-]]></view>
+JOIN c_tax t ON it.c_tax_id = t.c_tax_id]]></view>
   </database>
--- a/src-db/database/model/views/C_INVOICE_LINETAX_VT.xml	Wed Apr 14 09:41:50 2010 +0200
+++ b/src-db/database/model/views/C_INVOICE_LINETAX_VT.xml	Wed Apr 14 11:56:39 2010 +0200
@@ -55,6 +55,5 @@
 SELECT it.ad_client_id, it.ad_org_id, it.isactive, it.created, it.createdby, it.updated, it.updatedby, l.ad_language, it.c_invoice_id, NULL AS c_invoiceline_id, it.c_tax_id, 9999 AS line, NULL AS qtyinvoiced, NULL AS uomsymbol, t.name, NULL AS description, NULL AS documentnote, NULL AS upc, NULL AS sku, NULL AS productvalue, NULL AS resourcedescription, NULL AS pricelist, NULL AS discount, it.taxbaseamt AS priceactual, it.taxamt AS linenetamt
 FROM c_invoicetax it
 JOIN c_tax t ON it.c_tax_id = t.c_tax_id, ad_language l
-WHERE l.isbaselanguage = 'N' AND l.issystemlanguage = 'Y'
-]]></view>
+WHERE l.isbaselanguage = 'N' AND l.issystemlanguage = 'Y']]></view>
   </database>
--- a/src-db/database/model/views/C_INVOICE_MONTH.xml	Wed Apr 14 09:41:50 2010 +0200
+++ b/src-db/database/model/views/C_INVOICE_MONTH.xml	Wed Apr 14 11:56:39 2010 +0200
@@ -10,6 +10,5 @@
 ELSE 100 - round((sum(c_invoiceline_v2.linenetamt) - sum(c_invoiceline_v2.lineoverlimitamt)) / sum(c_invoiceline_v2.linenetamt) * 100, 2)
 END AS lineoverlimit
 FROM c_invoiceline_v2
-GROUP BY c_invoiceline_v2.ad_client_id, c_invoiceline_v2.ad_org_id, c_invoiceline_v2.salesrep_id, TRUNC(c_invoiceline_v2.dateinvoiced, 'MM')
-]]></view>
+GROUP BY c_invoiceline_v2.ad_client_id, c_invoiceline_v2.ad_org_id, c_invoiceline_v2.salesrep_id, TRUNC(c_invoiceline_v2.dateinvoiced, 'MM')]]></view>
   </database>
--- a/src-db/database/model/views/C_INVOICE_PRODMONTH.xml	Wed Apr 14 09:41:50 2010 +0200
+++ b/src-db/database/model/views/C_INVOICE_PRODMONTH.xml	Wed Apr 14 11:56:39 2010 +0200
@@ -10,6 +10,5 @@
 ELSE 100 - round((sum(il.linenetamt) - sum(il.lineoverlimitamt)) / sum(il.linenetamt) * 100, 2)
 END AS lineoverlimit, sum(il.qtyinvoiced) AS qtyinvoiced
 FROM c_invoiceline_v2 il
-GROUP BY il.ad_client_id, il.ad_org_id, il.m_product_category_id, TRUNC(il.dateinvoiced, 'MM')
-]]></view>
+GROUP BY il.ad_client_id, il.ad_org_id, il.m_product_category_id, TRUNC(il.dateinvoiced, 'MM')]]></view>
   </database>
--- a/src-db/database/model/views/C_INVOICE_PRODWEEK.xml	Wed Apr 14 09:41:50 2010 +0200
+++ b/src-db/database/model/views/C_INVOICE_PRODWEEK.xml	Wed Apr 14 11:56:39 2010 +0200
@@ -10,6 +10,5 @@
 ELSE 100 - round((sum(il.linenetamt) - sum(il.lineoverlimitamt)) / sum(il.linenetamt) * 100, 2)
 END AS lineoverlimit, sum(il.qtyinvoiced) AS qtyinvoiced
 FROM c_invoiceline_v2 il
-GROUP BY il.ad_client_id, il.ad_org_id, il.m_product_category_id, TRUNC(il.dateinvoiced, 'DY')
-]]></view>
+GROUP BY il.ad_client_id, il.ad_org_id, il.m_product_category_id, TRUNC(il.dateinvoiced, 'DY')]]></view>
   </database>
--- a/src-db/database/model/views/C_INVOICE_V.xml	Wed Apr 14 09:41:50 2010 +0200
+++ b/src-db/database/model/views/C_INVOICE_V.xml	Wed Apr 14 11:56:39 2010 +0200
@@ -22,6 +22,5 @@
 ELSE 1
 END AS multiplierap, d.docbasetype
 FROM c_invoice i
-JOIN c_doctype d ON i.c_doctype_id = d.c_doctype_id
-]]></view>
+JOIN c_doctype d ON i.c_doctype_id = d.c_doctype_id]]></view>
   </database>
--- a/src-db/database/model/views/C_INVOICE_V2.xml	Wed Apr 14 09:41:50 2010 +0200
+++ b/src-db/database/model/views/C_INVOICE_V2.xml	Wed Apr 14 11:56:39 2010 +0200
@@ -18,6 +18,5 @@
 ELSE 1
 END AS multiplier
 FROM c_invoice i, c_doctype d, c_bpartner b
-WHERE i.c_doctype_id = d.c_doctype_id AND i.c_bpartner_id = b.c_bpartner_id
-]]></view>
+WHERE i.c_doctype_id = d.c_doctype_id AND i.c_bpartner_id = b.c_bpartner_id]]></view>
   </database>
--- a/src-db/database/model/views/C_INVOICE_VENDORMONTH.xml	Wed Apr 14 09:41:50 2010 +0200
+++ b/src-db/database/model/views/C_INVOICE_VENDORMONTH.xml	Wed Apr 14 11:56:39 2010 +0200
@@ -11,6 +11,5 @@
 END AS lineoverlimit, sum(il.qtyinvoiced) AS qtyinvoiced
 FROM c_invoiceline_v2 il, m_product_po po
 WHERE il.m_product_id = po.m_product_id
-GROUP BY il.ad_client_id, il.ad_org_id, po.c_bpartner_id, TRUNC(il.dateinvoiced, 'MM')
-]]></view>
+GROUP BY il.ad_client_id, il.ad_org_id, po.c_bpartner_id, TRUNC(il.dateinvoiced, 'MM')]]></view>
   </database>
--- a/src-db/database/model/views/C_INVOICE_WEEK.xml	Wed Apr 14 09:41:50 2010 +0200
+++ b/src-db/database/model/views/C_INVOICE_WEEK.xml	Wed Apr 14 11:56:39 2010 +0200
@@ -10,6 +10,5 @@
 ELSE 100 - round((sum(c_invoiceline_v2.linenetamt) - sum(c_invoiceline_v2.lineoverlimitamt)) / sum(c_invoiceline_v2.linenetamt) * 100, 2)
 END AS lineoverlimit
 FROM c_invoiceline_v2
-GROUP BY c_invoiceline_v2.ad_client_id, c_invoiceline_v2.ad_org_id, c_invoiceline_v2.salesrep_id, TRUNC(c_invoiceline_v2.dateinvoiced, 'DY')
-]]></view>
+GROUP BY c_invoiceline_v2.ad_client_id, c_invoiceline_v2.ad_org_id, c_invoiceline_v2.salesrep_id, TRUNC(c_invoiceline_v2.dateinvoiced, 'DY')]]></view>
   </database>
--- a/src-db/database/model/views/C_ORDER_HEADER_V.xml	Wed Apr 14 09:41:50 2010 +0200
+++ b/src-db/database/model/views/C_ORDER_HEADER_V.xml	Wed Apr 14 11:56:39 2010 +0200
@@ -11,6 +11,5 @@
 LEFT JOIN c_greeting bpcg ON bpc.c_greeting_id = bpcg.c_greeting_id
 JOIN ad_orginfo oi ON o.ad_org_id = oi.ad_org_id
 LEFT JOIN ad_user u ON o.salesrep_id = u.ad_user_id
-LEFT JOIN c_bpartner ubp ON u.c_bpartner_id = ubp.c_bpartner_id
-]]></view>
+LEFT JOIN c_bpartner ubp ON u.c_bpartner_id = ubp.c_bpartner_id]]></view>
   </database>
--- a/src-db/database/model/views/C_ORDER_HEADER_VT.xml	Wed Apr 14 09:41:50 2010 +0200
+++ b/src-db/database/model/views/C_ORDER_HEADER_VT.xml	Wed Apr 14 11:56:39 2010 +0200
@@ -11,6 +11,5 @@
 LEFT JOIN c_greeting_trl bpcg ON bpc.c_greeting_id = bpcg.c_greeting_id AND dt.ad_language = bpcg.ad_language
 JOIN ad_orginfo oi ON o.ad_org_id = oi.ad_org_id
 LEFT JOIN ad_user u ON o.salesrep_id = u.ad_user_id
-LEFT JOIN c_bpartner ubp ON u.c_bpartner_id = ubp.c_bpartner_id
-]]></view>
+LEFT JOIN c_bpartner ubp ON u.c_bpartner_id = ubp.c_bpartner_id]]></view>
   </database>
--- a/src-db/database/model/views/C_ORDER_LINETAX_V.xml	Wed Apr 14 09:41:50 2010 +0200
+++ b/src-db/database/model/views/C_ORDER_LINETAX_V.xml	Wed Apr 14 11:56:39 2010 +0200
@@ -31,6 +31,5 @@
 UNION 
 SELECT ot.ad_client_id, ot.ad_org_id, ot.isactive, ot.created, ot.createdby, ot.updated, ot.updatedby, 'en_US' AS ad_language, ot.c_order_id, NULL AS c_orderline_id, ot.c_tax_id, NULL AS line, NULL AS qtyordered, NULL AS uomsymbol, t.name, NULL AS description, NULL AS documentnote, NULL AS upc, NULL AS sku, NULL AS productvalue, NULL AS resourcedescription, NULL AS pricelist, NULL AS discount, ot.taxbaseamt AS priceactual, ot.taxamt AS linenetamt
 FROM c_ordertax ot
-JOIN c_tax t ON ot.c_tax_id = t.c_tax_id
-]]></view>
+JOIN c_tax t ON ot.c_tax_id = t.c_tax_id]]></view>
   </database>
--- a/src-db/database/model/views/C_ORDER_LINETAX_VT.xml	Wed Apr 14 09:41:50 2010 +0200
+++ b/src-db/database/model/views/C_ORDER_LINETAX_VT.xml	Wed Apr 14 11:56:39 2010 +0200
@@ -35,6 +35,5 @@
 SELECT ot.ad_client_id, ot.ad_org_id, ot.isactive, ot.created, ot.createdby, ot.updated, ot.updatedby, l.ad_language, ot.c_order_id, NULL AS c_orderline_id, ot.c_tax_id, NULL AS line, NULL AS qtyordered, NULL AS uomsymbol, t.name, NULL AS description, NULL AS documentnote, NULL AS upc, NULL AS sku, NULL AS productvalue, NULL AS resourcedescription, NULL AS pricelist, NULL AS discount, ot.taxbaseamt AS priceactual, ot.taxamt AS linenetamt
 FROM c_ordertax ot
 JOIN c_tax t ON ot.c_tax_id = t.c_tax_id, ad_language l
-WHERE l.isbaselanguage = 'N' AND l.issystemlanguage = 'Y'
-]]></view>
+WHERE l.isbaselanguage = 'N' AND l.issystemlanguage = 'Y']]></view>
   </database>
--- a/src-db/database/model/views/C_ORDER_OPEN.xml	Wed Apr 14 09:41:50 2010 +0200
+++ b/src-db/database/model/views/C_ORDER_OPEN.xml	Wed Apr 14 11:56:39 2010 +0200
@@ -2,6 +2,5 @@
   <database name="VIEW C_ORDER_OPEN">
     <view name="C_ORDER_OPEN"><![CDATA[SELECT l.ad_client_id, l.ad_org_id, l.isactive, l.created, l.createdby, l.updated, l.updatedby, o.c_order_id, o.docstatus, o.docaction, o.c_doctype_id, o.salesrep_id, o.c_bpartner_id, o.c_bpartner_location_id, o.ad_user_id, o.poreference, o.c_currency_id, o.issotrx, l.c_orderline_id, l.dateordered, l.datepromised, l.m_product_id, l.m_warehouse_id, l.directship, l.c_uom_id, l.qtyordered, l.qtyreserved, l.qtydelivered, l.qtyinvoiced, l.priceactual, l.qtyordered - l.qtydelivered AS qtytodeliver, l.qtyordered - l.qtyinvoiced AS qtytoinvoice, (l.qtyordered - l.qtyinvoiced) * l.priceactual AS netamttoinvoice
 FROM c_order o, c_orderline l
-WHERE o.c_order_id = l.c_order_id AND (l.qtyordered <> l.qtydelivered OR l.qtyordered <> l.qtyinvoiced)
-]]></view>
+WHERE o.c_order_id = l.c_order_id AND (l.qtyordered <> l.qtydelivered OR l.qtyordered <> l.qtyinvoiced)]]></view>
   </database>
--- a/src-db/database/model/views/C_PERIODCONTROL_V.xml	Wed Apr 14 09:41:50 2010 +0200
+++ b/src-db/database/model/views/C_PERIODCONTROL_V.xml	Wed Apr 14 11:56:39 2010 +0200
@@ -2,6 +2,5 @@
   <database name="VIEW C_PERIODCONTROL_V">
     <view name="C_PERIODCONTROL_V"><![CDATA[SELECT pc.c_periodcontrol_id AS c_periodcontrol_v_id, pc.ad_client_id, pc.ad_org_id, pc.isactive, pc.created, pc.createdby, pc.updated, pc.updatedby, pc.c_period_id, pc.docbasetype, pc.periodstatus, pc.periodaction, pc.processing, y.c_calendar_id, y.year, p.startdate, p.enddate, p.name
 FROM c_periodcontrol pc, c_period p, c_year y
-WHERE pc.c_period_id = p.c_period_id AND p.c_year_id = y.c_year_id
-]]></view>
+WHERE pc.c_period_id = p.c_period_id AND p.c_year_id = y.c_year_id]]></view>
   </database>
--- a/src-db/database/model/views/C_PROJECTPROPOSAL_V.xml	Wed Apr 14 09:41:50 2010 +0200
+++ b/src-db/database/model/views/C_PROJECTPROPOSAL_V.xml	Wed Apr 14 11:56:39 2010 +0200
@@ -2,6 +2,5 @@
   <database name="VIEW C_PROJECTPROPOSAL_V">
     <view name="C_PROJECTPROPOSAL_V"><![CDATA[SELECT p.datesend AS fromdatesend, p.datesend AS todatesend, p.ad_client_id, p.ad_org_id, p.ad_user_id, p.c_bpartner_id, p.c_bpartner_location_id, p.c_project_id, p.c_projectproposal_id, p.issotrx, u.firstname, u.lastname, p.datesend, p.created, p.createdby, p.updated, p.updatedby
 FROM c_projectproposal p, ad_user u, c_project pr
-WHERE p.ad_user_id = u.ad_user_id AND p.c_project_id = pr.c_project_id AND p.isactive = 'Y' AND pr.isactive = 'Y'
-]]></view>
+WHERE p.ad_user_id = u.ad_user_id AND p.c_project_id = pr.c_project_id AND p.isactive = 'Y' AND pr.isactive = 'Y']]></view>
   </database>
--- a/src-db/database/model/views/C_PROJECT_DETAILS_V.xml	Wed Apr 14 09:41:50 2010 +0200
+++ b/src-db/database/model/views/C_PROJECT_DETAILS_V.xml	Wed Apr 14 11:56:39 2010 +0200
@@ -8,6 +8,5 @@
 FROM c_projectline pl
 JOIN c_project pj ON pl.c_project_id = pj.c_project_id
 LEFT JOIN m_product p ON pl.m_product_id = p.m_product_id
-WHERE pl.isprinted = 'Y'
-]]></view>
+WHERE pl.isprinted = 'Y']]></view>
   </database>
--- a/src-db/database/model/views/C_PROJECT_DETAILS_VT.xml	Wed Apr 14 09:41:50 2010 +0200
+++ b/src-db/database/model/views/C_PROJECT_DETAILS_VT.xml	Wed Apr 14 11:56:39 2010 +0200
@@ -8,6 +8,5 @@
 FROM c_projectline pl
 JOIN c_project pj ON pl.c_project_id = pj.c_project_id
 LEFT JOIN m_product p ON pl.m_product_id = p.m_product_id
-WHERE pl.isprinted = 'Y'
-]]></view>
+WHERE pl.isprinted = 'Y']]></view>
   </database>
--- a/src-db/database/model/views/C_PROJECT_HEADER_V.xml	Wed Apr 14 09:41:50 2010 +0200
+++ b/src-db/database/model/views/C_PROJECT_HEADER_V.xml	Wed Apr 14 11:56:39 2010 +0200
@@ -12,6 +12,5 @@
 LEFT JOIN ad_user bpc ON p.ad_user_id = bpc.ad_user_id
 LEFT JOIN c_greeting bpcg ON bpc.c_greeting_id = bpcg.c_greeting_id
 LEFT JOIN c_bpartner_location bpl ON p.c_bpartner_location_id = bpl.c_bpartner_location_id
-LEFT JOIN c_paymentterm pt ON p.c_paymentterm_id = pt.c_paymentterm_id
-]]></view>
+LEFT JOIN c_paymentterm pt ON p.c_paymentterm_id = pt.c_paymentterm_id]]></view>
   </database>
--- a/src-db/database/model/views/C_PROJECT_HEADER_VT.xml	Wed Apr 14 09:41:50 2010 +0200
+++ b/src-db/database/model/views/C_PROJECT_HEADER_VT.xml	Wed Apr 14 11:56:39 2010 +0200
@@ -12,6 +12,5 @@
 LEFT JOIN c_greeting bpg ON bp.c_greeting_id = bpg.c_greeting_id
 LEFT JOIN ad_user bpc ON p.ad_user_id = bpc.ad_user_id
 LEFT JOIN c_greeting bpcg ON bpc.c_greeting_id = bpcg.c_greeting_id
-LEFT JOIN c_bpartner_location bpl ON p.c_bpartner_location_id = bpl.c_bpartner_location_id
-]]></view>
+LEFT JOIN c_bpartner_location bpl ON p.c_bpartner_location_id = bpl.c_bpartner_location_id]]></view>
   </database>
--- a/src-db/database/model/views/FIN_PAYMENT_DETAIL_V.xml	Wed Apr 14 09:41:50 2010 +0200
+++ b/src-db/database/model/views/FIN_PAYMENT_DETAIL_V.xml	Wed Apr 14 11:56:39 2010 +0200
@@ -6,6 +6,5 @@
 LEFT JOIN c_invoice i ON psi.c_invoice_id = i.c_invoice_id
 LEFT JOIN fin_payment_sched_ord_v pso ON psd.fin_payment_schedule_order = pso.fin_payment_sched_ord_v_id
 LEFT JOIN c_order o ON pso.c_order_id = o.c_order_id
-WHERE p.fin_payment_id = pd.fin_payment_id AND pd.fin_payment_detail_id = psd.fin_payment_detail_id
-]]></view>
+WHERE p.fin_payment_id = pd.fin_payment_id AND pd.fin_payment_detail_id = psd.fin_payment_detail_id]]></view>
   </database>
--- a/src-db/database/model/views/FIN_PAYMENT_PROP_DETAIL_V.xml	Wed Apr 14 09:41:50 2010 +0200
+++ b/src-db/database/model/views/FIN_PAYMENT_PROP_DETAIL_V.xml	Wed Apr 14 11:56:39 2010 +0200
@@ -8,6 +8,5 @@
 LEFT JOIN c_order o ON pso.c_order_id = o.c_order_id
 LEFT JOIN fin_payment_detail pd ON psd.fin_payment_detail_id = pd.fin_payment_detail_id
 LEFT JOIN fin_payment p ON pd.fin_payment_id = p.fin_payment_id
-WHERE ppd.fin_payment_scheduledetail_id = psd.fin_payment_scheduledetail_id
-]]></view>
+WHERE ppd.fin_payment_scheduledetail_id = psd.fin_payment_scheduledetail_id]]></view>
   </database>
--- a/src-db/database/model/views/FIN_PAYMENT_SCHED_INV_V.xml	Wed Apr 14 09:41:50 2010 +0200
+++ b/src-db/database/model/views/FIN_PAYMENT_SCHED_INV_V.xml	Wed Apr 14 11:56:39 2010 +0200
@@ -7,6 +7,5 @@
 WHERE ps.c_invoice_id IS NOT NULL AND psd.fin_payment_schedule_invoice = ps.fin_payment_schedule_id) AS lastpayment, (SELECT count(*) AS count
 FROM fin_payment_detail pd, fin_payment_scheduledetail psd
 WHERE pd.fin_payment_detail_id = psd.fin_payment_detail_id AND ps.c_invoice_id IS NOT NULL AND psd.fin_payment_schedule_invoice = ps.fin_payment_schedule_id) AS numberofpayments
-FROM fin_payment_schedule ps
-]]></view>
+FROM fin_payment_schedule ps]]></view>
   </database>
--- a/src-db/database/model/views/FIN_PAYMENT_SCHED_ORD_V.xml	Wed Apr 14 09:41:50 2010 +0200
+++ b/src-db/database/model/views/FIN_PAYMENT_SCHED_ORD_V.xml	Wed Apr 14 11:56:39 2010 +0200
@@ -7,6 +7,5 @@
 WHERE ps.c_order_id IS NOT NULL AND psd.fin_payment_schedule_order = ps.fin_payment_schedule_id) AS lastpayment, (SELECT count(*) AS count
 FROM fin_payment_detail pd, fin_payment_scheduledetail psd
 WHERE pd.fin_payment_detail_id = psd.fin_payment_detail_id AND ps.c_order_id IS NOT NULL AND psd.fin_payment_schedule_order = ps.fin_payment_schedule_id) AS numberofpayments
-FROM fin_payment_schedule ps
-]]></view>
+FROM fin_payment_schedule ps]]></view>
   </database>
--- a/src-db/database/model/views/FIN_RECONCILIATIONLINE_V.xml	Wed Apr 14 09:41:50 2010 +0200
+++ b/src-db/database/model/views/FIN_RECONCILIATIONLINE_V.xml	Wed Apr 14 11:56:39 2010 +0200
@@ -2,6 +2,5 @@
   <database name="VIEW FIN_RECONCILIATIONLINE_V">
     <view name="FIN_RECONCILIATIONLINE_V"><![CDATA[SELECT fin_finacc_transaction.fin_finacc_transaction_id AS fin_reconciliationline_v_id, fin_finacc_transaction.fin_finacc_transaction_id, fin_finacc_transaction.ad_client_id, fin_finacc_transaction.ad_org_id, fin_finacc_transaction.created, fin_finacc_transaction.createdby, fin_finacc_transaction.updated, fin_finacc_transaction.updatedby, fin_finacc_transaction.isactive, fin_finacc_transaction.fin_payment_id, fin_finacc_transaction.c_currency_id, fin_finacc_transaction.fin_financial_account_id, fin_finacc_transaction.dateacct, fin_finacc_transaction.c_glitem_id, fin_finacc_transaction.paymentamt, fin_finacc_transaction.depositamt, fin_finacc_transaction.c_project_id, fin_finacc_transaction.c_campaign_id, fin_finacc_transaction.c_activity_id, fin_finacc_transaction.user1_id, fin_finacc_transaction.user2_id, fin_finacc_transaction.trxtype, fin_finacc_transaction.statementdate, fin_finacc_transaction.description, fin_finacc_transaction.fin_reconciliation_id, fin_bankstatementline.fin_bankstatementline_id
 FROM fin_finacc_transaction
-LEFT JOIN fin_bankstatementline ON fin_finacc_transaction.fin_finacc_transaction_id = fin_bankstatementline.fin_finacc_transaction_id
-]]></view>
+LEFT JOIN fin_bankstatementline ON fin_finacc_transaction.fin_finacc_transaction_id = fin_bankstatementline.fin_finacc_transaction_id]]></view>
   </database>
--- a/src-db/database/model/views/GL_JOURNALLINE_ACCT_V.xml	Wed Apr 14 09:41:50 2010 +0200
+++ b/src-db/database/model/views/GL_JOURNALLINE_ACCT_V.xml	Wed Apr 14 11:56:39 2010 +0200
@@ -2,6 +2,5 @@
   <database name="VIEW GL_JOURNALLINE_ACCT_V">
     <view name="GL_JOURNALLINE_ACCT_V"><![CDATA[SELECT gl.gl_journalline_id, gl.ad_client_id, gl.ad_org_id, gl.isactive, gl.created, gl.createdby, gl.updated, gl.updatedby, gl.gl_journal_id, gl.line, gl.isgenerated, gl.description, gl.amtsourcedr, gl.amtsourcecr, gl.c_currency_id, gl.currencyratetype, gl.currencyrate, gl.dateacct, gl.amtacctdr, gl.amtacctcr, gl.c_uom_id, gl.qty, gl.c_validcombination_id, vc.c_acctschema_id, vc.account_id, vc.m_product_id, vc.c_bpartner_id, vc.ad_orgtrx_id, vc.c_locfrom_id, vc.c_locto_id, vc.c_salesregion_id, vc.c_project_id, vc.c_campaign_id, vc.user1_id, vc.user2_id, vc.isfullyqualified, vc.c_activity_id
 FROM gl_journalline gl, c_validcombination vc
-WHERE gl.c_validcombination_id = vc.c_validcombination_id
-]]></view>
+WHERE gl.c_validcombination_id = vc.c_validcombination_id]]></view>
   </database>
--- a/src-db/database/model/views/MA_PROCESSPLAN_TOTALIZED.xml	Wed Apr 14 09:41:50 2010 +0200
+++ b/src-db/database/model/views/MA_PROCESSPLAN_TOTALIZED.xml	Wed Apr 14 11:56:39 2010 +0200
@@ -18,6 +18,5 @@
 FROM ma_sequence, ma_sequenceproduct
 WHERE ma_sequence.ma_sequence_id = ma_sequenceproduct.ma_sequence_id
 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 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>
   </database>
--- a/src-db/database/model/views/MA_SEQUENCE_EMPLOYEE_COST.xml	Wed Apr 14 09:41:50 2010 +0200
+++ b/src-db/database/model/views/MA_SEQUENCE_EMPLOYEE_COST.xml	Wed Apr 14 11:56:39 2010 +0200
@@ -13,6 +13,5 @@
 WHERE ccv.ma_costcenter_id = ma_costcenter_version.ma_costcenter_id AND ccv.validfrom <= ma_processplan_version.datefrom)) AND c_salary_category_cost.datefrom = ((SELECT max(sc.datefrom) AS max
 FROM c_salary_category_cost sc
 WHERE sc.c_salary_category_id = c_salary_category_cost.c_salary_category_id AND sc.datefrom <= ma_processplan_version.datefrom))
-GROUP BY ma_sequence.ma_sequence_id, c_salary_category_cost.c_salary_category_id, c_salary_category_cost.cost, c_salary_category_cost.costuom, ma_sequence.costcenteruse
-]]></view>
+GROUP BY ma_sequence.ma_sequence_id, c_salary_category_cost.c_salary_category_id, c_salary_category_cost.cost, c_salary_category_cost.costuom, ma_sequence.costcenteruse]]></view>
   </database>
--- a/src-db/database/model/views/MA_SEQUENCE_INDIRECT_COST_COST.xml	Wed Apr 14 09:41:50 2010 +0200
+++ b/src-db/database/model/views/MA_SEQUENCE_INDIRECT_COST_COST.xml	Wed Apr 14 11:56:39 2010 +0200
@@ -13,6 +13,5 @@
 WHERE ccv.ma_costcenter_id = ma_costcenter_version.ma_costcenter_id AND ccv.validfrom <= ma_processplan_version.datefrom)) AND ma_indirect_cost_value.datefrom = ((SELECT max(sc.datefrom) AS max
 FROM ma_indirect_cost_value sc
 WHERE sc.ma_indirect_cost_id = ma_indirect_cost_value.ma_indirect_cost_id AND sc.datefrom <= ma_processplan_version.datefrom))
-GROUP BY ma_sequence.ma_sequence_id, ma_indirect_cost_value.ma_indirect_cost_id, ma_indirect_cost_value.cost, ma_indirect_cost_value.cost_uom, ma_sequence.costcenteruse
-]]></view>
+GROUP BY ma_sequence.ma_sequence_id, ma_indirect_cost_value.ma_indirect_cost_id, ma_indirect_cost_value.cost, ma_indirect_cost_value.cost_uom, ma_sequence.costcenteruse]]></view>
   </database>
--- a/src-db/database/model/views/MA_SEQUENCE_MACHINE_COST.xml	Wed Apr 14 09:41:50 2010 +0200
+++ b/src-db/database/model/views/MA_SEQUENCE_MACHINE_COST.xml	Wed Apr 14 11:56:39 2010 +0200
@@ -13,6 +13,5 @@
 WHERE ccv.ma_costcenter_id = ma_costcenter_version.ma_costcenter_id AND ccv.validfrom <= ma_processplan_version.datefrom)) AND ma_machine_cost.validfrom = ((SELECT max(mc.validfrom) AS max
 FROM ma_machine_cost mc
 WHERE mc.ma_machine_id = ma_machine_cost.ma_machine_id AND mc.validfrom <= ma_processplan_version.datefrom))
-GROUP BY ma_sequence.ma_sequence_id, ma_machine_cost.ma_machine_id, ma_machine_cost.cost, ma_machine_cost.costuom, ma_sequence.costcenteruse
-]]></view>
+GROUP BY ma_sequence.ma_sequence_id, ma_machine_cost.ma_machine_id, ma_machine_cost.cost, ma_machine_cost.costuom, ma_sequence.costcenteruse]]></view>
   </database>
--- a/src-db/database/model/views/M_INOUT_CANDIDATE_V.xml	Wed Apr 14 09:41:50 2010 +0200
+++ b/src-db/database/model/views/M_INOUT_CANDIDATE_V.xml	Wed Apr 14 11:56:39 2010 +0200
@@ -6,6 +6,5 @@
 WHERE o.docstatus = 'CO' AND o.isdelivered = 'N' AND (o.c_doctype_id IN (SELECT c_doctype.c_doctype_id
 FROM c_doctype
 WHERE c_doctype.docbasetype = 'SOO' AND (c_doctype.docsubtypeso NOT IN ('ON', 'OB', 'WR')))) AND l.qtyordered <> l.qtydelivered AND l.directship = 'N' AND l.m_product_id IS NOT NULL
-GROUP BY o.ad_client_id, o.ad_org_id, o.c_bpartner_id, o.c_order_id, o.documentno, o.dateordered, o.totallines, o.c_doctype_id
-]]></view>
+GROUP BY o.ad_client_id, o.ad_org_id, o.c_bpartner_id, o.c_order_id, o.documentno, o.dateordered, o.totallines, o.c_doctype_id]]></view>
   </database>
--- a/src-db/database/model/views/M_INOUT_HEADER_V.xml	Wed Apr 14 09:41:50 2010 +0200
+++ b/src-db/database/model/views/M_INOUT_HEADER_V.xml	Wed Apr 14 11:56:39 2010 +0200
@@ -9,6 +9,5 @@
 LEFT JOIN ad_user bpc ON io.ad_user_id = bpc.ad_user_id
 LEFT JOIN c_greeting bpcg ON bpc.c_greeting_id = bpcg.c_greeting_id
 JOIN ad_orginfo oi ON io.ad_org_id = oi.ad_org_id
-JOIN m_warehouse wh ON io.m_warehouse_id = wh.m_warehouse_id
-]]></view>
+JOIN m_warehouse wh ON io.m_warehouse_id = wh.m_warehouse_id]]></view>
   </database>
--- a/src-db/database/model/views/M_INOUT_HEADER_VT.xml	Wed Apr 14 09:41:50 2010 +0200
+++ b/src-db/database/model/views/M_INOUT_HEADER_VT.xml	Wed Apr 14 11:56:39 2010 +0200
@@ -9,6 +9,5 @@
 LEFT JOIN ad_user bpc ON io.ad_user_id = bpc.ad_user_id
 LEFT JOIN c_greeting_trl bpcg ON bpc.c_greeting_id = bpcg.c_greeting_id AND dt.ad_language = bpcg.ad_language
 JOIN ad_orginfo oi ON io.ad_org_id = oi.ad_org_id
-JOIN m_warehouse wh ON io.m_warehouse_id = wh.m_warehouse_id
-]]></view>
+JOIN m_warehouse wh ON io.m_warehouse_id = wh.m_warehouse_id]]></view>
   </database>
--- a/src-db/database/model/views/M_INOUT_LINE_V.xml	Wed Apr 14 09:41:50 2010 +0200
+++ b/src-db/database/model/views/M_INOUT_LINE_V.xml	Wed Apr 14 11:56:39 2010 +0200
@@ -14,6 +14,5 @@
 JOIN m_inoutline iol ON b.m_product_id = iol.m_product_id
 JOIN m_product bp ON bp.m_product_id = iol.m_product_id AND bp.isbom = 'Y' AND bp.isverified = 'Y' AND bp.ispicklistprintdetails = 'Y'
 JOIN m_product p ON b.m_productbom_id = p.m_product_id
-JOIN c_uom uom ON p.c_uom_id = uom.c_uom_id
-]]></view>
+JOIN c_uom uom ON p.c_uom_id = uom.c_uom_id]]></view>
   </database>
--- a/src-db/database/model/views/M_INOUT_LINE_VT.xml	Wed Apr 14 09:41:50 2010 +0200
+++ b/src-db/database/model/views/M_INOUT_LINE_VT.xml	Wed Apr 14 11:56:39 2010 +0200
@@ -16,6 +16,5 @@
 JOIN m_product bp ON bp.m_product_id = iol.m_product_id AND bp.isbom = 'Y' AND bp.isverified = 'Y' AND bp.ispicklistprintdetails = 'Y'
 JOIN m_product p ON b.m_productbom_id = p.m_product_id
 JOIN c_uom_trl uom ON p.c_uom_id = uom.c_uom_id
-JOIN m_product_trl pt ON iol.m_product_id = pt.m_product_id AND uom.ad_language = pt.ad_language
-]]></view>
+JOIN m_product_trl pt ON iol.m_product_id = pt.m_product_id AND uom.ad_language = pt.ad_language]]></view>
   </database>
--- a/src-db/database/model/views/M_TRANSACTION_SUM.xml	Wed Apr 14 09:41:50 2010 +0200
+++ b/src-db/database/model/views/M_TRANSACTION_SUM.xml	Wed Apr 14 11:56:39 2010 +0200
@@ -3,6 +3,5 @@
     <view name="M_TRANSACTION_SUM"><![CDATA[SELECT t.ad_client_id, t.ad_org_id, t.movementtype, l.m_warehouse_id, t.m_locator_id, t.m_product_id, t.movementdate, sum(t.movementqty) AS movementqty
 FROM m_transaction t, m_locator l
 WHERE t.m_locator_id = l.m_locator_id
-GROUP BY t.ad_client_id, t.ad_org_id, t.movementtype, l.m_warehouse_id, t.m_locator_id, t.m_product_id, t.movementdate
-]]></view>
+GROUP BY t.ad_client_id, t.ad_org_id, t.movementtype, l.m_warehouse_id, t.m_locator_id, t.m_product_id, t.movementdate]]></view>
   </database>
--- a/src-db/database/model/views/M_TRANSACTION_V.xml	Wed Apr 14 09:41:50 2010 +0200
+++ b/src-db/database/model/views/M_TRANSACTION_V.xml	Wed Apr 14 11:56:39 2010 +0200
@@ -2,6 +2,5 @@
   <database name="VIEW M_TRANSACTION_V">
     <view name="M_TRANSACTION_V"><![CDATA[SELECT t.ad_client_id, t.ad_org_id, t.movementdate, t.movementqty, t.m_product_id, t.m_locator_id, p.m_product_category_id, p.value, po.c_bpartner_id, po.pricepo, po.pricelastpo, po.pricelist
 FROM m_transaction t, m_product p, m_product_po po
-WHERE t.m_product_id = p.m_product_id AND t.m_product_id = po.m_product_id AND po.iscurrentvendor = 'Y'
-]]></view>
+WHERE t.m_product_id = p.m_product_id AND t.m_product_id = po.m_product_id AND po.iscurrentvendor = 'Y']]></view>
   </database>
--- a/src-db/database/model/views/R_REQUEST_V.xml	Wed Apr 14 09:41:50 2010 +0200
+++ b/src-db/database/model/views/R_REQUEST_V.xml	Wed Apr 14 11:56:39 2010 +0200
@@ -2,6 +2,5 @@
   <database name="VIEW R_REQUEST_V">
     <view name="R_REQUEST_V"><![CDATA[SELECT r_request.r_request_id, r_request.ad_client_id, r_request.ad_org_id, r_request.isactive, r_request.created, r_request.createdby, r_request.updated, r_request.updatedby, r_request.documentno, r_request.requestamt, r_request.priority, r_request.duetype, r_request.summary, r_request.isescalated, r_request.datelastaction, r_request.lastresult, r_request.ad_user_id, r_request.c_bpartner_id, r_request.c_campaign_id, r_request.c_order_id, r_request.c_invoice_id, r_request.c_debt_payment_id, r_request.m_product_id, r_request.c_project_id, r_request.actiontype, r_request.r_mailtext_id, r_request.mailsubject, r_request.mailtext, r_request.result, r_request.nextaction, r_request.datenextaction, r_request.processing, r_request.processed, r_request.r_requesttype_id, r_request.salesrep_id, r_request.isselfservice
 FROM r_request
-WHERE r_request.isactive = 'Y' AND r_request.processed = 'N' AND now() > r_request.datenextaction
-]]></view>
+WHERE r_request.isactive = 'Y' AND r_request.processed = 'N' AND now() > r_request.datenextaction]]></view>
   </database>
--- a/src-db/database/model/views/S_TIMEEXPENSELINE_V.xml	Wed Apr 14 09:41:50 2010 +0200
+++ b/src-db/database/model/views/S_TIMEEXPENSELINE_V.xml	Wed Apr 14 11:56:39 2010 +0200
@@ -3,6 +3,5 @@
     <view name="S_TIMEEXPENSELINE_V"><![CDATA[SELECT tel.s_timeexpenseline_id, tel.ad_client_id, tel.ad_org_id, tel.isactive, tel.created, tel.createdby, tel.updated, tel.updatedby, tel.s_timeexpense_id, tel.line, tel.istimereport, te.datereport, tel.m_product_id, tel.qty, tel.expenseamt, tel.c_currency_id, tel.convertedamt, tel.s_resourceassignment_id, tel.description, tel.note, tel.isinvoiced, tel.c_project_id, tel.c_activity_id, tel.c_campaign_id, tel.c_invoiceline_id, tel.invoiceprice, tel.c_uom_id, tel.c_orderline_id, tel.c_projectphase_id, tel.c_projecttask_id, tel.s_timetype_id, te.c_bpartner_id, tel.dateexpense, tel.c_bpartner_id AS tel_c_bpartner_id
 FROM s_timeexpenseline tel
 JOIN s_timeexpense te ON tel.s_timeexpense_id = te.s_timeexpense_id
-WHERE tel.qty <> 0 AND tel.c_invoiceline_id IS NULL AND te.processed = 'Y' AND tel.isactive = 'Y' AND te.isactive = 'Y' AND tel.istimereport <> 'Y'
-]]></view>
+WHERE tel.qty <> 0 AND tel.c_invoiceline_id IS NULL AND te.processed = 'Y' AND tel.isactive = 'Y' AND te.isactive = 'Y' AND tel.istimereport <> 'Y']]></view>
   </database>