VIEW: APPS.CCT_MULTISITE_CONFIGS_VL

Source

View Text - Preformatted

SELECT a.multisite_config_id, a.config_name, d.server_group_id, d.group_name, a.from_middleware_id, b.config_name , e.server_group_id, e.group_name,a.to_middleware_id, c.config_name ,a.Tie_Line_Access_Code, a.last_update_date,a.last_updated_by, a.creation_date, a.created_by , a.last_update_login, a.object_version_number, a.f_deletedflag FROM IEO_SVR_GROUPS D,CCT_MULTISITE_CONFIGS A,CCT_MIDDLEWARES B,CCT_MIDDLEWARES C,IEO_SVR_GROUPS E WHERE a.from_middleware_id = b.middleware_id and b.server_group_id = d.server_group_id and a.to_middleware_id = c.middleware_id and c.server_group_id = e.server_group_id

View Text - HTML Formatted

SELECT A.MULTISITE_CONFIG_ID
, A.CONFIG_NAME
, D.SERVER_GROUP_ID
, D.GROUP_NAME
, A.FROM_MIDDLEWARE_ID
, B.CONFIG_NAME
, E.SERVER_GROUP_ID
, E.GROUP_NAME
, A.TO_MIDDLEWARE_ID
, C.CONFIG_NAME
, A.TIE_LINE_ACCESS_CODE
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
, A.CREATION_DATE
, A.CREATED_BY
, A.LAST_UPDATE_LOGIN
, A.OBJECT_VERSION_NUMBER
, A.F_DELETEDFLAG
FROM IEO_SVR_GROUPS D
, CCT_MULTISITE_CONFIGS A
, CCT_MIDDLEWARES B
, CCT_MIDDLEWARES C
, IEO_SVR_GROUPS E
WHERE A.FROM_MIDDLEWARE_ID = B.MIDDLEWARE_ID
AND B.SERVER_GROUP_ID = D.SERVER_GROUP_ID
AND A.TO_MIDDLEWARE_ID = C.MIDDLEWARE_ID
AND C.SERVER_GROUP_ID = E.SERVER_GROUP_ID