SELECT ASIM.SUBSCRIPTION_ITEM_MAP_ID , ASS.SUBSCRIBED_SVC_ID FROM AHM_SUBSCRIBED_ITEMS ASI , AHM_SUBSCRIPTION_ITEMS_MAP ASIM , AHM_SUBSCRIBED_SVCS ASS WHERE ASI.SUBSCRIBED_SVC_ID = ASS.SUBSCRIBED_SVC_ID AND ASIM.SUBSCRIPTION_ITEM_MAP_ID = ASI.SUBSCRIPTION_ITEM_MAP_ID