ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN A81513419A2527A3E0530100007F59FD FA Calendar Type Y select fct.calendar_type value, fct.description||' ('||fct.number_per_fiscal_year||')' description from fa_calendar_types fct order by fct.calendar_type US A813C0D5997571EBE0530100007FE5B1 FA Period (calendar type dependent) Y select fcp.period_name value, fcp.period_num||' - '||ffy.fiscal_year description from fa_calendar_periods fcp, fa_calendar_types fct, fa_fiscal_year ffy where fcp.calendar_type=:$flex$.fa_calendar_type and fcp.calendar_type=fct.calendar_type and fct.fiscal_year_name=ffy.fiscal_year_name and fcp.start_date between ffy.start_date and ffy.end_date order by fcp.start_date desc US 8E2FF36EDE9079D2E0530100007F1FF2 FND Currency Y select fcv.currency_code value, fcv.description from fnd_currencies_vl fcv where fcv.enabled_flag='Y' order by fcv.currency_code US 05FCF30F9B56017AE0630100007F6C53 GL Ledger (Asset Book Secured) Y select gl.name value, fifsv.id_flex_structure_name||': '||decode(gl.ledger_category_code,'NONE',xxen_util.meaning(gl.object_type_code,'LEDGERS',101),xxen_util.meaning(gl.ledger_category_code,'GL_ASF_LEDGER_CATEGORY',101))||': '||gl.description description from gl_ledgers gl, fnd_id_flex_structures_vl fifsv where gl.ledger_id in (select set_of_books_id from fa_book_controls_sec) and gl.chart_of_accounts_id=fifsv.id_flex_num and fifsv.id_flex_code='GL#' and fifsv.application_id=101 order by fifsv.id_flex_structure_name, decode(gl.ledger_category_code,'PRIMARY',1,'SECONDARY',2,'ALC',3,'NONE',4), gl.name US 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US A317138E538E3694E053B86B6358A3C6 select distinct gl.name ledger, fpiv.book_type_code book, &segment_columns &asset_columns fpiv.period_name period, sum(fpiv.depreciation) over (partition by fpiv.request_id, fpiv.book_type_code, &segment_columns2 &asset_number fpiv.period_name, fpiv.fiscal_year) depreciation, fpiv.fiscal_year, fpiv.period_index, &segment_columns3 fpiv.request_id from gl_ledgers gl, fa_book_controls fbc, fa_proj_interim_v fpiv, fa_additions_vl fav, fa_categories_b_kfv fcbk, fa_asset_keywords_kfv fakk, gl_code_combinations gcc where 1=1 and gl.ledger_id=fbc.set_of_books_id and fbc.book_type_code=fpiv.book_type_code and fpiv.asset_id=fav.asset_id and fav.asset_category_id=fcbk.category_id(+) and fav.asset_key_ccid=fakk.code_combination_id(+) and fpiv.code_combination_id=gcc.code_combination_id order by fpiv.request_id, gl.name, fpiv.book_type_code, &segment_columns2 &asset_number fpiv.fiscal_year, fpiv.period_index Y XXEN_FA_FAS_XMLP AR FA Depreciation Projection استنادًا إلى "تقرير إسقاط الإهلاك" من Oracle FASPRJ يستخدم استدعاء حزمة DB المخصص XXEN_FASPRJ لبدء تشغيل FAPROJ القياسي لإهلاك Oracle القياسي. يتم شرح توليد البيانات في ملاحظة: كيف تتعامل توقعات الاستهلاك مع جدول FA_PROJ_INTERIM_XXX أو FA_PROJ_INTERIM_REP؟ (معرف الوثيقة 1607626.1) https://support.oracle.com/CSP/main/article؟cmd=show&type=NOT&id=1607626.1 D FA Depreciation Projection Basierend auf dem 'Depreciation Projection Report' FASPRJ von Oracle Verwendet den benutzerdefinierten DB-Paketaufruf XXEN_FASPRJ, um den Oracle-Standard-Abschreibungsprojektions-Report FAPROJ zu starten. Die Datengenerierung wird im Hinweis erläutert: Wie handhabt FA Depreciation Projections die Tabelle FA_PROJ_INTERIM_XXX oder FA_PROJ_INTERIM_REP ? (Dok-ID 1607626.1) https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=1607626.1 E FA Depreciation Projection Basado en el "Informe de proyección de depreciación" de Oracle FASPRJ Utiliza la llamada al paquete de BD personalizado XXEN_FASPRJ para lanzar el FAPROJ de proyección de depreciación estándar de Oracle. La generación de datos se explica en la nota: ¿Cómo maneja FA Depreciation Projections la tabla FA_PROJ_INTERIM_XXX o FA_PROJ_INTERIM_REP? (Doc ID 1607626.1) https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=1607626.1 F FA Depreciation Projection Basé sur le "Depreciation Projection Report" d'Oracle FASPRJ Utilise le paquet personnalisé de la DB, appelé XXEN_FASPRJ, pour lancer le FAPROJ concurrent de la norme Oracle de projection d'amortissement. La génération des données est expliquée en note : Comment les projections d'amortissement FA traitent-elles la table FA_PROJ_INTERIM_XXX ou FA_PROJ_INTERIM_REP ? (Doc ID 1607626.1) https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=1607626.1 I FA Depreciation Projection Basato sul 'Depreciation Projection Report' FASPRJ di Oracle Utilizza la chiamata personalizzata del pacchetto DB XXEN_FASPRJ per lanciare la proiezione di ammortamento standard Oracle concorrente FAPROJ. La generazione dei dati è spiegata nella nota: Come FA Depreciation Projections gestisce la tabella FA_PROJ_INTERIM_XXX o FA_PROJ_INTERIM_REP? (Doc ID 1607626.1) https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=1607626.1 JA FA Depreciation Projection オラクルの「減価償却予測レポート」FASPRJに基づく Oracle標準の減価償却投影同時起動FAPROJを起動するためにカスタムDBパッケージコールXXEN_FASPRJを使用しています。データ生成については注記で説明しています。 FA減価償却計画はどのようにテーブルFA_PROJ_INTERIM_XXXまたはFA_PROJ_INTERIM_REPを処理しますか？(ドキュメントID 1607626.1) https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=1607626.1 KO FA Depreciation Projection 오라클의 '감가 상각 예측 보고서'FASPRJ 기반 사용자 지정 DB 패키지 호출 XXEN_FASPRJ를 사용하여 Oracle 표준 감가 상각 예상 동시 FAPROJ를 시작합니다. 데이터 생성에 대한 설명은 다음과 같습니다. FA 감가 상각 예측은 테이블 FA_PROJ_INTERIM_XXX 또는 FA_PROJ_INTERIM_REP를 어떻게 처리합니까? (문서 ID 1607626.1) https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=1607626.1 PTB FA Depreciation Projection Baseado no "Relatório de Projeção de Depreciação" FASPRJ da Oracle Utiliza o pacote personalizado DB call XXEN_FASPRJ para lançar a Projeção de Depreciação padrão Oracle FAPROJ concorrente. A geração de dados é explicada em nota: Como as Projeções de Depreciação FA tratam a Tabela FA_PROJ_INTERIM_XXX ou FA_PROJ_INTERIM_REP ? (Doc ID 1607626.1) https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=1607626.1 RU FA Depreciation Projection На основании отчета Oracle "Прогноз амортизации" FASPRJ Использует пользовательский вызов пакета БД XXEN_FASPRJ для одновременного запуска FAPROJ по стандарту Oracle "Прогноз амортизации". Генерация данных описана в примечании: Как обрабатывается таблица прогнозов амортизации FA_PROJ_INTERIM_XXX или FA_PROJ_INTERIM_REP ? (Идент. номер документа 1607626.1). https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=1607626.1 S FA Depreciation Projection Baserat på Oracles '' Avskrivningsprojektionsrapport '' FASPRJ Använder anpassat DB-paketsamtal XXEN_FASPRJ för att starta Oracle standardavskrivningsprojektion samtidigt FAPROJ. Datagenereringen förklaras i anmärkning: Hur hanterar FA-avskrivningsprognoser tabellen FA_PROJ_INTERIM_XXX eller FA_PROJ_INTERIM_REP? (Doc ID 1607626.1) https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=1607626.1 TR FA Depreciation Projection Oracle'ın 'Amortisman Projeksiyon Raporu' FASPRJ'ye dayanmaktadır Oracle standart Amortisman Projeksiyonu eşzamanlı FAPROJ'u başlatmak için özel DB paket çağrısı XXEN_FASPRJ'yi kullanır. Veri üretimi notta açıklanmıştır: FA Amortisman Tahminleri FA_PROJ_INTERIM_XXX veya FA_PROJ_INTERIM_REP Tablosunu Nasıl İşler? (Belge Kimliği 1607626.1) https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=1607626.1 US FA Depreciation Projection Based on Oracle's 'Depreciation Projection Report' FASPRJ Uses custom DB package call XXEN_FA_FAS_XMLP to launch Oracle standard Depreciation Projection concurrent FAPROJ. The data generation is explained in note: How Does FA Depreciation Projections Handle Table FA_PROJ_INTERIM_XXX or FA_PROJ_INTERIM_REP ? (KB730395) https://support.oracle.com/support/?kmContentId=1607626 ZHS FA Depreciation Projection 根据甲骨文的 "折旧预测报告 "FASPRJ。 使用自定义DB包调用XXEN_FASPRJ启动Oracle标准折旧预测并发FAPROJ。数据的生成见注解。 FA折旧预测如何处理表FA_PROJ_INTERIM_XXX或FA_PROJ_INTERIM_REP ?(文件ID 1607626.1) https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=1607626.1 Enginatics R12 only &asset_columns &asset_number &segment_columns &segment_columns2 &segment_columns3 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 FASPRJ Y US FAS Code 2 10 &segment_columns select 'gcc.'||lower(fifsv.application_column_name)||' "'||substrb(fifsv.form_left_prompt_,1,xxen_report.max_column_length)||'",'||chr(10)|| 'xxen_util.segment_description(gcc.'||lower(fifsv.application_column_name)||', '''||fifsv.application_column_name||''', gcc.chart_of_accounts_id'|| ( select ', gcc.'||lower(fifs.application_column_name) from fnd_id_flex_segments fifs where fifsv.application_id=fifs.application_id and fifsv.id_flex_code=fifs.id_flex_code and fifsv.id_flex_num=fifs.id_flex_num and fifsv.enabled_flag=fifs.enabled_flag and fifs.flex_value_set_id=(select ffvs.parent_flex_value_set_id from fnd_flex_value_sets ffvs where fifsv.flex_value_set_id=ffvs.flex_value_set_id) )||') "'||substrb(fifsv.form_left_prompt_,1,xxen_report.max_column_length-5)||' desc",' text from (select xxen_util.init_cap(fifsv.form_left_prompt) form_left_prompt_, fifsv.* from fnd_id_flex_segments_vl fifsv) fifsv where ( fifsv.application_id, fifsv.id_flex_code, fifsv.id_flex_num, fifsv.application_column_name ) in (select fsav.application_id, fsav.id_flex_code, fsav.id_flex_num, fsav.application_column_name from fnd_segment_attribute_values fsav where fsav.segment_attribute_type in ('GL_BALANCING','GL_ACCOUNT') and fsav.attribute_value='Y') and fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.id_flex_num in (select gl.chart_of_accounts_id from gl_ledgers gl where xxen_util.contains(:ledger,gl.name)='Y') order by fifsv.segment_num LOV GL Ledger (Asset Book Secured) 05FCF30F9B56017AE0630100007F6C53 Y select gl.name value, fifsv.id_flex_structure_name||': '||decode(gl.ledger_category_code,'NONE',xxen_util.meaning(gl.object_type_code,'LEDGERS',101),xxen_util.meaning(gl.ledger_category_code,'GL_ASF_LEDGER_CATEGORY',101))||': '||gl.description description from gl_ledgers gl, fnd_id_flex_structures_vl fifsv where gl.ledger_id in (select set_of_books_id from fa_book_controls_sec) and gl.chart_of_accounts_id=fifsv.id_flex_num and fifsv.id_flex_code='GL#' and fifsv.application_id=101 order by fifsv.id_flex_structure_name, decode(gl.ledger_category_code,'PRIMARY',1,'SECONDARY',2,'ALC',3,'NONE',4), gl.name select gl.name from gl_sets_of_books gl where gl.set_of_books_id in (select set_of_books_id from fa_book_controls_sec) and gl.set_of_books_id = nvl(fnd_profile.value('GL_SET_OF_BKS_ID'),gl.set_of_books_id) Y F Grand livre US Ledger 3 &segment_columns2 select 'gcc.'||lower(fifsv.application_column_name)||',' text from fnd_id_flex_segments_vl fifsv where ( fifsv.application_id, fifsv.id_flex_code, fifsv.id_flex_num, fifsv.application_column_name ) in (select fsav.application_id, fsav.id_flex_code, fsav.id_flex_num, fsav.application_column_name from fnd_segment_attribute_values fsav where fsav.segment_attribute_type in ('GL_BALANCING','GL_ACCOUNT') and fsav.attribute_value='Y') and fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.id_flex_num in (select gl.chart_of_accounts_id from gl_ledgers gl where xxen_util.contains(:ledger,gl.name)='Y') order by fifsv.segment_num F Grand livre US Ledger 4 &segment_columns3 select 'gcc.'||lower(fifsv.application_column_name)||'||'' - '''||'||xxen_util.segment_description(gcc.'||lower(fifsv.application_column_name)||', '''||fifsv.application_column_name||''', gcc.chart_of_accounts_id'|| ( select ', gcc.'||lower(fifs.application_column_name) from fnd_id_flex_segments fifs where fifsv.application_id=fifs.application_id and fifsv.id_flex_code=fifs.id_flex_code and fifsv.id_flex_num=fifs.id_flex_num and fifsv.enabled_flag=fifs.enabled_flag and fifs.flex_value_set_id=(select ffvs.parent_flex_value_set_id from fnd_flex_value_sets ffvs where fifsv.flex_value_set_id=ffvs.flex_value_set_id) )||') "'||substrb(fifsv.form_left_prompt_,1,xxen_report.max_column_length-10)||' with desc",' text from (select xxen_util.init_cap(fifsv.form_left_prompt) form_left_prompt_, fifsv.* from fnd_id_flex_segments_vl fifsv) fifsv where ( fifsv.application_id, fifsv.id_flex_code, fifsv.id_flex_num, fifsv.application_column_name ) in (select fsav.application_id, fsav.id_flex_code, fsav.id_flex_num, fsav.application_column_name from fnd_segment_attribute_values fsav where fsav.segment_attribute_type in ('GL_BALANCING','GL_ACCOUNT') and fsav.attribute_value='Y') and fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.id_flex_num in (select gl.chart_of_accounts_id from gl_ledgers gl where xxen_util.contains(:ledger,gl.name)='Y') order by fifsv.segment_num F Grand livre US Ledger 5 20 :p_calendar_type LOV FA Calendar Type A81513419A2527A3E0530100007F59FD Y select fct.calendar_type value, fct.description||' ('||fct.number_per_fiscal_year||')' description from fa_calendar_types fct order by fct.calendar_type Monthly Y F Calendrier US Calendar 6 30 :p_period_count Number select fct.number_per_fiscal_year from fa_calendar_types fct where fct.calendar_type=:$flex$.fa_calendar_type Y F Nombre de périodes US Number of Periods 7 40 :p_period_name LOV FA Period (calendar type dependent) A813C0D5997571EBE0530100007FE5B1 Y select fcp.period_name value, fcp.period_num||' - '||ffy.fiscal_year description from fa_calendar_periods fcp, fa_calendar_types fct, fa_fiscal_year ffy where fcp.calendar_type=:$flex$.fa_calendar_type and fcp.calendar_type=fct.calendar_type and fct.fiscal_year_name=ffy.fiscal_year_name and fcp.start_date between ffy.start_date and ffy.end_date order by fcp.start_date desc Y F Période de départ US Starting Period 8 50 :p_currency LOV FND Currency 8E2FF36EDE9079D2E0530100007F1FF2 Y select fcv.currency_code value, fcv.description from fnd_currencies_vl fcv where fcv.enabled_flag='Y' order by fcv.currency_code select gl.currency_code from gl_ledgers gl where gl.name=:$flex$.ledger Y F Monnaie US Currency 9 60 :p_book1 LOV custom Y select fbc.book_type_code value, fbc.book_type_name description from fa_book_controls_sec fbc, fa_deprn_periods fdp where fbc.book_type_code=fdp.book_type_code and fdp.period_close_date is null and ( fbc.book_type_code in (select fmbc.book_type_code from gl_ledgers gl, fa_mc_book_controls fmbc where gl.currency_code=:$flex$.currency and xxen_util.contains(:$flex$.ledger,gl.name)='Y' and gl.ledger_id=fmbc.set_of_books_id) or fbc.book_type_code in (select fbc1.book_type_code from gl_ledgers gl, fa_book_controls fbc1 where gl.currency_code=:$flex$.currency and xxen_util.contains(:$flex$.ledger,gl.name)='Y' and gl.ledger_id=fbc1.set_of_books_id) ) order by fbc.book_type_code Y US Book1 10 70 :p_book2 LOV custom Y select fbc.book_type_code value, fbc.book_type_name description from fa_book_controls_sec fbc, fa_deprn_periods fdp where fbc.book_type_code<>:$flex$.book1 and fbc.book_type_code=fdp.book_type_code and fdp.period_close_date is null and ( fbc.book_type_code in (select fmbc.book_type_code from gl_ledgers gl, fa_mc_book_controls fmbc where gl.currency_code=:$flex$.currency and xxen_util.contains(:$flex$.ledger,gl.name)='Y' and gl.ledger_id=fmbc.set_of_books_id) or fbc.book_type_code in (select fbc1.book_type_code from gl_ledgers gl, fa_book_controls fbc1 where gl.currency_code=:$flex$.currency and xxen_util.contains(:$flex$.ledger,gl.name)='Y' and gl.ledger_id=fbc1.set_of_books_id) ) order by fbc.book_type_code US Book2 11 80 :p_book3 LOV custom Y select fbc.book_type_code value, fbc.book_type_name description from fa_book_controls_sec fbc, fa_deprn_periods fdp where fbc.book_type_code<>:$flex$.book1 and fbc.book_type_code<>:$flex$.book2 and fbc.book_type_code=fdp.book_type_code and fdp.period_close_date is null and ( fbc.book_type_code in (select fmbc.book_type_code from gl_ledgers gl, fa_mc_book_controls fmbc where gl.currency_code=:$flex$.currency and xxen_util.contains(:$flex$.ledger,gl.name)='Y' and gl.ledger_id=fmbc.set_of_books_id) or fbc.book_type_code in (select fbc1.book_type_code from gl_ledgers gl, fa_book_controls fbc1 where gl.currency_code=:$flex$.currency and xxen_util.contains(:$flex$.ledger,gl.name)='Y' and gl.ledger_id=fbc1.set_of_books_id) ) order by fbc.book_type_code US Book3 12 90 :p_book4 LOV custom Y select fbc.book_type_code value, fbc.book_type_name description from fa_book_controls_sec fbc, fa_deprn_periods fdp where fbc.book_type_code<>:$flex$.book1 and fbc.book_type_code<>:$flex$.book2 and fbc.book_type_code<>:$flex$.book3 and fbc.book_type_code=fdp.book_type_code and fdp.period_close_date is null and ( fbc.book_type_code in (select fmbc.book_type_code from gl_ledgers gl, fa_mc_book_controls fmbc where gl.currency_code=:$flex$.currency and xxen_util.contains(:$flex$.ledger,gl.name)='Y' and gl.ledger_id=fmbc.set_of_books_id) or fbc.book_type_code in (select fbc1.book_type_code from gl_ledgers gl, fa_book_controls fbc1 where gl.currency_code=:$flex$.currency and xxen_util.contains(:$flex$.ledger,gl.name)='Y' and gl.ledger_id=fbc1.set_of_books_id) ) order by fbc.book_type_code US Book4 13 100 &asset_columns fav.asset_number, fav.description, fav.tag_number, fcbk.concatenated_segments category, fav.serial_number, fakk.concatenated_segments asset_key, fakk.concatenated_segments||' - '||fav.description asset_key_description, LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y F Afficher le numéro de l'actif US Show Asset Number 14 &asset_number fav.asset_number, US Show Asset Number 15 110 &segment_columns select 'gcc.'||lower(fifsv.application_column_name)||' "'||substrb(fifsv.form_left_prompt_,1,xxen_report.max_column_length)||'",'||chr(10)|| 'xxen_util.segment_description(gcc.'||lower(fifsv.application_column_name)||', '''||fifsv.application_column_name||''', gcc.chart_of_accounts_id'|| ( select ', gcc.'||lower(fifs.application_column_name) from fnd_id_flex_segments fifs where fifsv.application_id=fifs.application_id and fifsv.id_flex_code=fifs.id_flex_code and fifsv.id_flex_num=fifs.id_flex_num and fifsv.enabled_flag=fifs.enabled_flag and fifs.flex_value_set_id=(select ffvs.parent_flex_value_set_id from fnd_flex_value_sets ffvs where fifsv.flex_value_set_id=ffvs.flex_value_set_id) )||') "'||substrb(fifsv.form_left_prompt_,1,xxen_report.max_column_length-5)||' desc",' text from (select xxen_util.init_cap(fifsv.form_left_prompt) form_left_prompt_, fifsv.* from fnd_id_flex_segments_vl fifsv) fifsv where (fifsv.application_id, fifsv.id_flex_code, fifsv.id_flex_num, fifsv.application_column_name) in (select fsav.application_id, fsav.id_flex_code, fsav.id_flex_num, fsav.application_column_name from fnd_segment_attribute_values fsav where fsav.segment_attribute_type='FA_COST_CTR' and fsav.attribute_value='Y') and fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.id_flex_num in (select gl.chart_of_accounts_id from gl_ledgers gl where xxen_util.contains(:ledger,gl.name)='Y') LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y F Afficher le centre de coût US Show Cost Center 16 &segment_columns2 select 'gcc.'||lower(fifsv.application_column_name)||',' text from fnd_id_flex_segments_vl fifsv where (fifsv.application_id, fifsv.id_flex_code, fifsv.id_flex_num, fifsv.application_column_name) in (select fsav.application_id, fsav.id_flex_code, fsav.id_flex_num, fsav.application_column_name from fnd_segment_attribute_values fsav where fsav.segment_attribute_type='FA_COST_CTR' and fsav.attribute_value='Y') and fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.id_flex_num in (select gl.chart_of_accounts_id from gl_ledgers gl where xxen_util.contains(:ledger,gl.name)='Y') F Afficher le centre de coût US Show Cost Center 17 &segment_columns3 select 'gcc.'||lower(fifsv.application_column_name)||'||'' - '''||'||xxen_util.segment_description(gcc.'||lower(fifsv.application_column_name)||', '''||fifsv.application_column_name||''', gcc.chart_of_accounts_id'|| ( select ', gcc.'||lower(fifs.application_column_name) from fnd_id_flex_segments fifs where fifsv.application_id=fifs.application_id and fifsv.id_flex_code=fifs.id_flex_code and fifsv.id_flex_num=fifs.id_flex_num and fifsv.enabled_flag=fifs.enabled_flag and fifs.flex_value_set_id=(select ffvs.parent_flex_value_set_id from fnd_flex_value_sets ffvs where fifsv.flex_value_set_id=ffvs.flex_value_set_id) )||') "'||substrb(fifsv.form_left_prompt_,1,xxen_report.max_column_length-10)||' with desc",' text from (select xxen_util.init_cap(fifsv.form_left_prompt) form_left_prompt_, fifsv.* from fnd_id_flex_segments_vl fifsv) fifsv where (fifsv.application_id, fifsv.id_flex_code, fifsv.id_flex_num, fifsv.application_column_name) in (select fsav.application_id, fsav.id_flex_code, fsav.id_flex_num, fsav.application_column_name from fnd_segment_attribute_values fsav where fsav.segment_attribute_type='FA_COST_CTR' and fsav.attribute_value='Y') and fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.id_flex_num in (select gl.chart_of_accounts_id from gl_ledgers gl where xxen_util.contains(:ledger,gl.name)='Y') F Afficher le centre de coût US Show Cost Center 18 120 1=1 fpiv.request_id in (select fcr.request_id from fnd_concurrent_requests fcr where fcr.description='FA Projections '||fnd_global.conc_request_id) LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y F Projection des amortissements en cours US Run Depreciation Projection 19 130 1=1 fpiv.request_id=:request_id LOV custom Y select fppr.request_id value, fppr.period_name||', '||fppr.period_count||', '||fppr.book_type_code1||' ('||(select count(*) from fa_proj_interim_rep fpir where fppr.request_id=fpir.request_id and fppr.book_type_code1=fpir.book_type_code)||')'|| nvl2(fppr.book_type_code2,', '||fppr.book_type_code2||' ('||(select count(*) from fa_proj_interim_rep fpir where fppr.request_id=fpir.request_id and fppr.book_type_code2=fpir.book_type_code)||')',null)|| nvl2(fppr.book_type_code3,', '||fppr.book_type_code3||' ('||(select count(*) from fa_proj_interim_rep fpir where fppr.request_id=fpir.request_id and fppr.book_type_code3=fpir.book_type_code)||')',null)|| nvl2(fppr.book_type_code4,', '||fppr.book_type_code4||' ('||(select count(*) from fa_proj_interim_rep fpir where fppr.request_id=fpir.request_id and fppr.book_type_code4=fpir.book_type_code)||')',null) description from fa_proj_param_run fppr where :$flex$.Run_Depreciation_Projection is null order by fppr.request_id desc F Id. de la demande précédente US Previous Request Id :$flex$.Run_Depreciation_Projection Run Depreciation Projection Previous Request Id :$flex$.book1 Book1 Book2 :$flex$.book1 Book1 Book3 :$flex$.book1 Book1 Book4 :$flex$.book2 Book2 Book3 :$flex$.book2 Book2 Book4 :$flex$.book3 Book3 Book4 :$flex$.currency Currency Book1 :$flex$.currency Currency Book2 :$flex$.currency Currency Book3 :$flex$.currency Currency Book4 :$flex$.fa_calendar_type Calendar Number of Periods :$flex$.fa_calendar_type Calendar Starting Period :$flex$.ledger Ledger Book1 :$flex$.ledger Ledger Book2 :$flex$.ledger Ledger Book3 :$flex$.ledger Ledger Book4 :$flex$.ledger Ledger Currency