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

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory
BOOK_TYPE_CODE	VARCHAR2	(15)
ASSET_ID	NUMBER	(15)
CATEGORY_ID	NUMBER	(15)
DATE_PLACED_IN_SERVICE	DATE
PERIOD_COUNTER	NUMBER	(15)
TRANSACTION_TYPE_CODE	VARCHAR2	(20)
TRANSACTION_SUBTYPE	VARCHAR2	(240)
CURRENT_PERIOD_AMORTIZATION	VARCHAR2	(240)
AMORTIZATION_START_DATE	DATE
TRANSACTION_HEADER_ID_IN	VARCHAR2	(15)
TRANSACTION_HEADER_ID_OUT	VARCHAR2	(15)
PRE_LIFE_IN_MONTHS	VARCHAR2	(4)
PRE_RATE_ADJUSTMENT_FACTOR	NUMBER
PRE_ADJUSTED_COST	NUMBER
PRE_SALVAGE_VALUE	NUMBER
LIFE_IN_MONTHS	NUMBER	(4)
RATE_ADJUSTMENT_FACTOR	NUMBER
ADJUSTED_COST	NUMBER
SALVAGE_VALUE	NUMBER
ADJUSTMENT_ID	NUMBER	(15)
ACTIVE_FLAG	VARCHAR2	(1)
CREATED_BY	NUMBER	(15)	Yes
CREATED_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
ADJUSTMENT_REVAL_TYPE	VARCHAR2	(1)

Query Text

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


SELECT BOOK_TYPE_CODE
,      ASSET_ID
,      CATEGORY_ID
,      DATE_PLACED_IN_SERVICE
,      PERIOD_COUNTER
,      TRANSACTION_TYPE_CODE
,      TRANSACTION_SUBTYPE
,      CURRENT_PERIOD_AMORTIZATION
,      AMORTIZATION_START_DATE
,      TRANSACTION_HEADER_ID_IN
,      TRANSACTION_HEADER_ID_OUT
,      PRE_LIFE_IN_MONTHS
,      PRE_RATE_ADJUSTMENT_FACTOR
,      PRE_ADJUSTED_COST
,      PRE_SALVAGE_VALUE
,      LIFE_IN_MONTHS
,      RATE_ADJUSTMENT_FACTOR
,      ADJUSTED_COST
,      SALVAGE_VALUE
,      ADJUSTMENT_ID
,      ACTIVE_FLAG
,      CREATED_BY
,      CREATED_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      ADJUSTMENT_REVAL_TYPE
FROM IGI.IGI_IAC_ADJUSTMENTS_HISTORY#;

Dependencies

[top of page]

IGI.IGI_IAC_ADJUSTMENTS_HISTORY# references the following:

IGI: IGI_IAC_ADJUSTMENTS_HISTORY

IGI.IGI_IAC_ADJUSTMENTS_HISTORY# is referenced by following:

APPS: IGI_IAC_ADJUSTMENTS_HISTORY