[Home] [Help] [Dependency Information]
Object Name: | OKL_SPLIT_ASSET_TRX_UV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKL.OKL_SPLIT_ASSET_TRX_UV |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | Split asset transaction identifier | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Not used in this view |
SFWT_FLAG | VARCHAR2 | (3) | Yes | Not used |
TAL_ID | NUMBER | Yes | Transaction line identifier | |
TARGET_KLE_ID | NUMBER | Resulting new fixed asset line identifier after split asset process | ||
LINE_DETAIL_NUMBER | NUMBER | Running line number | ||
ASSET_NUMBER | VARCHAR2 | (15) | Yes | New asset number |
DESCRIPTION | VARCHAR2 | (1995) | New asset description | |
QUANTITY | NUMBER | New asset quantity | ||
COST | NUMBER | New asset cost | ||
TAX_BOOK | VARCHAR2 | (15) | Not used | |
LIFE_IN_MONTHS_TAX | NUMBER | (15) | Not used | |
DEPRN_METHOD_TAX | VARCHAR2 | (12) | Not used | |
DEPRN_RATE_TAX | NUMBER | Not used | ||
SALVAGE_VALUE | NUMBER | (15) | Salvage value of new asset | |
SPLIT_PERCENT | NUMBER | Split percentage on which split will be done | ||
INVENTORY_ITEM_ID | NUMBER | Inventory item identifier of the new asset being created | ||
CURRENCY_CODE | VARCHAR2 | (15) | Currency code | |
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | Currency conversion type | |
CURRENCY_CONVERSION_RATE | NUMBER | Currency conversion rate | ||
CURRENCY_CONVERSION_DATE | DATE | Currency conversion date | ||
SERIAL_NUMBER_CONTROL_CODE | NUMBER | Serial Number Control Code |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, OBJECT_VERSION_NUMBER
, SFWT_FLAG
, TAL_ID
, TARGET_KLE_ID
, LINE_DETAIL_NUMBER
, ASSET_NUMBER
, DESCRIPTION
, QUANTITY
, COST
, TAX_BOOK
, LIFE_IN_MONTHS_TAX
, DEPRN_METHOD_TAX
, DEPRN_RATE_TAX
, SALVAGE_VALUE
, SPLIT_PERCENT
, INVENTORY_ITEM_ID
, CURRENCY_CODE
, CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_RATE
, CURRENCY_CONVERSION_DATE
, SERIAL_NUMBER_CONTROL_CODE
FROM APPS.OKL_SPLIT_ASSET_TRX_UV;
APPS.OKL_SPLIT_ASSET_TRX_UV is not referenced by any database object
|
|
|