This view gives the detail of Service Items and Online Services.
Implementation/DBA Data:
Not implemented in this database
View Text
SELECT B.HOSTED_SVCS_ID , C.SUBSCRIPTION_ITEM_MAP_ID , C.ITEM_TYPE , A.SEGMENT2 , A.DESCRIPTION , A.PRIMARY_UNIT_OF_MEASURE FROM MTL_SYSTEM_ITEMS A , AHM_SERVICE_SEL_V B , AHM_SUBSCRIPTION_ITEMS_MAP C WHERE A.ORDERABLE_ON_WEB_FLAG='Y' AND A.SERVICE_ITEM_FLAG='Y' AND A.INVENTORY_ITEM_ID=C.INVENTORY_ITEM_ID AND A.ORGANIZATION_ID=C.INVENTORY_ORG_ID AND C. HOSTED_SVC_ID =B.HOSTED_SVCS_ID