[Home] [Help]
View: AHM_CUSTAPPROVAL_V
| Product: | AHM - Hosting Manager(Obsolete) |
|---|
| Description: | This view give the party_id , which db the party is assigned and the subscription Agreement. |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT DISTINCT(A.PARTY_ID) PARTY_ID
, A.PARTY_NAME PARTY_NAME
, A.CREATION_DATE CREATION_DATE
, DECODE (B.STATUS
, 'S'
, 'SUBSCRIBED'
, 'R'
, 'REJECTED'
, 'A'
, 'APPROVED'
, 'Z'
, 'APPROVAL HALTED'
, 'X'
, 'REJECTION HALTED') STATUS
, C.RULE_VALUE "NUM_USERS"
, D.RULE_VALUE "GEOGRAPHY"
, E.RULE_VALUE "SLOT_TYPE"
, F.RULE_VALUE "SLA"
, G.DB_NAME "DB_NAME"
FROM HZ_PARTIES A
, AHM_SUBSCRIBED_SVCS B
, AHM_PARTY_RULE_ATTRIBUTES C
, AHM_PARTY_RULE_ATTRIBUTES D
, AHM_PARTY_RULE_ATTRIBUTES E
, AHM_PARTY_RULE_ATTRIBUTES F
, AHM_HOST_DATABASES_VL G
, AHM_SLOT_ALLOCATIONS J
WHERE A.PARTY_ID=B.PARTY_ID
AND B.PARTY_ID = C.PARTY_ID
AND C.PARTY_ID = D.PARTY_ID
AND D.PARTY_ID = E.PARTY_ID
AND E.PARTY_ID = F.PARTY_ID
AND E.RECOMMENDED_SLOT_TYPE_ID = J.SLOT_TYPE_ID(+)
AND J.DB_ID = G.DB_ID(+)
AND C.RULE_ID = 3
AND D.RULE_ID = 1
AND E.RULE_ID = 0
AND F.RULE_ID = 2
AND B.STATUS != 'A'
Columns
| Name |
| PARTY_ID |
| PARTY_NAME |
| CREATION_DATE |
| STATUS |
| "NUM_USERS" |
| "GEOGRAPHY" |
| "SLOT_TYPE" |
| "SLA" |
| DB_NAME |