[Home] [Help] [Dependency Information]
Object Name: | OKX_ASSETS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKX.OKX_ASSETS_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID1 | NUMBER | (15) | Yes | Primary Key column System generated asset identification number |
ID2 | CHAR | (1) | Primary key column | |
NAME | VARCHAR2 | (15) | Yes | User defined asset number |
DESCRIPTION | VARCHAR2 | (80) | User defined asset description | |
ASSET_ID | NUMBER | (15) | Yes | Asset identification number |
ASSET_NUMBER | VARCHAR2 | (15) | Yes | User defined asset number |
CORPORATE_BOOK | VARCHAR2 | (15) | Yes | Corporate book code for the asset |
LIFE_IN_MONTHS | NUMBER | (4) | Total life of the asset in months | |
ORIGINAL_COST | NUMBER | Yes | Original cost of the asset | |
COST | NUMBER | Yes | Current cost of the asset | |
ADJUSTED_COST | NUMBER | Yes | Recoverable cost less depreciation reserve. Reset when you perform an amortized adjustment or revaluation | |
TAG_NUMBER | VARCHAR2 | (15) | Tag number of the asset | |
CURRENT_UNITS | NUMBER | Yes | Current number of units for the asset | |
SERIAL_NUMBER | VARCHAR2 | (35) | Serial number of the asset | |
REVAL_CEILING | NUMBER | Upper limit for revaluing asset cost | ||
NEW_USED | VARCHAR2 | (4) | Yes | Indicates whether the asset is new or used |
IN_SERVICE_DATE | DATE | Yes | Date the asset was placed in service | |
MANUFACTURER_NAME | VARCHAR2 | (360) | Name of the manufacturer | |
MODEL_NUMBER | VARCHAR2 | (40) | Model number of asset | |
ASSET_TYPE | VARCHAR2 | (11) | Yes | Indicates whether the asset is CIP, capitalized or expensed |
SALVAGE_VALUE | NUMBER | Yes | Asset salvage value | |
PERCENT_SALVAGE_VALUE | NUMBER | Salvage value percentage amount | ||
DEPRECIATION_CATEGORY | NUMBER | (15) | Yes | Unique identifier for asset category |
DEPRN_START_DATE | DATE | Yes | Date the asset started to depreciate | |
DEPRN_METHOD_CODE | VARCHAR2 | (12) | Yes | Name of the depreciation method for the asset |
RATE_ADJUSTMENT_FACTOR | NUMBER | Yes | Percent of remaining depreciation after a revaluation or an amortized change, or 1 | |
BASIC_RATE | NUMBER | Base rate used to calculate depreciation amount for flat-rate methods | ||
ADJUSTED_RATE | NUMBER | Actual rate used to calculate depreciation for flat-rate methods | ||
START_DATE_ACTIVE | DATE | Yes | Effective from date | |
END_DATE_ACTIVE | DATE | Effective to date | ||
STATUS | VARCHAR2 | (2) | Indicates whether current record is active or inactive | |
PRIMARY_UOM_CODE | VARCHAR2 | (0) | Primary unit of measure code | |
RECOVERABLE_COST | NUMBER | Yes | Cost minus salvage value or depreciation ceiling, whichever is lower | |
ORG_ID | NUMBER | (15) | Unique identifier for operating unit | |
SET_OF_BOOKS_ID | NUMBER | (15) | Yes | Unique identifier for accounting set of books |
PROPERTY_TYPE_CODE | VARCHAR2 | (10) | Indicates the property type | |
PROPERTY_1245_1250_CODE | VARCHAR2 | (4) | Indicates whether property class is 1245(personal) or 1250(real) | |
IN_USE_FLAG | VARCHAR2 | (3) | Yes | Indicates whether the asset is in use |
OWNED_LEASED | VARCHAR2 | (15) | Yes | Indicates whether asset is owned or leased |
INVENTORIAL | VARCHAR2 | (3) | Indicates whether the asset should be included in physical inventory |
Cut, paste (and edit) the following text to query this object:
SELECT ID1
, ID2
, NAME
, DESCRIPTION
, ASSET_ID
, ASSET_NUMBER
, CORPORATE_BOOK
, LIFE_IN_MONTHS
, ORIGINAL_COST
, COST
, ADJUSTED_COST
, TAG_NUMBER
, CURRENT_UNITS
, SERIAL_NUMBER
, REVAL_CEILING
, NEW_USED
, IN_SERVICE_DATE
, MANUFACTURER_NAME
, MODEL_NUMBER
, ASSET_TYPE
, SALVAGE_VALUE
, PERCENT_SALVAGE_VALUE
, DEPRECIATION_CATEGORY
, DEPRN_START_DATE
, DEPRN_METHOD_CODE
, RATE_ADJUSTMENT_FACTOR
, BASIC_RATE
, ADJUSTED_RATE
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, STATUS
, PRIMARY_UOM_CODE
, RECOVERABLE_COST
, ORG_ID
, SET_OF_BOOKS_ID
, PROPERTY_TYPE_CODE
, PROPERTY_1245_1250_CODE
, IN_USE_FLAG
, OWNED_LEASED
, INVENTORIAL
FROM APPS.OKX_ASSETS_V;
|
|
|