View: FA_DEFERRED_DEPRN_MRC_V

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

View Text

SELECT FMCDD.SET_OF_BOOKS_ID
, FMCDD.CORP_BOOK_TYPE_CODE
, FMCDD.TAX_BOOK_TYPE_CODE
, FMCDD.ASSET_ID
, FMCDD.DISTRIBUTION_ID
, FMCDD.DEFERRED_DEPRN_EXPENSE_CCID
, FMCDD.DEFERRED_DEPRN_RESERVE_CCID
, FMCDD.DEFERRED_DEPRN_EXPENSE_AMOUNT
, FMCDD.DEFERRED_DEPRN_RESERVE_AMOUNT
, FMCDD.CORP_PERIOD_COUNTER
, FMCDD.TAX_PERIOD_COUNTER
, FMCDD.JE_HEADER_ID
, FMCDD.EXPENSE_JE_LINE_NUM
, FMCDD.RESERVE_JE_LINE_NUM
FROM FA_MC_DEFERRED_DEPRN FMCDD
WHERE FMCDD.SET_OF_BOOKS_ID = NVL(TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO')
, 45
, 10))
, -1)

Columns