View: FA_DEPRN_PERIODS_MRC_V

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

View Text

SELECT FMCDP.SET_OF_BOOKS_ID
, FMCDP.BOOK_TYPE_CODE
, FMCDP.PERIOD_NAME
, FMCDP.PERIOD_COUNTER
, FMCDP.FISCAL_YEAR
, FMCDP.PERIOD_NUM
, FMCDP.PERIOD_OPEN_DATE
, FMCDP.PERIOD_CLOSE_DATE
, FMCDP.DEPRECIATION_BATCH_ID
, FMCDP.RETIREMENT_BATCH_ID
, FMCDP.RECLASS_BATCH_ID
, FMCDP.TRANSFER_BATCH_ID
, FMCDP.ADDITION_BATCH_ID
, FMCDP.ADJUSTMENT_BATCH_ID
, FMCDP.DEFERRED_DEPRN_BATCH_ID
, FMCDP.CALENDAR_PERIOD_OPEN_DATE
, FMCDP.CALENDAR_PERIOD_CLOSE_DATE
, FMCDP.CIP_ADDITION_BATCH_ID
, FMCDP.CIP_ADJUSTMENT_BATCH_ID
, FMCDP.CIP_RECLASS_BATCH_ID
, FMCDP.CIP_RETIREMENT_BATCH_ID
, FMCDP.CIP_REVAL_BATCH_ID
, FMCDP.CIP_TRANSFER_BATCH_ID
, FMCDP.REVAL_BATCH_ID
, FMCDP.DEPRN_ADJUSTMENT_BATCH_ID
, FMCDP.DEPRN_RUN
FROM FA_MC_DEPRN_PERIODS FMCDP
WHERE FMCDP.SET_OF_BOOKS_ID = NVL(TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO')
, 45
, 10))
, -1)

Columns