ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D470D851A9E05362FB09050512 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 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.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 Y OFA FAS770_XML AR FA نموذج 4562 - تقرير الإهلاك والاستهلاك (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Imported from BI Publisher Description: نموذج 4562 - تقرير الإهلاك والاستهلاك Application: الأصول Source: نموذج 4562 - تقرير الإهلاك والاستهلاك (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: FAS770_XML DB package: FA_FAS771_XMLP_PKG D FA Formular 4562 - Abschreibungen- Nicht unterstützt: Reserviert für zukünftige Verwendung Imported from BI Publisher Description: Formular 4562 - Abschreibungen Application: Anlagen Source: Formular 4562 - Abschreibungen (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: FAS770_XML DB package: FA_FAS771_XMLP_PKG E FA Formulario 4562 - Amortizaciones: No Admitido, Reservado para Uso Futuro Imported from BI Publisher Description: Formulario 4562 - Amortizaciones Application: Assets Source: Formulario 4562 - Amortizaciones (XML): No Admitido, Reservado para Uso Futuro Short Name: FAS770_XML DB package: FA_FAS771_XMLP_PKG F FA Form 4562 - Depreciation and Amortization (USA)- Non pris en charge : réservé pour une utilisation future Imported from BI Publisher Description: Form 4562 - Depreciation and Amortization (USA) Application: Assets Source: Form 4562 - Depreciation and Amortization (USA) (XML) - Non pris en charge : réservé pour une utilisation future Short Name: FAS770_XML DB package: FA_FAS771_XMLP_PKG I FA Modello 4562 - rapporto Ammortamento- non supportato: riservato per usi futuri Imported from BI Publisher Description: Modello 4562 - Rapporto Ammortamento Application: Assets Source: Modello 4562 - rapporto Ammortamento (XML) - non supportato: riservato per usi futuri Short Name: FAS770_XML DB package: FA_FAS771_XMLP_PKG JA FA フォーム4562 - 減価償却レポート- 未サポート: 将来の使用のために予約 Imported from BI Publisher Description: フォーム4562 - 減価償却レポート Application: Assets Source: フォーム4562 - 減価償却レポート(XML) - 未サポート: 将来の使用のために予約 Short Name: FAS770_XML DB package: FA_FAS771_XMLP_PKG KO FA 양식 4562 - 감가상각과 상각 보고서- 지원되지 않음: 추후 사용을 위해 예약됨 Imported from BI Publisher Description: 양식 4562 - 감가상각과 상각보고서 Application: Assets Source: 양식 4562 - 감가상각과 상각 보고서(XML) - 지원되지 않음: 추후 사용을 위해 예약됨 Short Name: FAS770_XML DB package: FA_FAS771_XMLP_PKG PTB FA Form 4562 - Relatório de Depreciação e Amortização- Não Suportado: Reservado Para Uso Futuro Imported from BI Publisher Description: Form 4562 - Relatório de Depreciação e Amortização Application: Assets Source: Form 4562 - Relatório de Depreciação e Amortização (XML) - Não Suportado: Reservado Para Uso Futuro Short Name: FAS770_XML DB package: FA_FAS771_XMLP_PKG RU FA Форма 4562 - отчет об амортизации- не поддерживается: зарезервировано для будущего использования Imported from BI Publisher Description: Форма 4562 - отчет об амортизации Application: Активы Source: Форма 4562 - отчет об амортизации (XML) - не поддерживается: зарезервировано для будущего использования Short Name: FAS770_XML DB package: FA_FAS771_XMLP_PKG S FA Formulär 4562 - avskrivnings- och amorteringsrapport- Stöds inte: Reserverad för framtida bruk Imported from BI Publisher Description: Formulär 4562 - avskrivnings- och amorteringsrapport Application: Assets Source: Formulär 4562 - avskrivnings- och amorteringsrapport (XML) - Stöds inte: Reserverad för framtida bruk Short Name: FAS770_XML DB package: FA_FAS771_XMLP_PKG TR FA Ekran 4562 - Amortisman ve İtfa Raporu- Desteklenmez: Gelecekte Kullanım İçin Ayrılmıştır Imported from BI Publisher Description: Ekran 4562 - Amortisman ve İtfa Raporu Application: Duran Varlıklar Source: Ekran 4562 - Amortisman ve İtfa Raporu (XML) - Desteklenmez: Gelecekte Kullanım İçin Ayrılmıştır Short Name: FAS770_XML DB package: FA_FAS771_XMLP_PKG US FA Form 4562 - Depreciation and Amortization Report- Not Supported: Reserved For Future Use Imported from BI Publisher Description: Form 4562 - Depreciation and Amortization Report Application: Assets Source: Form 4562 - Depreciation and Amortization Report (XML) - Not Supported: Reserved For Future Use Short Name: FAS770_XML DB package: FA_FAS771_XMLP_PKG ZHS FA 表单 4562 - 折旧和摊销报表- 不支持：已保留供将来使用 Imported from BI Publisher Description: 表单 4562 - 折旧和摊销报表 Application: 资产 Source: 表单 4562 - 折旧和摊销报表 (XML) - 不支持：已保留供将来使用 Short Name: FAS770_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 -20 :p_adjusted Char FALSE 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_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 帐簿 账簿类型 3 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 会计年度 会计年度