FA_ADJ_RATES_INT_V

Details

  • Schema: FUSION

  • Object owner: FA

  • Object type: VIEW

Columns

Name

BOOK_TRANSACTION_RATE_ID

TRANSACTION_INTERFACE_ID

INTERFACE_TYPE_CODE

BOOK_TYPE_CODE

SET_OF_BOOKS_ID

LINE_ID

INTERFACE_LINE_NUMBER

FIXED_ASSETS_COST

EXCHANGE_RATE

CURRENCY_CODE

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

LOAD_REQUEST_ID

Query

SQL_Statement

SELECT BOOK_TRANSACTION_RATE_ID

,TRANSACTION_INTERFACE_ID

,INTERFACE_TYPE_CODE

,BOOK_TYPE_CODE

,SET_OF_BOOKS_ID

,LINE_ID

,INTERFACE_LINE_NUMBER

,FIXED_ASSETS_COST

,EXCHANGE_RATE

,CURRENCY_CODE

,CREATED_BY

,CREATION_DATE

,LAST_UPDATED_BY

,LAST_UPDATE_DATE

,LAST_UPDATE_LOGIN

,OBJECT_VERSION_NUMBER

,LOAD_REQUEST_ID

FROM FA_BOOK_TRANSACTION_RATES_INT

WHERE INTERFACE_TYPE_CODE = 'ADJUSTMENT'