details: /erp/devel/api-checks/rev/020253f70ba6 changeset: 120:020253f70ba6 user: Gorka Ion Damián <gorkaion.damian <at> openbravo.com> date: Thu Apr 22 16:12:52 2010 +0200 summary: Fixes issue 13081. Ack as false positive. Added a new column at the end of a view.
diffstat: model/model/views/FIN_PAYMENT_DETAIL_V.xml | 8 +++++--- 1 files changed, 5 insertions(+), 3 deletions(-) diffs (19 lines): diff -r 34d646b416fb -r 020253f70ba6 model/model/views/FIN_PAYMENT_DETAIL_V.xml --- a/model/model/views/FIN_PAYMENT_DETAIL_V.xml Tue Apr 20 12:05:56 2010 +0200 +++ b/model/model/views/FIN_PAYMENT_DETAIL_V.xml Thu Apr 22 16:12:52 2010 +0200 @@ -1,10 +1,12 @@ <?xml version="1.0"?> <database name="VIEW FIN_PAYMENT_DETAIL_V"> - <view name="FIN_PAYMENT_DETAIL_V"><![CDATA[SELECT psd.fin_payment_scheduledetail_id AS fin_payment_detail_v_id, psd.ad_client_id, psd.ad_org_id, psd.isactive, psd.created, psd.createdby, psd.updated, psd.updatedby, psi.fin_payment_sched_inv_v_id, pso.fin_payment_sched_ord_v_id, i.documentno AS invoiceno, o.documentno AS orderno, p.documentno AS paymentno, pd.fin_payment_id, COALESCE(psi.duedate, pso.duedate) AS duedate, COALESCE(i.grandtotal, o.grandtotal) AS invoicedamt, COALESCE(psi.expected, pso.expected) AS expected, psd.amount AS paidamt, p.c_bpartner_id, p.fin_paymentmethod_id, p.fin_financial_account_id, p.c_currency_id, p.paymentdate -FROM fin_payment p, fin_payment_detail pd, fin_payment_scheduledetail psd + <view name="FIN_PAYMENT_DETAIL_V"><![CDATA[SELECT psd.fin_payment_scheduledetail_id AS fin_payment_detail_v_id, psd.ad_client_id, psd.ad_org_id, psd.isactive, psd.created, psd.createdby, psd.updated, psd.updatedby, psi.fin_payment_sched_inv_v_id, pso.fin_payment_sched_ord_v_id, i.documentno AS invoiceno, o.documentno AS orderno, p.documentno AS paymentno, pd.fin_payment_id, COALESCE(psi.duedate, pso.duedate) AS duedate, COALESCE(i.grandtotal, o.grandtotal) AS invoicedamt, COALESCE(psi.expected, pso.expected) AS expected, psd.amount AS paidamt, p.c_bpartner_id, p.fin_paymentmethod_id, p.fin_financial_account_id, p.c_currency_id, p.paymentdate, gli.name AS glitemname +FROM fin_payment p, fin_payment_detail pd +JOIN fin_payment_scheduledetail psd ON pd.fin_payment_detail_id = psd.fin_payment_detail_id LEFT JOIN fin_payment_sched_inv_v psi ON psd.fin_payment_schedule_invoice = psi.fin_payment_sched_inv_v_id 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> +LEFT JOIN c_glitem gli ON pd.c_glitem_id = gli.c_glitem_id +WHERE p.fin_payment_id = pd.fin_payment_id]]></view> </database> ------------------------------------------------------------------------------ _______________________________________________ Openbravo-commits mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openbravo-commits
