details: https://code.openbravo.com/erp/devel/pi/rev/191b774fbb86
changeset: 20175:191b774fbb86
user: David Miguelez <david.miguelez <at> openbravo.com>
date: Mon Apr 22 19:17:06 2013 +0200
summary: Fixes Issue 23603. In views changes 'N' to TO_CHAR('N') for avoid
warnings.
diffstat:
modules/org.openbravo.advpaymentmngt/src-db/database/model/views/APRM_FINACC_TRANSACTION_V.xml
| 2 +-
src-db/database/model/views/FIN_PAYMENT_SCHED_INV_V.xml
| 2 +-
2 files changed, 2 insertions(+), 2 deletions(-)
diffs (18 lines):
diff -r 2921e1682100 -r 191b774fbb86
modules/org.openbravo.advpaymentmngt/src-db/database/model/views/APRM_FINACC_TRANSACTION_V.xml
---
a/modules/org.openbravo.advpaymentmngt/src-db/database/model/views/APRM_FINACC_TRANSACTION_V.xml
Mon Apr 22 16:35:48 2013 +0200
+++
b/modules/org.openbravo.advpaymentmngt/src-db/database/model/views/APRM_FINACC_TRANSACTION_V.xml
Mon Apr 22 19:17:06 2013 +0200
@@ -1,4 +1,4 @@
<?xml version="1.0"?>
<database name="VIEW APRM_FINACC_TRANSACTION_V">
- <view name="APRM_FINACC_TRANSACTION_V"><![CDATA[SELECT
trx.fin_finacc_transaction_id AS aprm_finacc_transaction_v_id,
trx.fin_finacc_transaction_id, trx.ad_client_id, trx.ad_org_id, trx.isactive,
trx.created, trx.createdby, trx.updated, trx.updatedby,
trx.fin_financial_account_id, trx.line, trx.description, trx.statementdate,
trx.trxtype, trx.fin_payment_id, trx.c_glitem_id, trx.depositamt,
trx.paymentamt, trx.c_currency_id, trx.fin_reconciliation_id, trx.status,
trx.createdbyalgorithm, trx.posted, trx.dateacct, trx.processed,
trx.processing, trx.user1_id, trx.user2_id, trx.c_activity_id,
trx.c_campaign_id, trx.c_project_id, trx.foreign_currency_id,
trx.foreign_amount, trx.em_aprm_modify, trx.foreign_convert_rate, CASE
trx.status WHEN 'RPPC' THEN 'Y' ELSE 'N' END AS cleared,
COALESCE(trx.c_bpartner_id, p.c_bpartner_id) AS c_bpartner_id,
trx.m_product_id, trx.c_salesregion_id, p.documentno AS paymentdocno,
COALESCE(r.processed, 'N') AS reconciled, 'N' AS delete_btn, (SELECT
ad_table.ad_table_id FROM ad_table WHERE lower(ad_table.tablename) =
'fin_finacc_transaction') AS forced_table_id, trx.c_costcenter_id FROM
fin_finacc_transaction trx LEFT JOIN fin_payment p ON trx.fin_payment_id =
p.fin_payment_id LEFT JOIN fin_reconciliation r ON trx.fin_reconciliation_id =
r.fin_reconciliation_id]]></view>
+ <view name="APRM_FINACC_TRANSACTION_V"><![CDATA[SELECT
trx.fin_finacc_transaction_id AS aprm_finacc_transaction_v_id,
trx.fin_finacc_transaction_id, trx.ad_client_id, trx.ad_org_id, trx.isactive,
trx.created, trx.createdby, trx.updated, trx.updatedby,
trx.fin_financial_account_id, trx.line, trx.description, trx.statementdate,
trx.trxtype, trx.fin_payment_id, trx.c_glitem_id, trx.depositamt,
trx.paymentamt, trx.c_currency_id, trx.fin_reconciliation_id, trx.status,
trx.createdbyalgorithm, trx.posted, trx.dateacct, trx.processed,
trx.processing, trx.user1_id, trx.user2_id, trx.c_activity_id,
trx.c_campaign_id, trx.c_project_id, trx.foreign_currency_id,
trx.foreign_amount, trx.em_aprm_modify, trx.foreign_convert_rate, CASE
trx.status WHEN 'RPPC' THEN 'Y' ELSE 'N' END AS cleared,
COALESCE(trx.c_bpartner_id, p.c_bpartner_id) AS c_bpartner_id,
trx.m_product_id, trx.c_salesregion_id, p.documentno AS paymentdocno,
COALESCE(r.processed, 'N') AS reconciled, to_char('N') AS delete_btn, (SELECT
ad_table.ad_table_id FROM ad_table WHERE lower(ad_table.tablename) =
'fin_finacc_transaction') AS forced_table_id, trx.c_costcenter_id FROM
fin_finacc_transaction trx LEFT JOIN fin_payment p ON trx.fin_payment_id =
p.fin_payment_id LEFT JOIN fin_reconciliation r ON trx.fin_reconciliation_id =
r.fin_reconciliation_id]]></view>
</database>
diff -r 2921e1682100 -r 191b774fbb86
src-db/database/model/views/FIN_PAYMENT_SCHED_INV_V.xml
--- a/src-db/database/model/views/FIN_PAYMENT_SCHED_INV_V.xml Mon Apr 22
16:35:48 2013 +0200
+++ b/src-db/database/model/views/FIN_PAYMENT_SCHED_INV_V.xml Mon Apr 22
19:17:06 2013 +0200
@@ -1,4 +1,4 @@
<?xml version="1.0"?>
<database name="VIEW FIN_PAYMENT_SCHED_INV_V">
- <view name="FIN_PAYMENT_SCHED_INV_V"><![CDATA[SELECT
ps.fin_payment_schedule_id AS fin_payment_sched_inv_v_id, ps.ad_client_id,
ps.ad_org_id, ps.isactive, ps.created, ps.createdby, ps.updated, ps.updatedby,
ps.c_invoice_id, ps.c_order_id, ps.duedate, ps.expecteddate,
ps.fin_paymentmethod_id, ps.amount AS expected, ps.paidamt AS received,
ps.outstandingamt AS outstanding, ps.c_currency_id, (SELECT max(p.paymentdate)
AS max FROM fin_payment p LEFT JOIN fin_payment_detail pd ON pd.fin_payment_id
= p.fin_payment_id LEFT JOIN fin_payment_scheduledetail psd ON
pd.fin_payment_detail_id = psd.fin_payment_detail_id 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, ps.fin_payment_priority_id, ps.update_payment_plan,
to_char('Y') AS ob_selected, (SELECT CASE WHEN to_number(max(pdv.paymentdate)
- min(ops.duedate)) > 0 THEN to_number(max(pdv.paymentdate) - min(ops.duedate))
ELSE 0 END AS "case" FROM fin_orig_paym_scheddetail opsd LEFT JOIN
fin_orig_payment_schedule ops ON opsd.fin_orig_payment_schedule_id =
ops.fin_orig_payment_schedule_id LEFT JOIN fin_payment_scheduledetail psd ON
psd.fin_payment_scheduledetail_id = opsd.fin_payment_scheduledetail_id LEFT
JOIN fin_payment_detail_v pdv ON pdv.fin_payment_detail_v_id =
psd.fin_payment_scheduledetail_id WHERE psd.fin_payment_schedule_invoice =
ps.fin_payment_schedule_id) AS daysoverdue, COALESCE((SELECT sum(psd.amount) AS
sum FROM fin_payment_scheduledetail psd, fin_payment_detail pd LEFT JOIN
fin_payment p ON pd.fin_payment_id = p.fin_payment_id WHERE
psd.fin_payment_schedule_invoice = ps.fin_payment_schedule_id AND
psd.fin_payment_detail_id = pd.fin_payment_detail_id AND p.status = 'RPAE'), 0)
AS awaiting_execution, 'Y' AS em_aprm_modif_paym_sched, 'Y' AS
em_aprm_modif_paym_out_sched FROM fin_payment_schedule ps]]></view>
+ <view name="FIN_PAYMENT_SCHED_INV_V"><![CDATA[SELECT
ps.fin_payment_schedule_id AS fin_payment_sched_inv_v_id, ps.ad_client_id,
ps.ad_org_id, ps.isactive, ps.created, ps.createdby, ps.updated, ps.updatedby,
ps.c_invoice_id, ps.c_order_id, ps.duedate, ps.expecteddate,
ps.fin_paymentmethod_id, ps.amount AS expected, ps.paidamt AS received,
ps.outstandingamt AS outstanding, ps.c_currency_id, (SELECT max(p.paymentdate)
AS max FROM fin_payment p LEFT JOIN fin_payment_detail pd ON pd.fin_payment_id
= p.fin_payment_id LEFT JOIN fin_payment_scheduledetail psd ON
pd.fin_payment_detail_id = psd.fin_payment_detail_id 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, ps.fin_payment_priority_id, ps.update_payment_plan,
to_char('Y') AS ob_selected, (SELECT CASE WHEN to_number(max(pdv.paymentdate)
- min(ops.duedate)) > 0 THEN to_number(max(pdv.paymentdate) - min(ops.duedate))
ELSE 0 END AS "case" FROM fin_orig_paym_scheddetail opsd LEFT JOIN
fin_orig_payment_schedule ops ON opsd.fin_orig_payment_schedule_id =
ops.fin_orig_payment_schedule_id LEFT JOIN fin_payment_scheduledetail psd ON
psd.fin_payment_scheduledetail_id = opsd.fin_payment_scheduledetail_id LEFT
JOIN fin_payment_detail_v pdv ON pdv.fin_payment_detail_v_id =
psd.fin_payment_scheduledetail_id WHERE psd.fin_payment_schedule_invoice =
ps.fin_payment_schedule_id) AS daysoverdue, COALESCE((SELECT sum(psd.amount) AS
sum FROM fin_payment_scheduledetail psd, fin_payment_detail pd LEFT JOIN
fin_payment p ON pd.fin_payment_id = p.fin_payment_id WHERE
psd.fin_payment_schedule_invoice = ps.fin_payment_schedule_id AND
psd.fin_payment_detail_id = pd.fin_payment_detail_id AND p.status = 'RPAE'), 0)
AS awaiting_execution, to_char('Y') AS em_aprm_modif_paym_sched, to_char('Y')
AS em_aprm_modif_paym_out_sched FROM fin_payment_schedule ps]]></view>
</database>
------------------------------------------------------------------------------
Try New Relic Now & We'll Send You this Cool Shirt
New Relic is the only SaaS-based application performance monitoring service
that delivers powerful full stack analytics. Optimize and monitor your
browser, app, & servers with just a few lines of code. Try New Relic
and get this awesome Nerd Life shirt! http://p.sf.net/sfu/newrelic_d2d_apr
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
