[Home] [Help] [Dependency Information]
Object Name: | FA_ARCHIVE_HISTORY# |
---|---|
Object Type: | VIEW |
Owner: | FA |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ARCHIVE_ID | NUMBER | (15) | Yes | |
BOOK_TYPE_CODE | VARCHAR2 | (15) | Yes | |
FISCAL_YEAR | NUMBER | (4) | Yes | |
STATUS | VARCHAR2 | (15) | ||
DEPRN_SUMMARY_ROWS_ARCHIVED | NUMBER | |||
DEPRN_SUMMARY_CHECK_SUM | NUMBER | |||
DEPRN_DETAIL_ROWS_ARCHIVED | NUMBER | |||
DEPRN_DETAIL_CHECK_SUM | NUMBER | |||
ADJUSTMENT_ROWS_ARCHIVED | NUMBER | |||
ADJUSTMENT_CHECK_SUM | NUMBER | |||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT ARCHIVE_ID
, BOOK_TYPE_CODE
, FISCAL_YEAR
, STATUS
, DEPRN_SUMMARY_ROWS_ARCHIVED
, DEPRN_SUMMARY_CHECK_SUM
, DEPRN_DETAIL_ROWS_ARCHIVED
, DEPRN_DETAIL_CHECK_SUM
, ADJUSTMENT_ROWS_ARCHIVED
, ADJUSTMENT_CHECK_SUM
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
FROM FA.FA_ARCHIVE_HISTORY#;
|
|
|