商机新增的业务流程,如何通过sql获取商机当前业务阶段

SELECT 
    opp.Name AS OpportunityName,opp.rf_number,
    stage.ActiveStageIdName,opp.OpportunityId,stage.ActiveStageId
FROM 
    OpportunityBase AS opp
INNER JOIN 
    rf_sales_process AS stage ON opp.OpportunityId=stage.bpf_opportunityid --and opp.stageid=stage.ActiveStageId
WHERE 
    opp.StateCode = 0 -- 活动状态的商机

  

posted @ 2025-03-26 15:32  溜溜球_小钢wan  阅读(25)  评论(0)    收藏  举报