This view gives all the Online Line Service and Subscription Item, Service Coverage Item details.
Implementation/DBA Data:
Not implemented in this database
View Text
SELECT A.HOSTED_SVC_ID , A.NAME , A.DESCRIPTION , A.NOTIFY_EMAIL_ADDRESS , A.HOSTED_SVC_NUMBER , A.ORACLE_APPS FROM AHM_HOSTED_SVCS_VL A WHERE A.STATUS='A' ORDER BY A.NAME