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

VIEW: APPS.OKL_AM_ASST_DEP_METHODS_UV

Object Details
Object Name: OKL_AM_ASST_DEP_METHODS_UV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_AM_ASST_DEP_METHODS_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
ID1 NUMBER (15) Yes ID1
ID2 CHAR (1)
ID2
NAME VARCHAR2 (53)
Depreciation Method Name
DESCRIPTION VARCHAR2 (80)
Depreciation Method Description
METHOD_CODE VARCHAR2 (12) Yes Depreciation Method Code
LIFE_IN_MONTHS NUMBER (4)
Life in Months
DEPRECIATE_LASTYEAR_FLAG VARCHAR2 (3) Yes Depreciate Last Year Flag
STL_METHOD_FLAG VARCHAR2 (3) Yes STL Method Flag
RATE_SOURCE_RULE VARCHAR2 (10) Yes Rate Source Rule
DEPRN_BASIS_RULE VARCHAR2 (4) Yes Depreciation Basis Rule
PRORATE_PERIODS_PER_YEAR NUMBER (3)
Prorate Periods Per Year
EXCLUDE_SALVAGE_VALUE_FLAG VARCHAR2 (3)
Exclude Salvage Value Flag
DEPRN_BASIS_FORMULA VARCHAR2 (25)
Depreciation Basis Formula
START_DATE_ACTIVE DATE

Start Date
END_DATE_ACTIVE DATE

End Date
STATUS CHAR (1)
Status
PRIMARY_UOM_CODE VARCHAR2 (0)
Primary UOM code
DEPRN_RATE NUMBER

Depreciation Rate
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
,      DEPRN_RATE
FROM APPS.OKL_AM_ASST_DEP_METHODS_UV;

Dependencies

[top of page]

APPS.OKL_AM_ASST_DEP_METHODS_UV references the following:

SchemaAPPS
SynonymFA_FLAT_RATES
SynonymFA_METHODS
APPS.OKL_AM_ASST_DEP_METHODS_UV is referenced by following:

SchemaAPPS
Package BodyOKL_AMH_PVT - show dependent code