JL Regional Fixed Assets Inflation Adjusted Asset Summary- Not Supported: Reserved For Future Use

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Regional Fixed Assets Inflation Adjusted Asset Summary
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
Run JL Regional Fixed Assets Inflation Adjusted Asset Summary- Not Supported: Reserved For Future Use and other Oracle EBS reports with Blitz Report™ on our demo environment
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 
 
 Char
Asset Type 
 
 LOV Oracle
Download
Related Blitz Reports
JL Mexican Fixed Assets ISR - draft JL Mexican Fixed Assets IMPAC - draft FA Form 4562 - Depreciation and Amortization Report- Not Supported: Reserved For Future Use FA Form 4562 - Depreciation and Amortization Detail FA Mass Revaluation Review - draft FA Form 4562 - Depreciation and Amortization Summary FA Asset Additions JL General Ledger Inventory and Balances Book Report- Not Supported: Reserved For Future Use JL Mexican Fixed Assets Fiscal Gain and Loss on Assets Retirements - draft
Blitz Report™

Blitz Report™ provides multiple benefits: