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_GEN_INTERFACE#

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory
INTERFACE_SEQ_ID	NUMBER	(15)	Yes
LATEST_MASS_REVAL_ID	NUMBER	(15)	Yes
LATEST_TXN_HEADER_ID	NUMBER	(15)	Yes
LAST_DEPRN_PERIOD_COUNTER	NUMBER	(15)	Yes
ASSET_ID	NUMBER	(15)	Yes
DISTRIBUTION_ID	NUMBER	(15)	Yes
CATEGORY_ID	NUMBER	(15)	Yes
BOOK_TYPE_CODE	VARCHAR2	(15)	Yes
CURRENT_MHC_PERIOD_COUNTER	NUMBER	(15)	Yes
PERIOD_COUNTER	NUMBER		Yes
TRANSFER_DATA_FLAG	VARCHAR2	(1)	Yes
UPGRADE_DATA_FLAG	VARCHAR2	(1)	Yes
PURGE_DATA_FLAG	VARCHAR2	(1)	Yes
NUMBER_OF_UNITS_ASSIGNED	NUMBER	(15)
NUMBER_OF_UNITS_RETIRED	NUMBER	(15)
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
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)
LAST_TXN_TYPE	VARCHAR2	(30)
GENERATE_SEQ_ID_IMPORT	NUMBER	(15)

Query Text

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


SELECT INTERFACE_SEQ_ID
,      LATEST_MASS_REVAL_ID
,      LATEST_TXN_HEADER_ID
,      LAST_DEPRN_PERIOD_COUNTER
,      ASSET_ID
,      DISTRIBUTION_ID
,      CATEGORY_ID
,      BOOK_TYPE_CODE
,      CURRENT_MHC_PERIOD_COUNTER
,      PERIOD_COUNTER
,      TRANSFER_DATA_FLAG
,      UPGRADE_DATA_FLAG
,      PURGE_DATA_FLAG
,      NUMBER_OF_UNITS_ASSIGNED
,      NUMBER_OF_UNITS_RETIRED
,      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
,      LAST_TXN_TYPE
,      GENERATE_SEQ_ID_IMPORT
FROM IGI.IGI_MHC_GEN_INTERFACE#;

Dependencies

[top of page]

IGI.IGI_MHC_GEN_INTERFACE# references the following:

IGI: IGI_MHC_GEN_INTERFACE

IGI.IGI_MHC_GEN_INTERFACE# is referenced by following:

APPS: IGI_MHC_GEN_INTERFACE