JL Colombian Fixed Assets Technical Appraisal Revaluation - draft

Description
Categories: BI Publisher
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
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
Category flex
 
Number
Category
 
Book
 
LOV Oracle