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

TABLE: IGI.IGI_IMP_IAC_INTERFACE

Object Details
Object Name: IGI_IMP_IAC_INTERFACE
Object Type: TABLE
Owner: IGI
FND Design Data: TableIGI.IGI_IMP_IAC_INTERFACE
Subobject Name:
Status: VALID


IGI_IMP_IAC_INTERFACE stores temporary asset information used in the Implementation Reconciliation process. The data is stored in this table so that it can be validated or modified prior to insertion into the IAC Transaction tables.
Scope: public
Product: IGI
Lifecycle: active
Display Name: Implementation Reconciliation Interface
Category: BUSINESS_ENTITY FA_ASSET


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGI_IAC_INTERFACE_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnASSET_ID
ColumnBOOK_TYPE_CODE
ColumnCATEGORY_ID
Columns
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) Yes 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_HIST NUMBER

Historic year to date operating account
OPERATING_ACCOUNT_YTD_MHCA NUMBER

MHCA 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
TRANSFERRED_FLAG VARCHAR2 (1) Yes Flag to indicate whether the asset has been transferred to IAC.
SELECTED_FLAG VARCHAR2 (1) Yes Flag to indicate whether the asset has been selected for transfer to IAC.
EXCEPTION_FLAG VARCHAR2 (1)
Flag to indicate whether the asset has an exception which the user should be aware of during reconciliation.
EXCEPTION_CODE VARCHAR2 (5)
Code to indicate type of exception, Populated if the exception flag is set to Y.
GROUP_ID NUMBER (15)
Group identifier. Records with the same group id are written to the same export data file.
EXPORT_FILE VARCHAR2 (240)
Export CSV file name
EXPORT_DATE DATE

Export Date
IMPORT_FILE VARCHAR2 (240)
Import CSV file name
IMPORT_DATE DATE

Import date
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).
VALID_FLAG VARCHAR2 (1)
Flag to indicate whether the asset has correct values for all the IAC parameters as per IAC calculations.
Query Text

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_HIST
,      OPERATING_ACCOUNT_YTD_MHCA
,      OPERATING_ACCOUNT_COST
,      OPERATING_ACCOUNT_BACKLOG
,      NBV_HIST
,      NBV_MHCA
,      TRANSFERRED_FLAG
,      SELECTED_FLAG
,      EXCEPTION_FLAG
,      EXCEPTION_CODE
,      GROUP_ID
,      EXPORT_FILE
,      EXPORT_DATE
,      IMPORT_FILE
,      IMPORT_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      VALID_FLAG
FROM IGI.IGI_IMP_IAC_INTERFACE;

Dependencies

[top of page]

IGI.IGI_IMP_IAC_INTERFACE does not reference any database object

IGI.IGI_IMP_IAC_INTERFACE is referenced by following:

SchemaAPPS
SynonymIGI_IMP_IAC_INTERFACE