VIEW: ZX.ZX_REPORTING_CODES_B#

Source

View Text - Preformatted

select REPORTING_CODE_ID REPORTING_CODE_ID, EXCEPTION_CODE EXCEPTION_CODE, EFFECTIVE_FROM EFFECTIVE_FROM, EFFECTIVE_TO EFFECTIVE_TO, RECORD_TYPE_CODE RECORD_TYPE_CODE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID, REPORTING_CODE_CHAR_VALUE REPORTING_CODE_CHAR_VALUE, REPORTING_CODE_DATE_VALUE REPORTING_CODE_DATE_VALUE, REPORTING_CODE_NUM_VALUE REPORTING_CODE_NUM_VALUE, REPORTING_TYPE_ID REPORTING_TYPE_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, ZD_EDITION_NAME ZD_EDITION_NAME from "ZX"."ZX_REPORTING_CODES_B"

View Text - HTML Formatted

SELECT REPORTING_CODE_ID REPORTING_CODE_ID
, EXCEPTION_CODE EXCEPTION_CODE
, EFFECTIVE_FROM EFFECTIVE_FROM
, EFFECTIVE_TO EFFECTIVE_TO
, RECORD_TYPE_CODE RECORD_TYPE_CODE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID
, REPORTING_CODE_CHAR_VALUE REPORTING_CODE_CHAR_VALUE
, REPORTING_CODE_DATE_VALUE REPORTING_CODE_DATE_VALUE
, REPORTING_CODE_NUM_VALUE REPORTING_CODE_NUM_VALUE
, REPORTING_TYPE_ID REPORTING_TYPE_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "ZX"."ZX_REPORTING_CODES_B"