[Home] [Help] [Dependency Information]
Object Name: | JL_CO_FA_PURGE |
---|---|
Object Type: | TABLE |
Owner: | JL |
FND Design Data: | JL.JL_CO_FA_PURGE |
Subobject Name: | |
Status: | VALID |
JL_CO_FA_PURGE stores information about the Colombian archive, purge and restore requests.
When you define an archive request from the Purge menu, Oracle Assets inserts a row that stores which technical appraisals and inflation adjustment information to archive for which book and fiscal year. It uses this information to archive, purge and restore information from JL_CO_FA_APPRAISALS, JL_CO_FA_ASSET_APPRS, JL_CO_FA_APPRAISAL_BOOKS and JL_CO_FA_ADJUSTMENTS.
Check sum and rows archive columns help to enforce data integrity at the time of archiving, purging, and restoring the information.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JL_CO_FA_PURGE_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | PURGE_ID |
JL_CO_FA_PURGE_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
BOOK_TYPE_CODE
FISCAL_YEAR |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PURGE_ID | NUMBER | (7) | Yes | Unique identifier to the purge requirement |
BOOK_TYPE_CODE | VARCHAR2 | (15) | Depreciation book name | |
FISCAL_YEAR | NUMBER | (4) | Yes | Fiscal year archived or purged |
STATUS | VARCHAR2 | (15) | Yes | Status of the purge requirement (NEW, ARCHIVED, PURGED or RESTORED) |
ADJUSTMENTS_ROWS_ARCHIVED | NUMBER | (15) | Yes | Number of JL_CO_FA_ADJUSTMENTS rows archived |
ADJUSTMENTS_CHECK_SUM | NUMBER | Yes | JL_CO_FA_ADJUSTMENTS adjustments amount check sum | |
APPRAISALS_ROWS_ARCHIVED | NUMBER | Yes | Number of JL_CO_FA_APPRAISALS rows archived | |
APPRAISALS_CHECK_SUM | NUMBER | Yes | JL_CO_FA_APPRAISALS appraisals check sum | |
ASSET_APPRS_ROWS_ARCHIVED | NUMBER | (15) | Yes | Number of JL_CO_FA_ASSET_APPRS rows archived |
ASSET_APPRS_CHECK_SUM | NUMBER | Yes | JL_CO_FA_ASSET_APPRS appraised asset values check sum | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who Column |
CREATION_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who Column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column | |
REQUEST_ID | NUMBER | (15) | Standard Who Column | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Standard Who Column | |
PROGRAM_ID | NUMBER | (15) | Standard Who Column | |
PROGRAM_UPDATE_DATE | DATE | Standard Who Column | ||
APPRAISAL_BOOKS_ROWS_ARCHIVED | NUMBER | (15) | Yes | Number of rows from table JL_CO_FA_APPRAISAL_BOOKS to be archived |
APPRAISAL_BOOKS_CHECK_SUM | NUMBER | Yes | JL_CO_FA_APPRAISAL_BOOKS appraisals check sum |
Cut, paste (and edit) the following text to query this object:
SELECT PURGE_ID
, BOOK_TYPE_CODE
, FISCAL_YEAR
, STATUS
, ADJUSTMENTS_ROWS_ARCHIVED
, ADJUSTMENTS_CHECK_SUM
, APPRAISALS_ROWS_ARCHIVED
, APPRAISALS_CHECK_SUM
, ASSET_APPRS_ROWS_ARCHIVED
, ASSET_APPRS_CHECK_SUM
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, APPRAISAL_BOOKS_ROWS_ARCHIVED
, APPRAISAL_BOOKS_CHECK_SUM
FROM JL.JL_CO_FA_PURGE;
JL.JL_CO_FA_PURGE does not reference any database object
JL.JL_CO_FA_PURGE is referenced by following:
|
|
|