DBA Data[Home] [Help]

VIEW: HR.PAY_REPORT_DEFINITIONS#

Source

View Text - Preformatted

select REPORT_DEFINITION_ID REPORT_DEFINITION_ID, REPORT_GROUP_ID REPORT_GROUP_ID, REPORT_NAME REPORT_NAME, REPORT_TYPE REPORT_TYPE, REPORT_LEVEL REPORT_LEVEL, MAGNETIC_BLOCK_ID MAGNETIC_BLOCK_ID, APPLICATION_SHORT_NAME APPLICATION_SHORT_NAME, ALTERABLE ALTERABLE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, ZD_EDITION_NAME ZD_EDITION_NAME from "HR"."PAY_REPORT_DEFINITIONS"
View Text - HTML Formatted

SELECT REPORT_DEFINITION_ID REPORT_DEFINITION_ID
, REPORT_GROUP_ID REPORT_GROUP_ID
, REPORT_NAME REPORT_NAME
, REPORT_TYPE REPORT_TYPE
, REPORT_LEVEL REPORT_LEVEL
, MAGNETIC_BLOCK_ID MAGNETIC_BLOCK_ID
, APPLICATION_SHORT_NAME APPLICATION_SHORT_NAME
, ALTERABLE ALTERABLE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "HR"."PAY_REPORT_DEFINITIONS"