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

TABLE: IGI.IGI_MHC_PROJ_INTERIM

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


IGI_MHC_PROJ_INTERIM is a temporary storage area for depreciation
projections. Oracle Assets never permanently stores data in this
table.
.
When you request a depreciation projection, the projections
program creates this table. The Depreciation Projection Report
submitted with the program drops the table after using the
information.
.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
REQUEST_ID NUMBER (15) Yes Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
BOOK_TYPE_CODE VARCHAR2 (15) Yes Depreciation book
ASSET_ID NUMBER (15) Yes Asset identification number
PERIOD_NAME VARCHAR2 (15) Yes Depreciation period
PERIOD_INDEX NUMBER (3) Yes Index of how many periods into the projection this period is
FISCAL_YEAR NUMBER (4) Yes Fiscal year
CODE_COMBINATION_ID NUMBER (15) Yes General Ledger depreciation expense account
DEPRECIATION NUMBER

Depreciation expense amount projected for this period
OPERATING_EXPENSE NUMBER

Operating Expense Amount
BACKLOG_RESERVE NUMBER

Backlog Depreciation Amount
INDEX_PERCENT NUMBER

Indexation percent
Query Text

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


SELECT REQUEST_ID
,      BOOK_TYPE_CODE
,      ASSET_ID
,      PERIOD_NAME
,      PERIOD_INDEX
,      FISCAL_YEAR
,      CODE_COMBINATION_ID
,      DEPRECIATION
,      OPERATING_EXPENSE
,      BACKLOG_RESERVE
,      INDEX_PERCENT
FROM IGI.IGI_MHC_PROJ_INTERIM;

Dependencies

[top of page]

IGI.IGI_MHC_PROJ_INTERIM does not reference any database object

IGI.IGI_MHC_PROJ_INTERIM is referenced by following:

SchemaAPPS
SynonymIGI_MHC_PROJ_INTERIM