ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F1803869E053B46B63588994 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) JL JLMXFIMP_XML US JL Mexican Fixed Assets IMPAC - draft 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 BI Publisher &c_all_segs :c_all_segs :c_base_currency_code :c_base_description :c_base_min_acct_unit :c_base_precision :c_curr_fiscal_yrx :c_end_mid_yr :c_fiscal_end_date :c_fiscal_start_date :c_ini_mid_yr :c_organization_name :c_ratio_precision :cat_flex_struct :lp_currency_code :lp_fa_adjustments :lp_fa_asset_invoices :lp_fa_book_controls :lp_fa_books :lp_fa_deferred_deprn :lp_fa_deprn_detail :lp_fa_deprn_periods :lp_fa_deprn_summary :lp_fa_retirements :max_period_counter :min_period_counter :p_book_type_code :p_ca_org_id :p_ca_set_of_books_id :p_conc_request_id :p_curr_fy :p_end_of_report :p_fully_deprn_assets :p_include_dpis :p_include_ret :p_include_zero_nbv_assets :p_mrcsobtype :p_no_data_found :p_process_id :periods_per_fy 1 10 :p_book_type_code LOV Oracle JLMX_FA_LEGAL_BOOKS Y select book_type_code id, book_type_code value, book_type_name description from fa_book_controls where global_attribute4='Y' order by book_type_code Y US Book Type Code 2 20 :p_ca_set_of_books_id LOV Oracle JLMX_FA_CA_SOB_CURRENCY Y select gsob.set_of_books_id id, gsob.currency_code value, gsob.name description from gl_sets_of_books gsob where gsob.set_of_books_id in ( select set_of_books_id from fa_book_controls where book_type_code=:$flex$.jlmx_fa_legal_books union all select set_of_books_id from fa_mc_book_controls where book_type_code=:$flex$.jlmx_fa_legal_books) order by gsob.currency_code Y US Ledger Currency 3 30 :p_curr_fy LOV Oracle JLMX_FA_LEGAL_BOOK_FY Y select fiscal_year id, fiscal_year value, null description from fa_fiscal_year where fiscal_year_name=(select fiscal_year_name from fa_book_controls where book_type_code=:$flex$.jlmx_fa_legal_books) and fiscal_year in (select distinct fiscal_year from fa_deprn_periods where book_type_code=:$flex$.jlmx_fa_legal_books) order by fiscal_year Y US Fiscal Year 4 40 :p_include_dpis LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description select meaning from fnd_lookups where lookup_type = 'YES_NO' and lookup_code = 'N' Y US Include DPIS Month for Periods of Use Calculation 5 50 :p_include_ret LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description select meaning from fnd_lookups where lookup_type = 'YES_NO' and lookup_code = 'N' Y US Include Retirement Month for Periods of Use Calculation 6 60 :p_fully_deprn_assets LOV Oracle JLMX_FA_FULLY_DEPRN_ASSET Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='JLMX_FA_FULLY_DEPRN_ASSET_OPT' and sysdate between nvl(start_date_active,sysdate-1) and nvl(end_date_active,sysdate+1) and enabled_flag='Y' order by lookup_code select meaning from fnd_lookups where lookup_type = 'JLMX_FA_FULLY_DEPRN_ASSET_OPT' and lookup_code = 'IN USE' Y US Fully Depreciated Assets 7 70 :p_include_zero_nbv_assets LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description select meaning from fnd_lookups where lookup_type = 'YES_NO' and lookup_code = 'Y' Y US Include zero NBV assets :$flex$.jlmx_fa_legal_books Book Type Code Fiscal Year :$flex$.jlmx_fa_legal_books Book Type Code Ledger Currency