This view returns the info for all subscribed services for the given party id
Implementation/DBA Data:
Not implemented in this database
View Text
SELECT A.PARTY_ID , A.SUBSCRIBED_SVC_ID , A.HOSTED_SVC_ID , B.HOSTED_SVC_KEY FROM AHM_SUBSCRIBED_SVCS A , AHM_HOSTED_SVCS_VL B WHERE A.HOSTED_SVC_ID IN (SELECT HOSTED_SVC_ID FROM AHM_SLOT_TYPE_SERVICES WHERE SLOT_TYPE_ID IN (SELECT SLOT_TYPE_ID FROM AHM_SLOT_ALLOCATIONS ) ) AND B.HOSTED_SVC_ID= A.HOSTED_SVC_ID AND B.STATUS='A' AND B.WEB_DISPLAY='Y'