View: PER_INFO_TYPE_SECURITY_CIT_V

Product:	PER - Human Resources
Description:	Join between Info type security and Contact info types
Implementation/DBA Data:	APPS.PER_INFO_TYPE_SECURITY_CIT_V

View Text

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 CITTL.LANGUAGE = USERENV('LANG')

Columns