eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.FA_DEPRN_WEB_V

Source

View Text - Preformatted


SELECT AD.ASSET_ID ASSET_ID , AD.ASSET_NUMBER , AD.DESCRIPTION , DP.BOOK_TYPE_CODE BOOK_TYPE_CODE , DP.PERIOD_COUNTER PERIOD_COUNTER , DP.PERIOD_NAME PERIOD_ENTERED , TO_CHAR(SUM(DD.DEPRN_AMOUNT), FND_CURRENCY.SAFE_GET_FORMAT_MASK(MAX(GLSB.CURRENCY_CODE),30)) DEPRN_AMOUNT , TO_CHAR(SUM(DD.REVAL_AMORTIZATION), FND_CURRENCY.SAFE_GET_FORMAT_MASK(MAX(GLSB.CURRENCY_CODE),30)) REVAL_AMORTIZATION , CAT.CONCATENATED_SEGMENTS CATEGORY , GLCC.CONCATENATED_SEGMENTS ACCOUNTING_CONCATENATED FROM FA_ADDITIONS AD, FA_CATEGORIES_B_KFV CAT, FA_DEPRN_PERIODS DP, FA_BOOK_CONTROLS BC, GL_SETS_OF_BOOKS GLSB, FA_DISTRIBUTION_HISTORY DH, GL_CODE_COMBINATIONS_KFV GLCC, FA_DEPRN_DETAIL DD WHERE AD.ASSET_ID = DD.ASSET_ID AND AD.ASSET_CATEGORY_ID = CAT.CATEGORY_ID AND DD.BOOK_TYPE_CODE = BC.BOOK_TYPE_CODE AND BC.SET_OF_BOOKS_ID = GLSB.SET_OF_BOOKS_ID AND DD.PERIOD_COUNTER = DP.PERIOD_COUNTER AND DD.BOOK_TYPE_CODE = DP.BOOK_TYPE_CODE AND DD.DISTRIBUTION_ID = DH.DISTRIBUTION_ID AND GLCC.CODE_COMBINATION_ID = (DH.CODE_COMBINATION_ID + 0) AND DD.DEPRN_SOURCE_CODE = 'D' GROUP BY AD.ASSET_ID, DP.PERIOD_COUNTER, AD.ASSET_NUMBER, AD.DESCRIPTION, DP.BOOK_TYPE_CODE, DP.PERIOD_NAME, CAT.CONCATENATED_SEGMENTS, GLCC.CONCATENATED_SEGMENTS UNION SELECT AD.ASSET_ID ASSET_ID, AD.ASSET_NUMBER, AD.DESCRIPTION, DP.BOOK_TYPE_CODE BOOK_TYPE_CODE, DP.PERIOD_COUNTER PERIOD_COUNTER, DP.PERIOD_NAME PERIOD_ENTERED, TO_CHAR(NVL(SUM(DECODE(ADJ.ADJUSTMENT_TYPE, 'EXPENSE', DECODE(ADJ.DEBIT_CREDIT_FLAG, 'DR', ADJ.ADJUSTMENT_AMOUNT, 'CR', -1 * ADJ.ADJUSTMENT_AMOUNT))),0), FND_CURRENCY.SAFE_GET_FORMAT_MASK(MAX(GLSB.CURRENCY_CODE),30)) DEPRN_AMOUNT, TO_CHAR(0, FND_CURRENCY.SAFE_GET_FORMAT_MASK(MAX(GLSB.CURRENCY_CODE),30)) REVAL_AMORTIZATION, CAT.CONCATENATED_SEGMENTS, GLCC.CONCATENATED_SEGMENTS FROM FA_ADDITIONS AD, FA_CATEGORIES_B_KFV CAT, FA_BOOK_CONTROLS BC, GL_SETS_OF_BOOKS GLSB, GL_CODE_COMBINATIONS_KFV GLCC , FA_DEPRN_PERIODS DP, FA_ADJUSTMENTS ADJ WHERE ADJ.SOURCE_TYPE_CODE='DEPRECIATION' AND ADJ.ADJUSTMENT_TYPE='EXPENSE' AND ADJ.BOOK_TYPE_CODE=DP.BOOK_TYPE_CODE AND ADJ.BOOK_TYPE_CODE=BC.BOOK_TYPE_CODE AND BC.SET_OF_BOOKS_ID = GLSB.SET_OF_BOOKS_ID AND ADJ.PERIOD_COUNTER_CREATED = DP.PERIOD_COUNTER AND DP.PERIOD_CLOSE_DATE IS NULL AND ADJ.ASSET_ID=AD.ASSET_ID AND AD.ASSET_CATEGORY_ID = CAT.CATEGORY_ID AND ADJ.CODE_COMBINATION_ID = GLCC.CODE_COMBINATION_ID GROUP BY AD.ASSET_ID, PERIOD_COUNTER, AD.ASSET_NUMBER, AD.DESCRIPTION, DP.BOOK_TYPE_CODE, DP.PERIOD_NAME, CAT.CONCATENATED_SEGMENTS, GLCC.CONCATENATED_SEGMENTS

View Text - HTML Formatted

SELECT AD.ASSET_ID ASSET_ID
, AD.ASSET_NUMBER
, AD.DESCRIPTION
, DP.BOOK_TYPE_CODE BOOK_TYPE_CODE
, DP.PERIOD_COUNTER PERIOD_COUNTER
, DP.PERIOD_NAME PERIOD_ENTERED
, TO_CHAR(SUM(DD.DEPRN_AMOUNT)
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(MAX(GLSB.CURRENCY_CODE)
, 30)) DEPRN_AMOUNT
, TO_CHAR(SUM(DD.REVAL_AMORTIZATION)
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(MAX(GLSB.CURRENCY_CODE)
, 30)) REVAL_AMORTIZATION
, CAT.CONCATENATED_SEGMENTS CATEGORY
, GLCC.CONCATENATED_SEGMENTS ACCOUNTING_CONCATENATED
FROM FA_ADDITIONS AD
, FA_CATEGORIES_B_KFV CAT
, FA_DEPRN_PERIODS DP
, FA_BOOK_CONTROLS BC
, GL_SETS_OF_BOOKS GLSB
, FA_DISTRIBUTION_HISTORY DH
, GL_CODE_COMBINATIONS_KFV GLCC
, FA_DEPRN_DETAIL DD
WHERE AD.ASSET_ID = DD.ASSET_ID
AND AD.ASSET_CATEGORY_ID = CAT.CATEGORY_ID
AND DD.BOOK_TYPE_CODE = BC.BOOK_TYPE_CODE
AND BC.SET_OF_BOOKS_ID = GLSB.SET_OF_BOOKS_ID
AND DD.PERIOD_COUNTER = DP.PERIOD_COUNTER
AND DD.BOOK_TYPE_CODE = DP.BOOK_TYPE_CODE
AND DD.DISTRIBUTION_ID = DH.DISTRIBUTION_ID
AND GLCC.CODE_COMBINATION_ID = (DH.CODE_COMBINATION_ID + 0)
AND DD.DEPRN_SOURCE_CODE = 'D' GROUP BY AD.ASSET_ID
, DP.PERIOD_COUNTER
, AD.ASSET_NUMBER
, AD.DESCRIPTION
, DP.BOOK_TYPE_CODE
, DP.PERIOD_NAME
, CAT.CONCATENATED_SEGMENTS
, GLCC.CONCATENATED_SEGMENTS UNION SELECT AD.ASSET_ID ASSET_ID
, AD.ASSET_NUMBER
, AD.DESCRIPTION
, DP.BOOK_TYPE_CODE BOOK_TYPE_CODE
, DP.PERIOD_COUNTER PERIOD_COUNTER
, DP.PERIOD_NAME PERIOD_ENTERED
, TO_CHAR(NVL(SUM(DECODE(ADJ.ADJUSTMENT_TYPE
, 'EXPENSE'
, DECODE(ADJ.DEBIT_CREDIT_FLAG
, 'DR'
, ADJ.ADJUSTMENT_AMOUNT
, 'CR'
, -1 * ADJ.ADJUSTMENT_AMOUNT)))
, 0)
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(MAX(GLSB.CURRENCY_CODE)
, 30)) DEPRN_AMOUNT
, TO_CHAR(0
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(MAX(GLSB.CURRENCY_CODE)
, 30)) REVAL_AMORTIZATION
, CAT.CONCATENATED_SEGMENTS
, GLCC.CONCATENATED_SEGMENTS
FROM FA_ADDITIONS AD
, FA_CATEGORIES_B_KFV CAT
, FA_BOOK_CONTROLS BC
, GL_SETS_OF_BOOKS GLSB
, GL_CODE_COMBINATIONS_KFV GLCC
, FA_DEPRN_PERIODS DP
, FA_ADJUSTMENTS ADJ
WHERE ADJ.SOURCE_TYPE_CODE='DEPRECIATION'
AND ADJ.ADJUSTMENT_TYPE='EXPENSE'
AND ADJ.BOOK_TYPE_CODE=DP.BOOK_TYPE_CODE
AND ADJ.BOOK_TYPE_CODE=BC.BOOK_TYPE_CODE
AND BC.SET_OF_BOOKS_ID = GLSB.SET_OF_BOOKS_ID
AND ADJ.PERIOD_COUNTER_CREATED = DP.PERIOD_COUNTER
AND DP.PERIOD_CLOSE_DATE IS NULL
AND ADJ.ASSET_ID=AD.ASSET_ID
AND AD.ASSET_CATEGORY_ID = CAT.CATEGORY_ID
AND ADJ.CODE_COMBINATION_ID = GLCC.CODE_COMBINATION_ID GROUP BY AD.ASSET_ID
, PERIOD_COUNTER
, AD.ASSET_NUMBER
, AD.DESCRIPTION
, DP.BOOK_TYPE_CODE
, DP.PERIOD_NAME
, CAT.CONCATENATED_SEGMENTS
, GLCC.CONCATENATED_SEGMENTS