VIEW: APPS.FA_TRANSACTIONS_V

Source

View Text - Preformatted

SELECT th.asset_id, ad.asset_number, adtl.description, th.transaction_header_id, th.transaction_type_code, th.book_type_code, th.invoice_transaction_id, th.trx_reference_id, dp.period_counter, dp.period_name from fa_transaction_headers th, fa_additions_b ad, fa_additions_tl adtl, fa_deprn_periods dp WHERE th.asset_id = ad.asset_id and adtl.asset_id = ad.asset_id and adtl.language = USERENV('LANG') and th.book_type_code = dp.book_type_code and th.date_effective between dp.period_open_date and nvl(dp.period_close_date, sysdate) UNION SELECT th.asset_id, ad.asset_number, adtl.description, th.transaction_header_id, th.transaction_type_code, dp.book_type_code, th.invoice_transaction_id, th.trx_reference_id, dp.period_counter, dp.period_name from fa_transaction_headers th, fa_additions_b ad, fa_additions_tl adtl, fa_deprn_periods dp, fa_book_controls fbc WHERE th.asset_id = ad.asset_id and adtl.asset_id = ad.asset_id and adtl.language = USERENV('LANG') and th.book_type_code = fbc.distribution_source_book and fbc.book_type_code = dp.book_type_code and th.transaction_type_code in ( 'TRANSFER','RECLASS', 'UNIT ADJUSTMENT','REINSTATEMENT','TRANSFER OUT') and th.date_effective between dp.period_open_date and nvl(dp.period_close_date, sysdate)

View Text - HTML Formatted

SELECT TH.ASSET_ID
, AD.ASSET_NUMBER
, ADTL.DESCRIPTION
, TH.TRANSACTION_HEADER_ID
, TH.TRANSACTION_TYPE_CODE
, TH.BOOK_TYPE_CODE
, TH.INVOICE_TRANSACTION_ID
, TH.TRX_REFERENCE_ID
, DP.PERIOD_COUNTER
, DP.PERIOD_NAME
FROM FA_TRANSACTION_HEADERS TH
, FA_ADDITIONS_B AD
, FA_ADDITIONS_TL ADTL
, FA_DEPRN_PERIODS DP
WHERE TH.ASSET_ID = AD.ASSET_ID
AND ADTL.ASSET_ID = AD.ASSET_ID
AND ADTL.LANGUAGE = USERENV('LANG')
AND TH.BOOK_TYPE_CODE = DP.BOOK_TYPE_CODE
AND TH.DATE_EFFECTIVE BETWEEN DP.PERIOD_OPEN_DATE
AND NVL(DP.PERIOD_CLOSE_DATE
, SYSDATE) UNION SELECT TH.ASSET_ID
, AD.ASSET_NUMBER
, ADTL.DESCRIPTION
, TH.TRANSACTION_HEADER_ID
, TH.TRANSACTION_TYPE_CODE
, DP.BOOK_TYPE_CODE
, TH.INVOICE_TRANSACTION_ID
, TH.TRX_REFERENCE_ID
, DP.PERIOD_COUNTER
, DP.PERIOD_NAME
FROM FA_TRANSACTION_HEADERS TH
, FA_ADDITIONS_B AD
, FA_ADDITIONS_TL ADTL
, FA_DEPRN_PERIODS DP
, FA_BOOK_CONTROLS FBC
WHERE TH.ASSET_ID = AD.ASSET_ID
AND ADTL.ASSET_ID = AD.ASSET_ID
AND ADTL.LANGUAGE = USERENV('LANG')
AND TH.BOOK_TYPE_CODE = FBC.DISTRIBUTION_SOURCE_BOOK
AND FBC.BOOK_TYPE_CODE = DP.BOOK_TYPE_CODE
AND TH.TRANSACTION_TYPE_CODE IN ( 'TRANSFER'
, 'RECLASS'
, 'UNIT ADJUSTMENT'
, 'REINSTATEMENT'
, 'TRANSFER OUT')
AND TH.DATE_EFFECTIVE BETWEEN DP.PERIOD_OPEN_DATE
AND NVL(DP.PERIOD_CLOSE_DATE
, SYSDATE)