ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F17F3869E053B46B63588994 SELECT FADD.ASSET_ID ASSET_ID, FADD.ASSET_NUMBER||' - '||FADD.DESCRIPTION ASSET_NUMBER, BKS.TRANSACTION_HEADER_ID_OUT TRANSACTION_HEADER_ID, BKS.DATE_PLACED_IN_SERVICE ACQDATE, RET.COST_RETIRED ORIGINAL_COST, RET.DATE_RETIRED DATE_RETIRED, RET.PROCEEDS_OF_SALE PROCEEDS_OF_SALE, FADD.ASSET_CATEGORY_ID ASSET_CATEGORY, BKS.RETIREMENT_ID RETIREMENT_ID, FDP.PERIOD_COUNTER, JL_JLMXFGLR_XMLP_PKG.c_nbvformula(FADD.ASSET_ID, BKS.TRANSACTION_HEADER_ID_OUT, FDP.PERIOD_COUNTER, BKS.RETIREMENT_ID, RET.COST_RETIRED) C_NBV, --&PROCEEDS_OF_SALE C_PROC_SALE, RET.PROCEEDS_OF_SALE C_PROC_SALE, JL_JLMXFGLR_XMLP_PKG.c_ret_dateformula() C_RET_DATE, JL_JLMXFGLR_XMLP_PKG.c_accum_deprn_prev_yrformula(FADD.ASSET_ID, FDP.PERIOD_COUNTER, BKS.RETIREMENT_ID, RET.COST_RETIRED) C_ACCUM_DEPRN_PREV_YR, JL_JLMXFGLR_XMLP_PKG.c_accum_deprn_curr_yrformula(JL_JLMXFGLR_XMLP_PKG.c_nbvformula(FADD.ASSET_ID, BKS.TRANSACTION_HEADER_ID_OUT, FDP.PERIOD_COUNTER, BKS.RETIREMENT_ID, RET.COST_RETIRED),JL_JLMXFGLR_XMLP_PKG.c_accum_deprn_prev_yrformula(FADD.ASSET_ID, FDP.PERIOD_COUNTER, BKS.RETIREMENT_ID, RET.COST_RETIRED)) C_ACCUM_DEPRN_CURR_YR, JL_JLMXFGLR_XMLP_PKG.c_price_indexformula(FADD.ASSET_CATEGORY_ID, BKS.DATE_PLACED_IN_SERVICE) C_PRICE_INDEX, JL_JLMXFGLR_XMLP_PKG.c_index_valueformula(JL_JLMXFGLR_XMLP_PKG.c_price_indexformula(FADD.ASSET_CATEGORY_ID, BKS.DATE_PLACED_IN_SERVICE), BKS.DATE_PLACED_IN_SERVICE) C_INDEX_VALUE, JL_JLMXFGLR_XMLP_PKG.c_index_value_half_periodformu(BKS.DATE_PLACED_IN_SERVICE, RET.DATE_RETIRED,JL_JLMXFGLR_XMLP_PKG.c_price_indexformula(FADD.ASSET_CATEGORY_ID, BKS.DATE_PLACED_IN_SERVICE)) C_INDEX_VALUE_HALF_PERIOD, JL_JLMXFGLR_XMLP_PKG.c_corr_factorformula(JL_JLMXFGLR_XMLP_PKG.c_index_value_half_periodformu(BKS.DATE_PLACED_IN_SERVICE, RET.DATE_RETIRED,JL_JLMXFGLR_XMLP_PKG.c_price_indexformula(FADD.ASSET_CATEGORY_ID, BKS.DATE_PLACED_IN_SERVICE)), JL_JLMXFGLR_XMLP_PKG.c_index_valueformula(JL_JLMXFGLR_XMLP_PKG.c_price_indexformula(FADD.ASSET_CATEGORY_ID, BKS.DATE_PLACED_IN_SERVICE), BKS.DATE_PLACED_IN_SERVICE)) C_CORR_FACTOR, JL_JLMXFGLR_XMLP_PKG.c_adj_nbvformula(RET.COST_RETIRED,JL_JLMXFGLR_XMLP_PKG.c_accum_deprn_curr_yrformula(JL_JLMXFGLR_XMLP_PKG.c_nbvformula(FADD.ASSET_ID, BKS.TRANSACTION_HEADER_ID_OUT, FDP.PERIOD_COUNTER, BKS.RETIREMENT_ID, RET.COST_RETIRED),JL_JLMXFGLR_XMLP_PKG.c_accum_deprn_prev_yrformula(FADD.ASSET_ID, FDP.PERIOD_COUNTER, BKS.RETIREMENT_ID, RET.COST_RETIRED)),JL_JLMXFGLR_XMLP_PKG.c_accum_deprn_prev_yrformula(FADD.ASSET_ID, FDP.PERIOD_COUNTER, BKS.RETIREMENT_ID, RET.COST_RETIRED),JL_JLMXFGLR_XMLP_PKG.c_corr_factorformula(JL_JLMXFGLR_XMLP_PKG.c_index_value_half_periodformu(BKS.DATE_PLACED_IN_SERVICE, RET.DATE_RETIRED,JL_JLMXFGLR_XMLP_PKG.c_price_indexformula(FADD.ASSET_CATEGORY_ID, BKS.DATE_PLACED_IN_SERVICE)), JL_JLMXFGLR_XMLP_PKG.c_index_valueformula(JL_JLMXFGLR_XMLP_PKG.c_price_indexformula(FADD.ASSET_CATEGORY_ID, BKS.DATE_PLACED_IN_SERVICE), BKS.DATE_PLACED_IN_SERVICE))) C_ADJ_NBV, JL_JLMXFGLR_XMLP_PKG.c_gain_lossformula(JL_JLMXFGLR_XMLP_PKG.c_adj_nbvformula(RET.COST_RETIRED,JL_JLMXFGLR_XMLP_PKG.c_accum_deprn_curr_yrformula(JL_JLMXFGLR_XMLP_PKG.c_nbvformula(FADD.ASSET_ID, BKS.TRANSACTION_HEADER_ID_OUT, FDP.PERIOD_COUNTER, BKS.RETIREMENT_ID, RET.COST_RETIRED),JL_JLMXFGLR_XMLP_PKG.c_accum_deprn_prev_yrformula(FADD.ASSET_ID, FDP.PERIOD_COUNTER, BKS.RETIREMENT_ID, RET.COST_RETIRED)),JL_JLMXFGLR_XMLP_PKG.c_accum_deprn_prev_yrformula(FADD.ASSET_ID, FDP.PERIOD_COUNTER, BKS.RETIREMENT_ID, RET.COST_RETIRED),JL_JLMXFGLR_XMLP_PKG.c_corr_factorformula(JL_JLMXFGLR_XMLP_PKG.c_index_value_half_periodformu(BKS.DATE_PLACED_IN_SERVICE, RET.DATE_RETIRED,JL_JLMXFGLR_XMLP_PKG.c_price_indexformula(FADD.ASSET_CATEGORY_ID, BKS.DATE_PLACED_IN_SERVICE)), JL_JLMXFGLR_XMLP_PKG.c_index_valueformula(JL_JLMXFGLR_XMLP_PKG.c_price_indexformula(FADD.ASSET_CATEGORY_ID, BKS.DATE_PLACED_IN_SERVICE), BKS.DATE_PLACED_IN_SERVICE))),RET.PROCEEDS_OF_SALE) C_GAIN_LOSS FROM FA_ADDITIONS FADD, &lp_fa_books BKS, &lp_fa_retirements RET, &lp_fa_deprn_periods FDP WHERE ret.book_type_code = :p_book_type_code AND bks.book_type_code = ret.book_type_code AND bks.asset_id = ret.asset_id AND bks.retirement_id = ret.retirement_id AND bks.cost <> 0 AND ret.status <> 'DELETED' AND (ret.date_retired BETWEEN :c_fiscal_start_date AND :c_fiscal_end_date) AND ret.book_type_code = fdp.book_type_code AND ret.date_retired BETWEEN FDP.CALENDAR_PERIOD_OPEN_DATE AND FDP.CALENDAR_PERIOD_CLOSE_DATE AND fadd.asset_id = bks.asset_id AND FADD.ASSET_TYPE='CAPITALIZED' ORDER BY fadd.asset_number, fadd.description Y JL JLMXFGLR_XML US JL Mexican Fixed Assets Fiscal Gain and Loss on Assets Retirements - draft Application: Latin America Localizations Source: Mexican Fixed Assets Fiscal Gain and Loss on Assets Retirements Report (XML) - Not Supported: Reserved For Future Use Short Name: JLMXFGLR_XML DB package: JL_JLMXFGLR_XMLP_PKG BI Publisher &lp_fa_books &lp_fa_deprn_periods &lp_fa_retirements &proceeds_of_sale :c_base_currency_code :c_base_description :c_base_min_acct_unit :c_base_precision :c_curr_fiscal_yr :c_curr_period_counter :c_fiscal_end_date :c_fiscal_start_date :c_last_period_counter :c_max_period_counter :c_min_period_counter :c_organization_name :c_ratio_precision :fy_end_date :fy_start_date :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 :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_include_dpis :p_include_ret :p_mrcsobtype :p_no_data_found 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 select currency_code from gl_sets_of_books where set_of_books_id = (select set_of_books_id from fa_book_controls where book_type_code=:$FLEX$.Book_Type_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