VIEW: JL.JL_CO_FA_PURGE#

Source

View Text - Preformatted

select PURGE_ID PURGE_ID, BOOK_TYPE_CODE BOOK_TYPE_CODE, FISCAL_YEAR FISCAL_YEAR, STATUS STATUS, ADJUSTMENTS_ROWS_ARCHIVED ADJUSTMENTS_ROWS_ARCHIVED, ADJUSTMENTS_CHECK_SUM ADJUSTMENTS_CHECK_SUM, APPRAISALS_ROWS_ARCHIVED APPRAISALS_ROWS_ARCHIVED, APPRAISALS_CHECK_SUM APPRAISALS_CHECK_SUM, ASSET_APPRS_ROWS_ARCHIVED ASSET_APPRS_ROWS_ARCHIVED, ASSET_APPRS_CHECK_SUM ASSET_APPRS_CHECK_SUM, 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_UPDATE_DATE PROGRAM_UPDATE_DATE, APPRAISAL_BOOKS_ROWS_ARCHIVED APPRAISAL_BOOKS_ROWS_ARCHIVED, APPRAISAL_BOOKS_CHECK_SUM APPRAISAL_BOOKS_CHECK_SUM from "JL"."JL_CO_FA_PURGE"

View Text - HTML Formatted

SELECT PURGE_ID PURGE_ID
, BOOK_TYPE_CODE BOOK_TYPE_CODE
, FISCAL_YEAR FISCAL_YEAR
, STATUS STATUS
, ADJUSTMENTS_ROWS_ARCHIVED ADJUSTMENTS_ROWS_ARCHIVED
, ADJUSTMENTS_CHECK_SUM ADJUSTMENTS_CHECK_SUM
, APPRAISALS_ROWS_ARCHIVED APPRAISALS_ROWS_ARCHIVED
, APPRAISALS_CHECK_SUM APPRAISALS_CHECK_SUM
, ASSET_APPRS_ROWS_ARCHIVED ASSET_APPRS_ROWS_ARCHIVED
, ASSET_APPRS_CHECK_SUM ASSET_APPRS_CHECK_SUM
, 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_UPDATE_DATE PROGRAM_UPDATE_DATE
, APPRAISAL_BOOKS_ROWS_ARCHIVED APPRAISAL_BOOKS_ROWS_ARCHIVED
, APPRAISAL_BOOKS_CHECK_SUM APPRAISAL_BOOKS_CHECK_SUM
FROM "JL"."JL_CO_FA_PURGE"