ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D470E551A9E05362FB09050512 SELECT &ACCT_FLEX_BAL_SEG COMP_CODE, NVL (&ACCT_FLEX_ACCT_SEG, BAL.Category_Books_Account) ACCOUNT, &ACCT_FLEX_COST_SEG COST_CTR, AD.Asset_Number ASSET, SUM (DECODE (BAL.Source_Type_Code, 'BEGIN', NVL(BAL.Amount,0), NULL)) BEGIN, SUM (DECODE (BAL.Source_Type_Code, 'ADDITION', NVL(BAL.Amount,0), NULL)) ADDITION, SUM (DECODE (BAL.Source_Type_Code, 'DEPRECIATION', NVL(BAL.Amount,0), NULL)) DEPRECIATION, SUM (DECODE (BAL.Source_Type_Code, 'RECLASS', NVL(BAL.Amount,0), NULL)) RECLASS, SUM (DECODE (BAL.Source_Type_Code, 'RETIREMENT', -NVL(BAL.Amount,0), NULL)) RETIREMENT, SUM (DECODE (BAL.Source_Type_Code, 'REVALUATION', NVL(BAL.Amount,0), NULL)) REVALUATION, SUM (DECODE (BAL.Source_Type_Code, 'TAX', NVL(BAL.Amount,0), NULL)) TAX, SUM (DECODE (BAL.Source_Type_Code, 'TRANSFER', NVL(BAL.Amount,0), NULL)) TRANSFER, SUM (DECODE (BAL.Source_Type_Code, 'END', NVL(BAL.Amount,0), NULL)) END, --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('comp_code_dsp', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') COMP_CODE_DSP1, FA_FASRSVED_XMLP_PKG.bal_out_of_balanceformula(:BAL_BEGIN, :BAL_ADD, :BAL_DEPRN, :BAL_RECLASS, :BAL_RETIRE, :BAL_ADJUST, :BAL_TRANS, :BAL_END) BAL_OUT_OF_BALANCE, --fnd_flex_xml_publisher_apis.process_kff_combination_1('account_dsp', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'Y', 'VALUE') ACCOUNT_DSP, fnd_flex_xml_publisher_apis.process_kff_combination_1('account_dsp', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'Y', 'VALUE') ACCOUNT_DSP1, FA_FASRSVED_XMLP_PKG.acct_out_of_balanceformula(:ACCT_BEGIN, :ACCT_ADD, :ACCT_DEPRN, :ACCT_RECLASS, :ACCT_RETIRE, :ACCT_ADJUST, :ACCT_TRANS, :ACCT_END) ACCT_OUT_OF_BALANCE, --fnd_flex_xml_publisher_apis.process_kff_combination_1('cost_ctr_dsp', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'FA_COST_CTR', 'Y', 'VALUE') COST_CTR_DSP, fnd_flex_xml_publisher_apis.process_kff_combination_1('cost_ctr_dsp', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'FA_COST_CTR', 'Y', 'VALUE') COST_CTR_DSP1, FA_FASRSVED_XMLP_PKG.ctr_out_of_balanceformula(:CTR_BEGIN, :CTR_ADD, :CTR_DEPRN, :CTR_RECLASS, :CTR_RETIRE, :CTR_ADJUST, :CTR_TRANS, :CTR_END) CTR_OUT_OF_BALANCE, FA_FASRSVED_XMLP_PKG.adjustformula(SUM ( DECODE ( BAL.Source_Type_Code , 'TAX' , NVL ( BAL.Amount , 0 ) , NULL ) ), SUM ( DECODE ( BAL.Source_Type_Code , 'REVALUATION' , NVL ( BAL.Amount , 0 ) , NULL ) )) ADJUST, FA_FASRSVED_XMLP_PKG.out_of_balanceformula(SUM ( DECODE ( BAL.Source_Type_Code , 'BEGIN' , NVL ( BAL.Amount , 0 ) , NULL ) ), SUM ( DECODE ( BAL.Source_Type_Code , 'ADDITION' , NVL ( BAL.Amount , 0 ) , NULL ) ), SUM ( DECODE ( BAL.Source_Type_Code , 'DEPRECIATION' , NVL ( BAL.Amount , 0 ) , NULL ) ), SUM ( DECODE ( BAL.Source_Type_Code , 'RECLASS' , NVL ( BAL.Amount , 0 ) , NULL ) ), SUM ( DECODE ( BAL.Source_Type_Code , 'RETIREMENT' , - NVL ( BAL.Amount , 0 ) , NULL ) ), :ADJUST, SUM ( DECODE ( BAL.Source_Type_Code , 'TRANSFER' , NVL ( BAL.Amount , 0 ) , NULL ) ), SUM ( DECODE ( BAL.Source_Type_Code , 'END' , NVL ( BAL.Amount , 0 ) , NULL ) )) OUT_OF_BALANCE, FA_FASRSVED_XMLP_PKG.reval_tax_flagformula(SUM ( DECODE ( BAL.Source_Type_Code , 'REVALUATION' , NVL ( BAL.Amount , 0 ) , NULL ) ), SUM ( DECODE ( BAL.Source_Type_Code , 'TAX' , NVL ( BAL.Amount , 0 ) , NULL ) )) REVAL_TAX_FLAG FROM FA_BALANCES_REPORT_GT BAL, FA_ADDITIONS AD, GL_CODE_COMBINATIONS DHCC, GL_CODE_COMBINATIONS AJCC WHERE AD.Asset_ID = BAL.Asset_ID AND DHCC.Code_Combination_ID = BAL.Distribution_CCID AND AJCC.Code_Combination_ID (+) = BAL.Adjustment_CCID AND :DO_INSERT = 1 GROUP BY &ACCT_FLEX_BAL_SEG, NVL (&ACCT_FLEX_ACCT_SEG, BAL.Category_Books_Account), &ACCT_FLEX_COST_SEG, AD.ASSET_NUMBER --Added during DT Fix ,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') ,fnd_flex_xml_publisher_apis.process_kff_combination_1('account_dsp', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'Y', 'VALUE') ,fnd_flex_xml_publisher_apis.process_kff_combination_1('cost_ctr_dsp', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'FA_COST_CTR', 'Y', 'VALUE') --End of DT Fix ORDER BY 1 ASC,2 ASC,3 ASC , 1 , 2 , 3 , 4 Y OFA FASRSVED_XML AR FA تقرير تفاصيل الاحتياطي (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Imported from BI Publisher Description: تقرير تفاصيل الاحتياطي Application: الأصول Source: تقرير تفاصيل الاحتياطي (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: FASRSVED_XML DB package: FA_FASRSVED_XMLP_PKG D FA Kumulierte Abschreibungen - Details- Nicht unterstützt: Reserviert für zukünftige Verwendung Imported from BI Publisher Description: Kumulierte Abschreibungen - Details Application: Anlagen Source: Kumulierte Abschreibungen - Details (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: FASRSVED_XML DB package: FA_FASRSVED_XMLP_PKG E FA Informe Detalle de Reserva de Amortización: No Admitido, Reservado para Uso Futuro Imported from BI Publisher Description: Informe Detalle de Reserva de Amortización Application: Assets Source: Informe Detalle de Reserva de Amortización (XML): No Admitido, Reservado para Uso Futuro Short Name: FASRSVED_XML DB package: FA_FASRSVED_XMLP_PKG F FA Etat détaillé de l'amortissement cumulé- Non pris en charge : réservé pour une utilisation future Imported from BI Publisher Description: Grand Livre des comptes d'amortissement Application: Assets Source: Etat détaillé de l'amortissement cumulé (XML) - Non pris en charge : réservé pour une utilisation future Short Name: FASRSVED_XML DB package: FA_FASRSVED_XMLP_PKG I FA Rapporto Dettaglio fondi- non supportato: riservato per usi futuri Imported from BI Publisher Description: Rapporto Dettagli fondi Application: Assets Source: Rapporto Dettaglio fondi (XML) - non supportato: riservato per usi futuri Short Name: FASRSVED_XML DB package: FA_FASRSVED_XMLP_PKG JA FA 償却累計額詳細レポート- 未サポート: 将来の使用のために予約 Imported from BI Publisher Description: 償却累計額詳細レポート Application: Assets Source: 償却累計額詳細レポート(XML) - 未サポート: 将来の使用のために予約 Short Name: FASRSVED_XML DB package: FA_FASRSVED_XMLP_PKG KO FA 충당금 상세 보고서- 지원되지 않음: 추후 사용을 위해 예약됨 Imported from BI Publisher Description: 충당금 상세내역 보고서 Application: Assets Source: 충당금 상세 보고서(XML) - 지원되지 않음: 추후 사용을 위해 예약됨 Short Name: FASRSVED_XML DB package: FA_FASRSVED_XMLP_PKG PTB FA Relatório Detalhado da Reserva- Não Suportado: Reservado Para Uso Futuro Imported from BI Publisher Description: Relatório de Detalhe de Livro Application: Assets Source: Relatório Detalhado da Reserva (XML) - Não Suportado: Reservado Para Uso Futuro Short Name: FASRSVED_XML DB package: FA_FASRSVED_XMLP_PKG RU FA Подробный отчет о резерве- не поддерживается: зарезервировано для будущего использования Imported from BI Publisher Description: Подробный отчет о резерве Application: Активы Source: Подробный отчет о резерве (XML) - не поддерживается: зарезервировано для будущего использования Short Name: FASRSVED_XML DB package: FA_FASRSVED_XMLP_PKG S FA Reservdetaljrapport- Stöds inte: Reserverad för framtida bruk Imported from BI Publisher Description: Reservdetaljrapport Application: Assets Source: Reservdetaljrapport (XML) - Stöds inte: Reserverad för framtida bruk Short Name: FASRSVED_XML DB package: FA_FASRSVED_XMLP_PKG TR FA Yedek Akçe Detay Raporu- Desteklenmiyor: İleride Kullanılmak Üzere Ayrılmıştır Imported from BI Publisher Description: Birikmiş Amortisman Detay Raporu Application: Duran Varlıklar Source: Yedek Akçe Detay Raporu (XML) - Desteklenmiyor: İleride Kullanılmak Üzere Ayrılmıştır Short Name: FASRSVED_XML DB package: FA_FASRSVED_XMLP_PKG US FA Reserve Detail Report- Not Supported: Reserved For Future Use Imported from BI Publisher Description: Reserve Detail Report Application: Assets Source: Reserve Detail Report (XML) - Not Supported: Reserved For Future Use Short Name: FASRSVED_XML DB package: FA_FASRSVED_XMLP_PKG ZHS FA 准备金明细报表- 不支持：已保留供将来使用 Imported from BI Publisher Description: 准备金明细报表 Application: 资产 Source: 准备金明细报表 (XML) - 不支持：已保留供将来使用 Short Name: FASRSVED_XML DB package: FA_FASRSVED_XMLP_PKG BI Publisher &acct_flex_acct_seg &acct_flex_bal_seg &acct_flex_cost_seg :acct_add :acct_adjust :acct_bal_aprompt :acct_begin :acct_cc_aprompt :acct_deprn :acct_end :acct_reclass :acct_retire :acct_trans :adjust :bal_add :bal_adjust :bal_begin :bal_deprn :bal_end :bal_reclass :bal_retire :bal_trans :cat_maj_rprompt :ctr_add :ctr_adjust :ctr_begin :ctr_deprn :ctr_end :ctr_reclass :ctr_retire :ctr_trans :do_insert :lp_currency_code :lp_fa_book_controls :p_adj_mode :p_book :p_ca_org_id :p_ca_set_of_books_id :p_conc_request_id :p_min_precision :p_mrcsobtype :p_period1 :p_period2 :p_report_type :period1_fy :period1_pcd :period1_pod :period2_fy :period2_pcd :period2_pod :rp_bal_lprompt :rp_company_name :rp_ctr_lprompt :rp_period_from :rp_period_to :rp_report_name 1 -20 :p_report_type Char RESERVE Y AR نوع التقرير نوع التقرير D Auswertungsart Auswertungsart E Tipo de Informe Tipo de Informe F Type d'état Type d'état I Tipo di rapporto Tipo di rapporto JA レポート・タイプ レポート・タイプ KO 보고서 유형 보고서 유형 PTB Tipo de Relatório Tipo de Relatório RU Тип отчета Тип отчета S Rapporttyp Rapporttyp TR Rapor Tipi Rapor Tipi US Report Type Report Type 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_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 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) Y AR عملة دفاتر الحسابات عملة دفاتر الحسابات D Währung Buchungsstruktur Währung Buchungsstruktur E Divisa de Juego de Libros Divisa de Juego de Libros F Devise de l'entité comptable Devise de l'entité comptable I Divisa set of books Divisa set of books JA 会計帳簿通貨 会計帳簿通貨 KO 회계장부 통화 회계장부 통화 PTB Moeda do Conjunto de Livros Moeda do Conjunto de Livros RU Валюта набора книг Валюта набора книг S Räkenskapsvaluta Räkenskapsvaluta TR Yasal Muhasebe Birimi Para Birimi Yasal Muhasebe Birimi Para Birimi US Set of Books Currency Set of Books Currency ZHS 帐套币种 帐套币种 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 Y AR من الفترة فترة البداية D Von Periode Von Periode E De Período Período de Inicio F De la période Période de début I Periodo - Da Periodo iniziale JA 期間:自 期間:自 KO 기간: 부터 시작 기간 PTB Período - De Período Inicial RU Начальный период Начальный период S Från period Startperiod TR İlk Dönem Başlangıç Dönemi US From Period Start Period ZHS 自期间 起始期间 5 40 :p_period2 LOV Oracle FA_PERIOD_TO_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 period_counter from fa_deprn_periods where book_type_code= :$flex$.fa_book_type and period_name= :$flex$.fa_period_name_closed) order by period_counter Y AR إلى الفترة فترة النهاية D Bis Periode Bis Periode E A Período Período de Finalización F A la période Fin de période I Periodo - A Periodo finale JA 期間:至 期間:至 KO 기간: 까지 종료 기간 PTB Período - Até Per. Final RU Конечный период Конечный период S Till period Slutperiod TR Son Dönem Bitiş Dönemi US To Period End Period ZHS 至期间 终止期间