[Home] [Help] [Dependency Information]
Object Name: | FA_LIFE_DERIVATION_INFO |
---|---|
Object Type: | TABLE |
Owner: | FA |
FND Design Data: | OFA.FA_LIFE_DERIVATION_INFO |
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: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FA_LIFE_DERIVATION_INFO_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
ASSET_ID
BOOK_TYPE_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRANSACTION_HEADER_ID | NUMBER | Yes | Id of the Transaction from the FA_TRANSACTION_HEADER table | |
ASSET_ID | NUMBER | Yes | Unique identifier of an asset | |
BOOK_TYPE_CODE | VARCHAR2 | (15) | Yes | Name of the Book to which the asset is assigned |
DERIVED_FROM_ENTITY_ID | NUMBER | Identifier of the entity the new asset attribute is derived from | ||
DERIVED_FROM_ENTITY | VARCHAR2 | (30) | Name of the Entity from where life is derived. The type of entity the new asset attribute is derived from :NODE- NodeNODE-P - Precedence Level NodeASSET- AssetLEASE- LeaseCATEGORY-LED-Category Life End DateCATEGORY-LIFE - Category Life |
Cut, paste (and edit) the following text to query this object:
SELECT TRANSACTION_HEADER_ID
, ASSET_ID
, BOOK_TYPE_CODE
, DERIVED_FROM_ENTITY_ID
, DERIVED_FROM_ENTITY
FROM FA.FA_LIFE_DERIVATION_INFO;
FA.FA_LIFE_DERIVATION_INFO does not reference any database object
FA.FA_LIFE_DERIVATION_INFO is referenced by following:
|
|
|