[Home] [Help]
View: AHM_HOSTING_MASTER_SUMMARY_V
Product: | AHM - Hosting Manager(Obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT AST.SLOT_TYPE_ID
, AST.SLOT_TYPE_NAME
, AST.DESCRIPTION
, DB_NAME
, AHD.DB_ID
, ASCV.HM_STATUS
FROM AHM_SLOT_TYPES_VL AST
, AHM_HOST_DATABASES_TL AHD
, AHM_SUMMARY_COUNT_V ASCV
WHERE AHD.DB_ID = AST.DB_ID
AND ASCV.SLOT_TYPE_ID (+) = AST.SLOT_TYPE_ID
Columns
Name |
SLOT_TYPE_ID |
SLOT_TYPE_NAME |
DESCRIPTION |
DB_NAME |
DB_ID |
HM_STATUS |