[Home] [Help]
| Product: | OFA - Assets |
|---|---|
| Description: | - Retrofitted |
| Implementation/DBA Data: |
APPS.FABV_TRANS_LINES
|
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