VIEW: APPS.CCT_MULTISITE_PATHS_VL

Source

View Text - Preformatted

SELECT b.multisite_path_id , a.config_name , b.multisite_config_id , c.route_point_number , c.mw_route_point_id , b.description , b.object_version_number , b.f_deletedflag from cct_multisite_configs a , cct_multisite_paths b , cct_mw_route_points c WHERE b.mw_route_point_id = c.mw_route_point_id (+) and b.multisite_config_id = a.multisite_config_id and exists (select 1 from cct_multisite_configs d where d.multisite_config_id = a.multisite_config_id and (f_deletedflag <> 'D' or f_deletedflag is null) ) and ( b.mw_route_point_id = '-1' or exists (select 1 from cct_mw_route_points e where e.mw_route_point_id = c.mw_route_point_id and (f_deletedflag <> 'D' or f_deletedflag is null)) )

View Text - HTML Formatted

SELECT B.MULTISITE_PATH_ID
, A.CONFIG_NAME
, B.MULTISITE_CONFIG_ID
, C.ROUTE_POINT_NUMBER
, C.MW_ROUTE_POINT_ID
, B.DESCRIPTION
, B.OBJECT_VERSION_NUMBER
, B.F_DELETEDFLAG
FROM CCT_MULTISITE_CONFIGS A
, CCT_MULTISITE_PATHS B
, CCT_MW_ROUTE_POINTS C
WHERE B.MW_ROUTE_POINT_ID = C.MW_ROUTE_POINT_ID (+)
AND B.MULTISITE_CONFIG_ID = A.MULTISITE_CONFIG_ID
AND EXISTS (SELECT 1
FROM CCT_MULTISITE_CONFIGS D
WHERE D.MULTISITE_CONFIG_ID = A.MULTISITE_CONFIG_ID
AND (F_DELETEDFLAG <> 'D' OR F_DELETEDFLAG IS NULL) )
AND ( B.MW_ROUTE_POINT_ID = '-1' OR EXISTS (SELECT 1
FROM CCT_MW_ROUTE_POINTS E
WHERE E.MW_ROUTE_POINT_ID = C.MW_ROUTE_POINT_ID
AND (F_DELETEDFLAG <> 'D' OR F_DELETEDFLAG IS NULL)) )