Product: | OFA - Assets |
---|---|
Description: | |
Implementation/DBA Data: | APPS.FA_DEPRN_PERIODS_MRC_V |
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)