DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.OKL_LA_BOOK_DEPRN_UV

Object Details
Object Name: OKL_LA_BOOK_DEPRN_UV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_LA_BOOK_DEPRN_UV
Subobject Name:
Status: VALID

View Type

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.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ID NUMBER
Yes Unique identifier
KLE_ID NUMBER

Asset line identifier
DNZ_KHR_ID NUMBER

Contract identifier
ASSET_NUMBER VARCHAR2 (15) Yes Asset Number
DESCRIPTION VARCHAR2 (1995)
Asset Description
CORPORATE_BOOK VARCHAR2 (70)
Corporate book
IN_SERVICE_DATE DATE

In service date
LIFE_IN_MONTHS VARCHAR2 (40)
Life in months
CATEGORY_ID VARCHAR2 (40)
Depreciation category identifier
CATEGORY_NAME VARCHAR2 (216)
Depreciation category name
DEPRECIATION_COST VARCHAR2 (40)
Depreciation cost
DEPRN_METHOD VARCHAR2 (12)
Depreciation method
DEPRN_RATE VARCHAR2 (40)
Depreciation rate
SALVAGE_VALUE VARCHAR2 (40)
Salvage value
PERCENT_SALVAGE_VALUE VARCHAR2 (40)
Percentage salvage value
FA_COST VARCHAR2 (40)
Fixed asset depreciation cost
ORIG_SYSTEM_ID1 VARCHAR2 (40)
Original line identifier
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ID
,      KLE_ID
,      DNZ_KHR_ID
,      ASSET_NUMBER
,      DESCRIPTION
,      CORPORATE_BOOK
,      IN_SERVICE_DATE
,      LIFE_IN_MONTHS
,      CATEGORY_ID
,      CATEGORY_NAME
,      DEPRECIATION_COST
,      DEPRN_METHOD
,      DEPRN_RATE
,      SALVAGE_VALUE
,      PERCENT_SALVAGE_VALUE
,      FA_COST
,      ORIG_SYSTEM_ID1
FROM APPS.OKL_LA_BOOK_DEPRN_UV;

Dependencies

[top of page]

APPS.OKL_LA_BOOK_DEPRN_UV references the following:

SchemaAPPS
SynonymOKC_K_LINES_B
SynonymOKC_K_LINES_TL
SynonymOKL_TXL_ASSETS_B
ViewOKX_ASST_CATGRS_V

APPS.OKL_LA_BOOK_DEPRN_UV is not referenced by any database object