CREATE OR REPLACE FORCE EDITIONABLE VIEW "OTHQ_OWN"."CMDB_NEXT_EXA_PDB_VW" 
(
    "ID",
    "NAME",
    "THIN_NAME",
    "DB_TYPE",
    "VERSION",
    "EXACS_SIZE_NUM",
    "DATABASE_MODE",
    "N_KEY",
    "ACCOUNT_TYPE",
    "ACCOUNT_COMP_ID",
    "ONLINE_SIGNUP",
    "RESOURCE_USER",
    "TIME_MAINTENANCE_REBOOT_DUE",
    "CREATED",
    "MODIFIED",
    "DESCRIPTION",
    "CLUSTER_NAME",
    "CLUSTER_ID",
    "DR_SOLUTION",
    "DB_NODE_HOSTNAME",
    "DB_NODE_ID",
    "CDB_SCAN_NAME",
    "CDB_INSTANCE",
    "CDB_VERSION",
    "CDB_ID",
    "CDB_PDB_CAPACITY_GIB",
    "CDB_OPERATING_STATUS",
    "DATA_GUARD_INFO"
) 
AS
SELECT
    t."ID",
    t."NAME",
    t."THIN_NAME",
    t."DB_TYPE",
    t."VERSION",
    t."EXACS_SIZE_NUM",
    t."DATABASE_MODE",
    t."N_KEY",
    t."ACCOUNT_TYPE",
    t."ACCOUNT_COMP_ID",
    t."ONLINE_SIGNUP",
    t."RESOURCE_USER",
    t."TIME_MAINTENANCE_REBOOT_DUE",
    t."CREATED",
    t."MODIFIED",
    t."DESCRIPTION",
    t."CLUSTER_NAME",
    t."CLUSTER_ID",
    t."DR_SOLUTION",
    t."DB_NODE_HOSTNAME",
    t."DB_NODE_ID",
    t."CDB_SCAN_NAME",
    t."CDB_INSTANCE",
    t."CDB_VERSION",
    t."CDB_ID",
    t."CDB_PDB_CAPACITY_GIB",
    t."CDB_OPERATING_STATUS",
    t."DATA_GUARD_INFO"
FROM
    "OTHQ_OWN"."SRC_CMDB_NEXT_EXA_PDB_TB" t
WHERE
    t."ACCOUNT_TYPE" IN ('PRODUCTION', 'SANDBOX');