details:   https://code.openbravo.com/erp/devel/pi/rev/7b1047b06a8d
changeset: 17715:7b1047b06a8d
user:      David Miguelez <david.miguelez <at> openbravo.com>
date:      Mon Aug 20 15:25:59 2012 +0200
summary:   Fixes issue 0021392: Exported database for fixing the consistency

diffstat:

 
modules/org.openbravo.advpaymentmngt/src-db/database/model/views/APRM_PAYMENT_PROP_PICK_EDIT.xml
 |  2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)

diffs (12 lines):

diff -r 731797e5038f -r 7b1047b06a8d 
modules/org.openbravo.advpaymentmngt/src-db/database/model/views/APRM_PAYMENT_PROP_PICK_EDIT.xml
--- 
a/modules/org.openbravo.advpaymentmngt/src-db/database/model/views/APRM_PAYMENT_PROP_PICK_EDIT.xml
  Mon Aug 20 15:18:26 2012 +0200
+++ 
b/modules/org.openbravo.advpaymentmngt/src-db/database/model/views/APRM_PAYMENT_PROP_PICK_EDIT.xml
  Mon Aug 20 15:25:59 2012 +0200
@@ -10,7 +10,7 @@
 ELSE 'Y'
 END AS ob_selected, COALESCE(psi.fin_payment_priority_id, 
pso.fin_payment_priority_id) AS fin_payment_priority_id, 
COALESCE(i.c_currency_id, o.c_currency_id) AS c_currency_id, 
COALESCE(i.issotrx, o.issotrx) AS issotrx
 FROM fin_payment_scheduledetail psd
-LEFT JOIN fin_payment_prop_detail ppd ON 
(psd.fin_payment_scheduledetail_id=ppd.fin_payment_scheduledetail_id)
+LEFT JOIN fin_payment_prop_detail ppd ON psd.fin_payment_scheduledetail_id = 
ppd.fin_payment_scheduledetail_id
 LEFT JOIN fin_payment_schedule psi ON psd.fin_payment_schedule_invoice = 
psi.fin_payment_schedule_id
 LEFT JOIN fin_payment_schedule pso ON psd.fin_payment_schedule_order = 
pso.fin_payment_schedule_id
 LEFT JOIN c_invoice i ON psi.c_invoice_id = i.c_invoice_id

------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits

Reply via email to