VIEW: APPS.CCT_MIDDLEWARES_VL

Source

View Text - Preformatted

SELECT a.MIDDLEWARE_ID , a.SERVER_GROUP_ID , a.CONFIG_NAME , a.MIDDLEWARE_IP_ADDRESS , a.MIDDLEWARE_PORT , a.middleware_type_id , b.middleware_type , c.meaning, 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_middlewares a , cct_middleware_types b , fnd_lookups c WHERE a.middleware_type_id = b.middleware_type_id and c.lookup_type ='CCT_MIDDLEWARE_TYPES' and b.middleware_type = c.lookup_code

View Text - HTML Formatted

SELECT A.MIDDLEWARE_ID
, A.SERVER_GROUP_ID
, A.CONFIG_NAME
, A.MIDDLEWARE_IP_ADDRESS
, A.MIDDLEWARE_PORT
, A.MIDDLEWARE_TYPE_ID
, B.MIDDLEWARE_TYPE
, C.MEANING
, 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_MIDDLEWARES A
, CCT_MIDDLEWARE_TYPES B
, FND_LOOKUPS C
WHERE A.MIDDLEWARE_TYPE_ID = B.MIDDLEWARE_TYPE_ID
AND C.LOOKUP_TYPE ='CCT_MIDDLEWARE_TYPES'
AND B.MIDDLEWARE_TYPE = C.LOOKUP_CODE