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

VIEW: APPS.OKX_AST_CAT_BKS_V

Object Details
Object Name: OKX_AST_CAT_BKS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKX.OKX_AST_CAT_BKS_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 Identifier for the asset category
ID2 VARCHAR2 (15) Yes Primary key column. Book name
NAME VARCHAR2 (216)
Concatenated segments of asset category flexfield
DESCRIPTION CHAR (1)
Not used
CATEGORY_ID NUMBER (15) Yes Identifies the asset category
BOOK_TYPE_CODE VARCHAR2 (15) Yes Book name
ASSET_CLEARING_ACCT VARCHAR2 (25) Yes Clearing account segment for capitalized asset
ASSET_COST_ACCT VARCHAR2 (25) Yes Cost account segment for capitalized assets
CIP_CLEARING_ACCT VARCHAR2 (25)
Clearing account segment for CIP assets
CIP_COST_ACCT VARCHAR2 (25)
Cost account segment for CIP assets
DEPRN_EXPENSE_ACCT VARCHAR2 (25) Yes Expense account segment for depreciation
DEPRN_RESERVE_ACCT VARCHAR2 (25) Yes Reserve account segment for depreciation
REVAL_AMORTIZATION_ACCT VARCHAR2 (25)
Account segment for revaluation reserve amortization
REVAL_RESERVE_ACCT VARCHAR2 (25)
Account segment for revaluation reserve
ASSET_COST_ACCOUNT_CCID NUMBER (15) Yes Cost account ccid
ASSET_CLEARING_ACCOUNT_CCID NUMBER (15) Yes Clearing account ccid
WIP_COST_ACCOUNT_CCID NUMBER (15)
CIP cost account ccid
WIP_CLEARING_ACCOUNT_CCID NUMBER (15)
CIP clearing account ccid
RESERVE_ACCOUNT_CCID NUMBER (15) Yes Accumulated depreciation ccid
REVAL_AMORT_ACCOUNT_CCID NUMBER (15)
Revaluation reserve account ccid
REVAL_RESERVE_ACCOUNT_CCID NUMBER (15)
Revaluation reserve account segment
PERCENT_SALVAGE_VALUE NUMBER

Not used
LIFE_EXTENSION_CEILING NUMBER

Life extension ceiling
LIFE_EXTENSION_FACTOR NUMBER

Life extension factor
DEFAULT_GROUP_ASSET_ID NUMBER (15)
Default group asset id
BONUS_DEPRN_EXPENSE_ACCT VARCHAR2 (25)
Expense account segment column for bonus depreciation
BONUS_DEPRN_RESERVE_ACCT VARCHAR2 (25)
Reserve account segment column for bonus depreciation
BONUS_RESERVE_ACCT_CCID NUMBER

Accumulated bonus depreciation ccid
START_DATE_ACTIVE DATE

Effective from date
END_DATE_ACTIVE DATE

Effective to date
STATUS VARCHAR2 (1)
Indicates whether the record is active of 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
,      CATEGORY_ID
,      BOOK_TYPE_CODE
,      ASSET_CLEARING_ACCT
,      ASSET_COST_ACCT
,      CIP_CLEARING_ACCT
,      CIP_COST_ACCT
,      DEPRN_EXPENSE_ACCT
,      DEPRN_RESERVE_ACCT
,      REVAL_AMORTIZATION_ACCT
,      REVAL_RESERVE_ACCT
,      ASSET_COST_ACCOUNT_CCID
,      ASSET_CLEARING_ACCOUNT_CCID
,      WIP_COST_ACCOUNT_CCID
,      WIP_CLEARING_ACCOUNT_CCID
,      RESERVE_ACCOUNT_CCID
,      REVAL_AMORT_ACCOUNT_CCID
,      REVAL_RESERVE_ACCOUNT_CCID
,      PERCENT_SALVAGE_VALUE
,      LIFE_EXTENSION_CEILING
,      LIFE_EXTENSION_FACTOR
,      DEFAULT_GROUP_ASSET_ID
,      BONUS_DEPRN_EXPENSE_ACCT
,      BONUS_DEPRN_RESERVE_ACCT
,      BONUS_RESERVE_ACCT_CCID
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      STATUS
,      PRIMARY_UOM_CODE
FROM APPS.OKX_AST_CAT_BKS_V;

Dependencies

[top of page]

APPS.OKX_AST_CAT_BKS_V references the following:

SchemaAPPS
SynonymFA_CATEGORIES_B
SynonymFA_CATEGORY_BOOKS
APPS.OKX_AST_CAT_BKS_V is referenced by following:

SchemaAPPS
Package BodyOKL_ACTIVATE_ASSET_PVT - show dependent code
Package BodyOKL_LIKE_KIND_EXCHANGE_PVT - show dependent code
Package BodyOKL_QA_DATA_INTEGRITY - show dependent code