[Home] [Help]
View: FA_DEPRN_GROUPS_V1
Product: | OFA - Assets |
Description: | Adds unplanned depreciation adjustments to fa_deprn_groups_v |
Implementation/DBA Data: |
APPS.FA_DEPRN_GROUPS_V1
|
View Text
SELECT DS.BOOK_TYPE_CODE
, DS.GROUP_ASSET_ID
, DP.PERIOD_NAME
, DS.PERIOD_COUNTER
, DS.DEPRN_AMOUNT
, DS.DEPRN_RESERVE
, DH.CODE_COMBINATION_ID
FROM FA_GROUP_DEPRN_SUMMARY DS
, FA_GROUP_DEPRN_DETAIL DD
, FA_DISTRIBUTION_HISTORY DH
, FA_DEPRN_PERIODS DP
WHERE DD.DISTRIBUTION_ID = DH.DISTRIBUTION_ID
AND DD.BOOK_TYPE_CODE = DS.BOOK_TYPE_CODE
AND DD.GROUP_ASSET_ID = DS.GROUP_ASSET_ID
AND DD.PERIOD_COUNTER = DS.PERIOD_COUNTER
AND DP.BOOK_TYPE_CODE = DS.BOOK_TYPE_CODE
AND DP.PERIOD_COUNTER = DS.PERIOD_COUNTER
AND EXISTS (SELECT 1
FROM FA_BOOKS_GROUPS BG
WHERE BG.GROUP_ASSET_ID = DS.GROUP_ASSET_ID
AND BG.BOOK_TYPE_CODE = DS.BOOK_TYPE_CODE
AND BG.PERIOD_COUNTER = DS.PERIOD_COUNTER)
Columns
Name |
BOOK_TYPE_CODE |
ASSET_ID |
PERIOD |
PERIOD_COUNTER |
DEPRN_AMOUNT |
DEPRN_RESERVE |
CODE_COMBINATION_ID |