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

VIEW: IGI.IGI_MHC_DEPRN_SUMMARY#

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

[View Source]

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

MHC_DEPRN_RESERVE NUMBER

MHC_COST NUMBER

MHC_SALVAGE_VALUE NUMBER

MHC_REVAL_RESERVE NUMBER

MHC_NET_BOOK_VALUE NUMBER

MHC_DEPRN_EXPENSE NUMBER

CURRENT_MHC_PRD_BACKLOG_DEPRN VARCHAR2 (240)
ACCUMULATED_BACKLOG_DEPRN VARCHAR2 (240)
MHC_CURR_YR_OP_EXPENSE NUMBER

MHC_CURR_YR_PPS_DEPRN NUMBER

MHC_CURR_YR_PPS_DEPRN_REVAL NUMBER

MHC_PRIOR_YR_OP_EXPENSE NUMBER

MHC_GENERAL_FUND NUMBER

ACCUMULATED_GENERAL_FUND NUMBER

CREATION_DATE VARCHAR2 (240)
CREATED_BY NUMBER
Yes
LAST_UPDATE_DATE VARCHAR2 (240)
LAST_UPDATED_LOGIN NUMBER

LAST_UPDATED_BY NUMBER

Query Text

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


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

Dependencies

[top of page]

IGI.IGI_MHC_DEPRN_SUMMARY# references the following:

SchemaIGI
TableIGI_MHC_DEPRN_SUMMARY
IGI.IGI_MHC_DEPRN_SUMMARY# is referenced by following:

SchemaAPPS
SynonymIGI_MHC_DEPRN_SUMMARY