[Home] [Help]
View: FA_TRANSACTIONS_V
View Text
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)
Columns
Name |
ASSET_ID |
ASSET_NUMBER |
DESCRIPTION |
TRANSACTION_HEADER_ID |
TRANSACTION_TYPE_CODE |
BOOK_TYPE_CODE |
INVOICE_TRANSACTION_ID |
TRX_REFERENCE_ID |
PERIOD_COUNTER |
PERIOD_NAME |