View: FA_DEPRN_GROUPS_V

Product:	OFA - Assets
Description:
Implementation/DBA Data:	APPS.FA_DEPRN_GROUPS_V

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

Columns