VIEW: APPS.HR_DOCUMENT_TYPES_V

Source

View Text - Preformatted

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, HDT.SYSTEM_DOCUMENT_TYPE 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')

View Text - HTML Formatted

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
, HDT.SYSTEM_DOCUMENT_TYPE
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')