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

VIEW: IGI.IGI_MHC_DEPRN_DETAIL#

Object Details
Object Name: IGI_MHC_DEPRN_DETAIL#
Object Type: VIEW
Owner: IGI
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
FA_DEPRN_DTL_ROWID ROWID (10) Yes
BOOK_TYPE_CODE VARCHAR2 (15) Yes
ASSET_ID NUMBER (15) Yes
CURRENT_MHC_PERIOD_COUNTER NUMBER (15) Yes
PERIOD_COUNTER NUMBER (15) Yes
DISTRIBUTION_ID NUMBER (15) Yes
MHC_YTD_DEPRN NUMBER

MHC_DEPRN_RESERVE NUMBER

MHC_COST NUMBER

MHC_SALVAGE_VALUE NUMBER

MHC_REVAL_RESERVE NUMBER

CURRENT_MHC_PRD_BACKLOG_DEPRN NUMBER

ACCUMULATED_BACKLOG_DEPRN NUMBER

MHC_NET_BOOK_VALUE NUMBER

MHC_DEPRN_EXPENSE NUMBER

MHC_CURR_YR_PPS_DEPRN NUMBER

MHC_CURR_YR_PPS_DEPRN_REVAL NUMBER

MHC_PRIOR_YR_OP_EXPENSE NUMBER

MHC_CURR_YR_OP_EXPENSE NUMBER

MHC_GENERAL_FUND NUMBER

ACCUMULATED_GENERAL_FUND NUMBER

CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER

LAST_UPDATE_LOGIN NUMBER

Query Text

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


SELECT FA_DEPRN_DTL_ROWID
,      BOOK_TYPE_CODE
,      ASSET_ID
,      CURRENT_MHC_PERIOD_COUNTER
,      PERIOD_COUNTER
,      DISTRIBUTION_ID
,      MHC_YTD_DEPRN
,      MHC_DEPRN_RESERVE
,      MHC_COST
,      MHC_SALVAGE_VALUE
,      MHC_REVAL_RESERVE
,      CURRENT_MHC_PRD_BACKLOG_DEPRN
,      ACCUMULATED_BACKLOG_DEPRN
,      MHC_NET_BOOK_VALUE
,      MHC_DEPRN_EXPENSE
,      MHC_CURR_YR_PPS_DEPRN
,      MHC_CURR_YR_PPS_DEPRN_REVAL
,      MHC_PRIOR_YR_OP_EXPENSE
,      MHC_CURR_YR_OP_EXPENSE
,      MHC_GENERAL_FUND
,      ACCUMULATED_GENERAL_FUND
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM IGI.IGI_MHC_DEPRN_DETAIL#;

Dependencies

[top of page]

IGI.IGI_MHC_DEPRN_DETAIL# references the following:

SchemaIGI
TableIGI_MHC_DEPRN_DETAIL
IGI.IGI_MHC_DEPRN_DETAIL# is referenced by following:

SchemaAPPS
SynonymIGI_MHC_DEPRN_DETAIL