ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D470AF51A9E05362FB09050512 SELECT ad.asset_category_id category_id, &C_ALL_SEGS category_segs, ad.asset_number||' - '||ad.description description, bk.global_attribute4 appraisal_id, to_date(bk.global_attribute5,'YYYY/MM/DD HH24:MI:SS') appraisal_date, to_number(bk.global_attribute6) appraisal_value, to_number(nvl(bk.global_attribute2,0)) current_valuation, to_number(nvl(bk.global_attribute3,0)) prior_valuation, fnd_flex_xml_publisher_apis.process_kff_combination_1('cat_flex_all_segs', 'OFA', 'CAT#', 101, NULL, ct.CATEGORY_ID, 'ALL', 'Y', 'DESCRIPTION') cat_flex_all_segs, JL_JLCOFARR_XMLP_PKG.f_net_valformula(to_number ( nvl ( bk.global_attribute2 , 0 ) ), to_number ( nvl ( bk.global_attribute3 , 0 ) )) f_net_val, JL_JLCOFARR_XMLP_PKG.f_app_valuationformula(to_number ( bk.global_attribute6 ), to_number ( nvl ( bk.global_attribute2 , 0 ) )) f_app_valuation, JL_JLCOFARR_XMLP_PKG.formula2formula(:Cs_appraisal_value) formula2 FROM fa_additions ad, fa_books bk, fa_categories ct WHERE bk.book_type_code = upper(:p_book_type_code) AND ad.asset_category_id = decode(:p_category_id,null,ad.asset_category_id, :p_category_id) AND bk.asset_id = ad.asset_id AND bk.transaction_header_id_out IS NULL AND bk.date_ineffective IS NULL AND bk.global_attribute2 IS NOT NULL AND bk.global_attribute3 IS NOT NULL AND ct.category_id = ad.asset_category_id ORDER BY category_segs,description JL JLCOFARR_XML US JL Colombian Fixed Assets Technical Appraisal Revaluation Report- Not Supported: Reserved For Future Use Imported from BI Publisher Description: Colombian Fixed Assets Technical Appraisal Revaluation Report Application: Latin America Localizations Source: Colombian Fixed Assets Technical Appraisal Revaluation Report (XML) - Not Supported: Reserved For Future Use Short Name: JLCOFARR_XML DB package: JL_JLCOFARR_XMLP_PKG BI Publisher &c_all_segs :c_all_segs :c_app_valuation :c_company_name :c_status :cat_flex_struct :cp_net_value :cs_appraisal_value :currency_code :p_book_type_code :p_category_id :p_conc_request_id :p_end_of_report :p_min_precision :p_no_data_found 1 -20 :p_category_flex Number SELECT category_flex_structure FROM FA_system_controls US Category flex CATEGORY FLEX 2 10 :p_book_type_code LOV Oracle FA_TAX_BOOKS Y select book_type_code id, book_type_code value, book_type_name description from fa_book_controls_sec where book_class='TAX' order by book_type_code Y US Book Book Type Code 3 20 :p_category_id Char US Category Category