[Home] [Help] [Dependency Information]
Object Name: | IGI_IAC_ADJUSTMENTS_HISTORY |
---|---|
Object Type: | TABLE |
Owner: | IGI |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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 | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
CREATED_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
ADJUSTMENT_REVAL_TYPE | VARCHAR2 | (1) |
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;
IGI.IGI_IAC_ADJUSTMENTS_HISTORY does not reference any database object
IGI.IGI_IAC_ADJUSTMENTS_HISTORY is referenced by following:
|
|
|