ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4703551A9E05362FB09050512 SELECT &CAT_FLEX_ALL_SEG Category, th.transaction_header_id TH_ID, th.mass_transaction_id Reval_Id, th.asset_id Asset_Id, ad.asset_number Asset_Number, ad.asset_category_id Asset_Class, ad.description, bkold.cost Old_Cost, bknew.cost New_Cost, bknew.cost - bkold.cost Adj_Cost, mrevr.reval_percent, mrev.book_type_code, JA_JAAUFREV_XMLP_PKG.C_OLD_REVAL_RSVFORMULA (th.asset_id,th.book_type_code,th.transaction_header_id) C_OLD_REVAL_RSV, JA_JAAUFREV_XMLP_PKG.C_OLD_DEP_RSVFORMULA (th.asset_id,th.book_type_code,th.transaction_header_id) C_OLD_DEP_RSV, JA_JAAUFREV_XMLP_PKG.C_NEW_DEP_RSVFORMULA(th.transaction_header_id,mrev.book_type_code,th.asset_id) C_NEW_DEP_RSV, JA_JAAUFREV_XMLP_PKG.C_CATEGORYFORMULA(ad.asset_category_id) C_CATEGORY FROM fa_transaction_headers th, fa_additions ad, fa_books bknew, fa_books bkold, fa_mass_revaluations mrev, fa_mass_revaluation_rules mrevr, fa_categories cat WHERE th.mass_transaction_id = :P_MASS_REVAL_ID and th.book_type_code = :P_BOOK_TYPE_CODE and th.transaction_type_code = 'REVALUATION' and th.asset_id = ad.asset_id and cat.category_id = ad.asset_category_id and ad.asset_category_id like decode(:P_ASSET_CLASS,null,'%',:P_ASSET_CLASS) and th.mass_transaction_id = mrev.mass_reval_id and mrev.status = 'COMPLETED' and th.mass_transaction_id = mrevr.mass_reval_id and th.transaction_header_id = bkold.transaction_header_id_out and th.transaction_header_id = bknew.transaction_header_id_in and (th.asset_id = mrevr.asset_id or cat.category_id = mrevr.category_id) ORDER BY ad.asset_category_id, ad.asset_number Y JA JAAUFREV_XML JA JA オーストラリア資産再評価レポート Imported from BI Publisher Description: オーストラリア資産再評価レポート Application: Asia/Pacific Localizations Source: オーストラリア資産再評価レポート(XML) Short Name: JAAUFREV_XML DB package: JA_JAAUFREV_XMLP_PKG KO JA 오스트레일리아 자산 재평가 보고서 Imported from BI Publisher Description: 오스트레일리아 자산 재평가 보고서 Application: Asia/Pacific Localizations Source: 오스트레일리아 자산 재평가 보고서(XML) Short Name: JAAUFREV_XML DB package: JA_JAAUFREV_XMLP_PKG US JA Australian Assets Revaluation Report- Not Supported: Reserved For Future Use - Not Supported: Reserved For Future Use Imported from BI Publisher Description: Australian Assets Revaluation Report Application: Asia/Pacific Localizations Source: Australian Assets Revaluation Report (XML) - Not Supported: Reserved For Future Use - Not Supported: Reserved For Future Use Short Name: JAAUFREV_XML DB package: JA_JAAUFREV_XMLP_PKG ZHS JA 澳大利亚资产重估报表- 不支持：已保留供将来使用 Imported from BI Publisher Description: 澳大利亚资产重估报表 Application: 亚太地区本地化 Source: 澳大利亚资产重估报表 (XML) - 不支持：已保留供将来使用 Short Name: JAAUFREV_XML DB package: JA_JAAUFREV_XMLP_PKG BI Publisher &cat_flex_all_seg :p_asset_class :p_book_type_code :p_conc_request_id :p_dummy :p_mass_reval_id :reserve 1 -20 :p_dummy Number select category_flex_structure from fa_system_controls Y US FND_NUMBER Dummy Parameter ZHS FND_NUMBER 虚拟参数 2 10 :p_mass_reval_id LOV Oracle JAAU_FA_MASS_REVALUATION_ID Y select mass_transaction_id id, mass_transaction_id value, null description from fa_transaction_headers th1 where transaction_type_code='REVALUATION' and rowid=(select max(rowid) from fa_transaction_headers th2 where th1.mass_transaction_id=th2.mass_transaction_id) order by 1 Y US Transaction Number MAS Transaction Number ZHS 事务处理编号 MAS 事务处理编号 3 20 :p_book_type_code LOV Oracle FA_BOOK_TYPE Y select book_type_code id, book_type_code value, book_type_name description from fa_book_controls_sec order by book_type_code Y US Asset Book Asset Book Type ZHS 资产账簿 资产账簿类型 4 30 :p_asset_class Char US Category Asset Category ZHS 类别 资产类别