DBA Data[Home] [Help]

VIEW: HR.HR_S_REPORT_FORMAT_MAPPINGS_F#

Source

View Text - Preformatted

select REPORT_TYPE REPORT_TYPE, REPORT_QUALIFIER REPORT_QUALIFIER, REPORT_FORMAT REPORT_FORMAT, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, RANGE_CODE RANGE_CODE, ASSIGNMENT_ACTION_CODE ASSIGNMENT_ACTION_CODE, INITIALIZATION_CODE INITIALIZATION_CODE, ARCHIVE_CODE ARCHIVE_CODE, MAGNETIC_CODE MAGNETIC_CODE, REPORT_CATEGORY REPORT_CATEGORY, REPORT_NAME REPORT_NAME, SORT_CODE SORT_CODE, UPDATABLE_FLAG UPDATABLE_FLAG, DEINITIALIZATION_CODE DEINITIALIZATION_CODE, REPORT_FORMAT_MAPPING_ID REPORT_FORMAT_MAPPING_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, LEGISLATION_CODE LEGISLATION_CODE, TEMPORARY_ACTION_FLAG TEMPORARY_ACTION_FLAG, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER from "HR"."HR_S_REPORT_FORMAT_MAPPINGS_F"
View Text - HTML Formatted

SELECT REPORT_TYPE REPORT_TYPE
, REPORT_QUALIFIER REPORT_QUALIFIER
, REPORT_FORMAT REPORT_FORMAT
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, RANGE_CODE RANGE_CODE
, ASSIGNMENT_ACTION_CODE ASSIGNMENT_ACTION_CODE
, INITIALIZATION_CODE INITIALIZATION_CODE
, ARCHIVE_CODE ARCHIVE_CODE
, MAGNETIC_CODE MAGNETIC_CODE
, REPORT_CATEGORY REPORT_CATEGORY
, REPORT_NAME REPORT_NAME
, SORT_CODE SORT_CODE
, UPDATABLE_FLAG UPDATABLE_FLAG
, DEINITIALIZATION_CODE DEINITIALIZATION_CODE
, REPORT_FORMAT_MAPPING_ID REPORT_FORMAT_MAPPING_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, LEGISLATION_CODE LEGISLATION_CODE
, TEMPORARY_ACTION_FLAG TEMPORARY_ACTION_FLAG
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM "HR"."HR_S_REPORT_FORMAT_MAPPINGS_F"