[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | OKX_AST_DPRTNS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  OKX.OKX_AST_DPRTNS_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 |
| ID2 | VARCHAR2 | (56) | Primary key column | |
| NAME | VARCHAR2 | (15) | Yes | Asset number |
| DESCRIPTION | VARCHAR2 | (72) | Description | |
| BOOK_TYPE_CODE | VARCHAR2 | (15) | Yes | Book name |
| ASSET_ID | NUMBER | (15) | Yes | Unique identifier for the asset |
| DEPRN_RUN_DATE | DATE | Yes | System date when depreciation was run | |
| DEPRN_AMOUNT | NUMBER | Yes | Depreciation expense for this depreciation period | |
| YTD_DEPRN | NUMBER | Yes | Year-to-date depreciation expense | |
| DEPRN_RESERVE | NUMBER | Yes | Total depreciation taken since begining of asset life | |
| DEPRN_SOURCE_CODE | VARCHAR2 | (15) | Yes | Indicates whether this record is created by thr depreciation BOOKS form or by running depreciation process |
| ADJUSTED_COST | NUMBER | Yes | Depreciable basis | |
| BONUS_RATE | NUMBER | Bonus rate used to calculate depreciation | ||
| LTD_PRODUCTION | NUMBER | Life to date production for an units of production asset | ||
| PERIOD_COUNTER | NUMBER | (15) | Yes | Depreciation period |
| PRODUCTION | NUMBER | Current period production for an units of production asset | ||
| REVAL_AMORTIZATION | NUMBER | Amount of revaluation reserve amortized during this period | ||
| REVAL_AMORTIZATION_BASIS | NUMBER | Revaluation reserve used in calculation amortization of revaluation reserve | ||
| REVAL_DEPRN_EXPENSE | NUMBER | Protion of depreciation expense dure to revaluation of asset cost | ||
| REVAL_RESERVE | NUMBER | For a period in which this asset was revalued: change in net book value due to revaluation of asset cost and sometimes also revaluation of depreciation reserve. For all other periods: revaluation reserve amount after depreciation run | ||
| YTD_PRODUCTION | NUMBER | Year-to-date production for a units of production asset | ||
| YTD_REVAL_DEPRN_EXPENSE | NUMBER | Year-to-date depreciation expense due to revaluation. Oracle Assets does not create any journal entries for this amount. It is for reporting only | ||
| PRIOR_FY_EXPENSE | NUMBER | Depreciation expense due to prior fiscal years | ||
| BONUS_DEPRN_AMOUNT | NUMBER | Bonus depreciation expense for this depreciation period. Amount included in deprn_amount | ||
| BONUS_YTD_DEPRN | NUMBER | Bonus year-to-date depreciation expense. Amount included in ytd_deprn | ||
| BONUS_DEPRN_RESERVE | NUMBER | Total bonus depreciation taken since the beginning of asset life. Amount included in deprn_reserve | ||
| PRIOR_FY_BONUS_EXPENSE | NUMBER | Bonus Depreciation expense due to prior fiscal years | ||
| START_DATE_ACTIVE | DATE | Effective from date | ||
| END_DATE_ACTIVE | DATE | Effective to date | ||
| STATUS | CHAR | (1) | Indicates whether record is active or 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
, BOOK_TYPE_CODE
, ASSET_ID
, DEPRN_RUN_DATE
, DEPRN_AMOUNT
, YTD_DEPRN
, DEPRN_RESERVE
, DEPRN_SOURCE_CODE
, ADJUSTED_COST
, BONUS_RATE
, LTD_PRODUCTION
, PERIOD_COUNTER
, PRODUCTION
, REVAL_AMORTIZATION
, REVAL_AMORTIZATION_BASIS
, REVAL_DEPRN_EXPENSE
, REVAL_RESERVE
, YTD_PRODUCTION
, YTD_REVAL_DEPRN_EXPENSE
, PRIOR_FY_EXPENSE
, BONUS_DEPRN_AMOUNT
, BONUS_YTD_DEPRN
, BONUS_DEPRN_RESERVE
, PRIOR_FY_BONUS_EXPENSE
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, STATUS
, PRIMARY_UOM_CODE
FROM APPS.OKX_AST_DPRTNS_V;
APPS
FA_ADDITIONS_B
FA_DEPRN_SUMMARY
APPS
OKL_ACTIVATE_ASSET_PVT
- show dependent code
OKL_LIKE_KIND_EXCHANGE_PVT
- show dependent code
OKL_LOSS_PROV_PVT
- show dependent code
OKL_SEEDED_FUNCTIONS_PVT
- show dependent code
OKL_SPLIT_ASSET_PVT
- show dependent code
|
|
|
|