VIEW: APPS.PER_INFO_TYPE_SECURITY_CIT_V

Source

View Text - Preformatted

SELECT its.application_id, its.responsibility_id, cit.information_type, cit.multiple_occurences_flag, cit.active_inactive_flag, cittl.description, cit.legislation_code, cit.request_id, cit.program_application_id, cit.program_id, cit.program_update_date, cit.object_version_number, cit.last_update_date, cit.last_updated_by, cit.last_update_login, cit.created_by, cit.creation_date FROM per_info_type_security its, per_contact_info_types cit, per_contact_info_types_tl cittl WHERE its.info_type_table_name = 'PER_CONTACT_INFO_TYPES' AND cit.information_type = cittl.information_type and cit.information_type = its.information_type AND cittl.language = USERENV('LANG')

View Text - HTML Formatted

SELECT ITS.APPLICATION_ID
, ITS.RESPONSIBILITY_ID
, CIT.INFORMATION_TYPE
, CIT.MULTIPLE_OCCURENCES_FLAG
, CIT.ACTIVE_INACTIVE_FLAG
, CITTL.DESCRIPTION
, CIT.LEGISLATION_CODE
, CIT.REQUEST_ID
, CIT.PROGRAM_APPLICATION_ID
, CIT.PROGRAM_ID
, CIT.PROGRAM_UPDATE_DATE
, CIT.OBJECT_VERSION_NUMBER
, CIT.LAST_UPDATE_DATE
, CIT.LAST_UPDATED_BY
, CIT.LAST_UPDATE_LOGIN
, CIT.CREATED_BY
, CIT.CREATION_DATE
FROM PER_INFO_TYPE_SECURITY ITS
, PER_CONTACT_INFO_TYPES CIT
, PER_CONTACT_INFO_TYPES_TL CITTL
WHERE ITS.INFO_TYPE_TABLE_NAME = 'PER_CONTACT_INFO_TYPES'
AND CIT.INFORMATION_TYPE = CITTL.INFORMATION_TYPE
AND CIT.INFORMATION_TYPE = ITS.INFORMATION_TYPE
AND CITTL.LANGUAGE = USERENV('LANG')