[Home] [Help] [Dependency Information]
Object Name: | IGI_MHC_REVAL_DETAILS_LL_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGI.IGI_MHC_REVAL_DETAILS_LL_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Refer to Base Table | |
DETAIL_SEQ_ID | NUMBER | (15) | Yes | Refer to Base Table |
MASS_REVAL_ID | NUMBER | (15) | Yes | Refer to Base Table |
ASSET_ID | NUMBER | (15) | Yes | Refer to Base Table |
CATEGORY_ID | NUMBER | (15) | Yes | Refer to Base Table |
BOOK_TYPE_CODE | VARCHAR2 | (15) | Yes | Refer to Base Table |
DISTRIBUTION_ID | NUMBER | (15) | Yes | Refer to Base Table |
CURRENT_MHC_PERIOD_COUNTER | NUMBER | (15) | Yes | Refer to Base Table |
PERIOD_COUNTER | NUMBER | Yes | Refer to Base Table | |
REVAL_MODE | VARCHAR2 | (30) | Refer to Base Table | |
NUMBER_OF_UNITS_ASSIGNED | NUMBER | (15) | Refer to Base Table | |
NUMBER_OF_UNITS_RETIRED | NUMBER | (15) | Refer to Base Table | |
LIFE_CHANGE_COUNT | NUMBER | (15) | Refer to Base Table | |
RUN_MODE | VARCHAR2 | (1) | Refer to Base Table | |
ACTIVE_FLAG | VARCHAR2 | (1) | Yes | Refer to Base Table |
ASSET_COST | NUMBER | Refer to Base Table | ||
SALVAGE_VALUE | NUMBER | Refer to Base Table | ||
ACCUMULATED_DEPRECIATION | NUMBER | Refer to Base Table | ||
PRIOR_YRS_ACCUM_DEPRECIATION | NUMBER | Refer to Base Table | ||
YTD_DEPRECIATION_RESERVE | NUMBER | Refer to Base Table | ||
CURR_MHC_PRD_BACKLOG_DEPRN | NUMBER | Refer to Base Table | ||
ACCUMULATED_BACKLOG_DEPRN | NUMBER | Refer to Base Table | ||
NET_BOOK_VALUE | NUMBER | Refer to Base Table | ||
REVALUATION_RESERVE | NUMBER | Refer to Base Table | ||
DEPRECIATION_EXPENSE | NUMBER | Refer to Base Table | ||
CURR_YEAR_OPERATING_EXPENSE | NUMBER | Refer to Base Table | ||
CURR_YR_PRIOR_PRDS_DEPRN | NUMBER | Refer to Base Table | ||
CURR_YR_PRIOR_PRDS_DEPRN_REVAL | NUMBER | Refer to Base Table | ||
PRIOR_YEAR_OPERATING_EXPENSE | NUMBER | Refer to Base Table | ||
GENERAL_FUND | NUMBER | Refer to Base Table | ||
ACCUMULATED_GENERAL_FUND | NUMBER | Refer to Base Table | ||
PRORATE_PERCENT | NUMBER | Refer to Base Table | ||
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
LAST_UPDATE_BY | NUMBER | (15) | Refer to Base Table | |
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). | |
PROCESS_STATUS_CODE | VARCHAR2 | (1) | Refer to Base Table | |
DEPRN_PROCESSED_FLAG | VARCHAR2 | (240) | Refer to Base Table |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, DETAIL_SEQ_ID
, MASS_REVAL_ID
, ASSET_ID
, CATEGORY_ID
, BOOK_TYPE_CODE
, DISTRIBUTION_ID
, CURRENT_MHC_PERIOD_COUNTER
, PERIOD_COUNTER
, REVAL_MODE
, NUMBER_OF_UNITS_ASSIGNED
, NUMBER_OF_UNITS_RETIRED
, LIFE_CHANGE_COUNT
, RUN_MODE
, ACTIVE_FLAG
, ASSET_COST
, SALVAGE_VALUE
, ACCUMULATED_DEPRECIATION
, PRIOR_YRS_ACCUM_DEPRECIATION
, YTD_DEPRECIATION_RESERVE
, CURR_MHC_PRD_BACKLOG_DEPRN
, ACCUMULATED_BACKLOG_DEPRN
, NET_BOOK_VALUE
, REVALUATION_RESERVE
, DEPRECIATION_EXPENSE
, CURR_YEAR_OPERATING_EXPENSE
, CURR_YR_PRIOR_PRDS_DEPRN
, CURR_YR_PRIOR_PRDS_DEPRN_REVAL
, PRIOR_YEAR_OPERATING_EXPENSE
, GENERAL_FUND
, ACCUMULATED_GENERAL_FUND
, PRORATE_PERCENT
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_BY
, LAST_UPDATE_LOGIN
, PROCESS_STATUS_CODE
, DEPRN_PROCESSED_FLAG
FROM APPS.IGI_MHC_REVAL_DETAILS_LL_V;
APPS.IGI_MHC_REVAL_DETAILS_LL_V is not referenced by any database object
|
|
|