AL.LocalizedDisplayName,
DT.LocalizedDisplayName,
OCN.Name
from
SMS_AppDependenceRelation AR
join
SMS_ApplicationLatest AL
on AR.FromApplicationCIID = AL.CI_ID
join
SMS_DeploymentType DT
on AR.FromDeploymentTypeCIID=DT.CI_ID
left join
SMS_ObjectContainerItem OCI
on AL.ModelName=OCI.InstanceKey
left join
SMS_ObjectContainerNode OCN
on OCI.ContainerNodeID = OCN.ContainerNodeID
where AR.ToApplicationCIID IN
(select SMS_AppDependenceRelation.ToApplicationCIID
from
SMS_AppDependenceRelation
join
SMS_ApplicationLatest
on SMS_AppDependenceRelation.ToApplicationCIID = SMS_ApplicationLatest.CI_ID
where
SMS_ApplicationLatest.LocalizedDisplayName
like
##PRM:SMS_ApplicationLatest.LocalizedDisplayName##)