VIEW: FA.FA_GROUP_DEPRN_DETAIL#

Source

View Text - Preformatted

select BOOK_TYPE_CODE BOOK_TYPE_CODE, GROUP_ASSET_ID GROUP_ASSET_ID, PERIOD_COUNTER PERIOD_COUNTER, DISTRIBUTION_ID DISTRIBUTION_ID, DEPRN_SOURCE_CODE DEPRN_SOURCE_CODE, DEPRN_RUN_DATE DEPRN_RUN_DATE, DEPRN_AMOUNT DEPRN_AMOUNT, YTD_DEPRN YTD_DEPRN, DEPRN_RESERVE DEPRN_RESERVE, ADDITION_COST_TO_CLEAR ADDITION_COST_TO_CLEAR, COST COST, DEPRN_ADJUSTMENT_AMOUNT DEPRN_ADJUSTMENT_AMOUNT, DEPRN_EXPENSE_JE_LINE_NUM DEPRN_EXPENSE_JE_LINE_NUM, DEPRN_RESERVE_JE_LINE_NUM DEPRN_RESERVE_JE_LINE_NUM, REVAL_AMORT_JE_LINE_NUM REVAL_AMORT_JE_LINE_NUM, REVAL_RESERVE_JE_LINE_NUM REVAL_RESERVE_JE_LINE_NUM, JE_HEADER_ID JE_HEADER_ID, REVAL_AMORTIZATION REVAL_AMORTIZATION, REVAL_DEPRN_EXPENSE REVAL_DEPRN_EXPENSE, REVAL_RESERVE REVAL_RESERVE, YTD_REVAL_DEPRN_EXPENSE YTD_REVAL_DEPRN_EXPENSE from "FA"."FA_GROUP_DEPRN_DETAIL"

View Text - HTML Formatted

SELECT BOOK_TYPE_CODE BOOK_TYPE_CODE
, GROUP_ASSET_ID GROUP_ASSET_ID
, PERIOD_COUNTER PERIOD_COUNTER
, DISTRIBUTION_ID DISTRIBUTION_ID
, DEPRN_SOURCE_CODE DEPRN_SOURCE_CODE
, DEPRN_RUN_DATE DEPRN_RUN_DATE
, DEPRN_AMOUNT DEPRN_AMOUNT
, YTD_DEPRN YTD_DEPRN
, DEPRN_RESERVE DEPRN_RESERVE
, ADDITION_COST_TO_CLEAR ADDITION_COST_TO_CLEAR
, COST COST
, DEPRN_ADJUSTMENT_AMOUNT DEPRN_ADJUSTMENT_AMOUNT
, DEPRN_EXPENSE_JE_LINE_NUM DEPRN_EXPENSE_JE_LINE_NUM
, DEPRN_RESERVE_JE_LINE_NUM DEPRN_RESERVE_JE_LINE_NUM
, REVAL_AMORT_JE_LINE_NUM REVAL_AMORT_JE_LINE_NUM
, REVAL_RESERVE_JE_LINE_NUM REVAL_RESERVE_JE_LINE_NUM
, JE_HEADER_ID JE_HEADER_ID
, REVAL_AMORTIZATION REVAL_AMORTIZATION
, REVAL_DEPRN_EXPENSE REVAL_DEPRN_EXPENSE
, REVAL_RESERVE REVAL_RESERVE
, YTD_REVAL_DEPRN_EXPENSE YTD_REVAL_DEPRN_EXPENSE
FROM "FA"."FA_GROUP_DEPRN_DETAIL"