VIEW: APPS.FA_ADJUSTMENTS_MRC_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)