ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN B00C1E99FCBA5D8DE0530100007F3B60Y select x.company_name company_name, x.ledger ledger, x.book book, x.currency currency, x.period period, x.fiscal_year fiscal_year, x.bal_segment balancing_segment, x.ast_account asset_account, x.rsv_account reserve_account, x.asset_number asset_number, x.asset_desc asset_description, x.start_date date_placed_in_service, x.method depreciation_method, x.d_life "Life Yr.Mo", x.cost cost, x.deprn_amount depreciation_amount, x.ytd_deprn ytd_depreciation, x.deprn_reserve depreciation_reserve, x.transaction_type transaction_type, x.company_name || ': ' || x.book || ' - ' || x.period || ' (' || x.currency || ')' comp_book_prd_curr_label, 'FY: ' || x.fiscal_year fiscal_year_label from ( select fsc.company_name, gl.name ledger, :p_book book, gl.currency_code currency, :p_period1 period, ffy.fiscal_year, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_bal_seg', 'SQLGL', 'GL#', gcc.chart_of_accounts_id, null, gcc.code_combination_id, 'GL_BALANCING', 'Y', 'VALUE') bal_segment, frlg.asset_cost_acct ast_account, frlg.deprn_reserve_acct rsv_account, fa.asset_number, fa.description asset_desc, frlg.date_placed_in_service start_date, frlg.method_code method, frlg.life life, frlg.rate adj_rate, frlg.bonus_rate bonus_rate, frlg.capacity prod, round(sum(frlg.cost),fc.precision) cost, round(sum(frlg.deprn_amount),fc.precision) deprn_amount, round(sum(frlg.ytd_deprn),fc.precision) ytd_deprn, round(sum(frlg.deprn_reserve),fc.precision) deprn_reserve, frlg.transaction_type t_type, case frlg.transaction_type when 'P' then 'Partial Unit Retirement' when 'F' then 'Full Retirement' when 'T' then 'Transfer Out' when 'N' then 'Non-depreciating Asset' when 'R' then 'Reclassification' when 'B' then 'Bonus Depreciation Amount' else frlg.transaction_type end transaction_type, fa_fas480_xmlp_pkg.d_lifeformula(frlg.life, frlg.rate, frlg.bonus_rate, frlg.capacity) d_life from fa_system_controls fsc, gl_ledgers gl, fnd_currencies fc, fa_book_controls fbc, fa_reserve_ledger_gt frlg, fa_additions fa, gl_code_combinations gcc, fa_fiscal_year ffy where gl.ledger_id = :p_ca_set_of_books_id and fc.currency_code = gl.currency_code and fbc.book_type_code = :p_book and fa.asset_id = frlg.asset_id and gcc.code_combination_id = frlg.dh_ccid and ffy.fiscal_year_name = fbc.fiscal_year_name and frlg.date_placed_in_service between ffy.start_date and ffy.end_date and 1=1 group by fsc.company_name, gl.name, :p_book, gl.currency_code, fc.precision, :p_period1, ffy.fiscal_year, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_bal_seg', 'SQLGL', 'GL#', gcc.chart_of_accounts_id, null, gcc.code_combination_id, 'GL_BALANCING', 'Y', 'VALUE'), frlg.asset_cost_acct, frlg.deprn_reserve_acct, fa.asset_number, fa.description, frlg.date_placed_in_service, frlg.method_code, frlg.life, frlg.rate, frlg.bonus_rate, frlg.capacity, frlg.transaction_type ) x order by x.company_name, x.ledger, x.book, x.currency, x.period, x.bal_segment, x.fiscal_year, x.ast_account, x.rsv_account, x.asset_number, x.asset_desc, x.method, x.d_life, x.start_date XXEN_FA_FAS_XMLP AR FA Tax Reserve Ledger Application: الأصول Source: تقرير الأستاذ الاحتياطي للضرائب (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: FAS480_XML DB package: FA_FAS480_XMLP_PKG D FA Tax Reserve Ledger Application: Anlagen Source: Steuerliche Abschreibungen (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: FAS480_XML DB package: FA_FAS480_XMLP_PKG E FA Tax Reserve Ledger Informe importado del libro de reservas fiscales estándar de Oracle Fuente: Informe del libro de reservas de impuestos (XML) Nombre corto: FAS480_XML Paquete DB: FA_FAS480_XMLP_PKG Paquete personalizado: XXEN_FA_FAS480_XMLP_PKG F FA Tax Reserve Ledger Application: Assets Source: Journal d'amortissement par livre de gestion (XML) - Non pris en charge : réservé pour une utilisation future Short Name: FAS480_XML DB package: FA_FAS480_XMLP_PKG I FA Tax Reserve Ledger Application: Assets Source: Rapporto Contabilità fondi fiscali (XML) - non supportato: riservato per usi futuri Short Name: FAS480_XML DB package: FA_FAS480_XMLP_PKG JA FA Tax Reserve Ledger オラクル標準税積立元帳レポートをインポート 出典は、以下の通りです。税務準備金元帳報告書（XML 短縮名。FAS480_XML DBパッケージ。FA_FAS480_XMLP_PKG カスタムパッケージ。XXEN_FA_FAS480_XMLP_PKG KO FA Tax Reserve Ledger 임포트 된 Oracle 표준 세금 준비금 원장 보고서 출처 : 세금 준비금 원장 보고서 (XML) 짧은 이름 : FAS480_XML DB 패키지 : FA_FAS480_XMLP_PKG 맞춤 패키지 : XXEN_FA_FAS480_XMLP_PKG PTB FA Tax Reserve Ledger Importação do relatório do livro-razão de reserva fiscal padrão da Oracle Fonte: Relatório do Ledger de Reserva Fiscal (XML) Nome curto: FAS480_XML Pacote DB: FA_FAS480_XMLP_PKG Pacote personalizado: XXEN_FA_FAS480_XMLP_PKG RU FA Tax Reserve Ledger Импортированный отчет по стандартной налоговой книге Oracle. Источник: Отчет по регистру налоговых резервов (XML) Короткое имя: FAS480_XML БД-пакет: FA_FAS480_XMLP_PKG Индивидуальный пакет: XXEN_FA_FAS480_XMLP_PKG S FA Tax Reserve Ledger Importerad Oracle standard skattereservebok Källa: Tax Reserve Ledger Report (XML) Kort namn: FAS480_XML DB-paket: FA_FAS480_XMLP_PKG Anpassat paket: XXEN_FA_FAS480_XMLP_PKG TR FA Tax Reserve Ledger İçe aktarılan Oracle standart vergi rezervi defteri raporu Kaynak: Vergi Karşılığı Defter Raporu (XML) Kısa isim: FAS480_XML DB paketi: FA_FAS480_XMLP_PKG Özel Paket: XXEN_FA_FAS480_XMLP_PKG US FA Tax Reserve Ledger Imported Oracle standard tax reserve ledger report Source: Tax Reserve Ledger Report (XML) Short Name: FAS480_XML DB package: FA_FAS480_XMLP_PKG Custom Package: XXEN_FA_FAS_XMLP ZHS FA Tax Reserve Ledger Application: 资产 Source: 纳税准备金分类帐报表 (XML) - 不支持：已保留供将来使用 Short Name: FAS480_XML DB package: FA_FAS480_XMLP_PKG Enginatics R12 only 1=1 :p_adj_mode :p_book :p_book1 :p_book2 :p_book3 :p_book4 :p_ca_set_of_books_id :p_calendar_type :p_conc_request_id :p_currency :p_fas_code :p_min_precision :p_mrcsobtype :p_period1 :p_period2 :p_period_count :p_period_name :p_report_type :p_run_id 1 -10 :p_fas_code Char FAS480 US FAS Code 2 10 :p_book LOV Oracle FA_BOOK_TYPE Y select book_type_code id, book_type_code value, book_type_name description from fa_book_controls_sec order by book_type_code select case when xrpv.parameter_type='LOV Oracle' and xrrpv.value not like '<multiple_values>%' then xxen_report.id_to_value(xrpv.parameter_id,xrrpv.value) else xrrpv.value end value from xxen_report_parameters_v xrpv, (select xrr.report_id,max(xrr.run_id) run_id from xxen_report_runs xrr where xrr.created_by = fnd_global.user_id and xrr.responsibility_id = fnd_global.resp_id group by xrr.report_id) xrr, xxen_report_run_param_values xrrpv where xrpv.report_name = 'FA Tax Reserve Ledger' and xrpv.parameter_name = 'Book' and xrpv.report_id = xrr.report_id and xrr.run_id = xrrpv.run_id and xrpv.parameter_id = xrrpv.parameter_id Y US Book 3 20 :p_ca_set_of_books_id LOV Oracle 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$.fa_book_type union all select set_of_books_id from fa_mc_book_controls where book_type_code=:$flex$.fa_book_type) order by gsob.currency_code select set_of_books_id from fa_book_controls where book_type_code=:$flex$.fa_book_type Y US Set of Books Currency 4 30 :p_period1 LOV Oracle FA_PERIOD_NAME_CLOSED Y select period_name id, period_name value, null description from fa_deprn_periods where book_type_code=:$flex$.fa_book_type and period_counter> (select min(dp2.period_counter) from fa_deprn_periods dp2 where dp2.book_type_code=:$flex$.fa_book_type) order by period_counter select fdp.period_name from fa_deprn_periods fdp where fdp.book_type_code=:$flex$.fa_book_type and fdp.period_counter= (select max(dp2.period_counter) from fa_deprn_periods dp2 where dp2.book_type_code=:$flex$.fa_book_type and dp2.period_close_date is not null) Y US Period :$flex$.fa_book_type Book Period :$flex$.fa_book_type Book Set of Books Currency 1B8DF42275E5B71DBA9511251AB6A3A8 Pivot: Default Template Tax Reserve Ledger Summary (Pivot) and Tax Reserve Ledger Details by Asset SYSADMIN 8 ASSET_ACCOUNT 11 ASSET_DESCRIPTION 10 ASSET_NUMBER 7 BALANCING_SEGMENT 3 BOOK 1 COMPANY_NAME 20 COMP_BOOK_PRD_CURR_LABEL 15 COST 4 CURRENCY 12 DATE_PLACED_IN_SERVICE 16 DEPRECIATION_AMOUNT 13 DEPRECIATION_METHOD 18 DEPRECIATION_RESERVE 6 FISCAL_YEAR 21 FISCAL_YEAR_LABEL 2 LEDGER 14 Life Yr.Mo 5 PERIOD 9 RESERVE_ACCOUNT 19 TRANSACTION_TYPE 17 YTD_DEPRECIATION ASSET_ACCOUNT ROW 4 BALANCING_SEGMENT ROW 2 COMP_BOOK_PRD_CURR_LABEL ROW 1 COST VALUE 1 SUM DEPRECIATION_AMOUNT VALUE 2 SUM DEPRECIATION_RESERVE VALUE 4 SUM FISCAL_YEAR_LABEL ROW 3 RESERVE_ACCOUNT ROW 5 YTD_DEPRECIATION VALUE 3 SUM S Site 1B8DF42275E5B71DBA9511251AB6A3A8