details: http://code.openbravo.com/erp/devel/pi/rev/6a109c695442
changeset: 3553:6a109c695442
user: Sathiyan Sivaprakasam <sathiyan.sivaprakasam <at> openbravo.com>
date: Wed Apr 08 16:50:14 2009 +0530
summary: Fixes bug 8367 Wrong Sales Representative in business partner
selector window
diffstat:
src/org/openbravo/erpCommon/info/BusinessPartnerMultiple_data.xsql | 11
++++++-----
1 files changed, 6 insertions(+), 5 deletions(-)
diffs (32 lines):
diff -r ec2d7a599959 -r 6a109c695442
src/org/openbravo/erpCommon/info/BusinessPartnerMultiple_data.xsql
--- a/src/org/openbravo/erpCommon/info/BusinessPartnerMultiple_data.xsql
Wed Apr 08 15:45:35 2009 +0530
+++ b/src/org/openbravo/erpCommon/info/BusinessPartnerMultiple_data.xsql
Wed Apr 08 16:50:14 2009 +0530
@@ -30,13 +30,14 @@
SELECT * FROM ( SELECT '0' AS RN1, A.* FROM (
SELECT bp.C_BPartner_ID, bp.VALUE, bp.NAME as name,
replace(bp.NAME, '''', CHR(92) || '''') as name_hidden,
(bp.SO_CreditLimit-bp.SO_CreditUsed) AS SO_CreditAvailable,
bp.SO_CreditUsed,
- bp.ActualLifetimeValue, bp.URL, MAX(s.EMAIL) AS EMAIL,
MAX(s.NAME) as SALESREP, bp.C_BPartner_ID || '#' || bp.NAME AS RowKey
+ bp.ActualLifetimeValue, bp.URL, MAX(s.EMAIL) AS EMAIL,
MAX(sales.NAME) as SALESREP, bp.C_BPartner_ID || '#' || bp.NAME AS RowKey
FROM C_BPARTNER_LOCATION l left join AD_USER c on
l.C_BPartner_Location_ID = c.C_BPartner_Location_ID
left join C_LOCATION a on
l.C_Location_ID=a.C_Location_ID
left join C_REGION on a.C_REGION_ID
= C_REGION.C_REGION_ID,
- C_BPARTNER bp left join AD_USER s on bp.SALESREP_ID =
s.AD_USER_ID
+ C_BPARTNER bp left join AD_USER s on bp.SALESREP_ID =
s.c_bpartner_id
+ left join C_BPARTNER sales on bp.SALESREP_ID =
sales.C_BPARTNER_ID
WHERE bp.C_BPARTNER_ID = l.C_BPartner_ID
- AND COALESCE(c.IsActive, 'Y')='Y'
+ AND COALESCE(c.IsActive, 'Y')='Y'
AND bp.IsSummary='N'
AND bp.AD_Client_ID IN ('1')
AND bp.AD_Org_ID IN ('1')
@@ -55,8 +56,8 @@
<Parameter name="contact" optional="true" after="AND
COALESCE(l.IsActive, 'Y')='Y'"><![CDATA[AND UPPER(c.Name) LIKE UPPER(?)
]]></Parameter>
<Parameter name="codigoPostal" optional="true" after="AND
COALESCE(l.IsActive, 'Y')='Y'"><![CDATA[AND UPPER(a.Postal) LIKE UPPER(?)
]]></Parameter>
<Parameter name="provincia" optional="true" after="AND
COALESCE(l.IsActive, 'Y')='Y'"><![CDATA[AND UPPER(C_REGION.NAME) LIKE
UPPER(?)]]></Parameter>
- <Parameter name="clients" optional="true" type="none" after="AND
COALESCE(l.IsActive, 'Y')='Y'"><![CDATA[AND ISCUSTOMER = 'Y' ]]></Parameter>
- <Parameter name="vendors" optional="true" type="none" after="AND
COALESCE(l.IsActive, 'Y')='Y'"><![CDATA[AND ISVENDOR ='Y']]></Parameter>
+ <Parameter name="clients" optional="true" type="none" after="AND
COALESCE(l.IsActive, 'Y')='Y'"><![CDATA[AND bp.ISCUSTOMER = 'Y' ]]></Parameter>
+ <Parameter name="vendors" optional="true" type="none" after="AND
COALESCE(l.IsActive, 'Y')='Y'"><![CDATA[AND bp.ISVENDOR ='Y']]></Parameter>
<Parameter name="ciudad" optional="true" after="AND
COALESCE(l.IsActive, 'Y')='Y'"><![CDATA[AND UPPER(a.City) LIKE UPPER(?)
]]></Parameter>
<Parameter name="orderBy" type="replace" optional="true" after="ORDER
BY " text="bp.NAME" />
<Parameter name="oraLimit" type="argument" optional="true"
after="WHERE 1=1"><![CDATA[AND RN1 BETWEEN ]]></Parameter>
------------------------------------------------------------------------------
This SF.net email is sponsored by:
High Quality Requirements in a Collaborative Environment.
Download a free trial of Rational Requirements Composer Now!
http://p.sf.net/sfu/www-ibm-com
_______________________________________________
Openbravo-commits mailing list
Openbravo-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
