[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 |