Skip to content
[Home] [Help]
View: FABV_TRANS_LINES
View Text
SELECT ADJUSTMENT_TYPE
, DECODE(DEBIT_CREDIT_FLAG
, 'DR'
, ADJUSTMENT_AMOUNT)
, DECODE(DEBIT_CREDIT_FLAG
, 'CR'
, ADJUSTMENT_AMOUNT)
, TRANSACTION_HEADER_ID
, SOURCE_TYPE_CODE
, BOOK_TYPE_CODE
, ASSET_ID
, CODE_COMBINATION_ID
, DISTRIBUTION_ID
, PERIOD_COUNTER_ADJUSTED
, PERIOD_COUNTER_CREATED
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
FROM FA_ADJUSTMENTS WITH READ ONLY
Columns
| Name |
| ACCOUNT_TYPE |
| DEBIT_AMOUNT |
| CREDIT_AMOUNT |
| TRANSACTION_HEADER_ID |
| SOURCE_TYPE_CODE |
| BOOK_TYPE_CODE |
| ASSET_ID |
| CODE_COMBINATION_ID |
| DISTRIBUTION_ID |
| PERIOD_COUNTER_ADJUSTED |
| PERIOD_COUNTER_CREATED |
| LAST_UPDATE_DATE |
| LAST_UPDATED_BY |