This view gives details for Service Item, Service Coverage details under the Online Services defined by ASP. For Service Item the UOM is selected from MTL_SYSTEM_ITEMS_B.PRIMARY_UNIT_OF_MEASURE and for Service Coverage Item the UOM is selec
Implementation/DBA Data:
Not implemented in this database
View Text
SELECT A.HOSTED_SVC_ID , A.SUBSCRIPTION_ITEM_MAP_ID , A.INVENTORY_ORG_ID , A.INVENTORY_ITEM_ID , A.STATUS , A.ITEM_TYPE , A.WEB_DISPLAY , B.SEGMENT1 , DECODE(A.ITEM_TYPE , 'SVC' , B.SERVICE_DURATION_PERIOD_CODE , B.PRIMARY_UNIT_OF_MEASURE) UOM_CODE , B.DESCRIPTION FROM AHM_SUBSCRIPTION_ITEMS_MAP A , MTL_SYSTEM_ITEMS_B B WHERE B.INVENTORY_ITEM_ID= A.INVENTORY_ITEM_ID AND B.ORGANIZATION_ID = A.INVENTORY_ORG_ID