FA Mass Revaluation Preview - draft

Description
Categories: BI Publisher
Application: Assets
Source: Mass Revaluation Preview Report (XML) - Not Supported: Reserved For Future Use
Short Name: FASRVPVW_XML
DB package: FA_FASRVPVW_XMLP_PKG
SELECT &CAT_FLEX   CATEGORY,
       mri.ASSET_ID,
       mri.ASSET_NUMBER,
       mri.ASSET_TYPE,
       mri.ASSET_CATEGORY_ID,
       AD.CURRENT_UNITS,
       mri.OLD_COST 	COST,
       mri.OLD_LIFE     LIFE_IN_MONTHS,
       MRI.REVAL_CEILING,
       ''     BOOKS_ROWID,
       mri.NEW_COST,
       mri.OLD_DEPRN_RESERVE     DEP_RSV,
       mri.NEW_DEPRN_RESERVE     NEW_DEP_RSV,
       mri.NEW_LIFE              NEW_LIFE,
       mri.OLD_REVAL_RESERVE     REVAL_RSV,
       mri.NEW_REVAL_RESERVE     NEW_REVAL_RSV,
       mri.REVAL_PERCENT         REVAL_PCT,
       mri.LIFE_EXTENSION_FACTOR ASS_LEF,
       mri.LIFE_EXTENSION_CEILING ASS_LEC ,
       mri.reval_fully_rsvd,
       mri.max_fully_rsvd_revals, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('d_category', 'OFA', 'CAT#', 101, NULL, CAT.CATEGORY_ID, 'ALL', 'Y', 'VALUE') D_CATEGORY, 
	&reval_fully_rsvd D_FRRF, 
	FA_FASRVPVW_XMLP_PKG.d_mfrrformula(:D_MFRR) D_MFRR, 
	FA_FASRVPVW_XMLP_PKG.d_reval_pctformula(:D_REVAL_PCT) D_REVAL_PCT, 
	&d_lef D_LEF, 
	&d_lec D_LEC, 
	&d_found D_FOUND, 
	FA_FASRVPVW_XMLP_PKG.d_lifeformula(mri.OLD_LIFE) D_LIFE, 
	FA_FASRVPVW_XMLP_PKG.d_new_lifeformula(mri.NEW_LIFE) D_NEW_LIFE, 
	&LIFE_IND LIFE_IND, 
	FA_FASRVPVW_XMLP_PKG.d_life_indformula(:LIFE_IND) D_LIFE_IND, 
	FA_FASRVPVW_XMLP_PKG.d_ass_mfrrformula(:D_ASS_MFRR) D_ASS_MFRR, 
	FA_FASRVPVW_XMLP_PKG.d_ass_reval_pctformula(mri.REVAL_PERCENT) D_ASS_REVAL_PCT, 
	&D_ASS_FOUND D_ASS_FOUND,
	FA_FASRVPVW_XMLP_PKG.D_ASS_FRRF_p D_ASS_FRRF
FROM   FA_MASS_REVAL_REP_ITF MRI,
       FA_CATEGORIES CAT,
       FA_ADDITIONS_B AD
WHERE  MRI.MASS_REVAL_ID = :P_MASS_REVAL_ID1
AND MRI.REQUEST_ID = :P_CONC_REQUEST2_ID
  AND  MRI.ASSET_ID = AD.ASSET_ID
  AND  AD.ASSET_CATEGORY_ID = CAT.CATEGORY_ID
 ORDER BY 3