JL Colombian Fixed Assets Technical Appraisal Revaluation Report- Not Supported: Reserved For Future Use
Description
Categories: BI Publisher
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
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
Run
JL Colombian Fixed Assets Technical Appraisal Revaluation Report- Not Supported: Reserved For Future Use and other Oracle EBS reports with Blitz Report™ on our demo environment
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 |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Book |
|
LOV Oracle | |
Category |
|
Char |