[Home] [Help]
View: FABV_TRANS_HDRS
View Text
SELECT TH.TRANSACTION_HEADER_ID
, TH.TRANSACTION_TYPE_CODE
, TH.TRANSACTION_DATE_ENTERED
, TH.TRANSACTION_NAME
, AJ.SOURCE_TYPE_CODE
, TH.BOOK_TYPE_CODE
, TH.ASSET_ID
, AJ.LAST_UPDATE_DATE
, AJ.LAST_UPDATED_BY
FROM FA_TRANSACTION_HEADERS TH
, FA_ADJUSTMENTS AJ
WHERE AJ.TRANSACTION_HEADER_ID = TH.TRANSACTION_HEADER_ID
AND AJ.BOOK_TYPE_CODE = TH.BOOK_TYPE_CODE
AND AJ.ASSET_ID = TH.ASSET_ID WITH READ ONLY
Columns
Name |
TRANSACTION_HEADER_ID |
TRANSACTION_TYPE_CODE |
TRANSACTION_DATE_ENTERED |
COMMENTS |
GL_BATCH_NAME |
BOOK_TYPE_CODE |
ASSET_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |