ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D470DE51A9E05362FB09050512 SELECT DISTINCT --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') COMP_CODE, BK_FED.DEPRN_METHOD_CODE FED_METHOD, --&CAT_FLEX_ALL_SEG CATEGORY, DECODE(AH.ASSET_TYPE,'CIP',CB_AMT.CIP_COST_ACCT, CB_AMT.ASSET_COST_ACCT) ACCT, AD.asset_number ASSET_NUMBER, ad.asset_id ASSET_ID, --fnd_flex_xml_publisher_apis.process_kff_combination_1('comp_code_dsp', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') COMP_CODE_DSP, --fnd_flex_xml_publisher_apis.process_kff_combination_1('d_category', 'OFA', 'CAT#', 101, NULL, cat.CATEGORY_ID, 'ALL', 'Y', 'VALUE') D_CATEGORY, fnd_flex_xml_publisher_apis.process_kff_combination_1('comp_code_dsp', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') COMP_CODE_DSP1, fnd_flex_xml_publisher_apis.process_kff_combination_1('d_category', 'OFA', 'CAT#', 101, NULL, cat.CATEGORY_ID, 'ALL', 'Y', 'VALUE') D_CATEGORY1, --&COMP_CODE BAL_SEG, fnd_flex_xml_publisher_apis.process_kff_combination_1('comp_code_dsp', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') BAL_SEG, FA_FASAAMTD_XMLP_PKG.fed_deprnformula(:FED_DD, :FED_ADJUST) FED_DEPRN, FA_FASAAMTD_XMLP_PKG.amt_deprnformula(:AMT_DD, :AMT_ADJUST) AMT_DEPRN, FA_FASAAMTD_XMLP_PKG.diff_deprnformula(:FED_DEPRN, :AMT_DEPRN) DIFF_DEPRN FROM FA_CATEGORY_BOOKS CB_FED, FA_CATEGORY_BOOKS CB_AMT, FA_CATEGORIES CAT, FA_BOOKS BK_FED, FA_BOOKS BK_AMT, FA_DEPRN_PERIODS DP_FED, FA_DEPRN_PERIODS DP_AMT, FA_ADDITIONS AD, GL_CODE_COMBINATIONS DHCC, FA_ASSET_HISTORY AH, FA_DEPRN_DETAIL DD, FA_DISTRIBUTION_HISTORY DH WHERE DD.ASSET_ID = AD.ASSET_ID AND DD.BOOK_TYPE_CODE IN (:P_FED_BOOK, :P_AMT_BOOK) AND DD.PERIOD_COUNTER between :FED_START_PERIOD_PC and :FED_END_PERIOD_PC AND DD.DEPRN_SOURCE_CODE = 'D' AND BK_FED.BOOK_TYPE_CODE = :P_FED_BOOK AND BK_AMT.BOOK_TYPE_CODE = :P_AMT_BOOK AND BK_FED.ASSET_ID = AD.ASSET_ID AND BK_AMT.ASSET_ID = AD.ASSET_ID AND DP_FED.PERIOD_CLOSE_DATE BETWEEN BK_FED.DATE_EFFECTIVE AND NVL(BK_FED.DATE_INEFFECTIVE, DP_FED.PERIOD_CLOSE_DATE) AND DP_AMT.PERIOD_CLOSE_DATE BETWEEN BK_AMT.DATE_EFFECTIVE AND NVL(BK_AMT.DATE_INEFFECTIVE, DP_AMT.PERIOD_CLOSE_DATE) AND CB_FED.BOOK_TYPE_CODE = :P_FED_BOOK AND CB_FED.CATEGORY_ID = CB_AMT.CATEGORY_ID AND CB_AMT.BOOK_TYPE_CODE = :P_AMT_BOOK AND CB_AMT.CATEGORY_ID = AH.CATEGORY_ID AND AH.ASSET_ID = AD.ASSET_ID AND DP_FED.PERIOD_CLOSE_DATE BETWEEN AH.DATE_EFFECTIVE AND NVL(AH.DATE_INEFFECTIVE, DP_FED.PERIOD_CLOSE_DATE) AND DECODE(AH.ASSET_TYPE,'CIP',CB_AMT.CIP_COST_ACCT, CB_AMT.ASSET_COST_ACCT) BETWEEN NVL(:P_FROM_ACCT, DECODE(AH.ASSET_TYPE,'CIP', CB_AMT.CIP_COST_ACCT, CB_AMT.ASSET_COST_ACCT)) AND NVL(:P_TO_ACCT, DECODE(AH.ASSET_TYPE,'CIP', CB_AMT.CIP_COST_ACCT, CB_AMT.ASSET_COST_ACCT)) AND dp_fed.period_counter = :PERIOD1_PC and dp_fed.book_type_code = :P_FED_BOOK and dp_AMT.period_counter = :PERIOD1_PC and dp_AMT.book_type_code = :P_AMT_BOOK AND CB_AMT.CATEGORY_ID = CAT.CATEGORY_ID AND DH.DISTRIBUTION_ID = DD.DISTRIBUTION_ID AND DHCC.CODE_COMBINATION_ID = DH.CODE_COMBINATION_ID UNION SELECT DISTINCT --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') COMP_CODE, BK_FED.DEPRN_METHOD_CODE FED_METHOD, --&CAT_FLEX_ALL_SEG CATEGORY, DECODE(AH.ASSET_TYPE,'CIP',CB_AMT.CIP_COST_ACCT, CB_AMT.ASSET_COST_ACCT) ACCT, AD.asset_number ASSET_NUMBER, ad.asset_id ASSET_ID, --fnd_flex_xml_publisher_apis.process_kff_combination_1('comp_code_dsp', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') COMP_CODE_DSP, --fnd_flex_xml_publisher_apis.process_kff_combination_1('d_category', 'OFA', 'CAT#', 101, NULL, cat.CATEGORY_ID, 'ALL', 'Y', 'VALUE') D_CATEGORY, fnd_flex_xml_publisher_apis.process_kff_combination_1('comp_code_dsp', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') COMP_CODE_DSP1, fnd_flex_xml_publisher_apis.process_kff_combination_1('d_category', 'OFA', 'CAT#', 101, NULL, cat.CATEGORY_ID, 'ALL', 'Y', 'VALUE') D_CATEGORY1, --&COMP_CODE BAL_SEG, fnd_flex_xml_publisher_apis.process_kff_combination_1('comp_code_dsp', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') BAL_SEG, FA_FASAAMTD_XMLP_PKG.fed_deprnformula(:FED_DD, :FED_ADJUST) FED_DEPRN, FA_FASAAMTD_XMLP_PKG.amt_deprnformula(:AMT_DD, :AMT_ADJUST) AMT_DEPRN, FA_FASAAMTD_XMLP_PKG.diff_deprnformula(:FED_DEPRN, :AMT_DEPRN) DIFF_DEPRN FROM FA_CATEGORY_BOOKS CB_FED, FA_CATEGORY_BOOKS CB_AMT, FA_CATEGORIES CAT, FA_BOOKS BK_FED, FA_BOOKS BK_AMT, FA_DEPRN_PERIODS DP_FED, FA_DEPRN_PERIODS DP_AMT, FA_ADDITIONS AD, GL_CODE_COMBINATIONS DHCC, FA_ASSET_HISTORY AH, FA_ADJUSTMENTS ADJ ,xla_ae_lines lines ,xla_distribution_links links ,fa_transaction_headers th WHERE AD.ASSET_ID = ADJ.ASSET_ID AND ADJ.BOOK_TYPE_CODE IN (:P_FED_BOOK, :P_AMT_BOOK) AND ADJ.PERIOD_COUNTER_ADJUSTED BETWEEN :FED_START_PERIOD_PC AND :FED_END_PERIOD_PC AND BK_FED.BOOK_TYPE_CODE = :P_FED_BOOK AND BK_AMT.BOOK_TYPE_CODE = :P_AMT_BOOK AND BK_FED.ASSET_ID = AD.ASSET_ID AND BK_AMT.ASSET_ID = AD.ASSET_ID AND DP_FED.PERIOD_CLOSE_DATE BETWEEN BK_FED.DATE_EFFECTIVE AND NVL(BK_FED.DATE_INEFFECTIVE, DP_FED.PERIOD_CLOSE_DATE) AND DP_AMT.PERIOD_CLOSE_DATE BETWEEN BK_AMT.DATE_EFFECTIVE AND NVL(BK_AMT.DATE_INEFFECTIVE, DP_AMT.PERIOD_CLOSE_DATE) AND CB_FED.BOOK_TYPE_CODE = :P_FED_BOOK AND CB_FED.CATEGORY_ID = CB_AMT.CATEGORY_ID AND CB_AMT.BOOK_TYPE_CODE = :P_AMT_BOOK AND CB_AMT.CATEGORY_ID = AH.CATEGORY_ID AND AH.ASSET_ID = AD.ASSET_ID AND DP_FED.PERIOD_CLOSE_DATE BETWEEN AH.DATE_EFFECTIVE AND NVL(AH.DATE_INEFFECTIVE, DP_FED.PERIOD_CLOSE_DATE) AND DECODE(AH.ASSET_TYPE,'CIP',CB_AMT.CIP_COST_ACCT, CB_AMT.ASSET_COST_ACCT) BETWEEN NVL(:P_FROM_ACCT, DECODE(AH.ASSET_TYPE,'CIP', CB_AMT.CIP_COST_ACCT, CB_AMT.ASSET_COST_ACCT)) AND NVL(:P_TO_ACCT, DECODE(AH.ASSET_TYPE,'CIP', CB_AMT.CIP_COST_ACCT, CB_AMT.ASSET_COST_ACCT)) AND dp_fed.period_counter = :PERIOD1_PC and dp_fed.book_type_code = :P_FED_BOOK and dp_AMT.period_counter = :PERIOD1_PC and dp_AMT.book_type_code = :P_AMT_BOOK AND CB_AMT.CATEGORY_ID = CAT.CATEGORY_ID AND lines.CODE_COMBINATION_ID = DHCC.CODE_COMBINATION_ID AND :P_ADJUSTED = 'TRUE' and th.transaction_header_id = adj.transaction_header_id and links.event_id = th.event_id and links.Source_distribution_id_num_1 = adj.transaction_header_id and links.Source_distribution_id_num_2 = adj.adjustment_line_id and links.application_id = 140 and lines.ae_header_id = links.ae_header_id and lines.ae_line_num = links.ae_line_num and lines.application_id = 140 and links.source_distribution_type = 'TRX' --ORDER BY 1,2,3,4,5 ORDER BY 5, 1, 2, 6, 3 OFA FASAMTXD_XML AR FA نموذج 4626 - تقرير تفاصيل AMT (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Imported from BI Publisher Description: نموذج 4626- تقرير تفاصيل AMT Application: الأصول Source: نموذج 4626 - تقرير تفاصيل AMT (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: FASAMTXD_XML DB package: FA_FASAAMTD_XMLP_PKG D FA Formular 4626 - AMT Details- Nicht unterstützt: Reserviert für zukünftige Verwendung Imported from BI Publisher Description: Formular 4626 - AMT Details Application: Anlagen Source: Formular 4626 - AMT Details (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: FASAMTXD_XML DB package: FA_FASAAMTD_XMLP_PKG E FA Formulario 4626 - AMT Detallado: No Admitido, Reservado para Uso Futuro Imported from BI Publisher Description: Formulario 4626 - AMT Detallado Application: Assets Source: Formulario 4626 - AMT Detallado (XML): No Admitido, Reservado para Uso Futuro Short Name: FASAMTXD_XML DB package: FA_FASAAMTD_XMLP_PKG F FA Form 4626 - AMT (USA) - Détail- Non pris en charge : réservé pour une utilisation ultérieure Imported from BI Publisher Description: Form 4626 - AMT (USA) - Détail Application: Assets Source: Form 4626 - AMT (USA) - Détail (XML) - Non pris en charge : réservé pour une utilisation ultérieure Short Name: FASAMTXD_XML DB package: FA_FASAAMTD_XMLP_PKG I FA Modello 4626 - rapporto Dettagli AMT- non supportato: riservato per usi futuri Imported from BI Publisher Description: Modello 4626 - Rapporto Dettagli AMT Application: Assets Source: Modello 4626 - rapporto Dettagli AMT (XML) - non supportato: riservato per usi futuri Short Name: FASAMTXD_XML DB package: FA_FASAAMTD_XMLP_PKG JA FA フォーム4626 - AMT詳細レポート- 未サポート: 将来の使用のために予約 Imported from BI Publisher Description: フォーム4626 - AMT詳細レポート Application: Assets Source: フォーム4626 - AMT詳細レポート(XML) - 未サポート: 将来の使用のために予約 Short Name: FASAMTXD_XML DB package: FA_FASAAMTD_XMLP_PKG KO FA 양식 4626 - AMT 상세 보고서- 지원되지 않음: 추후 사용을 위해 예약됨 Imported from BI Publisher Description: 양식 4626 - AMT 상세내역 보고서 Application: Assets Source: 양식 4626 - AMT 상세 보고서(XML) - 지원되지 않음: 추후 사용을 위해 예약됨 Short Name: FASAMTXD_XML DB package: FA_FASAAMTD_XMLP_PKG PTB FA Form 4626 - AMT - Relatório Detalhado- Não Suportado: Reservado Para Uso Futuro Imported from BI Publisher Description: Form 4626 - Relatório de Detalhe de AMT Application: Assets Source: Form 4626 - AMT - Relatório Detalhado (XML) - Não Suportado: Reservado Para Uso Futuro Short Name: FASAMTXD_XML DB package: FA_FASAAMTD_XMLP_PKG RU FA Форма 4626 - подробный отчет об АМН- не поддерживается: зарезервировано для будущего использования Imported from BI Publisher Description: Форма 4626 - подробный отчет об АМН Application: Активы Source: Форма 4626 - подробный отчет об АМН (XML) - не поддерживается: зарезервировано для будущего использования Short Name: FASAMTXD_XML DB package: FA_FASAAMTD_XMLP_PKG S FA Formulär 4626 - Beloppsinformation - detaljrapport- Stöds inte: Reserverad för framtida bruk Imported from BI Publisher Description: Formulär 4626 - Beloppsinformation - detaljrapport Application: Assets Source: Formulär 4626 - Beloppsinformation - detaljrapport (XML) - Stöds inte: Reserverad för framtida bruk Short Name: FASAMTXD_XML DB package: FA_FASAAMTD_XMLP_PKG TR FA Ekran 4626 - AMT Detay Raporu- Desteklenmiyor: İleride Kullanılmak Üzere Ayrılmıştır Imported from BI Publisher Description: Ekran 4626 - AMT Detay Raporu Application: Duran Varlıklar Source: Ekran 4626 - AMT Detay Raporu (XML) - Desteklenmiyor: İleride Kullanılmak Üzere Ayrılmıştır Short Name: FASAMTXD_XML DB package: FA_FASAAMTD_XMLP_PKG US FA Form 4626 - AMT Detail Report- Not Supported: Reserved For Future Use Imported from BI Publisher Description: Form 4626 - AMT Detail Report Application: Assets Source: Form 4626 - AMT Detail Report (XML) - Not Supported: Reserved For Future Use Short Name: FASAMTXD_XML DB package: FA_FASAAMTD_XMLP_PKG ZHS FA 表单 4626 - AMT 明细报表- 不支持：已保留供将来使用 Imported from BI Publisher Description: 表单 4626 - AMT 明细报表 Application: 资产 Source: 表单 4626 - AMT 明细报表 (XML) - 不支持：已保留供将来使用 Short Name: FASAMTXD_XML DB package: FA_FASAAMTD_XMLP_PKG BI Publisher &cat_flex_all_seg &comp_code :amt_adjust :amt_dd :amt_deprn :amt_end_period_pc :amt_start_period_pc :fed_adjust :fed_dd :fed_deprn :fed_end_period_pc :fed_start_period_pc :p_adjusted :p_amt_book :p_conc_request_id :p_fed_book :p_from_acct :p_min_precision :p_period1 :p_to_acct :period1_fy :period1_pc :period1_pcd :period1_pod :rp_bal_lprompt :rp_company_name :rp_report_name 1 -30 :p_not_used_in_report Number select Accounting_Flex_Structure from FA_BOOK_CONTROLS where Book_Type_Code = :$flex$.federal_book AR هيكل محاسبي مرن هيكل محاسبي مرن D Konto-FlexFeld-Struktur Konto-FlexFeld-Struktur E Estructura Contable Tipo de Estructura Contable F Structure clé comptable flexible Structure de clé comptable flexible I Struttura flexfield contabile Struttura del flexfield contabile JA 会計フレックスフィールド体系 会計フレックスフィールド体系 KO 회계 가변 구조 회계 가변 구조 PTB Estrutura de Flexfield Contábil Estrutura de Flexfield Contábil RU Структура ГП плана счетов Структура ГП плана счетов S Kodsträngsstruktur Kodsträngsstruktur TR Hesap Esnek Yapısı Hesap Esnekalanı Yapısı US Acct Flex Structure Accounting Flex Structure ZHS 会计科目弹性域结构 会计弹性结构 2 -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 已调整报表 已调整报表 3 10 :p_fed_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 FED-Buch FED-Buch E Libro Federal Libro Federal F Livre fédéral Livre fédéral I Registro federale Registro federale JA FEDERAL台帳 FEDERAL台帳 KO FED 장부 FED 장부 PTB Livro Federal Livro Federal RU Федеральная книга Федеральная книга S Extern redovisning Extern redovisning TR Federal Vergi Defteri Federal Vergi Defteri US Federal Book Federal Book ZHS 联邦帐簿 联邦帐簿 4 20 :p_amt_book LOV Oracle FA_TAX_BOOKS Y select book_type_code id, book_type_code value, book_type_name description from fa_book_controls_sec where book_class='TAX' order by book_type_code Y AR دفتر AMT دفتر AMT D AMT-Buch AMT-Buch E Libro AMT Libro AMT F Livre AMT Livre AMT I Registro AMT Registro AMT JA AMT台帳 AMT台帳 KO 장부 장부 PTB Livro AMT Livro AMT RU Книга АМН Книга АМН S AMT-bok AMT-bok TR AMT Defteri AMT Defteri US AMT Book AMT Book ZHS AMT 帐簿 AMT 帐簿 5 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 Y AR فترة النهاية اسم فترة النهاية D Bis Periode Bis Periode E Período de Finalización Nombre del Período de Finalización F Fin de période Nom de la période de fin I Periodo finale Nome del periodo finale JA 期間:至 期間名:至 KO 종료 기간 종료 기간명 PTB Per. Final Nome do Período Final RU Конечный период Имя конечного периода S Slutperiod Slutperiod TR Bitiş Dönemi Son Dönem Adı US End Period End Period Name ZHS 终止期间 终止期间名称 6 40 :p_from_acct Char AR من حساب أصل من حساب أصل D Von Anlagenkonto Von Anlagenkonto E De Cuenta de Activo De Cuenta de Activo F Du compte d'immobilisations Du compte d'immobilisations I Conto attività - Da Conto attività - Da JA 資産勘定:自 資産勘定:自 KO 자산 계정: 부터 자산 계정: 부터 PTB Conta de Ativo - De Conta de Ativo - De RU Начальный счет активов Начальный счет активов S Från anläggningskonto Från anläggningskonto TR İlk Varlık Hesabı İlk Varlık Hesabı US From Asset Account From Asset Account ZHS 自资产帐户 自资产帐户 7 50 :p_to_acct Char AR إلى حساب أصل إلى حساب أصل D Bis Anlagenkonto Bis Anlagenkonto E A Cuenta de Activo A Cuenta de Activo F Au compte d'immobilisations Au compte d'immobilisations I Conto attività - A Conto attività - A JA 資産勘定:至 資産勘定:至 KO 자산 계정: 까지 자산 계정: 까지 PTB Conta de Ativo - Até Conta de Ativo - Até RU Конечный счет активов Конечный счет активов S Till anläggningskonto Till anläggningskonto TR Son Varlık Hesabı Son Varlık Hesabı US To Asset Account To Asset Account ZHS 至资产帐户 至资产帐户 :$flex$.fa_book_type Federal Book End Period :$flex$.federal_book Federal Book Acct Flex Structure