VIEW: APPS.FA_DEPRN_PERIODS_MRC_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)