[Home] [Help] [Dependency Information]
Object Name: | IGI_IMP_IAC_INTERMEDIATE |
---|---|
Object Type: | TABLE |
Owner: | IGI |
FND Design Data: | IGI.IGI_IMP_IAC_INTERMEDIATE |
Subobject Name: | |
Status: | VALID |
IGI_IMP_IAC_INTERMEDIATE is used as an intermediate table to store the values returned for each asset by the Inflation Accounting Implementation Import process. The values from here are used to update records in igi_imp_iac_interface after first being subject to basic validations.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ASSET_ID | NUMBER | (15) | Yes | Asset Identification number |
ASSET_NUMBER | VARCHAR2 | (15) | Yes | User assigned asset number |
BOOK_TYPE_CODE | VARCHAR2 | (15) | Yes | Tax or Corporate book used for the data preparation process |
CATEGORY_ID | NUMBER | (15) | Yes | Category Id |
HIST_SALVAGE_VALUE | NUMBER | Historic salvage value | ||
LIFE_IN_MONTHS | NUMBER | (4) | Life in months | |
COST_HIST | NUMBER | Historic cost of the asset | ||
COST_MHCA | NUMBER | MHCA cost of the asset | ||
DEPRN_EXP_HIST | NUMBER | Historic depreciation expense | ||
DEPRN_EXP_MHCA | NUMBER | MHCA depreciation expense | ||
YTD_HIST | NUMBER | Historic year to date depreciation expense | ||
YTD_MHCA | NUMBER | MHCA year to date depreciation expense | ||
ACCUM_DEPRN_HIST | NUMBER | Historic accumulated depreciation | ||
ACCUM_DEPRN_MHCA | NUMBER | MHCA accumulated depreciation | ||
REVAL_RESERVE_HIST | NUMBER | Historic revaluation reserve | ||
REVAL_RESERVE_MHCA | NUMBER | MHCA revaluation reserve | ||
BACKLOG_HIST | NUMBER | Historic backlog depreciation | ||
BACKLOG_MHCA | NUMBER | MHCA backlog depreciation | ||
GENERAL_FUND_HIST | NUMBER | Historic General fund | ||
GENERAL_FUND_MHCA | NUMBER | MHCA general fund | ||
GENERAL_FUND_PER_HIST | NUMBER | Historic general fund per period | ||
GENERAL_FUND_PER_MHCA | NUMBER | MHCA general fund per period | ||
OPERATING_ACCOUNT_HIST | NUMBER | Historic operating account | ||
OPERATING_ACCOUNT_MHCA | NUMBER | MHCA operating account | ||
OPERATING_ACCOUNT_YTD_MHCA | NUMBER | MHCA year to date operating account | ||
OPERATING_ACCOUNT_YTD_HIST | NUMBER | Historic year to date operating account | ||
OPERATING_ACCOUNT_COST | NUMBER | MHCA operating account due to cost change | ||
OPERATING_ACCOUNT_BACKLOG | NUMBER | MHCA operating account due to backlog change | ||
NBV_HIST | NUMBER | Historic net book value | ||
NBV_MHCA | NUMBER | MHCA net book value | ||
ERRORED_FLAG | VARCHAR2 | (1) | Flag to indicate import error. | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
REQUEST_ID | NUMBER | (15) | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | |
PROGRAM_ID | NUMBER | (15) | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | |
PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). |
Cut, paste (and edit) the following text to query this object:
SELECT ASSET_ID
, ASSET_NUMBER
, BOOK_TYPE_CODE
, CATEGORY_ID
, HIST_SALVAGE_VALUE
, LIFE_IN_MONTHS
, COST_HIST
, COST_MHCA
, DEPRN_EXP_HIST
, DEPRN_EXP_MHCA
, YTD_HIST
, YTD_MHCA
, ACCUM_DEPRN_HIST
, ACCUM_DEPRN_MHCA
, REVAL_RESERVE_HIST
, REVAL_RESERVE_MHCA
, BACKLOG_HIST
, BACKLOG_MHCA
, GENERAL_FUND_HIST
, GENERAL_FUND_MHCA
, GENERAL_FUND_PER_HIST
, GENERAL_FUND_PER_MHCA
, OPERATING_ACCOUNT_HIST
, OPERATING_ACCOUNT_MHCA
, OPERATING_ACCOUNT_YTD_MHCA
, OPERATING_ACCOUNT_YTD_HIST
, OPERATING_ACCOUNT_COST
, OPERATING_ACCOUNT_BACKLOG
, NBV_HIST
, NBV_MHCA
, ERRORED_FLAG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
FROM IGI.IGI_IMP_IAC_INTERMEDIATE;
IGI.IGI_IMP_IAC_INTERMEDIATE does not reference any database object
IGI.IGI_IMP_IAC_INTERMEDIATE is referenced by following:
|
|
|