[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | OKL_CS_ASSET_LINES_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  OKL.OKL_CS_ASSET_LINES_V
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
View based on fixed asset line in Oracle Contracts for Lease 'LEASE' contracts. Fixed asset line in OKL points to a fixed asset(asset_id) in Oracle FA.Also this view shows asset for loan type of contracts.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | Primary key column. | ||
| ID2 | CHAR | (1) | # | |
| NAME | VARCHAR2 | (150) | Item Name | |
| DESCRIPTION | VARCHAR2 | (1995) | User entered description | |
| ITEM_DESCRIPTION | VARCHAR2 | (1995) | Item Description | |
| COMMENTS | VARCHAR2 | (1995) | User entered comments | |
| CHR_ID | NUMBER | ID of the contract to which this line belongs. The field will be have a value only for parent lines. | ||
| DNZ_CHR_ID | NUMBER | Contract ID. Denormalized for performance. | ||
| LTY_CODE | VARCHAR2 | (30) | Foreign key to FND_LOOKUP_VALUES. | |
| LSE_TYPE | VARCHAR2 | (10) | Line style type ID. | |
| LSE_PARENT_ID | NUMBER | Parent ID. | ||
| PARENT_LINE_ID | NUMBER | ID of the parent Line. A line can have sub-lines. | ||
| LINE_NUMBER | VARCHAR2 | (150) | Sequencial line number. | |
| DATE_TERMINATED | DATE | Date Terminated | ||
| START_DATE_ACTIVE | DATE | Start Date | ||
| END_DATE_ACTIVE | DATE | End Date | ||
| STATUS | VARCHAR2 | (1) | Status | |
| ASSET_ID | NUMBER | Asset_id | ||
| QUANTITY | NUMBER | Current Uints of asset | ||
| UNIT_OF_MEASURE_CODE | VARCHAR2 | (3) | Unit Of Measure | |
| ASSET_NUMBER | VARCHAR2 | (15) | Asset Number | |
| CORPORATE_BOOK | VARCHAR2 | (70) | Corporate Book | |
| LIFE_IN_MONTHS | NUMBER | Asset Life in months | ||
| ORIGINAL_COST | NUMBER | Original Cost | ||
| COST | NUMBER | Cost of asset | ||
| ADJUSTED_COST | NUMBER | Adjusted cost of asset | ||
| TAG_NUMBER | VARCHAR2 | (40) | Tag Number | |
| CURRENT_UNITS | NUMBER | Current Units of asset in fa | ||
| SERIAL_NUMBER | VARCHAR2 | (35) | Serial Number | |
| REVAL_CEILING | NUMBER | Reval Ceiling | ||
| NEW_USED | VARCHAR2 | (4) | New/Used Flag | |
| IN_SERVICE_DATE | DATE | In Service Date | ||
| MANUFACTURER_NAME | VARCHAR2 | (30) | Manufacturar Name | |
| MODEL_NUMBER | VARCHAR2 | (40) | Model Number | |
| ASSET_TYPE | VARCHAR2 | (11) | Asset Type | |
| SALVAGE_VALUE | NUMBER | Salvage value | ||
| PERCENT_SALVAGE_VALUE | NUMBER | Percentage Salvage value | ||
| DEPRECIATION_CATEGORY | NUMBER | (15) | Depreciation Category | |
| DEPRN_START_DATE | DATE | Depreciation Start Date | ||
| DEPRN_METHOD_CODE | VARCHAR2 | (12) | Depreciation Method | |
| RATE_ADJUSTMENT_FACTOR | NUMBER | Adjustment Factor | ||
| BASIC_RATE | NUMBER | Depreciation Rate | ||
| ADJUSTED_RATE | NUMBER | Adjusted Rate | ||
| RECOVERABLE_COST | NUMBER | Recoverable Cost | ||
| ORG_ID | NUMBER | Operating Unit identifier | ||
| SET_OF_BOOKS_ID | NUMBER | Accounting books defining column | ||
| PROPERTY_TYPE_CODE | VARCHAR2 | (10) | Property Type code | |
| PROPERTY_1245_1250_CODE | VARCHAR2 | (4) | Property 1245_1250 Code | |
| IN_USE_FLAG | VARCHAR2 | (3) | In Use Y/N | |
| OWNED_LEASED | VARCHAR2 | (15) | Owned/Leased | |
| INVENTORIAL | VARCHAR2 | (3) | Inventorial Y/N | |
| LINE_STATUS | VARCHAR2 | (30) | Line Status | |
| ASSET_STATUS | VARCHAR2 | (90) | Asset Status | |
| YEAR_BUILT | NUMBER | (4) | Year of Manufacture |
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
, ASSET_STATUS
, YEAR_BUILT
FROM APPS.OKL_CS_ASSET_LINES_V;
APPS
FA_ADDITIONS_B
FA_ADDITIONS_TL
FA_BOOKS
FA_BOOK_CONTROLS
OKC_K_HEADERS_B
OKC_K_ITEMS
OKC_K_LINES_B
OKC_K_LINES_TL
OKC_LINE_STYLES_B
OKC_STATUSES_V
OKL_K_HEADERS
OKL_K_LINES
OKL_TXL_ASSETS_B
APPS
OKL_CS_CONT_ASSETS_UV
OKL_CS_SERVICE_ASSETS_UV
|
|
|
|