eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: IGI.IGI_MHC_REVALUATION_DETAIL#

Object Details

Object Name:	IGI_MHC_REVALUATION_DETAIL#
Object Type:	VIEW
Owner:	IGI
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
DETAIL_SEQ_ID	NUMBER	(15)	Yes
MASS_REVAL_ID	NUMBER	(15)	Yes
ASSET_ID	NUMBER	(15)	Yes
CATEGORY_ID	NUMBER	(15)	Yes
BOOK_TYPE_CODE	VARCHAR2	(15)	Yes
DISTRIBUTION_ID	NUMBER	(15)	Yes
CURRENT_MHC_PERIOD_COUNTER	NUMBER	(15)	Yes
PERIOD_COUNTER	NUMBER		Yes
REVAL_MODE	VARCHAR2	(30)
NUMBER_OF_UNITS_ASSIGNED	NUMBER	(15)
NUMBER_OF_UNITS_RETIRED	NUMBER	(15)
LIFE_CHANGE_COUNT	NUMBER	(15)
RUN_MODE	VARCHAR2	(1)
ACTIVE_FLAG	VARCHAR2	(1)	Yes
ASSET_COST	NUMBER
SALVAGE_VALUE	NUMBER
ACCUMULATED_DEPRECIATION	NUMBER
PRIOR_YRS_ACCUM_DEPRECIATION	NUMBER
YTD_DEPRECIATION_RESERVE	NUMBER
CURR_MHC_PRD_BACKLOG_DEPRN	NUMBER
ACCUMULATED_BACKLOG_DEPRN	NUMBER
NET_BOOK_VALUE	NUMBER
REVALUATION_RESERVE	NUMBER
DEPRECIATION_EXPENSE	NUMBER
CURR_YEAR_OPERATING_EXPENSE	NUMBER
CURR_YR_PRIOR_PRDS_DEPRN	NUMBER
CURR_YR_PRIOR_PRDS_DEPRN_REVAL	NUMBER
PRIOR_YEAR_OPERATING_EXPENSE	NUMBER
GENERAL_FUND	NUMBER
ACCUMULATED_GENERAL_FUND	NUMBER
PROCESS_STATUS_CODE	VARCHAR2	(1)
DEPRN_PROCESSED_FLAG	VARCHAR2	(240)
PRORATE_PERCENT	NUMBER
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_DATE	DATE
LAST_UPDATE_BY	NUMBER	(15)
LAST_UPDATE_LOGIN	NUMBER	(15)

Query Text

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


SELECT 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
,      PROCESS_STATUS_CODE
,      DEPRN_PROCESSED_FLAG
,      PRORATE_PERCENT
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_BY
,      LAST_UPDATE_LOGIN
FROM IGI.IGI_MHC_REVALUATION_DETAIL#;

Dependencies

[top of page]

IGI.IGI_MHC_REVALUATION_DETAIL# references the following:

IGI: IGI_MHC_REVALUATION_DETAIL

IGI.IGI_MHC_REVALUATION_DETAIL# is referenced by following:

APPS: IGI_MHC_REVALUATION_DETAIL