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