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_MX_FA_ISR_IMPAC

Object Details

Object Name:	JL_MX_FA_ISR_IMPAC
Object Type:	TABLE
Owner:	JL
FND Design Data:	JL.JL_MX_FA_ISR_IMPAC
Subobject Name:
Status:	VALID

JL_MX_FA_ISR_IMPAC holds information generated during the execution of ISR and IMPAC reports. Records are inserted by the ISR Report and are read by the IMPAC Report.

Storage Details

Tablespace:	APPS_TS_NOLOGGING
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JL_MX_FA_ISR_IMPAC_U1	NORMAL	UNIQUE	APPS_TS_NOLOGGING	PROCESS_ID ASSET_ID TRANSACTION_HEADER_ID_IN

Columns

Name	Datatype	Length	Mandatory	Comments
PROCESS_ID	NUMBER	(15)		Concurrent Process ID
ASSET_CATEGORY_ID	NUMBER	(15)	Yes	Asset category identification number
ASSET_ID	NUMBER	(15)	Yes	Asset identification number
ASSET_NUMBER	VARCHAR2	(30)		Asset Number
INPC	NUMBER			Consumer price index value for date of acquisition
ORIGINAL_COST	NUMBER			Original Cost
ACCUM_DEPRN_PREVIOUS_FY	NUMBER			Accumulated Depreciation of Previous fiscal year (Historical)
ADJUSTED_DEPRN_CURRENT_FY	NUMBER			Adjusted Depreciation of Current fiscal year
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
CREATION_DATE	DATE			Standard Who Column
CREATED_BY	NUMBER	(15)		Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
TRANSACTION_HEADER_ID_IN	NUMBER	(15)	Yes	Identifies the transation that made this row effective
TRANSACTION_HEADER_ID_OUT	NUMBER	(15)		Identifies the transaction that made this row ineffective
DESCRIPTION	VARCHAR2	(80)	Yes	Description of the asset
DATE_PLACED_IN_SERVICE	DATE		Yes	Date the asset was placed in service
PRORATE_DATE	DATE		Yes	Date used to prorate depreciation
RETIREMENT_ID	NUMBER	(15)		Identifies the retirement transaction if the asset has been retired
PERIOD_COUNTER_FULLY_RESERVED	NUMBER	(15)		Period that the asset became fully reserved

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PROCESS_ID
,      ASSET_CATEGORY_ID
,      ASSET_ID
,      ASSET_NUMBER
,      INPC
,      ORIGINAL_COST
,      ACCUM_DEPRN_PREVIOUS_FY
,      ADJUSTED_DEPRN_CURRENT_FY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      TRANSACTION_HEADER_ID_IN
,      TRANSACTION_HEADER_ID_OUT
,      DESCRIPTION
,      DATE_PLACED_IN_SERVICE
,      PRORATE_DATE
,      RETIREMENT_ID
,      PERIOD_COUNTER_FULLY_RESERVED
FROM JL.JL_MX_FA_ISR_IMPAC;

Dependencies

[top of page]

JL.JL_MX_FA_ISR_IMPAC does not reference any database object

JL.JL_MX_FA_ISR_IMPAC is referenced by following:

APPS: JL_MX_FA_ISR_IMPAC