FA Mass Reclassification Preview - draft

Description
Categories: BI Publisher
Application: Assets
Source: Mass Reclassification Preview Report (XML) - Not Supported: Reserved For Future Use
Short Name: FASRCPVW_XML
DB package: FA_FASRCPVW_XMLP_PKG
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
Ask a question