FND Design Data [Home] [Help]

View: FABV_TRANS_LINES

Product: OFA - Assets
Description: - Retrofitted
Implementation/DBA Data: ViewAPPS.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