VIEW: APPS.CCT_IVR_MAPS_VL

Source

View Text - Preformatted

SELECT a.IVR_MAP_ID , a.IVR_VAR_NAME , a.INTERACTION_KEY_ID , c.INTERACTION_KEY , B.meaning , c.data_type , d.meaning , a.SERVER_GROUP_ID , a.mw_route_point_id , (select e.route_point_number from cct_mw_route_points e where e.mw_route_point_id = a.mw_route_point_id) route_point_number , (select f.middleware_id from cct_middlewares f, cct_mw_route_points e where e.mw_route_point_id = a.mw_route_point_id and e.middleware_id = f.middleware_id) middleware_id , (select f.config_name from cct_middlewares f, cct_mw_route_points e where e.mw_route_point_id = a.mw_route_point_id and e.middleware_id = f.middleware_id) middleware, a.last_update_date, a.last_updated_by, a.creation_date, a.created_by, a.last_update_login, a.object_version_number, f_deletedflag from cct_ivr_maps a , fnd_lookups b , CCT_INTERACTION_KEYS c , fnd_lookups d WHERE A.INTERACTION_KEY_ID = C.INTERACTION_KEY_ID AND B.LOOKUP_TYPE= 'CCT_INTERACTION_KEYS' AND upper(C.INTERACTION_KEY) = B.LOOKUP_CODE AND D.LOOKUP_TYPE= 'CCT_INTERACTION_TYPES' AND upper(C.DATA_TYPE) = D.LOOKUP_CODE

View Text - HTML Formatted

SELECT A.IVR_MAP_ID
, A.IVR_VAR_NAME
, A.INTERACTION_KEY_ID
, C.INTERACTION_KEY
, B.MEANING
, C.DATA_TYPE
, D.MEANING
, A.SERVER_GROUP_ID
, A.MW_ROUTE_POINT_ID
, (SELECT E.ROUTE_POINT_NUMBER
FROM CCT_MW_ROUTE_POINTS E
WHERE E.MW_ROUTE_POINT_ID = A.MW_ROUTE_POINT_ID) ROUTE_POINT_NUMBER
, (SELECT F.MIDDLEWARE_ID
FROM CCT_MIDDLEWARES F
, CCT_MW_ROUTE_POINTS E
WHERE E.MW_ROUTE_POINT_ID = A.MW_ROUTE_POINT_ID
AND E.MIDDLEWARE_ID = F.MIDDLEWARE_ID) MIDDLEWARE_ID
, (SELECT F.CONFIG_NAME
FROM CCT_MIDDLEWARES F
, CCT_MW_ROUTE_POINTS E
WHERE E.MW_ROUTE_POINT_ID = A.MW_ROUTE_POINT_ID
AND E.MIDDLEWARE_ID = F.MIDDLEWARE_ID) MIDDLEWARE
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
, A.CREATION_DATE
, A.CREATED_BY
, A.LAST_UPDATE_LOGIN
, A.OBJECT_VERSION_NUMBER
, F_DELETEDFLAG
FROM CCT_IVR_MAPS A
, FND_LOOKUPS B
, CCT_INTERACTION_KEYS C
, FND_LOOKUPS D
WHERE A.INTERACTION_KEY_ID = C.INTERACTION_KEY_ID
AND B.LOOKUP_TYPE= 'CCT_INTERACTION_KEYS'
AND UPPER(C.INTERACTION_KEY) = B.LOOKUP_CODE
AND D.LOOKUP_TYPE= 'CCT_INTERACTION_TYPES'
AND UPPER(C.DATA_TYPE) = D.LOOKUP_CODE