[Home] [Help]
View: AHM_INCLUDE_SVC_RESP_V
Product: | AHM - Hosting Manager(Obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT ASTSRM.RESPONSIBILITY_ID
, ASS.SUBSCRIBED_SVC_ID
, ASTS.SLOT_TYPE_ID
FROM AHM_SLOT_TYPE_SVC_RESP_MAP ASTSRM
, AHM_SLOT_TYPE_SERVICES ASTS
, AHM_HOSTED_SVCS_B AHS
, AHM_SUBSCRIBED_SVCS ASS
WHERE ASS.HOSTED_SVC_ID = AHS.HOSTED_SVC_ID
AND AHS.HOSTED_SVC_ID = ASTS.HOSTED_SVC_ID
AND ASTS.SLOT_TYPE_SERVICE_ID = ASTSRM.SLOT_TYPE_SERVICE_ID
Columns
Name |
RESPONSIBILITY_ID |
SUBSCRIBED_SVC_ID |
SLOT_TYPE_ID |