CUCU2/src/custom/restcontroller/webmanage/sale/order/SQL/查询商品费用方案方法.sql

SELECT DISTINCT t3.functionname
from sa_orderitems t1
         INNER JOIN sys_datafunction_bind t2 ON t2.ownerid = t1.itemid and t2.ownertable = 'plm_item'
         INNER JOIN sys_datafunction t3 ON t3.sys_datafunctionid = t2.sys_datafunctionid
WHERE t1.sa_orderid = $sa_orderid$
  and t1.siteid = $siteid$ and  t3.status='启用'