VIEW: APPS.CCT_TELESETS_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.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.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