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

VIEW: APPS.OKX_ASST_DEP_METHODS_V

Object Details
Object Name: OKX_ASST_DEP_METHODS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKX.OKX_ASST_DEP_METHODS_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
ID1 NUMBER (15) Yes Primary key column. Unique identification number for a depreciation method
ID2 CHAR (1)
Primary key column
NAME VARCHAR2 (53)
Method code concatenated with life in months
DESCRIPTION VARCHAR2 (80)
Method description
METHOD_CODE VARCHAR2 (12) Yes Short name for the method
LIFE_IN_MONTHS NUMBER (4)
Life of an asset that uses this depreciation method. Used only for life-based depreciation methods
DEPRECIATE_LASTYEAR_FLAG VARCHAR2 (3) Yes Indicates whether the asset is to be depreciated in its last year of life
STL_METHOD_FLAG VARCHAR2 (3) Yes Indicates a straight line definition rule
RATE_SOURCE_RULE VARCHAR2 (10) Yes Indicates the depreciation rate source. Either CALCULATED, FLAT, PRODUCTION or TABLE
DEPRN_BASIS_RULE VARCHAR2 (4) Yes Indicates whether depreciation is based on cost or net book value
PRORATE_PERIODS_PER_YEAR NUMBER (3)
Number of prorate periods for table based methods
EXCLUDE_SALVAGE_VALUE_FLAG VARCHAR2 (3)
Indicates whether to exclude salvage value from the depreciable basis
DEPRN_BASIS_FORMULA VARCHAR2 (25)
Formula used to base depreciation basis
START_DATE_ACTIVE DATE

Effective from date
END_DATE_ACTIVE DATE

Effective to date
STATUS CHAR (1)
Indicates whether the depreciation method is active or inactive
PRIMARY_UOM_CODE VARCHAR2 (0)
Primary unit of measure code
Query Text

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


SELECT ID1
,      ID2
,      NAME
,      DESCRIPTION
,      METHOD_CODE
,      LIFE_IN_MONTHS
,      DEPRECIATE_LASTYEAR_FLAG
,      STL_METHOD_FLAG
,      RATE_SOURCE_RULE
,      DEPRN_BASIS_RULE
,      PRORATE_PERIODS_PER_YEAR
,      EXCLUDE_SALVAGE_VALUE_FLAG
,      DEPRN_BASIS_FORMULA
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      STATUS
,      PRIMARY_UOM_CODE
FROM APPS.OKX_ASST_DEP_METHODS_V;

Dependencies

[top of page]

APPS.OKX_ASST_DEP_METHODS_V references the following:

SchemaAPPS
SynonymFA_METHODS
APPS.OKX_ASST_DEP_METHODS_V is referenced by following:

SchemaAPPS
Package BodyOKL_ASD_PVT - show dependent code
Package BodyOKL_LA_STREAM_PVT - show dependent code
PL/SQL PackageOKL_LA_STREAM_PVT - show dependent code
Package BodyOKL_TAL_PVT - show dependent code