HR_DOCUMENT_TYPES_VL

Details

• Schema: FUSION

• Object owner: PER

• Object type: VIEW

Columns

Name

ROW_ID DOCUMENT_TYPE_ID DOCUMENT_TYPE CATEGORY_CODE SUB_CATEGORY_CODE ENTERPRISE_ID LEGISLATION_CODE DOCUMENT_TYPE_LEVEL DESCRIPTION WARNING_PERIOD ACTIVE_INACTIVE_FLAG MULTIPLE_OCCURENCES_FLAG AUTHORIZATION_REQUIRED DOCUMENT_NAME_REQUIRED DOCUMENT_NUMBER_REQUIRED DATE_FROM_REQUIRED DATE_TO_REQUIRED ISSUING_AUTHORITY_REQUIRED ISSUED_DATE_REQUIRED ISSUING_COUNTRY_REQUIRED ISSUING_LOCATION_REQUIRED COMMENTS_REQUIRED PUBLISH_REQUIRED SYSTEM_DOCUMENT_TYPE OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN MODULE_ID HIERARCHY_CODE BI_REPORT_PATH LOCK_CREATE LOCK_CREATE_ROLE_LIST LOCK_UPDATE LOCK_UPDATE_ROLE_LIST LOCK_DELETE LOCK_DELETE_ROLE_LIST MIN_ATTACHMENTS_COUNT RESTRICT_CREATE_ATTACH RESTRICT_UPDATE_ATTACH RESTRICT_DELETE_ATTACH ARCHIVE_CRITERIA_DAYS ARCHIVE_CRITERIA_BASIS PURGE_ARCHIVE_CRITERIA_DAYS DOCUMENT_NAME_LABEL DOCUMENT_NUMBER_LABEL DATE_FROM_LABEL DATE_TO_LABEL ISSUING_AUTHORITY_LABEL ISSUED_DATE_LABEL ISSUING_COUNTRY_LABEL ISSUING_LOCATION_LABEL COMMENTS_LABEL DFF_GLB_SEG_DISPLAY_PREF DFF_CTX_SEG_DISPLAY_PREF DFF_CTX_SEG_DEFAULT_VALUE TAG_LIST DT_ATTRIBUTE_CATEGORY DT_ATTRIBUTE1 DT_ATTRIBUTE2 DT_ATTRIBUTE3 DT_ATTRIBUTE4 DT_ATTRIBUTE5 DT_ATTRIBUTE6 DT_ATTRIBUTE7 DT_ATTRIBUTE8 DT_ATTRIBUTE9 DT_ATTRIBUTE10 DT_ATTRIBUTE_NUMBER1 DT_ATTRIBUTE_NUMBER2 DT_ATTRIBUTE_NUMBER3 DT_ATTRIBUTE_NUMBER4 DT_ATTRIBUTE_NUMBER5 DT_ATTRIBUTE_NUMBER6 DT_ATTRIBUTE_NUMBER7 DT_ATTRIBUTE_NUMBER8 DT_ATTRIBUTE_NUMBER9 DT_ATTRIBUTE_NUMBER10 DT_ATTRIBUTE_DATE1 DT_ATTRIBUTE_DATE2 DT_ATTRIBUTE_DATE3 DT_ATTRIBUTE_DATE4 DT_ATTRIBUTE_DATE5 DT_ATTRIBUTE_DATE6 DT_ATTRIBUTE_DATE7 DT_ATTRIBUTE_DATE8 DT_ATTRIBUTE_DATE9 DT_ATTRIBUTE_DATE10 DT_ATTRIBUTE_TIMESTAMP1 DT_ATTRIBUTE_TIMESTAMP2 DT_ATTRIBUTE_TIMESTAMP3 DT_ATTRIBUTE_TIMESTAMP4 DT_ATTRIBUTE_TIMESTAMP5 DT_INFORMATION_CATEGORY DT_INFORMATION1 DT_INFORMATION2 DT_INFORMATION3 DT_INFORMATION4 DT_INFORMATION5 DT_INFORMATION6 DT_INFORMATION7 DT_INFORMATION8 DT_INFORMATION9 DT_INFORMATION10 DT_INFORMATION_NUMBER1 DT_INFORMATION_NUMBER2 DT_INFORMATION_NUMBER3 DT_INFORMATION_NUMBER4 DT_INFORMATION_NUMBER5 DT_INFORMATION_NUMBER6 DT_INFORMATION_NUMBER7 DT_INFORMATION_NUMBER8 DT_INFORMATION_NUMBER9 DT_INFORMATION_NUMBER10 DT_INFORMATION_DATE1 DT_INFORMATION_DATE2 DT_INFORMATION_DATE3 DT_INFORMATION_DATE4 DT_INFORMATION_DATE5 DT_INFORMATION_DATE6 DT_INFORMATION_DATE7 DT_INFORMATION_DATE8 DT_INFORMATION_DATE9 DT_INFORMATION_DATE10 DT_INFORMATION_TIMESTAMP1 DT_INFORMATION_TIMESTAMP2 DT_INFORMATION_TIMESTAMP3 DT_INFORMATION_TIMESTAMP4 DT_INFORMATION_TIMESTAMP5

Query

SQL_Statement

SELECT B.ROWID ROW_ID, B.DOCUMENT_TYPE_ID, T.DOCUMENT_TYPE, B.CATEGORY_CODE, B.SUB_CATEGORY_CODE, B.ENTERPRISE_ID, B.LEGISLATION_CODE, B.DOCUMENT_TYPE_LEVEL, T.DESCRIPTION, B.WARNING_PERIOD, B.ACTIVE_INACTIVE_FLAG, B.MULTIPLE_OCCURENCES_FLAG, B.AUTHORIZATION_REQUIRED, B.DOCUMENT_NAME_REQUIRED, B.DOCUMENT_NUMBER_REQUIRED, B.DATE_FROM_REQUIRED, B.DATE_TO_REQUIRED, B.ISSUING_AUTHORITY_REQUIRED, B.ISSUED_DATE_REQUIRED, B.ISSUING_COUNTRY_REQUIRED, B.ISSUING_LOCATION_REQUIRED, B.COMMENTS_REQUIRED, B.PUBLISH_REQUIRED, B.SYSTEM_DOCUMENT_TYPE, B.OBJECT_VERSION_NUMBER, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN, B.MODULE_ID, B.HIERARCHY_CODE, B.BI_REPORT_PATH, B.LOCK_CREATE, B.LOCK_CREATE_ROLE_LIST, B.LOCK_UPDATE, B.LOCK_UPDATE_ROLE_LIST, B.LOCK_DELETE, B.LOCK_DELETE_ROLE_LIST, B.MIN_ATTACHMENTS_COUNT, B.RESTRICT_CREATE_ATTACH, B.RESTRICT_UPDATE_ATTACH, B.RESTRICT_DELETE_ATTACH , B.ARCHIVE_CRITERIA_DAYS, B.ARCHIVE_CRITERIA_BASIS, B.PURGE_ARCHIVE_CRITERIA_DAYS , T.DOCUMENT_NAME_LABEL, T.DOCUMENT_NUMBER_LABEL, T.DATE_FROM_LABEL, T.DATE_TO_LABEL, T.ISSUING_AUTHORITY_LABEL, T.ISSUED_DATE_LABEL, T.ISSUING_COUNTRY_LABEL, T.ISSUING_LOCATION_LABEL, T.COMMENTS_LABEL, B.DFF_GLB_SEG_DISPLAY_PREF, B.DFF_CTX_SEG_DISPLAY_PREF, B.DFF_CTX_SEG_DEFAULT_VALUE, B.TAG_LIST, B.DT_ATTRIBUTE_CATEGORY, B.DT_ATTRIBUTE1, B.DT_ATTRIBUTE2, B.DT_ATTRIBUTE3, B.DT_ATTRIBUTE4, B.DT_ATTRIBUTE5, B.DT_ATTRIBUTE6, B.DT_ATTRIBUTE7, B.DT_ATTRIBUTE8, B.DT_ATTRIBUTE9, B.DT_ATTRIBUTE10, B.DT_ATTRIBUTE_NUMBER1, B.DT_ATTRIBUTE_NUMBER2, B.DT_ATTRIBUTE_NUMBER3, B.DT_ATTRIBUTE_NUMBER4, B.DT_ATTRIBUTE_NUMBER5, B.DT_ATTRIBUTE_NUMBER6, B.DT_ATTRIBUTE_NUMBER7, B.DT_ATTRIBUTE_NUMBER8, B.DT_ATTRIBUTE_NUMBER9, B.DT_ATTRIBUTE_NUMBER10, B.DT_ATTRIBUTE_DATE1, B.DT_ATTRIBUTE_DATE2, B.DT_ATTRIBUTE_DATE3, B.DT_ATTRIBUTE_DATE4, B.DT_ATTRIBUTE_DATE5, B.DT_ATTRIBUTE_DATE6, B.DT_ATTRIBUTE_DATE7, B.DT_ATTRIBUTE_DATE8, B.DT_ATTRIBUTE_DATE9, B.DT_ATTRIBUTE_DATE10, B.DT_ATTRIBUTE_TIMESTAMP1, B.DT_ATTRIBUTE_TIMESTAMP2, B.DT_ATTRIBUTE_TIMESTAMP3, B.DT_ATTRIBUTE_TIMESTAMP4, B.DT_ATTRIBUTE_TIMESTAMP5, B.DT_INFORMATION_CATEGORY, B.DT_INFORMATION1, B.DT_INFORMATION2, B.DT_INFORMATION3, B.DT_INFORMATION4, B.DT_INFORMATION5, B.DT_INFORMATION6, B.DT_INFORMATION7, B.DT_INFORMATION8, B.DT_INFORMATION9, B.DT_INFORMATION10, B.DT_INFORMATION_NUMBER1, B.DT_INFORMATION_NUMBER2, B.DT_INFORMATION_NUMBER3, B.DT_INFORMATION_NUMBER4, B.DT_INFORMATION_NUMBER5, B.DT_INFORMATION_NUMBER6, B.DT_INFORMATION_NUMBER7, B.DT_INFORMATION_NUMBER8, B.DT_INFORMATION_NUMBER9, B.DT_INFORMATION_NUMBER10, B.DT_INFORMATION_DATE1, B.DT_INFORMATION_DATE2, B.DT_INFORMATION_DATE3, B.DT_INFORMATION_DATE4, B.DT_INFORMATION_DATE5, B.DT_INFORMATION_DATE6, B.DT_INFORMATION_DATE7, B.DT_INFORMATION_DATE8, B.DT_INFORMATION_DATE9, B.DT_INFORMATION_DATE10, B.DT_INFORMATION_TIMESTAMP1, B.DT_INFORMATION_TIMESTAMP2, B.DT_INFORMATION_TIMESTAMP3, B.DT_INFORMATION_TIMESTAMP4, B.DT_INFORMATION_TIMESTAMP5 FROM HR_DOCUMENT_TYPES_B B, HR_DOCUMENT_TYPES_TL T WHERE B.DOCUMENT_TYPE_ID = T.DOCUMENT_TYPE_ID AND T.LANGUAGE = USERENV('LANG')