Product: | OFA - Assets |
---|---|
Description: | |
Implementation/DBA Data: | APPS.FA_BOOKS_GROUPS_MRC_V |
SELECT IMBG.SET_OF_BOOKS_ID
, IMBG.BOOK_TYPE_CODE
, IMBG.GROUP_ASSET_ID
, IMBG.COST
, IMBG.ORIGINAL_COST
, IMBG.SALVAGE_VALUE
, IMBG.ADJUSTED_COST
, IMBG.ADJUSTED_RECOVERABLE_COST
, IMBG.RECOVERABLE_COST
, IMBG.COST_CHANGE_FLAG
, IMBG.TRANSACTION_HEADER_ID_IN
, IMBG.TRANSACTION_HEADER_ID_OUT
, IMBG.PERIOD_COUNTER_LIFE_COMPLETE
, IMBG.PERIOD_COUNTER
, IMBG.BEGINNING_BALANCE_FLAG
, IMBG.DATE_EFFECTIVE
, IMBG.DATE_INEFFECTIVE
, IMBG.IDLED_FLAG
, IMBG.ITC_AMOUNT
, IMBG.ITC_AMOUNT_ID
, IMBG.ITC_BASIS
, IMBG.PERCENT_SALVAGE_VALUE
, IMBG.PERIOD_COUNTER_CAPITALIZED
, IMBG.PERIOD_COUNTER_FULLY_RESERVED
, IMBG.PERIOD_COUNTER_FULLY_RETIRED
, IMBG.RETIREMENT_ID
, IMBG.RETIREMENT_PENDING_FLAG
, IMBG.TAX_REQUEST_ID
, IMBG.CAPITALIZE_FLAG
, IMBG.YTD_PROCEEDS
, IMBG.LTD_PROCEEDS
, IMBG.LAST_UPDATED_BY
, IMBG.LAST_UPDATE_DATE
, IMBG.LAST_UPDATE_LOGIN
, IMBG.CREATED_BY
, IMBG.CREATION_DATE
, IMBG.GLOBAL_ATTRIBUTE1
, IMBG.GLOBAL_ATTRIBUTE2
, IMBG.GLOBAL_ATTRIBUTE3
, IMBG.GLOBAL_ATTRIBUTE4
, IMBG.GLOBAL_ATTRIBUTE5
, IMBG.GLOBAL_ATTRIBUTE6
, IMBG.GLOBAL_ATTRIBUTE7
, IMBG.GLOBAL_ATTRIBUTE8
, IMBG.GLOBAL_ATTRIBUTE9
, IMBG.GLOBAL_ATTRIBUTE10
, IMBG.GLOBAL_ATTRIBUTE11
, IMBG.GLOBAL_ATTRIBUTE12
, IMBG.GLOBAL_ATTRIBUTE13
, IMBG.GLOBAL_ATTRIBUTE14
, IMBG.GLOBAL_ATTRIBUTE15
, IMBG.GLOBAL_ATTRIBUTE16
, IMBG.GLOBAL_ATTRIBUTE17
, IMBG.GLOBAL_ATTRIBUTE18
, IMBG.GLOBAL_ATTRIBUTE19
, IMBG.GLOBAL_ATTRIBUTE20
FROM FA_MC_BOOKS_GROUPS IMBG
WHERE IMBG.SET_OF_BOOKS_ID = NVL(TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO')
, 45
, 10))
, -1)