VIEW: IGC.IGC_CC_ARCHIVE_HISTORY_OBS#

Source

View Text - Preformatted

select CC_HEADER_ID CC_HEADER_ID, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, ORG_ID ORG_ID, CC_TYPE CC_TYPE, CC_NUM CC_NUM, PARENT_HEADER_ID PARENT_HEADER_ID, ARCHIVE_DATE ARCHIVE_DATE, ARCHIVED_BY ARCHIVED_BY, ARCHIVE_DONE_FLAG ARCHIVE_DONE_FLAG, PURGE_DATE PURGE_DATE, PURGED_BY PURGED_BY, PURGE_DONE_FLAG PURGE_DONE_FLAG, NUM_ACCT_LINES_ARC NUM_ACCT_LINES_ARC, NUM_DET_PF_LINES_ARC NUM_DET_PF_LINES_ARC, NUM_MC_ACCT_LINES_ARC NUM_MC_ACCT_LINES_ARC, NUM_MC_DET_PF_LINES_ARC NUM_MC_DET_PF_LINES_ARC, LAST_CC_ACTIVITY_DATE LAST_CC_ACTIVITY_DATE, USER_REQ_LAST_ACTIVITY_DATE USER_REQ_LAST_ACTIVITY_DATE, 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_CC_ARCHIVE_HISTORY_OBS"

View Text - HTML Formatted

SELECT CC_HEADER_ID CC_HEADER_ID
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, ORG_ID ORG_ID
, CC_TYPE CC_TYPE
, CC_NUM CC_NUM
, PARENT_HEADER_ID PARENT_HEADER_ID
, ARCHIVE_DATE ARCHIVE_DATE
, ARCHIVED_BY ARCHIVED_BY
, ARCHIVE_DONE_FLAG ARCHIVE_DONE_FLAG
, PURGE_DATE PURGE_DATE
, PURGED_BY PURGED_BY
, PURGE_DONE_FLAG PURGE_DONE_FLAG
, NUM_ACCT_LINES_ARC NUM_ACCT_LINES_ARC
, NUM_DET_PF_LINES_ARC NUM_DET_PF_LINES_ARC
, NUM_MC_ACCT_LINES_ARC NUM_MC_ACCT_LINES_ARC
, NUM_MC_DET_PF_LINES_ARC NUM_MC_DET_PF_LINES_ARC
, LAST_CC_ACTIVITY_DATE LAST_CC_ACTIVITY_DATE
, USER_REQ_LAST_ACTIVITY_DATE USER_REQ_LAST_ACTIVITY_DATE
, 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_CC_ARCHIVE_HISTORY_OBS"