eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: AHM_PARTY_SUB_ITEMS_V

Product:	AHM - Hosting Manager(Obsolete)
Description:	This view returns the info for all subscribed items for the given party id
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT A.SUBSCRIBED_SVC_ID
, A.SUBSCRIBED_ITEM_ID
, A.STATUS
, A.INVENTORY_ITEM_ID
, A.QUANTITY
, A.INVENTORY_ORG_ID
, A.SUPPORT_INV_ITEM_ID
, B.SEGMENT1
, B.PRIMARY_UNIT_OF_MEASURE
, B.DESCRIPTION
, B.SEGMENT1
, A.SUPPORT_QUANTITY
, A.SERVICE_DURATION_PERIOD_CODE
FROM AHM_SUBSCRIBED_ITEMS A
, MTL_SYSTEM_ITEMS_B B
WHERE B.INVENTORY_ITEM_ID = A.INVENTORY_ITEM_ID
AND B.ORGANIZATION_ID = A.INVENTORY_ORG_ID

Columns

Name
SUBSCRIBED_SVC_ID
SUBSCRIBED_ITEM_ID
STATUS
INVENTORY_ITEM_ID
QUANTITY
INVENTORY_ORG_ID
SUPPORT_INV_ITEM_ID
SEGMENT1
PRIMARY_UNIT_OF_MEASURE
DESCRIPTION
SVC_NAME
SUPPORT_QUANTITY
SERVICE_DURATION_PERIOD_CODE