FA Mass Reclassification Preview - draft

➜ Back to Library
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
Download
Related Blitz Reports
FA Mass Reclassification Review - draft FA Asset Impairments FA Mass Revaluation Preview - draft FA Mass Additions Posting - draft FA Asset Cost FA CIP Statistics for the Central Statistical Office (KSH) (Hungary) (1) XXEUCL FA Asset Cost Insert FA CIP Statistics for the Central Statistical Office (KSH) (Hungary) FA Additions By Source
Blitz Report™