[Home] [Help]
View: AHM_ACTIVE_ITEM_SEL_V
| Product: | AHM - Hosting Manager(Obsolete) |
|---|
| Description: | This view gives details for Service Item, Service Coverage details under the Online Services defined by ASP. |
|---|
| 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
, B.PRIMARY_UNIT_OF_MEASURE
, 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
AND A.STATUS = 'A'
AND A.WEB_DISPLAY = 'Y'
Columns
| Name |
| HOSTED_SVC_ID |
| SUBSCRIPTION_ITEM_MAP_ID |
| INVENTORY_ORG_ID |
| INVENTORY_ITEM_ID |
| STATUS |
| ITEM_TYPE |
| WEB_DISPLAY |
| NAME |
| UOM_CODE |
| DESCRIPTION |