[Home] [Help] [Dependency Information]
Object Name: | JL_MX_FA_ISR_IMPAC# |
---|---|
Object Type: | VIEW |
Owner: | JL |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PROCESS_ID | NUMBER | (15) | ||
ASSET_CATEGORY_ID | NUMBER | (15) | Yes | |
ASSET_ID | NUMBER | (15) | Yes | |
ASSET_NUMBER | VARCHAR2 | (30) | ||
INPC | NUMBER | |||
ORIGINAL_COST | NUMBER | |||
ACCUM_DEPRN_PREVIOUS_FY | NUMBER | |||
ADJUSTED_DEPRN_CURRENT_FY | NUMBER | |||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | |||
CREATED_BY | NUMBER | (15) | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
TRANSACTION_HEADER_ID_IN | NUMBER | (15) | Yes | |
TRANSACTION_HEADER_ID_OUT | NUMBER | (15) | ||
DESCRIPTION | VARCHAR2 | (80) | Yes | |
DATE_PLACED_IN_SERVICE | DATE | Yes | ||
PRORATE_DATE | DATE | Yes | ||
RETIREMENT_ID | NUMBER | (15) | ||
PERIOD_COUNTER_FULLY_RESERVED | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT PROCESS_ID
, ASSET_CATEGORY_ID
, ASSET_ID
, ASSET_NUMBER
, INPC
, ORIGINAL_COST
, ACCUM_DEPRN_PREVIOUS_FY
, ADJUSTED_DEPRN_CURRENT_FY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, TRANSACTION_HEADER_ID_IN
, TRANSACTION_HEADER_ID_OUT
, DESCRIPTION
, DATE_PLACED_IN_SERVICE
, PRORATE_DATE
, RETIREMENT_ID
, PERIOD_COUNTER_FULLY_RESERVED
FROM JL.JL_MX_FA_ISR_IMPAC#;
|
|
|