eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: JL.JL_CO_FA_PURGE

Object Details

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.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

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

Columns

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

Query Text

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;

Dependencies

[top of page]

JL.JL_CO_FA_PURGE does not reference any database object

JL.JL_CO_FA_PURGE is referenced by following:

APPS: JL_CO_FA_PURGE