ON p.id = i.parts_id
LEFT JOIN oe
- ON (oe.ordnumber = ${arap}.ordnumber AND NOT ${arap}.ordnumber = '')
+ ON (oe.ordnumber = ${arap}.ordnumber AND NOT ${arap}.ordnumber = ''
+ AND ". ($arap eq 'ar' ? 'oe.customer_id IS NOT NULL' : 'oe_vendor_id IS NOT NULL') ." )
${where}
ORDER BY ${arap}.transdate DESC LIMIT 15";