JL Mexican Fixed Assets IMPAC - draft

➜ Back to Library
Description
Categories: BI Publisher
Application: Latin America Localizations
Source: Mexican Fixed Assets IMPAC Report (XML) - Not Supported: Reserved For Future Use
Short Name: JLMXFIMP_XML
DB package: JL_JLMXFIMP_XMLP_PKG
Run JL Mexican Fixed Assets IMPAC - draft and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT IMPAC.ASSET_ID, 
              IMPAC.ASSET_NUMBER,
              IMPAC.TRANSACTION_HEADER_ID_IN,
              IMPAC.TRANSACTION_HEADER_ID_OUT,
              IMPAC.DESCRIPTION DESCRIPTION,
              IMPAC.DATE_PLACED_IN_SERVICE ACQDATE,
              IMPAC.PRORATE_DATE PRORATE_DATE,
              IMPAC.RETIREMENT_ID RETIREMENT_ID,
              IMPAC.ORIGINAL_COST,
              IMPAC.INPC,
              IMPAC.ADJUSTED_DEPRN_CURRENT_FY,
              IMPAC.ACCUM_DEPRN_PREVIOUS_FY,
              IMPAC.ASSET_CATEGORY_ID ASSET_CATEGORY,
              IMPAC.PERIOD_COUNTER_FULLY_RESERVED,
              &C_ALL_SEGS CATEG_DESC, 
	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_JLMXFIMP_XMLP_PKG.c_price_indexformula(IMPAC.ASSET_CATEGORY_ID, IMPAC.DATE_PLACED_IN_SERVICE) C_PRICE_INDEX, 
	JL_JLMXFIMP_XMLP_PKG.c_index_value_juneformula(JL_JLMXFIMP_XMLP_PKG.c_price_indexformula(IMPAC.ASSET_CATEGORY_ID, IMPAC.DATE_PLACED_IN_SERVICE)) C_INDEX_VALUE_JUNE, 
	JL_JLMXFIMP_XMLP_PKG.c_corr_factorformula(IMPAC.DATE_PLACED_IN_SERVICE,JL_JLMXFIMP_XMLP_PKG.c_index_value_juneformula(JL_JLMXFIMP_XMLP_PKG.c_price_indexformula(IMPAC.ASSET_CATEGORY_ID, IMPAC.DATE_PLACED_IN_SERVICE)), IMPAC.INPC) C_CORR_FACTOR, 
	JL_JLMXFIMP_XMLP_PKG.c_nbv_end_prev_fyformula(IMPAC.ORIGINAL_COST, nvl(IMPAC.ACCUM_DEPRN_PREVIOUS_FY,0)) C_NBV_END_PREV_FY, 
	JL_JLMXFIMP_XMLP_PKG.c_adj_nbv_end_prev_fyformula(JL_JLMXFIMP_XMLP_PKG.c_nbv_end_prev_fyformula(IMPAC.ORIGINAL_COST, nvl(IMPAC.ACCUM_DEPRN_PREVIOUS_FY,0)),JL_JLMXFIMP_XMLP_PKG.c_corr_factorformula(IMPAC.DATE_PLACED_IN_SERVICE,JL_JLMXFIMP_XMLP_PKG.c_index_value_juneformula(JL_JLMXFIMP_XMLP_PKG.c_price_indexformula(IMPAC.ASSET_CATEGORY_ID, IMPAC.DATE_PLACED_IN_SERVICE)), IMPAC.INPC)) C_ADJ_NBV_END_PREV_FY, 
	JL_JLMXFIMP_XMLP_PKG.c_50per_adj_deprn_curr_fyformu(IMPAC.ADJUSTED_DEPRN_CURRENT_FY) C_50PER_ADJ_DEPRN_CURR_FY, 
	JL_JLMXFIMP_XMLP_PKG.c_adj_nbv_less_50performula(	JL_JLMXFIMP_XMLP_PKG.c_adj_nbv_end_prev_fyformula(JL_JLMXFIMP_XMLP_PKG.c_nbv_end_prev_fyformula(IMPAC.ORIGINAL_COST, nvl(IMPAC.ACCUM_DEPRN_PREVIOUS_FY,0)),JL_JLMXFIMP_XMLP_PKG.c_corr_factorformula(IMPAC.DATE_PLACED_IN_SERVICE,JL_JLMXFIMP_XMLP_PKG.c_index_value_juneformula(JL_JLMXFIMP_XMLP_PKG.c_price_indexformula(IMPAC.ASSET_CATEGORY_ID, IMPAC.DATE_PLACED_IN_SERVICE)), IMPAC.INPC)),JL_JLMXFIMP_XMLP_PKG.c_50per_adj_deprn_curr_fyformu(IMPAC.ADJUSTED_DEPRN_CURRENT_FY)) C_ADJ_NBV_LESS_50PER, 
	JL_JLMXFIMP_XMLP_PKG.c_impac_base_valueformula(IMPAC.DATE_PLACED_IN_SERVICE, IMPAC.RETIREMENT_ID,JL_JLMXFIMP_XMLP_PKG.cf_retirement_date(IMPAC.RETIREMENT_ID), IMPAC.PERIOD_COUNTER_FULLY_RESERVED, JL_JLMXFIMP_XMLP_PKG.c_adj_nbv_less_50performula(	JL_JLMXFIMP_XMLP_PKG.c_adj_nbv_end_prev_fyformula(JL_JLMXFIMP_XMLP_PKG.c_nbv_end_prev_fyformula(IMPAC.ORIGINAL_COST, nvl(IMPAC.ACCUM_DEPRN_PREVIOUS_FY,0)),JL_JLMXFIMP_XMLP_PKG.c_corr_factorformula(IMPAC.DATE_PLACED_IN_SERVICE,JL_JLMXFIMP_XMLP_PKG.c_index_value_juneformula(JL_JLMXFIMP_XMLP_PKG.c_price_indexformula(IMPAC.ASSET_CATEGORY_ID, IMPAC.DATE_PLACED_IN_SERVICE)), IMPAC.INPC)),JL_JLMXFIMP_XMLP_PKG.c_50per_adj_deprn_curr_fyformu(IMPAC.ADJUSTED_DEPRN_CURRENT_FY))) C_IMPAC_BASE_VALUE, 
	JL_JLMXFIMP_XMLP_PKG.c_index_value_acqformula(JL_JLMXFIMP_XMLP_PKG.c_price_indexformula(IMPAC.ASSET_CATEGORY_ID, IMPAC.DATE_PLACED_IN_SERVICE), IMPAC.DATE_PLACED_IN_SERVICE) C_index_value_acq, 
	JL_JLMXFIMP_XMLP_PKG.cf_retirement_date(IMPAC.RETIREMENT_ID) CF_RETIREMENT_DATE
FROM  FA_CATEGORIES CT, JL_MX_FA_ISR_IMPAC IMPAC
 WHERE  IMPAC.PROCESS_ID = :P_PROCESS_ID
  AND     CT.CATEGORY_ID = IMPAC.ASSET_CATEGORY_ID
  ORDER BY CATEG_DESC,
                     IMPAC.ASSET_NUMBER,
                     IMPAC.DESCRIPTION,
                     NVL(RETIREMENT_ID,0)
Parameter Name SQL text Validation
Book Type Code 
 
 LOV Oracle
Ledger Currency 
 
 LOV Oracle
Fiscal Year 
 
 LOV Oracle
Include DPIS Month for Periods of Use Calculation 
 
 LOV Oracle
Include Retirement Month for Periods of Use Calculation 
 
 LOV Oracle
Fully Depreciated Assets 
 
 LOV Oracle
Include zero NBV assets 
 
 LOV Oracle
Download
Related Blitz Reports
JL Colombian Fixed Assets Inflation Adjusted Drill Down - draft JL Colombian Fixed Assets Technical Appraisal Revaluation Report- Not Supported: Reserved For Future Use JL Colombian Inflation Adjusted Fixed Assets Report- Not Supported: Reserved For Future Use JL Regional Fixed Assets Inflation Adjusted Asset Summary- Not Supported: Reserved For Future Use JL Mexican Fixed Assets ISR - draft JL Colombian Fixed Assets Inflation Adjusted Account Drill Down Report- Not Supported: Reserved For Future Use JL Argentine Exhibit of Fixed Assets - draft JL General Ledger Inventory and Balances Book Report- Not Supported: Reserved For Future Use JL Colombian Fixed Assets Technical Appraisal Additions - draft
Blitz Report™

Blitz Report™ provides multiple benefits: