View: HR_DOCUMENT_TYPES_V

Product:	PER - Human Resources
Description:	Translated view of Document Types.
Implementation/DBA Data:	APPS.HR_DOCUMENT_TYPES_V

View Text

SELECT HDT.ROWID
, HDT.DOCUMENT_TYPE_ID
, HDTTL.DOCUMENT_TYPE
, HDTTL.DESCRIPTION
, HDT.CATEGORY_CODE
, HL.MEANING
, HDT.SUB_CATEGORY_CODE
, PST.SHARED_TYPE_NAME
, HDT.ACTIVE_INACTIVE_FLAG
, HDT.MULTIPLE_OCCURENCES_FLAG
, HDT.LEGISLATION_CODE
, HDT.AUTHORIZATION_REQUIRED
, HDT.WARNING_PERIOD
, HDT.REQUEST_ID
, HDT.PROGRAM_APPLICATION_ID
, HDT.PROGRAM_ID
, HDT.PROGRAM_UPDATE_DATE
, HDT.OBJECT_VERSION_NUMBER
, HDT.LAST_UPDATE_DATE
, HDT.LAST_UPDATED_BY
, HDT.LAST_UPDATE_LOGIN
, HDT.CREATED_BY
, HDT.CREATION_DATE
FROM HR_DOCUMENT_TYPES_TL HDTTL
, HR_DOCUMENT_TYPES HDT
, HR_LOOKUPS HL
, PER_SHARED_TYPES_VL PST
WHERE HDT.SUB_CATEGORY_CODE = PST.SHARED_TYPE_CODE
AND PST.LOOKUP_TYPE = 'DOCUMENT_CATEGORY'
AND HDT.CATEGORY_CODE = HL.LOOKUP_CODE
AND HL.LOOKUP_TYPE = 'DOCUMENT_CATEGORY'
AND HDTTL.DOCUMENT_TYPE_ID = HDT.DOCUMENT_TYPE_ID
AND HDTTL.LANGUAGE = USERENV('LANG')

Columns