do i need to activate an application to view videos on my phone after i subscribe to mobile video?

No, there is no need for an application to view videos as the Mobile Video service utilizes the video player that is already on your phone to view the videos you shoot.