FA Mass Reclassification Review - draft

Description
Categories: BI Publisher
Columns: Asset Number, Book, New Category, Convention, Method, Life, Basic Rate, Adjusted Rate, Production Capacity, Depreciate Flag ...
Application: Assets
Source: Mass Reclassification Review Report (XML) - Not Supported: Reserved For Future Use
Short Name: FASRCRVW_XML
DB package: FA_FASRCRVW_XMLP_PKG
SELECT     ASSET_NUMBER,
	BOOK,
	NEW_CATEGORY,
	CONVENTION,
	METHOD,
	LIFE,
	BASIC_RATE,
	ADJUSTED_RATE,
	PRODUCTION_CAPACITY,
	DEPRECIATE_FLAG,
	SALVAGE_VAL_PERCENTAGE,
	FA_FASRCRVW_XMLP_PKG.d_basic_rateformula(FA_MASS_RECLASS_ITF.BASIC_RATE) D_BASIC_RATE,
	FA_FASRCRVW_XMLP_PKG.d_adjusted_rateformula(FA_MASS_RECLASS_ITF.ADJUSTED_RATE) D_ADJUSTED_RATE,
	FA_FASRCRVW_XMLP_PKG.d_salvage_val_pctformula(FA_MASS_RECLASS_ITF.SALVAGE_VAL_PERCENTAGE) D_SALVAGE_VAL_PCT
FROM FA_MASS_RECLASS_ITF
WHERE	REQUEST_ID = :P_REQUEST_ID_T
ORDER BY	ASSET_NUMBER, BOOK