VIEW: APPS.FA_FIN_INQRY_UPL_WEB_V

Source

View Text - Preformatted

SELECT TH.TRANSACTION_HEADER_ID , TH.BOOK_TYPE_CODE , TH.ASSET_ID , TH.TRANSACTION_TYPE_CODE , TH.TRANSACTION_SUBTYPE , LU.MEANING , AD.CODE_COMBINATION_ID , TO_CHAR(NVL(SUM(DECODE(AD.ADJUSTMENT_TYPE,'EXPENSE', DECODE(AD.DEBIT_CREDIT_FLAG, 'DR',AD.ADJUSTMENT_AMOUNT, 'CR',-1 * AD.ADJUSTMENT_AMOUNT))),0), FND_CURRENCY.SAFE_GET_FORMAT_MASK(MAX(GLSB.CURRENCY_CODE),30)) ADJUSTMENT_AMOUNT , GLCC.CONCATENATED_SEGMENTS ACCT_CONC_SEGMENTS FROM FA_TRANSACTION_HEADERS TH, FA_BOOK_CONTROLS BC, GL_SETS_OF_BOOKS GLSB, GL_CODE_COMBINATIONS_KFV GLCC, FA_ADJUSTMENTS AD, FA_LOOKUPS LU WHERE LU.LOOKUP_TYPE(+)='UNPLANNED DEPRN' AND TH.TRANSACTION_SUBTYPE=LU.LOOKUP_CODE(+) AND TH.TRANSACTION_HEADER_ID=AD.TRANSACTION_HEADER_ID AND TH.TRANSACTION_TYPE_CODE='ADJUSTMENT' AND TH.TRANSACTION_KEY IN ('U', 'UA', 'UE') AND GLSB.SET_OF_BOOKS_ID = BC.SET_OF_BOOKS_ID AND GLCC.CODE_COMBINATION_ID = AD.CODE_COMBINATION_ID AND GLCC.CHART_OF_ACCOUNTS_ID = BC.ACCOUNTING_FLEX_STRUCTURE AND BC.BOOK_TYPE_CODE = AD.BOOK_TYPE_CODE GROUP BY TH.TRANSACTION_HEADER_ID, TH.BOOK_TYPE_CODE, TH.ASSET_ID, TH.TRANSACTION_TYPE_CODE, TH.TRANSACTION_SUBTYPE, LU.MEANING, AD.CODE_COMBINATION_ID, GLCC.CONCATENATED_SEGMENTS

View Text - HTML Formatted

SELECT TH.TRANSACTION_HEADER_ID
, TH.BOOK_TYPE_CODE
, TH.ASSET_ID
, TH.TRANSACTION_TYPE_CODE
, TH.TRANSACTION_SUBTYPE
, LU.MEANING
, AD.CODE_COMBINATION_ID
, TO_CHAR(NVL(SUM(DECODE(AD.ADJUSTMENT_TYPE
, 'EXPENSE'
, DECODE(AD.DEBIT_CREDIT_FLAG
, 'DR'
, AD.ADJUSTMENT_AMOUNT
, 'CR'
, -1 * AD.ADJUSTMENT_AMOUNT)))
, 0)
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(MAX(GLSB.CURRENCY_CODE)
, 30)) ADJUSTMENT_AMOUNT
, GLCC.CONCATENATED_SEGMENTS ACCT_CONC_SEGMENTS
FROM FA_TRANSACTION_HEADERS TH
, FA_BOOK_CONTROLS BC
, GL_SETS_OF_BOOKS GLSB
, GL_CODE_COMBINATIONS_KFV GLCC
, FA_ADJUSTMENTS AD
, FA_LOOKUPS LU
WHERE LU.LOOKUP_TYPE(+)='UNPLANNED DEPRN'
AND TH.TRANSACTION_SUBTYPE=LU.LOOKUP_CODE(+)
AND TH.TRANSACTION_HEADER_ID=AD.TRANSACTION_HEADER_ID
AND TH.TRANSACTION_TYPE_CODE='ADJUSTMENT'
AND TH.TRANSACTION_KEY IN ('U'
, 'UA'
, 'UE')
AND GLSB.SET_OF_BOOKS_ID = BC.SET_OF_BOOKS_ID
AND GLCC.CODE_COMBINATION_ID = AD.CODE_COMBINATION_ID
AND GLCC.CHART_OF_ACCOUNTS_ID = BC.ACCOUNTING_FLEX_STRUCTURE
AND BC.BOOK_TYPE_CODE = AD.BOOK_TYPE_CODE GROUP BY TH.TRANSACTION_HEADER_ID
, TH.BOOK_TYPE_CODE
, TH.ASSET_ID
, TH.TRANSACTION_TYPE_CODE
, TH.TRANSACTION_SUBTYPE
, LU.MEANING
, AD.CODE_COMBINATION_ID
, GLCC.CONCATENATED_SEGMENTS