FA Mass Reclassification Preview - draft

SELECT     ASSET_NUMBER,
	BOOK,
	OLD_CATEGORY,
	CONVENTION,
	METHOD,
	LIFE,
	BASIC_RATE,
	ADJUSTED_RATE,
	PRODUCTION_CAPACITY,
	DEPRECIATE_FLAG,
	SALVAGE_VAL_PERCENTAGE, 
	FA_FASRCPVW_XMLP_PKG.d_basic_rateformula(FA_MASS_RECLASS_ITF.BASIC_RATE) D_BASIC_RATE, 
	FA_FASRCPVW_XMLP_PKG.d_adjusted_rateformula(FA_MASS_RECLASS_ITF.ADJUSTED_RATE) D_ADJUSTED_RATE, 
	FA_FASRCPVW_XMLP_PKG.d_salvage_val_pctformula(FA_MASS_RECLASS_ITF.SALVAGE_VAL_PERCENTAGE) D_SALVAGE_VAL_PCT, 
	FA_FASRCPVW_XMLP_PKG.d_same_catformula(FA_MASS_RECLASS_ITF.OLD_CATEGORY) D_SAME_CAT
FROM FA_MASS_RECLASS_ITF
WHERE	REQUEST_ID = :P_REQUEST_ID_1
ORDER BY	ASSET_NUMBER, BOOK

SELECT ASSET_NUMBER, BOOK, OLD_CATEGORY, CONVENTION, METHOD, LIFE, BASIC_RATE, ADJUSTED_RATE, PRODUCTION_CAPACITY, DEPRECIATE_FLAG, SALVAGE_VAL_PERCENTAGE, FA_FASRCPVW_XMLP_PKG.d_basic_rateformula(FA_MASS_RECLASS_ITF.BASIC_RATE) D_BASIC_RATE, FA_FASRCPVW_XMLP_PKG.d_adjusted_rateformula(FA_MASS_RECLASS_ITF.ADJUSTED_RATE) D_ADJUSTED_RATE, FA_FASRCPVW_XMLP_PKG.d_salvage_val_pctformula(FA_MASS_RECLASS_ITF.SALVAGE_VAL_PERCENTAGE) D_SALVAGE_VAL_PCT, FA_FASRCPVW_XMLP_PKG.d_same_catformula(FA_MASS_RECLASS_ITF.OLD_CATEGORY) D_SAME_CAT FROM FA_MASS_RECLASS_ITF WHERE REQUEST_ID = :P_REQUEST_ID_1 ORDER BY ASSET_NUMBER, BOOK