VIEW: APPS.OKL_FA_DIST_UV

Source

View Text - Preformatted

SELECT FAD.BOOK_TYPE_CODE || '-' || FADD.ASSET_NUMBER || '-' || FAD.TRANSACTION_HEADER_ID ID, FAD.ADJUSTMENT_TYPE AE_LINE_TYPE, FAD.CODE_COMBINATION_ID CODE_COMBINATION_ID, OKL_ACCOUNTING_UTIL.GET_CONCAT_SEGMENTS(FAD.CODE_COMBINATION_ID) CONCATE_SEGMENTS, OKL_ACCOUNTING_UTIL.GET_CONCATE_DESC(FAD.CODE_COMBINATION_ID) CONCATE_SEGMENTS_DESC, FAD.ADJUSTMENT_TYPE AE_LINE_TYPE_MEANING, FAD.DEBIT_CREDIT_FLAG CR_DR_FLAG, FAD.DEBIT_CREDIT_FLAG DR_CR_FLAG_MEANING, FAD.ADJUSTMENT_AMOUNT AMOUNT, FTH.TRANSACTION_DATE_ENTERED ACCOUNTING_DATE, FAD.ADJUSTMENT_TYPE TEMPLATE_NAME, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('YES_NO', DECODE (FAD.JE_HEADER_ID, NULL, 'N', 'Y' ), 0, 0) POSTED, FAD.BOOK_TYPE_CODE || '-' || FADD.ASSET_NUMBER || '-' || FAD.TRANSACTION_HEADER_ID SOURCE_ID, 'FA_TRANSACTION_DETAIL' SOURCE_TABLE, FAD.ASSET_ID ASSET_ID, FAD.TRANSACTION_HEADER_ID DISTRIBUTION_ID, FTH.TRANSACTION_HEADER_ID PERIOD_COUNTER, FAD.BOOK_TYPE_CODE BOOK_TYPE_CODE FROM FA_ADJUSTMENTS FAD, FA_ADDITIONS FADD, FA_TRANSACTION_HEADERS FTH WHERE FAD.ASSET_ID = FADD.ASSET_ID AND FAD.TRANSACTION_HEADER_ID = FTH.TRANSACTION_HEADER_ID AND FAD.SOURCE_TYPE_CODE <> 'DEPRECIATION' AND FAD.ADJUSTMENT_AMOUNT > 0 AND FAD.adjustment_type <> decode(FAD.source_type_code,'RETIREMENT','EXPENSE','NULL') AND FAD.adjustment_type <> decode(FAD.source_type_code,'RETIREMENT','REVAL EXPENSE','NULL') UNION ALL SELECT FDD.BOOK_TYPE_CODE || '-' || FAD.ASSET_NUMBER || '-' || FDD.PERIOD_COUNTER ID, FDD.DEPRN_SOURCE_CODE AE_LINE_TYPE, FD.CODE_COMBINATION_ID CODE_COMBINATION_ID, OKL_ACCOUNTING_UTIL.GET_CONCAT_SEGMENTS(FD.CODE_COMBINATION_ID) CONCATE_SEGMENTS, OKL_ACCOUNTING_UTIL.GET_CONCATE_DESC(FD.CODE_COMBINATION_ID) CONCATE_SEGMENTS_DESC, FL.MEANING AE_LINE_TYPE_MEANING, 'D' CR_DR_FLAG, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('DR_CR', 'D', 101, 101) DR_CR_FLAG_MEANING, (FDD.DEPRN_AMOUNT - NVL(FDD.BONUS_DEPRN_AMOUNT, 0)) AMOUNT, FDP.CALENDAR_PERIOD_CLOSE_DATE ACCOUNTING_DATE, FL.MEANING TEMPLATE_NAME, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('YES_NO', DECODE (FDD.JE_HEADER_ID, NULL, 'N', 'Y' ), 0, 0) POSTED, FDD.BOOK_TYPE_CODE || '-' || FAD.ASSET_NUMBER || '-' || FDD.PERIOD_COUNTER || '-' || FDD.DISTRIBUTION_ID SOURCE_ID, 'FA_DEPRN_DETAIL' SOURCE_TABLE, FDD.ASSET_ID ASSET_ID, FDD.DISTRIBUTION_ID DISTRIBUTION_ID, FDD.PERIOD_COUNTER PERIOD_COUNTER, FDD.BOOK_TYPE_CODE BOOK_TYPE_CODE FROM FA_DEPRN_DETAIL FDD, FA_ADDITIONS FAD, FA_DISTRIBUTION_HISTORY FD, FA_DEPRN_PERIODS FDP, FA_LOOKUPS FL WHERE FDD.ASSET_ID = FAD.ASSET_ID AND FDD.DISTRIBUTION_ID = FD.DISTRIBUTION_ID AND FDD.BOOK_TYPE_CODE = FDP.BOOK_TYPE_CODE AND FDD.PERIOD_COUNTER = FDP.PERIOD_COUNTER AND FL.LOOKUP_TYPE = 'JOURNAL ENTRIES' AND FL.LOOKUP_CODE = 'DEPRECIATION EXPENSE' UNION ALL SELECT FDD.BOOK_TYPE_CODE || '-' || FAD.ASSET_NUMBER || '-' || FDD.PERIOD_COUNTER ID, 'DEPRECIATION RESERVE' AE_LINE_TYPE, JL.CODE_COMBINATION_ID CODE_COMBINATION_ID, OKL_ACCOUNTING_UTIL.GET_CONCAT_SEGMENTS(JL.CODE_COMBINATION_ID) CONCATE_SEGMENTS, OKL_ACCOUNTING_UTIL.GET_CONCATE_DESC(JL.CODE_COMBINATION_ID) CONCATE_SEGMENTS_DESC, FL.MEANING AE_LINE_TYPE_MEANING, 'C' CR_DR_FLAG, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('DR_CR', 'C', 101, 101) DR_CR_FLAG_MEANING, (FDD.DEPRN_AMOUNT - NVL(FDD.BONUS_DEPRN_AMOUNT, 0)) AMOUNT, FDP.CALENDAR_PERIOD_CLOSE_DATE ACCOUNTING_DATE, FL.MEANING TEMPLATE_NAME, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('YES_NO', DECODE (FDD.JE_HEADER_ID, NULL, 'N', 'Y' ), 0, 0) POSTED, FDD.BOOK_TYPE_CODE || '-' || FAD.ASSET_NUMBER || '-' || FDD.PERIOD_COUNTER || '-' || FDD.DISTRIBUTION_ID SOURCE_ID, 'FA_DEPRN_DETAIL' SOURCE_TABLE, FDD.ASSET_ID ASSET_ID, FDD.DISTRIBUTION_ID DISTRIBUTION_ID, FDD.PERIOD_COUNTER PERIOD_COUNTER, FDD.BOOK_TYPE_CODE BOOK_TYPE_CODE FROM FA_DEPRN_DETAIL FDD, FA_ADDITIONS FAD, FA_DISTRIBUTION_HISTORY FD, FA_DEPRN_PERIODS FDP, GL_JE_LINES JL, FA_LOOKUPS FL WHERE FDD.ASSET_ID = FAD.ASSET_ID AND FDD.DISTRIBUTION_ID = FD.DISTRIBUTION_ID AND FDD.BOOK_TYPE_CODE = FDP.BOOK_TYPE_CODE AND FDD.PERIOD_COUNTER = FDP.PERIOD_COUNTER AND FDD.JE_HEADER_ID = JL.JE_HEADER_ID AND FDD.DEPRN_RESERVE_JE_LINE_NUM = JL.JE_LINE_NUM AND FL.LOOKUP_TYPE = 'JOURNAL ENTRIES' AND FL.LOOKUP_CODE = 'DEPRECIATION RESERVE' UNION ALL SELECT FDD.BOOK_TYPE_CODE || '-' || FAD.ASSET_NUMBER || '-' || FDD.PERIOD_COUNTER ID, 'REVALUATION EXPENSE' AE_LINE_TYPE, JL.CODE_COMBINATION_ID CODE_COMBINATION_ID, OKL_ACCOUNTING_UTIL.GET_CONCAT_SEGMENTS(JL.CODE_COMBINATION_ID) CONCATE_SEGMENTS, OKL_ACCOUNTING_UTIL.GET_CONCATE_DESC(JL.CODE_COMBINATION_ID) CONCATE_SEGMENTS_DESC, FL.MEANING AE_LINE_TYPE_MEANING, DECODE(JL.ACCOUNTED_DR, NULL, 'C', 'D') CR_DR_FLAG, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('DR_CR', DECODE(JL.ACCOUNTED_DR, NULL, 'C', 'D'), 101, 101) DR_CR_FLAG_MEANING, FDD.REVAL_AMORTIZATION AMOUNT, FDP.CALENDAR_PERIOD_CLOSE_DATE ACCOUNTING_DATE, FL.MEANING TEMPLATE_NAME, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('YES_NO', DECODE (FDD.JE_HEADER_ID, NULL, 'N', 'Y' ), 0, 0) POSTED, FDD.BOOK_TYPE_CODE || '-' || FAD.ASSET_NUMBER || '-' || FDD.PERIOD_COUNTER || '-' || FDD.DISTRIBUTION_ID SOURCE_ID, 'FA_DEPRN_DETAIL' SOURCE_TABLE, FDD.ASSET_ID ASSET_ID, FDD.DISTRIBUTION_ID DISTRIBUTION_ID, FDD.PERIOD_COUNTER PERIOD_COUNTER, FDD.BOOK_TYPE_CODE BOOK_TYPE_CODE FROM FA_DEPRN_DETAIL FDD, FA_ADDITIONS FAD, FA_DISTRIBUTION_HISTORY FD, FA_DEPRN_PERIODS FDP, GL_JE_LINES JL, FA_LOOKUPS FL WHERE FDD.REVAL_AMORT_JE_LINE_NUM IS NOT NULL AND FDD.ASSET_ID = FAD.ASSET_ID AND FDD.DISTRIBUTION_ID = FD.DISTRIBUTION_ID AND FDD.BOOK_TYPE_CODE = FDP.BOOK_TYPE_CODE AND FDD.PERIOD_COUNTER = FDP.PERIOD_COUNTER AND FDD.JE_HEADER_ID = JL.JE_HEADER_ID AND FDD.REVAL_AMORT_JE_LINE_NUM = JL.JE_LINE_NUM AND FL.LOOKUP_TYPE = 'JOURNAL ENTRIES' AND FL.LOOKUP_CODE = 'REVALUATION EXPENSE' UNION ALL SELECT FDD.BOOK_TYPE_CODE || '-' || FAD.ASSET_NUMBER || '-' || FDD.PERIOD_COUNTER ID, 'REVALUATION RESERVE' AE_LINE_TYPE, JL.CODE_COMBINATION_ID CODE_COMBINATION_ID, OKL_ACCOUNTING_UTIL.GET_CONCAT_SEGMENTS(JL.CODE_COMBINATION_ID) CONCATE_SEGMENTS, OKL_ACCOUNTING_UTIL.GET_CONCATE_DESC(JL.CODE_COMBINATION_ID) CONCATE_SEGMENTS_DESC, FL.MEANING AE_LINE_TYPE_MEANING, DECODE(JL.ACCOUNTED_DR, NULL, 'C', 'D') CR_DR_FLAG, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('DR_CR', DECODE(JL.ACCOUNTED_DR, NULL, 'C', 'D'), 101, 101) DR_CR_FLAG_MEANING, FDD.REVAL_DEPRN_EXPENSE AMOUNT, FDP.CALENDAR_PERIOD_CLOSE_DATE ACCOUNTING_DATE, FL.MEANING TEMPLATE_NAME, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('YES_NO', DECODE (FDD.JE_HEADER_ID, NULL, 'N', 'Y' ), 0, 0) POSTED, FDD.BOOK_TYPE_CODE || '-' || FAD.ASSET_NUMBER || '-' || FDD.PERIOD_COUNTER || '-' || FDD.DISTRIBUTION_ID SOURCE_ID, 'FA_DEPRN_DETAIL' SOURCE_TABLE, FDD.ASSET_ID ASSET_ID, FDD.DISTRIBUTION_ID DISTRIBUTION_ID, FDD.PERIOD_COUNTER PERIOD_COUNTER, FDD.BOOK_TYPE_CODE BOOK_TYPE_CODE FROM FA_DEPRN_DETAIL FDD, FA_ADDITIONS FAD, FA_DISTRIBUTION_HISTORY FD, FA_DEPRN_PERIODS FDP, GL_JE_LINES JL, FA_LOOKUPS FL WHERE FDD.REVAL_RESERVE_JE_LINE_NUM IS NOT NULL AND FDD.ASSET_ID = FAD.ASSET_ID AND FDD.DISTRIBUTION_ID = FD.DISTRIBUTION_ID AND FDD.BOOK_TYPE_CODE = FDP.BOOK_TYPE_CODE AND FDD.PERIOD_COUNTER = FDP.PERIOD_COUNTER AND FDD.JE_HEADER_ID = JL.JE_HEADER_ID AND FDD.REVAL_RESERVE_JE_LINE_NUM = JL.JE_LINE_NUM AND FL.LOOKUP_TYPE = 'JOURNAL ENTRIES' AND FL.LOOKUP_CODE = 'REVALUATION RESERVE' UNION ALL SELECT FDD.BOOK_TYPE_CODE || '-' || FAD.ASSET_NUMBER || '-' || FDD.PERIOD_COUNTER ID, 'BONUS DEPRECIATION EXPENSE' AE_LINE_TYPE, JL.CODE_COMBINATION_ID CODE_COMBINATION_ID, OKL_ACCOUNTING_UTIL.GET_CONCAT_SEGMENTS(JL.CODE_COMBINATION_ID) CONCATE_SEGMENTS, OKL_ACCOUNTING_UTIL.GET_CONCATE_DESC(JL.CODE_COMBINATION_ID) CONCATE_SEGMENTS_DESC, FL.MEANING AE_LINE_TYPE_MEANING, DECODE(JL.ACCOUNTED_DR, NULL, 'C', 'D') CR_DR_FLAG, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('DR_CR', DECODE(JL.ACCOUNTED_DR, NULL, 'C', 'D'), 101, 101) DR_CR_FLAG_MEANING, FDD.BONUS_DEPRN_AMOUNT AMOUNT, FDP.CALENDAR_PERIOD_CLOSE_DATE ACCOUNTING_DATE, FL.MEANING TEMPLATE_NAME, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('YES_NO', DECODE (FDD.JE_HEADER_ID, NULL, 'N', 'Y' ), 0, 0) POSTED, FDD.BOOK_TYPE_CODE || '-' || FAD.ASSET_NUMBER || '-' || FDD.PERIOD_COUNTER || '-' || FDD.DISTRIBUTION_ID SOURCE_ID, 'FA_DEPRN_DETAIL' SOURCE_TABLE, FDD.ASSET_ID ASSET_ID, FDD.DISTRIBUTION_ID DISTRIBUTION_ID, FDD.PERIOD_COUNTER PERIOD_COUNTER, FDD.BOOK_TYPE_CODE BOOK_TYPE_CODE FROM FA_DEPRN_DETAIL FDD, FA_ADDITIONS FAD, FA_DISTRIBUTION_HISTORY FD, FA_DEPRN_PERIODS FDP, GL_JE_LINES JL, FA_LOOKUPS FL WHERE FDD.BONUS_DEPRN_EXP_JE_LINE_NUM IS NOT NULL AND FDD.ASSET_ID = FAD.ASSET_ID AND FDD.DISTRIBUTION_ID = FD.DISTRIBUTION_ID AND FDD.BOOK_TYPE_CODE = FDP.BOOK_TYPE_CODE AND FDD.PERIOD_COUNTER = FDP.PERIOD_COUNTER AND FDD.JE_HEADER_ID = JL.JE_HEADER_ID AND FDD.BONUS_DEPRN_EXP_JE_LINE_NUM = JL.JE_LINE_NUM AND FL.LOOKUP_TYPE = 'JOURNAL ENTRIES' AND FL.LOOKUP_CODE = 'BONUS DEPRECIATION EXPENSE' UNION ALL SELECT FDD.BOOK_TYPE_CODE || '-' || FAD.ASSET_NUMBER || '-' || FDD.PERIOD_COUNTER ID, 'BONUS DEPRECIATION RESERVE' AE_LINE_TYPE, JL.CODE_COMBINATION_ID CODE_COMBINATION_ID, OKL_ACCOUNTING_UTIL.GET_CONCAT_SEGMENTS(JL.CODE_COMBINATION_ID) CONCATE_SEGMENTS, OKL_ACCOUNTING_UTIL.GET_CONCATE_DESC(JL.CODE_COMBINATION_ID) CONCATE_SEGMENTS_DESC, FL.MEANING AE_LINE_TYPE_MEANING, DECODE(JL.ACCOUNTED_DR, NULL, 'C', 'D') CR_DR_FLAG, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('DR_CR', DECODE(JL.ACCOUNTED_DR, NULL, 'C', 'D'), 101, 101) DR_CR_FLAG_MEANING, FDD.BONUS_DEPRN_AMOUNT AMOUNT, FDP.CALENDAR_PERIOD_CLOSE_DATE ACCOUNTING_DATE, FL.MEANING TEMPLATE_NAME, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('YES_NO', DECODE (FDD.JE_HEADER_ID, NULL, 'N', 'Y' ), 0, 0) POSTED, FDD.BOOK_TYPE_CODE || '-' || FAD.ASSET_NUMBER || '-' || FDD.PERIOD_COUNTER || '-' || FDD.DISTRIBUTION_ID SOURCE_ID, 'FA_DEPRN_DETAIL' SOURCE_TABLE, FDD.ASSET_ID ASSET_ID, FDD.DISTRIBUTION_ID DISTRIBUTION_ID, FDD.PERIOD_COUNTER PERIOD_COUNTER, FDD.BOOK_TYPE_CODE BOOK_TYPE_CODE FROM FA_DEPRN_DETAIL FDD, FA_ADDITIONS FAD, FA_DISTRIBUTION_HISTORY FD, FA_DEPRN_PERIODS FDP, GL_JE_LINES JL, FA_LOOKUPS FL WHERE FDD.BONUS_DEPRN_RSV_JE_LINE_NUM IS NOT NULL AND FDD.ASSET_ID = FAD.ASSET_ID AND FDD.DISTRIBUTION_ID = FD.DISTRIBUTION_ID AND FDD.BOOK_TYPE_CODE = FDP.BOOK_TYPE_CODE AND FDD.PERIOD_COUNTER = FDP.PERIOD_COUNTER AND FDD.JE_HEADER_ID = JL.JE_HEADER_ID AND FDD.BONUS_DEPRN_RSV_JE_LINE_NUM = JL.JE_LINE_NUM AND FL.LOOKUP_TYPE = 'JOURNAL ENTRIES' AND FL.LOOKUP_CODE = 'BONUS DEPRECIATION RESERVE'

View Text - HTML Formatted

SELECT FAD.BOOK_TYPE_CODE || '-' || FADD.ASSET_NUMBER || '-' || FAD.TRANSACTION_HEADER_ID ID
, FAD.ADJUSTMENT_TYPE AE_LINE_TYPE
, FAD.CODE_COMBINATION_ID CODE_COMBINATION_ID
, OKL_ACCOUNTING_UTIL.GET_CONCAT_SEGMENTS(FAD.CODE_COMBINATION_ID) CONCATE_SEGMENTS
, OKL_ACCOUNTING_UTIL.GET_CONCATE_DESC(FAD.CODE_COMBINATION_ID) CONCATE_SEGMENTS_DESC
, FAD.ADJUSTMENT_TYPE AE_LINE_TYPE_MEANING
, FAD.DEBIT_CREDIT_FLAG CR_DR_FLAG
, FAD.DEBIT_CREDIT_FLAG DR_CR_FLAG_MEANING
, FAD.ADJUSTMENT_AMOUNT AMOUNT
, FTH.TRANSACTION_DATE_ENTERED ACCOUNTING_DATE
, FAD.ADJUSTMENT_TYPE TEMPLATE_NAME
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('YES_NO'
, DECODE (FAD.JE_HEADER_ID
, NULL
, 'N'
, 'Y' )
, 0
, 0) POSTED
, FAD.BOOK_TYPE_CODE || '-' || FADD.ASSET_NUMBER || '-' || FAD.TRANSACTION_HEADER_ID SOURCE_ID
, 'FA_TRANSACTION_DETAIL' SOURCE_TABLE
, FAD.ASSET_ID ASSET_ID
, FAD.TRANSACTION_HEADER_ID DISTRIBUTION_ID
, FTH.TRANSACTION_HEADER_ID PERIOD_COUNTER
, FAD.BOOK_TYPE_CODE BOOK_TYPE_CODE
FROM FA_ADJUSTMENTS FAD
, FA_ADDITIONS FADD
, FA_TRANSACTION_HEADERS FTH
WHERE FAD.ASSET_ID = FADD.ASSET_ID
AND FAD.TRANSACTION_HEADER_ID = FTH.TRANSACTION_HEADER_ID
AND FAD.SOURCE_TYPE_CODE <> 'DEPRECIATION'
AND FAD.ADJUSTMENT_AMOUNT > 0
AND FAD.ADJUSTMENT_TYPE <> DECODE(FAD.SOURCE_TYPE_CODE
, 'RETIREMENT'
, 'EXPENSE'
, 'NULL')
AND FAD.ADJUSTMENT_TYPE <> DECODE(FAD.SOURCE_TYPE_CODE
, 'RETIREMENT'
, 'REVAL EXPENSE'
, 'NULL') UNION ALL SELECT FDD.BOOK_TYPE_CODE || '-' || FAD.ASSET_NUMBER || '-' || FDD.PERIOD_COUNTER ID
, FDD.DEPRN_SOURCE_CODE AE_LINE_TYPE
, FD.CODE_COMBINATION_ID CODE_COMBINATION_ID
, OKL_ACCOUNTING_UTIL.GET_CONCAT_SEGMENTS(FD.CODE_COMBINATION_ID) CONCATE_SEGMENTS
, OKL_ACCOUNTING_UTIL.GET_CONCATE_DESC(FD.CODE_COMBINATION_ID) CONCATE_SEGMENTS_DESC
, FL.MEANING AE_LINE_TYPE_MEANING
, 'D' CR_DR_FLAG
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('DR_CR'
, 'D'
, 101
, 101) DR_CR_FLAG_MEANING
, (FDD.DEPRN_AMOUNT - NVL(FDD.BONUS_DEPRN_AMOUNT
, 0)) AMOUNT
, FDP.CALENDAR_PERIOD_CLOSE_DATE ACCOUNTING_DATE
, FL.MEANING TEMPLATE_NAME
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('YES_NO'
, DECODE (FDD.JE_HEADER_ID
, NULL
, 'N'
, 'Y' )
, 0
, 0) POSTED
, FDD.BOOK_TYPE_CODE || '-' || FAD.ASSET_NUMBER || '-' || FDD.PERIOD_COUNTER || '-' || FDD.DISTRIBUTION_ID SOURCE_ID
, 'FA_DEPRN_DETAIL' SOURCE_TABLE
, FDD.ASSET_ID ASSET_ID
, FDD.DISTRIBUTION_ID DISTRIBUTION_ID
, FDD.PERIOD_COUNTER PERIOD_COUNTER
, FDD.BOOK_TYPE_CODE BOOK_TYPE_CODE
FROM FA_DEPRN_DETAIL FDD
, FA_ADDITIONS FAD
, FA_DISTRIBUTION_HISTORY FD
, FA_DEPRN_PERIODS FDP
, FA_LOOKUPS FL
WHERE FDD.ASSET_ID = FAD.ASSET_ID
AND FDD.DISTRIBUTION_ID = FD.DISTRIBUTION_ID
AND FDD.BOOK_TYPE_CODE = FDP.BOOK_TYPE_CODE
AND FDD.PERIOD_COUNTER = FDP.PERIOD_COUNTER
AND FL.LOOKUP_TYPE = 'JOURNAL ENTRIES'
AND FL.LOOKUP_CODE = 'DEPRECIATION EXPENSE' UNION ALL SELECT FDD.BOOK_TYPE_CODE || '-' || FAD.ASSET_NUMBER || '-' || FDD.PERIOD_COUNTER ID
, 'DEPRECIATION RESERVE' AE_LINE_TYPE
, JL.CODE_COMBINATION_ID CODE_COMBINATION_ID
, OKL_ACCOUNTING_UTIL.GET_CONCAT_SEGMENTS(JL.CODE_COMBINATION_ID) CONCATE_SEGMENTS
, OKL_ACCOUNTING_UTIL.GET_CONCATE_DESC(JL.CODE_COMBINATION_ID) CONCATE_SEGMENTS_DESC
, FL.MEANING AE_LINE_TYPE_MEANING
, 'C' CR_DR_FLAG
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('DR_CR'
, 'C'
, 101
, 101) DR_CR_FLAG_MEANING
, (FDD.DEPRN_AMOUNT - NVL(FDD.BONUS_DEPRN_AMOUNT
, 0)) AMOUNT
, FDP.CALENDAR_PERIOD_CLOSE_DATE ACCOUNTING_DATE
, FL.MEANING TEMPLATE_NAME
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('YES_NO'
, DECODE (FDD.JE_HEADER_ID
, NULL
, 'N'
, 'Y' )
, 0
, 0) POSTED
, FDD.BOOK_TYPE_CODE || '-' || FAD.ASSET_NUMBER || '-' || FDD.PERIOD_COUNTER || '-' || FDD.DISTRIBUTION_ID SOURCE_ID
, 'FA_DEPRN_DETAIL' SOURCE_TABLE
, FDD.ASSET_ID ASSET_ID
, FDD.DISTRIBUTION_ID DISTRIBUTION_ID
, FDD.PERIOD_COUNTER PERIOD_COUNTER
, FDD.BOOK_TYPE_CODE BOOK_TYPE_CODE
FROM FA_DEPRN_DETAIL FDD
, FA_ADDITIONS FAD
, FA_DISTRIBUTION_HISTORY FD
, FA_DEPRN_PERIODS FDP
, GL_JE_LINES JL
, FA_LOOKUPS FL
WHERE FDD.ASSET_ID = FAD.ASSET_ID
AND FDD.DISTRIBUTION_ID = FD.DISTRIBUTION_ID
AND FDD.BOOK_TYPE_CODE = FDP.BOOK_TYPE_CODE
AND FDD.PERIOD_COUNTER = FDP.PERIOD_COUNTER
AND FDD.JE_HEADER_ID = JL.JE_HEADER_ID
AND FDD.DEPRN_RESERVE_JE_LINE_NUM = JL.JE_LINE_NUM
AND FL.LOOKUP_TYPE = 'JOURNAL ENTRIES'
AND FL.LOOKUP_CODE = 'DEPRECIATION RESERVE' UNION ALL SELECT FDD.BOOK_TYPE_CODE || '-' || FAD.ASSET_NUMBER || '-' || FDD.PERIOD_COUNTER ID
, 'REVALUATION EXPENSE' AE_LINE_TYPE
, JL.CODE_COMBINATION_ID CODE_COMBINATION_ID
, OKL_ACCOUNTING_UTIL.GET_CONCAT_SEGMENTS(JL.CODE_COMBINATION_ID) CONCATE_SEGMENTS
, OKL_ACCOUNTING_UTIL.GET_CONCATE_DESC(JL.CODE_COMBINATION_ID) CONCATE_SEGMENTS_DESC
, FL.MEANING AE_LINE_TYPE_MEANING
, DECODE(JL.ACCOUNTED_DR
, NULL
, 'C'
, 'D') CR_DR_FLAG
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('DR_CR'
, DECODE(JL.ACCOUNTED_DR
, NULL
, 'C'
, 'D')
, 101
, 101) DR_CR_FLAG_MEANING
, FDD.REVAL_AMORTIZATION AMOUNT
, FDP.CALENDAR_PERIOD_CLOSE_DATE ACCOUNTING_DATE
, FL.MEANING TEMPLATE_NAME
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('YES_NO'
, DECODE (FDD.JE_HEADER_ID
, NULL
, 'N'
, 'Y' )
, 0
, 0) POSTED
, FDD.BOOK_TYPE_CODE || '-' || FAD.ASSET_NUMBER || '-' || FDD.PERIOD_COUNTER || '-' || FDD.DISTRIBUTION_ID SOURCE_ID
, 'FA_DEPRN_DETAIL' SOURCE_TABLE
, FDD.ASSET_ID ASSET_ID
, FDD.DISTRIBUTION_ID DISTRIBUTION_ID
, FDD.PERIOD_COUNTER PERIOD_COUNTER
, FDD.BOOK_TYPE_CODE BOOK_TYPE_CODE
FROM FA_DEPRN_DETAIL FDD
, FA_ADDITIONS FAD
, FA_DISTRIBUTION_HISTORY FD
, FA_DEPRN_PERIODS FDP
, GL_JE_LINES JL
, FA_LOOKUPS FL
WHERE FDD.REVAL_AMORT_JE_LINE_NUM IS NOT NULL
AND FDD.ASSET_ID = FAD.ASSET_ID
AND FDD.DISTRIBUTION_ID = FD.DISTRIBUTION_ID
AND FDD.BOOK_TYPE_CODE = FDP.BOOK_TYPE_CODE
AND FDD.PERIOD_COUNTER = FDP.PERIOD_COUNTER
AND FDD.JE_HEADER_ID = JL.JE_HEADER_ID
AND FDD.REVAL_AMORT_JE_LINE_NUM = JL.JE_LINE_NUM
AND FL.LOOKUP_TYPE = 'JOURNAL ENTRIES'
AND FL.LOOKUP_CODE = 'REVALUATION EXPENSE' UNION ALL SELECT FDD.BOOK_TYPE_CODE || '-' || FAD.ASSET_NUMBER || '-' || FDD.PERIOD_COUNTER ID
, 'REVALUATION RESERVE' AE_LINE_TYPE
, JL.CODE_COMBINATION_ID CODE_COMBINATION_ID
, OKL_ACCOUNTING_UTIL.GET_CONCAT_SEGMENTS(JL.CODE_COMBINATION_ID) CONCATE_SEGMENTS
, OKL_ACCOUNTING_UTIL.GET_CONCATE_DESC(JL.CODE_COMBINATION_ID) CONCATE_SEGMENTS_DESC
, FL.MEANING AE_LINE_TYPE_MEANING
, DECODE(JL.ACCOUNTED_DR
, NULL
, 'C'
, 'D') CR_DR_FLAG
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('DR_CR'
, DECODE(JL.ACCOUNTED_DR
, NULL
, 'C'
, 'D')
, 101
, 101) DR_CR_FLAG_MEANING
, FDD.REVAL_DEPRN_EXPENSE AMOUNT
, FDP.CALENDAR_PERIOD_CLOSE_DATE ACCOUNTING_DATE
, FL.MEANING TEMPLATE_NAME
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('YES_NO'
, DECODE (FDD.JE_HEADER_ID
, NULL
, 'N'
, 'Y' )
, 0
, 0) POSTED
, FDD.BOOK_TYPE_CODE || '-' || FAD.ASSET_NUMBER || '-' || FDD.PERIOD_COUNTER || '-' || FDD.DISTRIBUTION_ID SOURCE_ID
, 'FA_DEPRN_DETAIL' SOURCE_TABLE
, FDD.ASSET_ID ASSET_ID
, FDD.DISTRIBUTION_ID DISTRIBUTION_ID
, FDD.PERIOD_COUNTER PERIOD_COUNTER
, FDD.BOOK_TYPE_CODE BOOK_TYPE_CODE
FROM FA_DEPRN_DETAIL FDD
, FA_ADDITIONS FAD
, FA_DISTRIBUTION_HISTORY FD
, FA_DEPRN_PERIODS FDP
, GL_JE_LINES JL
, FA_LOOKUPS FL
WHERE FDD.REVAL_RESERVE_JE_LINE_NUM IS NOT NULL
AND FDD.ASSET_ID = FAD.ASSET_ID
AND FDD.DISTRIBUTION_ID = FD.DISTRIBUTION_ID
AND FDD.BOOK_TYPE_CODE = FDP.BOOK_TYPE_CODE
AND FDD.PERIOD_COUNTER = FDP.PERIOD_COUNTER
AND FDD.JE_HEADER_ID = JL.JE_HEADER_ID
AND FDD.REVAL_RESERVE_JE_LINE_NUM = JL.JE_LINE_NUM
AND FL.LOOKUP_TYPE = 'JOURNAL ENTRIES'
AND FL.LOOKUP_CODE = 'REVALUATION RESERVE' UNION ALL SELECT FDD.BOOK_TYPE_CODE || '-' || FAD.ASSET_NUMBER || '-' || FDD.PERIOD_COUNTER ID
, 'BONUS DEPRECIATION EXPENSE' AE_LINE_TYPE
, JL.CODE_COMBINATION_ID CODE_COMBINATION_ID
, OKL_ACCOUNTING_UTIL.GET_CONCAT_SEGMENTS(JL.CODE_COMBINATION_ID) CONCATE_SEGMENTS
, OKL_ACCOUNTING_UTIL.GET_CONCATE_DESC(JL.CODE_COMBINATION_ID) CONCATE_SEGMENTS_DESC
, FL.MEANING AE_LINE_TYPE_MEANING
, DECODE(JL.ACCOUNTED_DR
, NULL
, 'C'
, 'D') CR_DR_FLAG
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('DR_CR'
, DECODE(JL.ACCOUNTED_DR
, NULL
, 'C'
, 'D')
, 101
, 101) DR_CR_FLAG_MEANING
, FDD.BONUS_DEPRN_AMOUNT AMOUNT
, FDP.CALENDAR_PERIOD_CLOSE_DATE ACCOUNTING_DATE
, FL.MEANING TEMPLATE_NAME
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('YES_NO'
, DECODE (FDD.JE_HEADER_ID
, NULL
, 'N'
, 'Y' )
, 0
, 0) POSTED
, FDD.BOOK_TYPE_CODE || '-' || FAD.ASSET_NUMBER || '-' || FDD.PERIOD_COUNTER || '-' || FDD.DISTRIBUTION_ID SOURCE_ID
, 'FA_DEPRN_DETAIL' SOURCE_TABLE
, FDD.ASSET_ID ASSET_ID
, FDD.DISTRIBUTION_ID DISTRIBUTION_ID
, FDD.PERIOD_COUNTER PERIOD_COUNTER
, FDD.BOOK_TYPE_CODE BOOK_TYPE_CODE
FROM FA_DEPRN_DETAIL FDD
, FA_ADDITIONS FAD
, FA_DISTRIBUTION_HISTORY FD
, FA_DEPRN_PERIODS FDP
, GL_JE_LINES JL
, FA_LOOKUPS FL
WHERE FDD.BONUS_DEPRN_EXP_JE_LINE_NUM IS NOT NULL
AND FDD.ASSET_ID = FAD.ASSET_ID
AND FDD.DISTRIBUTION_ID = FD.DISTRIBUTION_ID
AND FDD.BOOK_TYPE_CODE = FDP.BOOK_TYPE_CODE
AND FDD.PERIOD_COUNTER = FDP.PERIOD_COUNTER
AND FDD.JE_HEADER_ID = JL.JE_HEADER_ID
AND FDD.BONUS_DEPRN_EXP_JE_LINE_NUM = JL.JE_LINE_NUM
AND FL.LOOKUP_TYPE = 'JOURNAL ENTRIES'
AND FL.LOOKUP_CODE = 'BONUS DEPRECIATION EXPENSE' UNION ALL SELECT FDD.BOOK_TYPE_CODE || '-' || FAD.ASSET_NUMBER || '-' || FDD.PERIOD_COUNTER ID
, 'BONUS DEPRECIATION RESERVE' AE_LINE_TYPE
, JL.CODE_COMBINATION_ID CODE_COMBINATION_ID
, OKL_ACCOUNTING_UTIL.GET_CONCAT_SEGMENTS(JL.CODE_COMBINATION_ID) CONCATE_SEGMENTS
, OKL_ACCOUNTING_UTIL.GET_CONCATE_DESC(JL.CODE_COMBINATION_ID) CONCATE_SEGMENTS_DESC
, FL.MEANING AE_LINE_TYPE_MEANING
, DECODE(JL.ACCOUNTED_DR
, NULL
, 'C'
, 'D') CR_DR_FLAG
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('DR_CR'
, DECODE(JL.ACCOUNTED_DR
, NULL
, 'C'
, 'D')
, 101
, 101) DR_CR_FLAG_MEANING
, FDD.BONUS_DEPRN_AMOUNT AMOUNT
, FDP.CALENDAR_PERIOD_CLOSE_DATE ACCOUNTING_DATE
, FL.MEANING TEMPLATE_NAME
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('YES_NO'
, DECODE (FDD.JE_HEADER_ID
, NULL
, 'N'
, 'Y' )
, 0
, 0) POSTED
, FDD.BOOK_TYPE_CODE || '-' || FAD.ASSET_NUMBER || '-' || FDD.PERIOD_COUNTER || '-' || FDD.DISTRIBUTION_ID SOURCE_ID
, 'FA_DEPRN_DETAIL' SOURCE_TABLE
, FDD.ASSET_ID ASSET_ID
, FDD.DISTRIBUTION_ID DISTRIBUTION_ID
, FDD.PERIOD_COUNTER PERIOD_COUNTER
, FDD.BOOK_TYPE_CODE BOOK_TYPE_CODE
FROM FA_DEPRN_DETAIL FDD
, FA_ADDITIONS FAD
, FA_DISTRIBUTION_HISTORY FD
, FA_DEPRN_PERIODS FDP
, GL_JE_LINES JL
, FA_LOOKUPS FL
WHERE FDD.BONUS_DEPRN_RSV_JE_LINE_NUM IS NOT NULL
AND FDD.ASSET_ID = FAD.ASSET_ID
AND FDD.DISTRIBUTION_ID = FD.DISTRIBUTION_ID
AND FDD.BOOK_TYPE_CODE = FDP.BOOK_TYPE_CODE
AND FDD.PERIOD_COUNTER = FDP.PERIOD_COUNTER
AND FDD.JE_HEADER_ID = JL.JE_HEADER_ID
AND FDD.BONUS_DEPRN_RSV_JE_LINE_NUM = JL.JE_LINE_NUM
AND FL.LOOKUP_TYPE = 'JOURNAL ENTRIES'
AND FL.LOOKUP_CODE = 'BONUS DEPRECIATION RESERVE'