[Home] [Help] [Dependency Information]
Object Name: | OKX_ASSET_LINES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKX.OKX_ASSET_LINES_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 | Yes | Primary key column. System generated unique identifier for fixed asset line | |
ID2 | CHAR | (1) | Primary key column | |
NAME | VARCHAR2 | (15) | Yes | User defined name of the Lease financial asset |
DESCRIPTION | VARCHAR2 | (80) | User defined description of the Lease financial asset | |
ITEM_DESCRIPTION | VARCHAR2 | (1995) | User defined item description of the Lease fianancial asset | |
COMMENTS | VARCHAR2 | (1995) | Comments | |
CHR_ID | NUMBER | System generated unique identifier for the contract | ||
DNZ_CHR_ID | NUMBER | Yes | System generated denormalized unique identifier for the contract | |
LTY_CODE | VARCHAR2 | (30) | Yes | Line type code |
LSE_TYPE | VARCHAR2 | (10) | Yes | Indicates whetehr thecontract line is a top line or sub line |
LSE_PARENT_ID | NUMBER | System generated parent line style identifier | ||
PARENT_LINE_ID | NUMBER | System generated unique identifier for the parent line | ||
LINE_NUMBER | VARCHAR2 | (150) | Yes | Asset line number |
DATE_TERMINATED | DATE | Date on which asset line was terminated | ||
START_DATE_ACTIVE | DATE | Effective from date | ||
END_DATE_ACTIVE | DATE | Effective to date | ||
STATUS | VARCHAR2 | (1) | Indiactes where the asset line is active or inactive | |
ASSET_ID | NUMBER | (15) | Yes | Unique identifier for fixed asset |
QUANTITY | NUMBER | Yes | Quantity of te asset | |
UNIT_OF_MEASURE_CODE | VARCHAR2 | (3) | Unis of measure code | |
ASSET_NUMBER | VARCHAR2 | (15) | Yes | User assigned number of the asset |
CORPORATE_BOOK | VARCHAR2 | (15) | Yes | Corporate book for the asset |
LIFE_IN_MONTHS | NUMBER | (4) | Life of the asset in complete months | |
ORIGINAL_COST | NUMBER | (14) | 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 units of the assets | |
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 | (30) | Manufacturer name | |
MODEL_NUMBER | VARCHAR2 | (40) | Model number of the asset | |
ASSET_TYPE | VARCHAR2 | (11) | Yes | Indicates whether the asset is CIP, capitalized or expensed |
SALVAGE_VALUE | NUMBER | Yes | Salvage value of the asset | |
PERCENT_SALVAGE_VALUE | NUMBER | Percentage salvage value | ||
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 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 amount for flat-rate methods | ||
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 property type | |
PROPERTY_1245_1250_CODE | VARCHAR2 | (4) | Indicate whether property class is 1245 (personal) or 1250 (real) | |
IN_USE_FLAG | VARCHAR2 | (3) | Yes | Indicates whether the asset is in use or not |
OWNED_LEASED | VARCHAR2 | (15) | Yes | Indicates whether the asset is owned or leased |
INVENTORIAL | VARCHAR2 | (3) | Indicates whether the asset should be included in physical inventory | |
LINE_STATUS | VARCHAR2 | (30) | Yes | Status of the fixed asset line |
YEAR_BUILT | NUMBER | (4) | Year of manufacture or construction of the asset |
Cut, paste (and edit) the following text to query this object:
SELECT ID1
, ID2
, NAME
, DESCRIPTION
, ITEM_DESCRIPTION
, COMMENTS
, CHR_ID
, DNZ_CHR_ID
, LTY_CODE
, LSE_TYPE
, LSE_PARENT_ID
, PARENT_LINE_ID
, LINE_NUMBER
, DATE_TERMINATED
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, STATUS
, ASSET_ID
, QUANTITY
, UNIT_OF_MEASURE_CODE
, 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
, RECOVERABLE_COST
, ORG_ID
, SET_OF_BOOKS_ID
, PROPERTY_TYPE_CODE
, PROPERTY_1245_1250_CODE
, IN_USE_FLAG
, OWNED_LEASED
, INVENTORIAL
, LINE_STATUS
, YEAR_BUILT
FROM APPS.OKX_ASSET_LINES_V;
|
|
|