View: JL_ZZ_FA_ADJ_SUMMARY_V

Product:	JL - Latin America Localizations
Description:
Implementation/DBA Data:	APPS.JL_ZZ_FA_ADJ_SUMMARY_V

View Text

SELECT AD.ASSET_ID
, AD.ASSET_NUMBER
, AD.TAG_NUMBER
, AD.ASSET_TYPE
, AD.CURRENT_UNITS
, AD.DESCRIPTION
, AD.ASSET_CATEGORY_ID
, AD.PARENT_ASSET_ID
, BCA.BOOK_TYPE_CODE
, BCA.DISTRIBUTION_SOURCE_BOOK
, DPA.PERIOD_COUNTER
, DPA.PERIOD_NAME
, BKA.COST
, DSA.DEPRN_RESERVE
, DSA.YTD_DEPRN
, NVL(JL_ZZ_FA_CALC_ADJUSTMENT_PKG.CALC_CORP_BOOK_COST(BCA.DISTRIBUTION_SOURCE_BOOK
, DPA.PERIOD_COUNTER
, BKA.ASSET_ID
, 'CC')
, 0) CORP_COST
, NVL(JL_ZZ_FA_CALC_ADJUSTMENT_PKG.CALC_CORP_DEPRN_RESERVE(BCA.DISTRIBUTION_SOURCE_BOOK
, DPA.PERIOD_COUNTER
, BKA.ASSET_ID
, 'CC')
, 0) CORP_DEPRN_RESERVE
, NVL(JL_ZZ_FA_CALC_ADJUSTMENT_PKG.CALC_CORP_YTD_DEPRN(BCA.DISTRIBUTION_SOURCE_BOOK
, DPA.PERIOD_COUNTER
, BKA.ASSET_ID
, 'CC')
, 0) CORP_YTD_DEPRN
FROM FA_DEPRN_SUMMARY DSA
, FA_DEPRN_PERIODS DPA
, FA_ADDITIONS AD
, FA_BOOKS BKA
, FA_BOOK_CONTROLS BCA
WHERE BCA.BOOK_CLASS = 'TAX'
AND BCA.GLOBAL_ATTRIBUTE1 = 'Y'
AND DPA.BOOK_TYPE_CODE = BCA.BOOK_TYPE_CODE
AND DPA.PERIOD_COUNTER <= BCA.LAST_PERIOD_COUNTER
AND BKA.BOOK_TYPE_CODE = DPA.BOOK_TYPE_CODE
AND BKA.DATE_EFFECTIVE <= NVL (DPA.PERIOD_CLOSE_DATE
, SYSDATE)
AND NVL (DPA.PERIOD_CLOSE_DATE
, SYSDATE) <= NVL (BKA.DATE_INEFFECTIVE
, SYSDATE)
AND AD.ASSET_ID = BKA.ASSET_ID
AND DSA.ASSET_ID = AD.ASSET_ID
AND DSA.BOOK_TYPE_CODE = DPA.BOOK_TYPE_CODE
AND DSA.PERIOD_COUNTER = DPA.PERIOD_COUNTER UNION SELECT AD.ASSET_ID
, AD.ASSET_NUMBER
, AD.TAG_NUMBER
, AD.ASSET_TYPE
, AD.CURRENT_UNITS
, AD.DESCRIPTION
, AD.ASSET_CATEGORY_ID
, AD.PARENT_ASSET_ID
, BCA.BOOK_TYPE_CODE
, BCA.DISTRIBUTION_SOURCE_BOOK
, DPA.PERIOD_COUNTER
, DPA.PERIOD_NAME
, BKA.COST
, DSA.DEPRN_RESERVE - JL_ZZ_FA_CALC_ADJUSTMENT_PKG.CALC_ADJUSTMENTS (BCA.BOOK_TYPE_CODE
, DPA.PERIOD_COUNTER
, AD.ASSET_ID
, 'RESERVE'
, 'NET' )
, DSA.YTD_DEPRN + JL_ZZ_FA_CALC_ADJUSTMENT_PKG.CALC_ADJUSTMENTS (BCA.BOOK_TYPE_CODE
, DPA.PERIOD_COUNTER
, AD.ASSET_ID
, 'EXPENSE'
, 'NET' )
, NVL(JL_ZZ_FA_CALC_ADJUSTMENT_PKG.CALC_CORP_BOOK_COST(BCA.DISTRIBUTION_SOURCE_BOOK
, DPA.PERIOD_COUNTER
, BKA.ASSET_ID
, 'CO')
, 0)
, NVL(JL_ZZ_FA_CALC_ADJUSTMENT_PKG.CALC_CORP_DEPRN_RESERVE(BCA.DISTRIBUTION_SOURCE_BOOK
, DPA.PERIOD_COUNTER
, BKA.ASSET_ID
, 'CO')
, 0)
, NVL(JL_ZZ_FA_CALC_ADJUSTMENT_PKG.CALC_CORP_YTD_DEPRN(BCA.DISTRIBUTION_SOURCE_BOOK
, DPA.PERIOD_COUNTER
, BKA.ASSET_ID
, 'CO')
, 0)
FROM FA_DEPRN_SUMMARY DSA
, FA_DEPRN_PERIODS DPA
, FA_ADDITIONS AD
, FA_BOOKS BKA
, FA_BOOK_CONTROLS BCA
WHERE BCA.BOOK_CLASS = 'TAX'
AND BCA.GLOBAL_ATTRIBUTE1 = 'Y'
AND DPA.BOOK_TYPE_CODE = BCA.BOOK_TYPE_CODE
AND DPA.PERIOD_COUNTER = BCA.LAST_PERIOD_COUNTER + 1
AND BKA.BOOK_TYPE_CODE = DPA.BOOK_TYPE_CODE
AND BKA.DATE_EFFECTIVE <= NVL (DPA.PERIOD_CLOSE_DATE
, SYSDATE)
AND NVL (DPA.PERIOD_CLOSE_DATE
, SYSDATE) <= NVL (BKA.DATE_INEFFECTIVE
, SYSDATE)
AND AD.ASSET_ID = BKA.ASSET_ID
AND DSA.ASSET_ID = AD.ASSET_ID
AND DSA.BOOK_TYPE_CODE = DPA.BOOK_TYPE_CODE
AND DSA.PERIOD_COUNTER = BCA.LAST_PERIOD_COUNTER UNION SELECT AD.ASSET_ID
, AD.ASSET_NUMBER
, AD.TAG_NUMBER
, AD.ASSET_TYPE
, AD.CURRENT_UNITS
, AD.DESCRIPTION
, AD.ASSET_CATEGORY_ID
, AD.PARENT_ASSET_ID
, BCA.BOOK_TYPE_CODE
, BCA.DISTRIBUTION_SOURCE_BOOK
, DPA.PERIOD_COUNTER
, DPA.PERIOD_NAME
, BKA.COST
, DSA.DEPRN_RESERVE - JL_ZZ_FA_CALC_ADJUSTMENT_PKG.CALC_ADJUSTMENTS (BCA.BOOK_TYPE_CODE
, DPA.PERIOD_COUNTER
, AD.ASSET_ID
, 'RESERVE'
, 'NET' )
, DSA.YTD_DEPRN + JL_ZZ_FA_CALC_ADJUSTMENT_PKG.CALC_ADJUSTMENTS (BCA.BOOK_TYPE_CODE
, DPA.PERIOD_COUNTER
, AD.ASSET_ID
, 'EXPENSE'
, 'NET' )
, NVL(JL_ZZ_FA_CALC_ADJUSTMENT_PKG.CALC_CORP_BOOK_COST(BCA.DISTRIBUTION_SOURCE_BOOK
, DPA.PERIOD_COUNTER
, BKA.ASSET_ID
, 'CO')
, 0)
, NVL(JL_ZZ_FA_CALC_ADJUSTMENT_PKG.CALC_CORP_DEPRN_RESERVE(BCA.DISTRIBUTION_SOURCE_BOOK
, DPA.PERIOD_COUNTER
, BKA.ASSET_ID
, 'CO')
, 0)
, NVL(JL_ZZ_FA_CALC_ADJUSTMENT_PKG.CALC_CORP_YTD_DEPRN(BCA.DISTRIBUTION_SOURCE_BOOK
, DPA.PERIOD_COUNTER
, BKA.ASSET_ID
, 'CO')
, 0)
FROM FA_DEPRN_SUMMARY DSA
, FA_DEPRN_PERIODS DPA
, FA_ADDITIONS AD
, FA_BOOKS BKA
, FA_BOOK_CONTROLS BCA
WHERE BCA.BOOK_CLASS = 'TAX'
AND BCA.GLOBAL_ATTRIBUTE1 = 'Y'
AND DPA.BOOK_TYPE_CODE = BCA.BOOK_TYPE_CODE
AND DPA.PERIOD_COUNTER = BCA.LAST_PERIOD_COUNTER + 1
AND BKA.BOOK_TYPE_CODE = DPA.BOOK_TYPE_CODE
AND BKA.GLOBAL_ATTRIBUTE1 = 'Y'
AND BKA.DATE_EFFECTIVE <= NVL (DPA.PERIOD_CLOSE_DATE
, SYSDATE)
AND NVL (DPA.PERIOD_CLOSE_DATE
, SYSDATE) <= NVL (BKA.DATE_INEFFECTIVE
, SYSDATE)
AND AD.ASSET_ID = BKA.ASSET_ID
AND DSA.ASSET_ID = AD.ASSET_ID
AND DSA.BOOK_TYPE_CODE = DPA.BOOK_TYPE_CODE
AND DSA.PERIOD_COUNTER = BCA.LAST_PERIOD_COUNTER

Columns