VIEW: APPS.FA_BOOKS_GROUPS_MRC_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)