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 |
