Query sorted, but by somebody cleverer than me.
select distinct
tp3.name as [Process Group]
,null as [In Project Scope (Yes/No)]
,tp2.name as [Process Name]
,IIF(ISNULL(po.alias),po.Name,po.alias) As [Process Activity Name]
,tEndObj.Name as [Standard Deliverable Name]
, to2.name as [Responsible]
from ((((((( t_package tp
inner join t_object po on tp.Package_ID = po.Package_ID)
LEFT join t_object to2 on po.ParentID = to2.object_ID)
INNER join t_connector tc on po.Object_ID = tc.Start_Object_ID)
left join t_package tp2 on tp2.Package_ID = tp.Parent_ID)
left join t_package tp3 on tp3.Package_ID = tp2.Parent_ID)
left join t_package tp4 on tp4.Package_ID = tp3.Parent_ID)
left join t_object tEndObj on tEndObj.Object_ID = tc.End_Object_ID)
where
po.Object_Type in ('Activity') and tEndObj.Stereotype in ('NATS_Deliverable') and tp4.name in ('Enabling Processes', 'Operating Processes', 'Management and Support Processes')
order by tp3.name, tp2.name, IIF(ISNULL(po.alias),po.Name,po.alias)
