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