VIEW: APPS.CCT_TELESETS_MS_VL

Source

View Text - Preformatted

SELECT a.TELESET_ID , a.TELESET_NAME , a.TELESET_HARDWARE_NUMBER , a.TELESET_TYPE_ID , b.TELESET_TYPE , c.meaning , a.SERVER_GROUP_ID , a.middleware_id, (select d.config_name from cct_middlewares d WHERE a.middleware_id = d.middleware_id) config_name , 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 cct_telesets a , cct_teleset_types b , fnd_lookups c WHERE a.teleset_type_id = b.teleset_type_id and c.lookup_type ='CCT_TELESET_TYPES' and b.teleset_type = c.lookup_code

View Text - HTML Formatted

SELECT A.TELESET_ID
, A.TELESET_NAME
, A.TELESET_HARDWARE_NUMBER
, A.TELESET_TYPE_ID
, B.TELESET_TYPE
, C.MEANING
, A.SERVER_GROUP_ID
, A.MIDDLEWARE_ID
, (SELECT D.CONFIG_NAME
FROM CCT_MIDDLEWARES D
WHERE A.MIDDLEWARE_ID = D.MIDDLEWARE_ID) CONFIG_NAME
, 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 CCT_TELESETS A
, CCT_TELESET_TYPES B
, FND_LOOKUPS C
WHERE A.TELESET_TYPE_ID = B.TELESET_TYPE_ID
AND C.LOOKUP_TYPE ='CCT_TELESET_TYPES'
AND B.TELESET_TYPE = C.LOOKUP_CODE