ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D470D951A9E05362FB09050512Y select fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_bal_seg', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') company_code, decode(fy.fiscal_year, :P_fiscal_year, to_char(fy.fiscal_year),:PREVIOUS_FISCAL_YEAR) fiscal_year_added, BK.deprn_method_code deprn_method, &CAT_FLEX_ALL_SEG category, AD.asset_number || ' - ' || AD.description asset_number, AD.ASSET_ID ASSET_ID, sum(dd.cost) cost, bk.life_in_months life_in_months, bk.adjusted_rate adjusted_rate, ds.bonus_rate bonus_rate, bk.production_capacity production, BK.prorate_convention_code prorate_convention, sum(dd.ytd_deprn) ytd_deprn, decode( instr(bk.deprn_method_code, '30B'), 0, decode ( instr(bk.deprn_method_code, '50B'), 0, 0, decode(fy.fiscal_year, :P_FISCAL_YEAR, (bk.recoverable_cost * .5 ) , 0) ) , decode(fy.fiscal_year, :P_FISCAL_YEAR, (bk.recoverable_cost * .3 ) , 0) ) special_deprn, fnd_flex_xml_publisher_apis.process_kff_combination_1('d_company_code', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') D_COMPANY_CODE, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_cat_flex', 'OFA', 'CAT#', 101, NULL, cat.CATEGORY_ID, 'ALL', 'Y', 'VALUE') C_CAT_FLEX, --&COMPANY_CODE BAL_SEG, FA_FAS771_XMLP_PKG.d_lifeformula(bk.life_in_months, bk.adjusted_rate, ds.bonus_rate, bk.production_capacity) D_LIFE, FA_FAS771_XMLP_PKG.ytdformula(:YTD_ADJ, sum ( dd.ytd_deprn )) YTD, FA_FAS771_XMLP_PKG.specialformula(AD.ASSET_ID, :Book, decode ( fy.fiscal_year , :P_fiscal_year , to_char ( fy.fiscal_year ) , :PREVIOUS_FISCAL_YEAR ), BK.deprn_method_code, decode ( instr ( bk.deprn_method_code , '30B' ) , 0 , decode ( instr ( bk.deprn_method_code , '50B' ) , 0 , 0 , decode ( fy.fiscal_year , :P_FISCAL_YEAR , ( bk.recoverable_cost * .5 ) , 0 ) ) , decode ( fy.fiscal_year , :P_FISCAL_YEAR , ( bk.recoverable_cost * .3 ) , 0 ) ), :YTD) SPECIAL, ((FA_FAS771_XMLP_PKG.ytdformula(:YTD_ADJ, sum ( dd.ytd_deprn ))) - (FA_FAS771_XMLP_PKG.specialformula(AD.ASSET_ID, :Book, decode ( fy.fiscal_year , :P_fiscal_year , to_char ( fy.fiscal_year ) , :PREVIOUS_FISCAL_YEAR ), BK.deprn_method_code, decode ( instr ( bk.deprn_method_code , '30B' ) , 0 , decode ( instr ( bk.deprn_method_code , '50B' ) , 0 , 0 , decode ( fy.fiscal_year , :P_FISCAL_YEAR , ( bk.recoverable_cost * .5 ) , 0 ) ) , decode ( fy.fiscal_year , :P_FISCAL_YEAR , ( bk.recoverable_cost * .3 ) , 0 ) ), :YTD) )) DEPRN_DEC , -- ((sum(dd.cost)) - (FA_FAS771_XMLP_PKG.specialformula(AD.ASSET_ID, :Book, decode ( fy.fiscal_year , :P_fiscal_year , to_char ( fy.fiscal_year ) , :PREVIOUS_FISCAL_YEAR ), BK.deprn_method_code, decode ( instr ( bk.deprn_method_code , '30B' ) , 0 , decode ( instr ( bk.deprn_method_code , '50B' ) , 0 , 0 , decode ( fy.fiscal_year , :P_FISCAL_YEAR , ( bk.recoverable_cost * .5 ) , 0 ) ) , decode ( fy.fiscal_year , :P_FISCAL_YEAR , ( bk.recoverable_cost * .3 ) , 0 ) ), :YTD))) COST_BASIS FA_FAS771_XMLP_PKG.costbasis(sum(dd.cost),FA_FAS771_XMLP_PKG.specialformula(AD.ASSET_ID, :Book, decode ( fy.fiscal_year , :P_fiscal_year , to_char ( fy.fiscal_year ) , :PREVIOUS_FISCAL_YEAR ), BK.deprn_method_code, decode ( instr ( bk.deprn_method_code , '30B' ) , 0 , decode ( instr ( bk.deprn_method_code , '50B' ) , 0 , 0 , decode ( fy.fiscal_year , :P_FISCAL_YEAR , ( bk.recoverable_cost * .5 ) , 0 ) ) , decode ( fy.fiscal_year , :P_FISCAL_YEAR , ( bk.recoverable_cost * .3 ) , 0 ) ), :YTD),BK.deprn_method_code,decode(fy.fiscal_year, :P_fiscal_year, to_char(fy.fiscal_year),:PREVIOUS_FISCAL_YEAR) ) COST_BASIS from FA_DEPRN_DETAIL dd, FA_DEPRN_SUMMARY DS, FA_ADDITIONS AD, FA_ASSET_HISTORY AH, FA_CATEGORIES CAT, FA_BOOKS BK, GL_CODE_COMBINATIONS DHCC, FA_DISTRIBUTION_HISTORY DH, FA_FISCAL_YEAR FY, FA_BOOK_CONTROLS BC where -- BK.book_type_code = :P_BOOK and BK.book_type_code = :P_BOOK and BK.asset_id = AD.asset_id and :report_period_close_date between BK.date_effective and nvl(BK.date_ineffective,sysdate) and BK.date_placed_in_service between FY.start_date and FY.end_date and nvl(BK.period_counter_fully_retired,:start_period_counter) >= :start_period_counter and nvl(BK.period_counter_fully_reserved,:start_period_counter)>= :start_period_counter and bc.book_type_code = :P_BOOK and bc.fiscal_year_name = fy.fiscal_year_name and dd.book_type_code = :P_BOOK and dd.asset_id = BK.asset_id and dd.deprn_source_code = 'D' and dd.period_counter = (select max(dd_sub.period_counter) from fa_deprn_detail dd_sub where dd_sub.book_type_code = :p_book and dd_sub.distribution_id = dd.distribution_id and dd_sub.period_counter between :start_period_counter and :end_period_counter) and dh.distribution_id = dd.distribution_id and ds.book_type_code = :P_BOOK and ds.asset_id = BK.ASSET_ID and ds.period_counter = dd.period_counter and ah.asset_id = bk.asset_id and :report_period_close_date between ah.date_effective and nvl(ah.date_ineffective,sysdate) and cat.category_id = ah.category_id and dh.code_combination_id = dhcc.code_combination_id (+) group by fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_bal_seg', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE'), fy.fiscal_year, BK.deprn_method_code, &CAT_FLEX_ALL_SEG, AD.asset_number, AD.description, AD.ASSET_ID, bk.life_in_months, bk.adjusted_rate, bk.production_capacity, ds.bonus_rate, BK.prorate_convention_code, -- bk.recoverable_cost order by bk.recoverable_cost --Added during DT Fix ,fnd_flex_xml_publisher_apis.process_kff_combination_1('d_company_code', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') ,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_cat_flex', 'OFA', 'CAT#', 101, NULL, cat.CATEGORY_ID, 'ALL', 'Y', 'VALUE') ,&COMPANY_CODE --End of DT Fix order by fnd_flex_xml_publisher_apis.process_kff_combination_1('d_company_code', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE'), decode(fy.fiscal_year,:P_fiscal_year, 0, 1), bk.life_in_months, BK.deprn_method_code, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_cat_flex', 'OFA', 'CAT#', 101, NULL, cat.CATEGORY_ID, 'ALL', 'Y', 'VALUE'), AD.asset_number OFA FAS771S_XML AR FA نموذج 4562 - تقرير إجمالي الإهلاك والاستهلاك (بتنسيق XML) Imported from BI Publisher Description: نموذج الإجمالي 4562 - تقرير الإهلاك والاستهلاك Application: الأصول Source: نموذج 4562 - تقرير إجمالي الإهلاك والاستهلاك (بتنسيق XML) Short Name: FAS771S_XML DB package: FA_FAS771_XMLP_PKG D FA Formular 4562 - Abschreibungen - Übersicht Imported from BI Publisher Description: Übersichtsformular 4562 - Abschreibung Application: Anlagen Source: Formular 4562 - Abschreibungen - Übersicht (XML) Short Name: FAS771S_XML DB package: FA_FAS771_XMLP_PKG E FA Formulario 4562 - Resumen de Amortizaciones Imported from BI Publisher Description: Formulario de Resumen 4562 - Amortizaciones Application: Assets Source: Formulario 4562 - Resumen de Amortizaciones (XML) Short Name: FAS771S_XML DB package: FA_FAS771_XMLP_PKG F FA Form 4562 - Depreciation and Amortization (USA) - Synthèse Imported from BI Publisher Description: Form 4562 - Depreciation and Amortization (USA) - Synthèse Application: Assets Source: Form 4562 - Depreciation and Amortization (USA) - Synthèse (XML) Short Name: FAS771S_XML DB package: FA_FAS771_XMLP_PKG I FA Modello 4562 - rapporto sintetico Ammortamento Imported from BI Publisher Description: Modello 4562 sintetico - rapporto Ammortamento Application: Assets Source: Modello 4562 - rapporto sintetico Ammortamento (XML) Short Name: FAS771S_XML DB package: FA_FAS771_XMLP_PKG JA FA フォーム4562 - 減価償却要約レポート Imported from BI Publisher Description: 要約フォーム4562 - 減価償却レポート Application: Assets Source: フォーム4562 - 減価償却要約レポート(XML) Short Name: FAS771S_XML DB package: FA_FAS771_XMLP_PKG KO FA 양식 4562 - 감가상각 및 상각 요약 보고서 Imported from BI Publisher Description: 요약 양식 4562 - 감가상각 및 상각 보고서 Application: Assets Source: 양식 4562 - 감가상각 및 상각 요약 보고서(XML) Short Name: FAS771S_XML DB package: FA_FAS771_XMLP_PKG PTB FA Form 4562 - Relatório do Resumo de Depreciação e Amortização Imported from BI Publisher Description: Form Resumido 4562 - Relatório de Depreciação e Amortização Application: Assets Source: Form 4562 - Relatório do Resumo de Depreciação e Amortização (XML) Short Name: FAS771S_XML DB package: FA_FAS771_XMLP_PKG RU FA Форма 4562 - сводный отчет об амортизации Imported from BI Publisher Description: Сводная форма 4562 - отчет об амортизации Application: Активы Source: Форма 4562 - сводный отчет об амортизации (XML) Short Name: FAS771S_XML DB package: FA_FAS771_XMLP_PKG S FA Formulär 4562 - översiktsrapport över avskrivning och amortering Imported from BI Publisher Description: Översiktsformulär 4562 - avskrivnings- och amorteringsrapport Application: Assets Source: Formulär 4562 - översiktsrapport över avskrivning och amortering (XML) Short Name: FAS771S_XML DB package: FA_FAS771_XMLP_PKG TR FA Ekran 4562 - Amortisman ve İtfa Özet Raporu Imported from BI Publisher Description: Özet Ekran 4562 - Amortisman ve İtfa Raporu Application: Duran Varlıklar Source: Ekran 4562 - Amortisman ve İtfa Özet Raporu (XML) Short Name: FAS771S_XML DB package: FA_FAS771_XMLP_PKG US FA Form 4562 - Depreciation and Amortization Summary Imported from BI Publisher Description: Summary Form 4562 - Depreciation and Amortization Report Application: Assets Source: Form 4562 - Depreciation and Amortization Summary Report (XML) Short Name: FAS771S_XML DB package: FA_FAS771_XMLP_PKG ZHS FA 表单 4562 - 折旧和摊销汇总报表 Imported from BI Publisher Description: 汇总表单 4562 - 折旧和摊销报表 Application: 资产 Source: 表单 4562 - 折旧和摊销汇总报表 (XML) Short Name: FAS771S_XML DB package: FA_FAS771_XMLP_PKG BI Publisher &cat_flex_all_seg &company_code :accounting_flex_structure :acct_bal_aprompt :book :book_class :currency_code :distribution_source_book :end_period_counter :p_adjusted :p_book :p_conc_request_id :p_fiscal_year :p_id_flex_num :p_min_precision :p_special_flag :previous_fiscal_year :report_period_close_date :rp_company_name :rp_report_name :start_period_counter :ytd :ytd_adj 1 -30 :p_adjusted Char TRUE Y AR التقرير المعدل التقرير المعدل D Berichtigungsauswertung Berichtigungsauswertung E Informe Ajustado Informe Ajustado F Etat ajusté Etat ajusté I Rapporto adeguato Rapporto adeguato JA 修正レポート 修正レポート KO 조정 보고서 조정 보고서 PTB Relatório Ajustado Relatório Ajustado RU Скорректированный отчет Скорректированный отчет S Justerad rapport Justerad rapport TR Düzeltilen Rapor Düzeltilen Rapor US Adjusted Report Adjusted Report ZHS 已调整报表 已调整报表 2 -10 :p_id_flex_num Number SELECT bc.accounting_flex_structure FROM FA_BOOK_CONTROLS bc,GL_SETS_OF_BOOKS sob,FND_CURRENCIES cur WHERE bc.book_type_code = :$flex$.book AND sob.set_of_books_id = bc.set_of_books_id AND sob.currency_code=cur.currency_code and rownum <2 Y AR دليل الحسابات دليل الحسابات D Kontenplan Kontenplan E Plan de Cuentas Plan de Cuentas F Plan de comptes Plan de comptes I Piano dei conti Piano dei conti JA 勘定体系 勘定体系 KO 계정코드집 계정코드집 PTB Plano de Contas Plano de Contas RU План счетов План счетов S Kontoplan Kontoplan TR Hesap Planı Hesap Planı US Chart of Accounts Chart of Accounts ZHS 科目表 科目表 3 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 Y AR الدفتر نوع الدفتر D AfA-Buch Art AfA-Buch E Libro Tipo de Libro F Livre Type de livre I Registro Tipo di registro JA 台帳 台帳タイプ KO 장부 장부 유형 PTB Livro Tipo de Livro RU Книга Тип книги S Bok Boktyp TR Defter Defter Tipi US Book Book Type ZHS 帐簿 账簿类型 4 20 :p_fiscal_year LOV Oracle FA_FISCAL_YEAR_DEPRN 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$.fa_book_type) and fiscal_year in (select distinct fiscal_year from fa_deprn_periods where book_type_code=:$flex$.fa_book_type) order by fiscal_year Y AR السنة المالية السنة المالية D Geschäftsjahr Geschäftsjahr E Año Fiscal Año Fiscal F Exercice Exercice I Anno fiscale Anno fiscale JA 会計年度 会計年度 KO 회계년도 회계년도 PTB Ano Fiscal Ano Fiscal RU Финансовый год Финансовый год S Räkenskapsår Räkenskapsår TR Mali Yıl Mali Yıl US Fiscal Year Fiscal Year ZHS 会计年度 会计年度