[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 |