[Home] [Help] [Dependency Information]
Object Name: | OKX_AST_CAT_BKS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKX.OKX_AST_CAT_BKS_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
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 |
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;
|
|
|