details: /erp/devel/pi/rev/9748e2df70e8
changeset: 11092:9748e2df70e8
user: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
date: Tue Mar 08 13:41:07 2011 +0100
summary: Fixes int-dbcons-pgsql - Build # 1375 - Failure
diffstat:
modules/org.openbravo.advpaymentmngt/src-db/database/model/views/APRM_RECONCILIATION_V.xml
| 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diffs (11 lines):
diff -r fe663d27823d -r 9748e2df70e8
modules/org.openbravo.advpaymentmngt/src-db/database/model/views/APRM_RECONCILIATION_V.xml
---
a/modules/org.openbravo.advpaymentmngt/src-db/database/model/views/APRM_RECONCILIATION_V.xml
Tue Mar 08 13:34:00 2011 +0100
+++
b/modules/org.openbravo.advpaymentmngt/src-db/database/model/views/APRM_RECONCILIATION_V.xml
Tue Mar 08 13:41:07 2011 +0100
@@ -1,6 +1,6 @@
<?xml version="1.0"?>
<database name="VIEW APRM_RECONCILIATION_V">
- <view name="APRM_RECONCILIATION_V"><![CDATA[SELECT
fin_reconciliation.fin_reconciliation_id AS aprm_reconciliation_v_id,
fin_reconciliation.fin_reconciliation_id, fin_reconciliation.ad_client_id,
fin_reconciliation.ad_org_id, fin_reconciliation.created,
fin_reconciliation.createdby, fin_reconciliation.updated,
fin_reconciliation.updatedby, fin_reconciliation.isactive,
fin_reconciliation.fin_financial_account_id, fin_reconciliation.documentno,
fin_reconciliation.c_doctype_id, fin_reconciliation.dateto,
fin_reconciliation.statementdate, fin_reconciliation.endingbalance,
fin_reconciliation.startingbalance, fin_reconciliation.docstatus,
fin_reconciliation.processing, fin_reconciliation.processed,
fin_reconciliation.posted, fin_reconciliation.printdetailed,
fin_reconciliation.em_aprm_process_reconciliation as process_reconciliation,
fin_reconciliation.printsummary, COALESCE(item.item_no, 0) AS item_no,
COALESCE(item.item_amt, 0) AS item_amt, COALESCE(unrec.unrec_no, 0) AS
unrec_no, COALESCE(unrec.unrec_amt, 0) AS unrec_amt,
COALESCE(outstanding.payment_no, 0) AS payment_no,
COALESCE(outstanding.payment_amt, 0) AS payment_amt,
COALESCE(outstanding.deposit_no, 0) AS deposit_no,
COALESCE(outstanding.deposit_amt, 0) AS deposit_amt, (SELECT
ad_table.ad_table_id
+ <view name="APRM_RECONCILIATION_V"><![CDATA[SELECT
fin_reconciliation.fin_reconciliation_id AS aprm_reconciliation_v_id,
fin_reconciliation.fin_reconciliation_id, fin_reconciliation.ad_client_id,
fin_reconciliation.ad_org_id, fin_reconciliation.created,
fin_reconciliation.createdby, fin_reconciliation.updated,
fin_reconciliation.updatedby, fin_reconciliation.isactive,
fin_reconciliation.fin_financial_account_id, fin_reconciliation.documentno,
fin_reconciliation.c_doctype_id, fin_reconciliation.dateto,
fin_reconciliation.statementdate, fin_reconciliation.endingbalance,
fin_reconciliation.startingbalance, fin_reconciliation.docstatus,
fin_reconciliation.processing, fin_reconciliation.processed,
fin_reconciliation.posted, fin_reconciliation.printdetailed,
fin_reconciliation.em_aprm_process_reconciliation AS process_reconciliation,
fin_reconciliation.printsummary, COALESCE(item.item_no, 0) AS item_no,
COALESCE(item.item_amt, 0) AS item_amt, COALESCE(unrec.unrec_no, 0) AS
unrec_no, COALESCE(unrec.unrec_amt, 0) AS unrec_amt,
COALESCE(outstanding.payment_no, 0) AS payment_no,
COALESCE(outstanding.payment_amt, 0) AS payment_amt,
COALESCE(outstanding.deposit_no, 0) AS deposit_no,
COALESCE(outstanding.deposit_amt, 0) AS deposit_amt, (SELECT
ad_table.ad_table_id
FROM ad_table
WHERE lower(ad_table.tablename) = 'fin_reconciliation') AS forced_table_id
FROM fin_reconciliation
------------------------------------------------------------------------------
What You Don't Know About Data Connectivity CAN Hurt You
This paper provides an overview of data connectivity, details
its effect on application quality, and explores various alternative
solutions. http://p.sf.net/sfu/progress-d2d
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
