Product: | OFA - Assets |
---|---|
Description: | |
Implementation/DBA Data: | APPS.FA_GROUP_DEPRN_DETAIL_MRC_V |
SELECT IMGDD.SET_OF_BOOKS_ID
, IMGDD.BOOK_TYPE_CODE
, IMGDD.GROUP_ASSET_ID
, IMGDD.PERIOD_COUNTER
, IMGDD.DISTRIBUTION_ID
, IMGDD.DEPRN_SOURCE_CODE
, IMGDD.DEPRN_RUN_DATE
, IMGDD.DEPRN_AMOUNT
, IMGDD.YTD_DEPRN
, IMGDD.DEPRN_RESERVE
, IMGDD.ADDITION_COST_TO_CLEAR
, IMGDD.COST
, IMGDD.DEPRN_ADJUSTMENT_AMOUNT
, IMGDD.DEPRN_EXPENSE_JE_LINE_NUM
, IMGDD.DEPRN_RESERVE_JE_LINE_NUM
, IMGDD.REVAL_AMORT_JE_LINE_NUM
, IMGDD.REVAL_RESERVE_JE_LINE_NUM
, IMGDD.JE_HEADER_ID
, IMGDD.REVAL_AMORTIZATION
, IMGDD.REVAL_DEPRN_EXPENSE
, IMGDD.REVAL_RESERVE
, IMGDD.YTD_REVAL_DEPRN_EXPENSE
FROM FA_MC_GROUP_DEPRN_DETAIL IMGDD
WHERE IMGDD.SET_OF_BOOKS_ID = NVL(TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO')
, 45
, 10))
, -1)