VIEW: IGC.IGC_CBC_ARCHIVE_HISTORY_OBS#

Source

View Text - Preformatted

select SET_OF_BOOKS_ID SET_OF_BOOKS_ID, PERIOD_SET_NAME PERIOD_SET_NAME, PERIOD_NAME PERIOD_NAME, TEMP_PERM_STATUS TEMP_PERM_STATUS, FISCAL_YEAR FISCAL_YEAR, ORG_ID ORG_ID, ARCHIVE_DONE_FLAG ARCHIVE_DONE_FLAG, ARCHIVE_DATE ARCHIVE_DATE, ARCHIVED_BY ARCHIVED_BY, PURGE_DONE_FLAG PURGE_DONE_FLAG, PURGE_DATE PURGE_DATE, PURGED_BY PURGED_BY, TOT_LINE_RECORDS_ARCHIVED TOT_LINE_RECORDS_ARCHIVED, TOT_BATCH_RECORDS_ARCHIVED TOT_BATCH_RECORDS_ARCHIVED, TOT_MC_BATCH_RECORDS_ARCHIVED TOT_MC_BATCH_RECORDS_ARCHIVED, TOT_MC_LINE_RECORDS_ARCHIVED TOT_MC_LINE_RECORDS_ARCHIVED, TOT_BUDGET_LINES_ARCHIVED TOT_BUDGET_LINES_ARCHIVED, TOT_ENCUMBRANCE_LINES_ARCHIVED TOT_ENCUMBRANCE_LINES_ARCHIVED, TOTAL_ENTERED_CR TOTAL_ENTERED_CR, TOTAL_ENTERED_DR TOTAL_ENTERED_DR, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY from "IGC"."IGC_CBC_ARCHIVE_HISTORY_OBS"

View Text - HTML Formatted

SELECT SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, PERIOD_SET_NAME PERIOD_SET_NAME
, PERIOD_NAME PERIOD_NAME
, TEMP_PERM_STATUS TEMP_PERM_STATUS
, FISCAL_YEAR FISCAL_YEAR
, ORG_ID ORG_ID
, ARCHIVE_DONE_FLAG ARCHIVE_DONE_FLAG
, ARCHIVE_DATE ARCHIVE_DATE
, ARCHIVED_BY ARCHIVED_BY
, PURGE_DONE_FLAG PURGE_DONE_FLAG
, PURGE_DATE PURGE_DATE
, PURGED_BY PURGED_BY
, TOT_LINE_RECORDS_ARCHIVED TOT_LINE_RECORDS_ARCHIVED
, TOT_BATCH_RECORDS_ARCHIVED TOT_BATCH_RECORDS_ARCHIVED
, TOT_MC_BATCH_RECORDS_ARCHIVED TOT_MC_BATCH_RECORDS_ARCHIVED
, TOT_MC_LINE_RECORDS_ARCHIVED TOT_MC_LINE_RECORDS_ARCHIVED
, TOT_BUDGET_LINES_ARCHIVED TOT_BUDGET_LINES_ARCHIVED
, TOT_ENCUMBRANCE_LINES_ARCHIVED TOT_ENCUMBRANCE_LINES_ARCHIVED
, TOTAL_ENTERED_CR TOTAL_ENTERED_CR
, TOTAL_ENTERED_DR TOTAL_ENTERED_DR
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
FROM "IGC"."IGC_CBC_ARCHIVE_HISTORY_OBS"