View: OKL_FA_DIST_UV

Product:	OKL - Lease and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_FA_DIST_UV

View Text

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'

Columns