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

VIEW: APPS.OKX_AST_CT_BK_DFS_V

Object Details
Object Name: OKX_AST_CT_BK_DFS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKX.OKX_AST_CT_BK_DFS_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. Identifier for asset category
ID2 VARCHAR2 (36)
Primary key column. Book name concatenated with date placed in service.
NAME CHAR (1)
Not used
DESCRIPTION CHAR (1)
Not used
CATEGORY_ID NUMBER (15) Yes Identifier for asset category
BOOK_TYPE_CODE VARCHAR2 (15) Yes Book name
START_DPIS DATE
Yes First date placed in service to which this set of default depreciation rules apply
END_DPIS DATE

Last date placed in service to which this set of default depreciation rules apply
LIFE_IN_MONTHS NUMBER (4)
Life of an asset in this asset category and book
DEPRN_METHOD VARCHAR2 (12) Yes Depreciation method used by this asset category and book
PRORATE_CONVENTION_CODE VARCHAR2 (10) Yes Depreciation prorate convention used by assets in this category and book
ITC_ELIGIBLE_FLAG VARCHAR2 (3) Yes Indicates whether the assets in this book and category are eligible for ITC
USE_ITC_CEILINGS_FLAG VARCHAR2 (3) Yes Indicates whetehr ITC ceilings are used by assets in this category and book
CEILING_NAME VARCHAR2 (30)
Name of the depreciation ceiling used
BASIC_RATE NUMBER

Basic depreciation rates used for flat-rate methods
ADJUSTED_RATE NUMBER

Basic depreciation rates used for flat-rate methods
BONUS_RULE VARCHAR2 (30)
Bonus depreciation rule for flat rate methods
DEPRECIATE_FLAG VARCHAR2 (3) Yes Indicates whether assets in this category are depreciating or non depreciating assets
RETIREMENT_PRORATE_CONVENTION VARCHAR2 (10) Yes Retirement prorate convention used by assets in this category and book
PRICE_INDEX_NAME VARCHAR2 (40)
Name of the price index
USE_STL_RETIREMENTS_FLAG VARCHAR2 (3) Yes Indicates whetehr a straightline retirement convention is used
STL_METHOD_CODE VARCHAR2 (12)
Straightline method code used for special tax retirements
STL_LIFE_IN_MONTHS NUMBER (4)
Life of an asset for use with straight line method for special tax retirements
SUBCOMPONENT_LIFE_RULE VARCHAR2 (13)
Rule by which to defualt the life of subcomponents in this category
MINIMUM_LIFE_IN_MONTHS NUMBER (4)
Minimum life for subcomponents
PRODUCTION_CAPACITY NUMBER

Capacity for a units of production asset
UNIT_OF_MEASURE VARCHAR2 (25)
Unit of measure for a units of production asset
CAPITAL_GAIN_THRESHOLD NUMBER

Minimum time to hold an asset for Oracle Assets to report is as a capital gain on the form 4797 reports when you retire it
USE_DEPRN_LIMITS_FLAG VARCHAR2 (3)
Indicates whether to use depreciation limit for the book
ALLOWED_DEPRN_LIMIT NUMBER

Default depreciation limit as a percent of cost
SPECIAL_DEPRN_LIMIT_AMOUNT NUMBER

Default depreciation limit as a flat amount, subtracted from the cost
PERCENT_SALVAGE_VALUE NUMBER

Default salvage value percentage
CUA_LIFE_END_DATE DATE

Not used
CUA_RULE_SET_ID NUMBER

Not used
Query Text

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


SELECT ID1
,      ID2
,      NAME
,      DESCRIPTION
,      CATEGORY_ID
,      BOOK_TYPE_CODE
,      START_DPIS
,      END_DPIS
,      LIFE_IN_MONTHS
,      DEPRN_METHOD
,      PRORATE_CONVENTION_CODE
,      ITC_ELIGIBLE_FLAG
,      USE_ITC_CEILINGS_FLAG
,      CEILING_NAME
,      BASIC_RATE
,      ADJUSTED_RATE
,      BONUS_RULE
,      DEPRECIATE_FLAG
,      RETIREMENT_PRORATE_CONVENTION
,      PRICE_INDEX_NAME
,      USE_STL_RETIREMENTS_FLAG
,      STL_METHOD_CODE
,      STL_LIFE_IN_MONTHS
,      SUBCOMPONENT_LIFE_RULE
,      MINIMUM_LIFE_IN_MONTHS
,      PRODUCTION_CAPACITY
,      UNIT_OF_MEASURE
,      CAPITAL_GAIN_THRESHOLD
,      USE_DEPRN_LIMITS_FLAG
,      ALLOWED_DEPRN_LIMIT
,      SPECIAL_DEPRN_LIMIT_AMOUNT
,      PERCENT_SALVAGE_VALUE
,      CUA_LIFE_END_DATE
,      CUA_RULE_SET_ID
FROM APPS.OKX_AST_CT_BK_DFS_V;

Dependencies

[top of page]

APPS.OKX_AST_CT_BK_DFS_V references the following:

SchemaAPPS
SynonymFA_CATEGORY_BOOK_DEFAULTS
APPS.OKX_AST_CT_BK_DFS_V is referenced by following:

SchemaAPPS
PL/SQL PackageOKL_ACTIVATE_ASSET_PVT - show dependent code
Package BodyOKL_LA_STREAM_PVT - show dependent code
PL/SQL PackageOKL_LA_STREAM_PVT - show dependent code