Product: | OFA - Assets |
---|---|
Description: | |
Implementation/DBA Data: | APPS.FA_ADJUSTMENTS_MRC_V |
SELECT FMCADJ.SET_OF_BOOKS_ID
, FMCADJ.TRANSACTION_HEADER_ID
, FMCADJ.SOURCE_TYPE_CODE
, FMCADJ.ADJUSTMENT_TYPE
, FMCADJ.DEBIT_CREDIT_FLAG
, FMCADJ.CODE_COMBINATION_ID
, FMCADJ.BOOK_TYPE_CODE
, FMCADJ.ASSET_ID
, FMCADJ.ADJUSTMENT_AMOUNT
, FMCADJ.DISTRIBUTION_ID
, FMCADJ.LAST_UPDATE_DATE
, FMCADJ.LAST_UPDATED_BY
, FMCADJ.LAST_UPDATE_LOGIN
, FMCADJ.ANNUALIZED_ADJUSTMENT
, FMCADJ.JE_HEADER_ID
, FMCADJ.JE_LINE_NUM
, FMCADJ.PERIOD_COUNTER_ADJUSTED
, FMCADJ.PERIOD_COUNTER_CREATED
, FMCADJ.ASSET_INVOICE_ID
, FMCADJ.GLOBAL_ATTRIBUTE1
, FMCADJ.GLOBAL_ATTRIBUTE2
, FMCADJ.GLOBAL_ATTRIBUTE3
, FMCADJ.GLOBAL_ATTRIBUTE4
, FMCADJ.GLOBAL_ATTRIBUTE5
, FMCADJ.GLOBAL_ATTRIBUTE6
, FMCADJ.GLOBAL_ATTRIBUTE7
, FMCADJ.GLOBAL_ATTRIBUTE8
, FMCADJ.GLOBAL_ATTRIBUTE9
, FMCADJ.GLOBAL_ATTRIBUTE10
, FMCADJ.GLOBAL_ATTRIBUTE11
, FMCADJ.GLOBAL_ATTRIBUTE12
, FMCADJ.GLOBAL_ATTRIBUTE13
, FMCADJ.GLOBAL_ATTRIBUTE14
, FMCADJ.GLOBAL_ATTRIBUTE15
, FMCADJ.GLOBAL_ATTRIBUTE16
, FMCADJ.GLOBAL_ATTRIBUTE17
, FMCADJ.GLOBAL_ATTRIBUTE18
, FMCADJ.GLOBAL_ATTRIBUTE19
, FMCADJ.GLOBAL_ATTRIBUTE20
, FMCADJ.GLOBAL_ATTRIBUTE_CATEGORY
, FMCADJ.DEPRN_OVERRIDE_FLAG
, FMCADJ.TRACK_MEMBER_FLAG
, FMCADJ.SOURCE_DEST_CODE
, FMCADJ.SOURCE_LINE_ID
, FMCADJ.ADJUSTMENT_LINE_ID
FROM FA_MC_ADJUSTMENTS FMCADJ
WHERE FMCADJ.SET_OF_BOOKS_ID = NVL(TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO')
, 45
, 10))
, -1)