JL Regional Fixed Assets Inflation Adjusted Asset Summary - draft

Description
Categories: BI Publisher
Application: Latin America Localizations
Source: Regional Fixed Assets Inflation Adjusted Asset Summary (XML) - Not Supported: Reserved For Future Use
Short Name: JLZZFIJR_XML
DB package: JL_JLZZFIJR_XMLP_PKG
select 
      &CF_Asset_Cat_Flex                                                                             Asset_Category,
     pc.asset_number||' - '||pc.description                                       Asset_number_desc,
       pc.asset_id                                                                                              asset_id,
       pc.corp_cost                                                                                            corp_cost,
       ((pc.adj_cost - pp.adj_cost) -(pc.corp_cost - pp.corp_cost))              Adj_cost_per,
       pc.adj_cost                                                                                               adj_cost,
       pc.corp_deprn_reserve                                                                            corp_depr_reserve,
       pc.adj_deprn_reserve                                                                              adj_deprn_reserve,
       pc.corp_ytd_deprn                                                                                    corp_ytd_deprn_expense,
       pc.adj_ytd_deprn                                                                                     adj_ytd_deprn_expense, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('cf_asset_category', 'OFA', 'CAT#', 101, NULL, ac.CATEGORY_ID, 'ALL', 'Y', 'VALUE') CF_Asset_Category,
	JL_JLZZFIJR_XMLP_PKG.cp_cat_corp_cost_p cp_cat_corp_cost,
	JL_JLZZFIJR_XMLP_PKG.cp_cat_adj_cost_per_p cp_cat_adj_cost_per,
	JL_JLZZFIJR_XMLP_PKG.cp_cat_adj_cost_p cp_cat_adj_cost,
	JL_JLZZFIJR_XMLP_PKG.cp_cat_corp_depr_reserve_p cp_cat_corp_depr_reserve,
	JL_JLZZFIJR_XMLP_PKG.cp_cat_depr_reserve_adj_per_p cp_cat_depr_reserve_adj_per,
	JL_JLZZFIJR_XMLP_PKG.cp_cat_adj_deprn_reserve_p cp_cat_adj_deprn_reserve,
	JL_JLZZFIJR_XMLP_PKG.cp_cat_corp_ytd_deprn_expe_p cp_cat_corp_ytd_deprn_expense,
	JL_JLZZFIJR_XMLP_PKG.cp_cat_ytd_deprn_expense_adj_ cp_cat_ytd_deprn_expense_adj_p,
	JL_JLZZFIJR_XMLP_PKG.cp_cat_adj_ytd_deprn_expense_p cp_cat_adj_ytd_deprn_expense, 
	JL_JLZZFIJR_XMLP_PKG.depr_expense_adj_performula(pc.asset_id, :Period_PC) depr_expense_adj_per, 
	JL_JLZZFIJR_XMLP_PKG.depr_reserve_adj_performula(pc.asset_id, :Period_PC) depr_reserve_adj_per,
	JL_JLZZFIJR_XMLP_PKG.CP_asset_corp_cost_p CP_asset_corp_cost,
	JL_JLZZFIJR_XMLP_PKG.CP_asset_adj_cost_per_p CP_asset_adj_cost_per,
	JL_JLZZFIJR_XMLP_PKG.CP_asset_adj_cost_p CP_asset_adj_cost,
	JL_JLZZFIJR_XMLP_PKG.CP_asset_corp_depr_reserve_p CP_asset_corp_depr_reserve,
	JL_JLZZFIJR_XMLP_PKG.CP_ASSET_DEPR_RESERVE_ADJ_P CP_asset_depr_reserve_adj_per,
	JL_JLZZFIJR_XMLP_PKG.CP_asset_adj_deprn_reserve_p CP_asset_adj_deprn_reserve,
	JL_JLZZFIJR_XMLP_PKG.CP_asset_corp_ytd_deprn_expen CP_asset_corp_ytd_deprn_expens,
	JL_JLZZFIJR_XMLP_PKG.CP_asset_ytd_depr_expn_adj_pe CP_asset_ytd_depr_expn_adj_per,
	JL_JLZZFIJR_XMLP_PKG.CP_asset_ytd_deprn_expense_p CP_asset_ytd_deprn_expense
from  jl_zz_fa_adj_summary_v pc,
        jl_zz_fa_adj_summary_v pp,
       fa_categories          ac
where pc.adj_book_type_code = :p_book
   and  pc.period_name = :p_period 
   and  pp.adj_book_type_code = pc.adj_book_type_code
   and  pp.asset_id = pc.asset_id
   and  pp.period_counter = pc.period_counter -1
   and ac.category_id = pc.asset_category_id
  and pc.asset_category_id = NVL(:p_category_id , pc.asset_category_id)
   and pc.asset_type IN (DECODE(:p_asset_type, 'ALL', 'CAPITALIZED', :p_asset_type),
                                        DECODE(:p_asset_type, 'ALL', 'CIP', :p_asset_type))
 order by 1,2
Parameter Name SQL text Validation
Book
 
LOV Oracle
Ledger Currency
 
LOV Oracle
Period
 
LOV Oracle
Asset Category
 
Asset Type
 
LOV Oracle
Category Flex
 
Number