[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_NOLOGGING |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JL_MX_FA_ISR_IMPAC_U1 | NORMAL | UNIQUE | APPS_TS_NOLOGGING |
PROCESS_ID
ASSET_ID TRANSACTION_HEADER_ID_IN |
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 |
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;
JL.JL_MX_FA_ISR_IMPAC does not reference any database object
JL.JL_MX_FA_ISR_IMPAC is referenced by following:
|
|
|