[Home] [Help] [Dependency Information]
Object Name: | IGI_MHC_DEPRN_DETAIL# |
---|---|
Object Type: | VIEW |
Owner: | IGI |
Subobject Name: | |
Status: | VALID |
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 |
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#;
|
|
|