[Home] [Help]
View: AHM_EXCLUDE_SVC_RESP_V
Product: | AHM - Hosting Manager(Obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT AREM.RESPONSIBILITY_ID
, AHSS.SUBSCRIBED_SVC_ID
, AREM.SLOT_TYPE_ID
FROM AHM_RESP_EXCLUSION_MAP AREM
, AHM_HOSTED_SVC_SI AHSS
, AHM_SELECT_SVC_SI ASSS
WHERE AREM.SUBSCRIPTION_ITEM_MAP_ID = AHSS.SUBSCRIPTION_ITEM_MAP_ID
AND ASSS.SUBSCRIBED_SVC_ID = AHSS.SUBSCRIBED_SVC_ID
AND AREM.SUBSCRIPTION_ITEM_MAP_ID <> ASSS.SUBSCRIPTION_ITEM_MAP_ID
Columns
Name |
RESPONSIBILITY_ID |
SUBSCRIBED_SVC_ID |
SLOT_TYPE_ID |