ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN B12587B17F666485E0530100007FA7F4 FA Book Y select x.value, x.description from ( select fbcs.book_type_code value, fbcs.book_type_name||' ('||fbcs.book_class||')' description from fa_book_controls_sec fbcs where :$flex$.ledger is null or fbcs.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y') and nvl(:$flex$.mrc_flag,'P') != 'R' union select fbcs.book_type_code value, fbcs.book_type_name||' ('||fbcs.book_class||')' description from fa_book_controls_sec fbcs, fa_mc_book_controls fmbc where fbcs.book_type_code = fmbc.book_type_code and fbcs.set_of_books_id = fmbc.primary_set_of_books_id and :$flex$.ledger is null or fmbc.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y') and nvl(:$flex$.mrc_flag,'P') = 'R' ) x order by x.value US 8E2FF36EDEDF79D2E0530100007F1FF2 FA Organization Y select haouv.name value, flvv.meaning description from hr_all_organization_units_vl haouv, fnd_lookup_values_vl flvv where haouv.organization_id in (select hoi.organization_id from hr_organization_information hoi where hoi.org_information1='FA_ORG' and hoi.org_information_context='CLASS' and hoi.org_information2='Y') and haouv.type=flvv.lookup_code(+) and flvv.lookup_type(+)='ORG_TYPE' and flvv.view_application_id(+)=3 and flvv.security_group_id(+)=0 order by haouv.name 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 535C61F92AE02EFAE0536209825EDD01 with c_alt_ledgers as ( select gl.ledger_id, fmbc.book_type_code, gl.name alternative_ledger, decode(gl.ledger_category_code,'ALC','Reporting','SECONDARY','Secondary') alternative_ledger_type, gl.currency_code alternative_ledger_currency, fifsv.description alt_ledger_chart_of_accounts, fmbc.gl_posting_allowed_flag alt_ledger_allow_gl_posting, fmbc.enabled_flag alternative_ledger_enabled from fa_mc_book_controls fmbc, gl_ledgers gl, fnd_id_flex_structures_vl fifsv where fmbc.set_of_books_id=gl.ledger_id and gl.ledger_category_code<>'PRIMARY' and gl.chart_of_accounts_id=fifsv.id_flex_num and fifsv.id_flex_code='GL#' and fifsv.application_id=101 and '&show_alt_ledgers'='Y' ), c_additions as( select fab.asset_id, fab.asset_number, (select fat.description from fa_additions_tl fat where fat.asset_id=fab.asset_id and fat.language=userenv('lang')) asset_description, fab.tag_number, fab.attribute_category_code asset_category_code, fnd_flex_xml_publisher_apis.process_kff_combination_1('asset_flex_cat_seg', 'OFA', 'CAT#', fsc.category_flex_structure, null, fab.asset_category_id, 'BASED_CATEGORY' , 'N', 'VALUE') major_category, fnd_flex_xml_publisher_apis.process_kff_combination_1('asset_flex_cat_seg', 'OFA', 'CAT#', fsc.category_flex_structure, null, fab.asset_category_id, 'BASED_CATEGORY' , 'N', 'DESCRIPTION') major_category_description, fnd_flex_xml_publisher_apis.process_kff_combination_1('asset_flex_cat_seg', 'OFA', 'CAT#', fsc.category_flex_structure, null, fab.asset_category_id, 'MINOR_CATEGORY' , 'N', 'VALUE') minor_category, fnd_flex_xml_publisher_apis.process_kff_combination_1('asset_flex_cat_seg', 'OFA', 'CAT#', fsc.category_flex_structure, null, fab.asset_category_id, 'MINOR_CATEGORY' , 'N', 'DESCRIPTION') minor_category_description, fab.serial_number, (select fakk.concatenated_segments from fa_asset_keywords_kfv fakk where fakk.code_combination_id=fab.asset_key_ccid) asset_key, (select fab1.asset_number from fa_additions_b fab1 where fab1.asset_id=fab.parent_asset_id) parent_asset_number, (select fat.description from fa_additions_tl fat where fat.asset_id=fab.parent_asset_id and fat.language=userenv('lang')) parent_description , fab.manufacturer_name, fab.model_number, fl.lease_number, fl.description lease_description, (select aps.vendor_name from ap_suppliers aps where fl.lessor_id=aps.vendor_id) lessor, fab.in_use_flag, fab.inventorial, fab.asset_type, fab.current_units, fab.property_type_code, fab.owned_leased, fab.property_1245_1250_code, fab.new_used, fab.commitment, fab.investment_law, fb.book_type_code, fb.cost, decode(fab.asset_type, 'CIP', fcb.cip_cost_acct, fcb.asset_cost_acct) asset_account, gl_flexfields_pkg.get_description(fbc.accounting_flex_structure,'GL_ACCOUNT',decode(fab.asset_type, 'CIP', fcb.cip_cost_acct, fcb.asset_cost_acct)) asset_account_description, decode(fab.asset_type, 'CIP', null,fcb.deprn_reserve_acct) reserve_account, decode(fab.asset_type, 'CIP', null,gl_flexfields_pkg.get_description(fbc.accounting_flex_structure,'GL_ACCOUNT',fcb.deprn_reserve_acct)) reserve_account_description, nvl(fbc.distribution_source_book,fbc.book_type_code) dist_book_type_code, trunc(fb.date_placed_in_service) date_in_service, (select fdp.period_name from fa_deprn_periods fdp where fb.book_type_code=fdp.book_type_code and fb.period_counter_fully_retired=fdp.period_counter) period_retired, fb.period_counter_fully_retired from fa_additions_b fab, fa_books fb, fa_leases fl, fa_book_controls fbc, fa_system_controls fsc, fa_category_books fcb where fab.asset_id=fb.asset_id and nvl(fb.disabled_flag,'N')='N' and fb.date_effective<=nvl2(:p_period,(select nvl(fdp2.period_close_date,sysdate) from fa_deprn_periods fdp2 where fb.book_type_code=fdp2.book_type_code and fdp2.period_name=:p_period),sysdate) and nvl(fb.date_ineffective,sysdate+1)>nvl2(:p_period,(select nvl(fdp2.period_close_date,sysdate) from fa_deprn_periods fdp2 where fb.book_type_code=fdp2.book_type_code and fdp2.period_name=:p_period),sysdate) and fbc.book_type_code=fb.book_type_code and fcb.book_type_code=fb.book_type_code and fcb.category_id=fab.asset_category_id and fab.lease_id=fl.lease_id(+) and ('&show_additions'='Y' or '&show_dprn'='Y' or '&show_trx'='Y' or '&show_dist'='Y' or '&show_inv_src'='Y') ), c_dprn as( select fds.book_type_code, fds.asset_id, fds.period_counter last_deprn_period_counter, fdp.period_name last_deprn_period_name, fdp.period_close_date last_deprn_period_close_date, fds.deprn_amount last_deprn_amount, case when fds.period_counter = nvl(fds.as_of_pc,fbc.last_period_counter) or floor((fds.period_counter - fdp.period_num)/fct.number_per_fiscal_year) = nvl(fds.as_of_fy,fbc.current_fiscal_year) then fds.ytd_deprn else 0 end ytd_deprn, fds.deprn_reserve, fds.deprn_source_code from ( select x.* from ( select max(fds.period_counter) over (partition by fds.asset_id,fds.book_type_code) max_period_counter, (select fdp2.period_counter from fa_deprn_periods fdp2 where fds.book_type_code=fdp2.book_type_code and fdp2.period_name=:p_period) as_of_pc, (select fdp2.fiscal_year from fa_deprn_periods fdp2 where fds.book_type_code=fdp2.book_type_code and fdp2.period_name=:p_period) as_of_fy, fds.* from fa_deprn_summary fds where fds.period_counter<=nvl2(:p_period,(select fdp2.period_counter from fa_deprn_periods fdp2 where fds.book_type_code=fdp2.book_type_code and fdp2.period_name=:p_period),fds.period_counter) ) x where x.period_counter=x.max_period_counter ) fds, fa_deprn_periods fdp, fa_book_controls fbc, fa_calendar_types fct where fds.book_type_code=fdp.book_type_code and fds.period_counter=fdp.period_counter and fds.book_type_code=fbc.book_type_code and fbc.deprn_calendar=fct.calendar_type and '&show_dprn'='Y' ), c_dist as( select fbc.book_type_code, fdh.asset_id, fdh.units_assigned assigned_units, papf.full_name assigned_owner, fnd_flex_xml_publisher_apis.process_kff_combination_1('asset_location', 'OFA', 'LOC#', fsc.location_flex_structure, null, fdh.location_id, 'ALL', 'Y', 'VALUE') assigned_location, gcck.concatenated_segments expense_account_segments, fnd_flex_xml_publisher_apis.process_kff_combination_1('expense_account', 'SQLGL', 'GL#', gcck.chart_of_accounts_id, null, fdh.code_combination_id, 'ALL', 'Y', 'DESCRIPTION') expense_account_description from fa_book_controls fbc, fa_distribution_history fdh, fa_system_controls fsc, gl_code_combinations_kfv gcck, per_all_people_f papf where fdh.book_type_code=nvl(fbc.distribution_source_book,fbc.book_type_code) and fdh.date_effective <= nvl2(:p_period,(select nvl(fdp2.period_close_date,sysdate) from fa_deprn_periods fdp2 where fdp2.book_type_code = fbc.book_type_code and fdp2.period_name = :p_period),sysdate) and nvl(fdh.date_ineffective,sysdate+1) > nvl2(:p_period,(select nvl(fdp2.period_close_date,sysdate) from fa_deprn_periods fdp2 where fdp2.book_type_code = fbc.book_type_code and fdp2.period_name = :p_period),sysdate) and fdh.code_combination_id=gcck.code_combination_id and fdh.assigned_to=papf.person_id(+) and fdh.date_effective between nvl(papf.effective_start_date,fdh.date_effective) and nvl(papf.effective_end_date,fdh.date_effective) and '&show_dist'='Y' ), c_fin_trx as ( select fb.asset_id, fb.book_type_code, (select fl.meaning from fa_lookups fl where fl.lookup_type='FAXOLTRX' and fl.lookup_code=fth.transaction_type_code) trx_transaction_type, fdp.period_name trx_period_entered, fcp.period_name trx_period_effective, fb.cost trx_current_cost, fth.transaction_date_entered trx_date_entered, fdp.fiscal_year trx_fiscal_year, fth.date_effective trx_date_effective, ftr.transaction_type trx_reference_type, ftr.trx_reference_id, fb.transaction_header_id_in from fa_books fb, fa_books fb0, fa_transaction_headers fth, fa_trx_references ftr, fa_deprn_periods fdp, fa_book_controls fbc, fa_calendar_periods fcp where fth.date_effective<=nvl2(:p_period,(select nvl(fdp2.period_close_date,sysdate) from fa_deprn_periods fdp2 where fth.book_type_code=fdp2.book_type_code and fdp2.period_name=:p_period),sysdate) and fb.transaction_header_id_in=fb0.transaction_header_id_out(+) and (fb.cost<>fb0.cost or fb0.cost is null) and fb.transaction_header_id_in=fth.transaction_header_id and fth.trx_reference_id=ftr.trx_reference_id(+) and fth.book_type_code=fdp.book_type_code and fth.date_effective between fdp.period_open_date and nvl(fdp.period_close_date,sysdate) and fb.book_type_code=fbc.book_type_code and fbc.deprn_calendar=fcp.calendar_type and fth.transaction_date_entered between fcp.start_date and fcp.end_date and fb.book_type_code=fdp.book_type_code and '&show_trx'='Y' ), c_inv_src as ( select faiv.asset_id, fb.book_type_code, faiv.vendor_name supplier, faiv.vendor_number supplier_number, faiv.po_number, faiv.invoice_number, faiv.invoice_date, faiv.invoice_line_number, faiv.description invoice_description, faiv.payables_units invoice_units, faiv.payables_cost invoice_amount from fa_invoice_details_v faiv, fa_books fb where faiv.asset_id=fb.asset_id and faiv.date_effective<=nvl2(:p_period,(select nvl(fdp2.period_close_date,sysdate) from fa_deprn_periods fdp2 where fb.book_type_code=fdp2.book_type_code and fdp2.period_name=:p_period),sysdate) and nvl(faiv.date_ineffective,sysdate+1)>nvl2(:p_period,(select nvl(fdp2.period_close_date,sysdate) from fa_deprn_periods fdp2 where fb.book_type_code=fdp2.book_type_code and fdp2.period_name=:p_period),sysdate) and fb.date_effective<=nvl2(:p_period,(select nvl(fdp2.period_close_date,sysdate) from fa_deprn_periods fdp2 where fb.book_type_code=fdp2.book_type_code and fdp2.period_name=:p_period),sysdate) and nvl(fb.date_ineffective,sysdate+1)>nvl2(:p_period,(select nvl(fdp2.period_close_date,sysdate) from fa_deprn_periods fdp2 where fb.book_type_code=fdp2.book_type_code and fdp2.period_name=:p_period),sysdate) and '&show_inv_src'='Y' ) select --main SQL starts here gl.name ledger, fbc.book_type_code asset_book, fbc.book_type_name asset_book_name, fbc.book_class class, fbc.distribution_source_book associated_corporate_book, (select fds.period_name from fa_deprn_periods fds where fds.period_counter=fbc.initial_period_counter and fds.book_type_code=fbc.book_type_code) initial_period, (select fds.period_name from fa_deprn_periods fds where fds.period_counter=fbc.last_mass_copy_period_counter and fds.book_type_code=fbc.book_type_code) last_mass_copy_period, (select fds.period_name from fa_deprn_periods fds where fds.period_counter=fbc.last_period_counter and fds.book_type_code=fbc.book_type_code) last_deprn_period, &calendar_columns &alt_ledger_columns &accounting_rules_columns &natural_account_columns &asset_number &addition_columns &dprn_columns &distribution_columns &trx_columns &inv_src_columns haouv.name operating_unit, (select fift.id_flex_structure_name from fnd_id_flex_structures_tl fift where gl.chart_of_accounts_id=fift.id_flex_num and fift.application_id=101 and fift.id_flex_code='GL#' and fift.language=userenv('lang')) chart_of_accounts, fbc.org_id, nvl(:p_period,'Current') as_of_period from fa_book_controls fbc, gl_ledgers gl, c_alt_ledgers, c_additions, c_dprn, c_dist, c_fin_trx, c_inv_src, hr_all_organization_units_vl haouv where 1=1 and fbc.set_of_books_id=gl.ledger_id and fbc.book_type_code=c_alt_ledgers.book_type_code(+) and fbc.book_type_code=c_additions.book_type_code(+) and c_additions.book_type_code=c_dprn.book_type_code(+) and c_additions.asset_id=c_dprn.asset_id(+) and c_additions.book_type_code=c_dist.book_type_code(+) and c_additions.asset_id=c_dist.asset_id(+) and c_additions.book_type_code=c_fin_trx.book_type_code(+) and c_additions.asset_id=c_fin_trx.asset_id(+) and c_additions.asset_id=c_inv_src.asset_id(+) and c_additions.book_type_code=c_inv_src.book_type_code(+) and fbc.org_id=haouv.organization_id(+) order by fbc.book_type_code &order_columns added date_ineffective conditions to fa_books in c_inv_src Y JL (:Ledger is not null or :Book is not null) AR FA Asset Book Details دفاتر أصول FA مع ملخص إهلاك الأصول وقيم المعاملات المالية. باستخدام المعلمات "إظهار التقويم" ، "إظهار دفاتر الأستاذ البديلة" ، "إظهار قواعد المحاسبة" ، يظهر "إظهار الحسابات الطبيعية" تفاصيل الإعداد لعناصر تحكم الكتاب. إذا قمت بإظهار جميع الأصول ، يجب عليك تحديد كتاب D FA Asset Book Details FA-Anlagenbücher mit Anlagenabschreibungsübersicht und Finanztransaktionswerten. Mit den Parametern 'Kalender anzeigen', 'Alternative Ledger anzeigen', 'Buchhaltungsregeln anzeigen', 'Natürliche Konten anzeigen' werden die Einrichtungsdetails der Buchsteuerungen angezeigt. Wenn Sie alle Assets anzeigen, müssen Sie ein Buch auswählen E FA Asset Book Details FA libros de activos con el resumen de la depreciación de los activos y los valores de las transacciones financieras. Mediante los parámetros "Mostrar calendario", "Mostrar libros alternativos", "Mostrar reglas contables", "Mostrar cuentas naturales" se muestran los detalles de configuración de los controles de los libros. Si muestra todos los activos, debe seleccionar un libro F FA Asset Book Details Les livres d'actifs des FA avec le résumé de la dépréciation des actifs et les valeurs des transactions financières. Les paramètres "Afficher le calendrier", "Afficher les grands livres alternatifs", "Afficher les règles comptables", "Afficher les comptes naturels" permettent d'afficher les détails de configuration des contrôles comptables. Si vous présentez tous les actifs, vous devez sélectionner un livre I FA Asset Book Details I libri contabili di FA con il riepilogo dell'ammortamento dei beni e i valori delle transazioni finanziarie. Usando i parametri 'Show Calendar', 'Show Alternative Ledgers', 'Show Accounting Rules', 'Show Natural Accounts' mostra i dettagli di impostazione dei controlli dei libri. Se si mostrano tutte le attività, è necessario selezionare un libro JA FA Asset Book Details 資産減価償却の概要と財務取引の値を持つFA資産の帳簿。 パラメータ'カレンダーを表示'、'代替元帳を表示'、'会計ルールを表示'、'自然会計を表示'を使用して、ブックコントロールのセットアップの詳細を示しています。 すべての資産を表示する場合は、ブックを選択する必要があります。 KO FA Asset Book Details 자산 감가 상각 요약 및 금융 거래 가치가있는 FA 자산 장부. '캘린더 표시', '대체 원장 표시', '회계 규칙 표시', '자연 계정 표시'매개 변수를 사용하여 장부 제어의 설정 세부 사항을 표시합니다. 모든 자산을 표시하는 경우 책을 선택해야합니다. PTB FA Asset Book Details FA livros patrimoniais com resumo de depreciação de ativos e valores de transações financeiras. Usando os parâmetros 'Mostrar Calendário', 'Mostrar Ledgers Alternativos', 'Mostrar Regras de Contabilidade', 'Mostrar Contas Naturais' mostra os detalhes de configuração dos controles contábeis. Se você mostrar todos os bens, você deve selecionar um livro RU FA Asset Book Details Бухгалтерские книги активов FA со сводкой амортизационных отчислений по активам и стоимостью финансовых операций. Используя параметры 'Показывать календарь', 'Показывать альтернативные книги', 'Показывать правила бухгалтерского учета', 'Показывать естественные счета', показывает детали настройки элементов управления книгами. Если вы показываете все активы, вы должны выбрать книгу S FA Asset Book Details FA tillgångsböcker med tillgångsavskrivningar och finansiella transaktionsvärden. Med hjälp av parametrarna 'Visa kalender', 'Visa alternativa redovisningar', 'Visa bokföringsregler', 'Visa naturliga konton' visas inställningarna för bokkontroller. Om du visar alla tillgångar måste du välja en bok TR FA Asset Book Details Varlık amortisman özeti ve finansal işlem değerleri içeren FA varlık defterleri. 'Takvimi Göster', 'Alternatif Defterleri Göster', 'Muhasebe Kurallarını Göster', 'Doğal Hesapları Göster' parametrelerini kullanarak kitap kontrollerinin kurulum ayrıntılarını gösterir. Tüm varlıkları gösterirseniz, bir kitap seçmelisiniz US FA Asset Book Details FA asset books with asset depreciation summary and financial transaction values. Using parameters 'Show Calendar', 'Show Alternative Ledgers', 'Show Accounting Rules', 'Show Natural Accounts' shows the setup details of book controls. You must select a Ledger and/or Book ZHS FA Asset Book Details FA资产账簿与资产折旧汇总和财务交易值。 使用参数 "显示日历"、"显示替代账"、"显示会计规则"、"显示自然账 "显示账簿控制的设置细节。 如果您显示所有的资产，您必须选择一个账本。 Enginatics R12 only &accounting_rules_columns &addition_columns &alt_ledger_columns &asset_number &calendar_columns &distribution_columns &dprn_columns &inv_src_columns &natural_account_columns &order_columns &show_additions &show_alt_ledgers &show_dist &show_dprn &show_inv_src &show_trx &trx_columns 1=1 :p_period 1 10 1=1 gl.name=:ledger and fbc.book_type_code in (select fbcs.book_type_code from fa_book_controls_sec fbcs) 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) F Grand livre US Ledger 2 20 1=1 fbc.book_type_code=:book_type_code LOV FA Book B12587B17F666485E0530100007FA7F4 Y select x.value, x.description from ( select fbcs.book_type_code value, fbcs.book_type_name||' ('||fbcs.book_class||')' description from fa_book_controls_sec fbcs where :$flex$.ledger is null or fbcs.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y') and nvl(:$flex$.mrc_flag,'P') != 'R' union select fbcs.book_type_code value, fbcs.book_type_name||' ('||fbcs.book_class||')' description from fa_book_controls_sec fbcs, fa_mc_book_controls fmbc where fbcs.book_type_code = fmbc.book_type_code and fbcs.set_of_books_id = fmbc.primary_set_of_books_id and :$flex$.ledger is null or fmbc.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y') and nvl(:$flex$.mrc_flag,'P') = 'R' ) x order by x.value F Livre US Book 3 30 :p_period LOV custom Y select fdp.period_name value, null description from fa_deprn_periods fdp where xxen_util.contains(:$flex$.book,fdp.book_type_code) = 'Y' and fdp.period_counter>(select min(fdp2.period_counter) from fa_deprn_periods fdp2 where fdp2.book_type_code=fdp.book_type_code) order by period_counter US As of Period 4 40 &calendar_columns fbc.date_ineffective inactive_on, fbc.allow_purge_flag allow_purge, (select fdp.period_name from fa_deprn_periods fdp where fdp.period_counter=fbc.last_purge_period_counter and fdp.book_type_code=fbc.book_type_code) purged_through, gl.short_name ledger, gl.description ledger_description, fbc.gl_posting_allowed_flag allow_gl_posting, fbc.deprn_calendar depreciation_calendar, fbc.fiscal_year_name, fbc.prorate_calendar, (select fdp.period_name from fa_deprn_periods fdp where fdp.period_close_date is null and fdp.book_type_code=fbc.book_type_code) current_period, fbc.current_fiscal_year, decode(fbc.deprn_allocation_code,'E','Evenly','D','By Days',fbc.deprn_allocation_code) divide_depreciation, fbc.depr_first_year_ret_flag depreciate_if_retired_first_yr, fbc.last_deprn_run_date last_depreciation_run_date, fbc.deprn_status last_depreciation_run_status, fbc.deprn_request_id last_depreciation_request, LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual F Calendrier des spectacles US Show Calendar 5 50 &show_alt_ledgers Y LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual F Afficher les grands livres alternatifs US Show Alternative Ledgers 6 &alt_ledger_columns c_alt_ledgers.alternative_ledger, c_alt_ledgers.alternative_ledger_type, c_alt_ledgers.alternative_ledger_currency, c_alt_ledgers.alt_ledger_chart_of_accounts, c_alt_ledgers.alt_ledger_allow_gl_posting, c_alt_ledgers.alternative_ledger_enabled, F Afficher les grands livres alternatifs US Show Alternative Ledgers 7 60 &accounting_rules_columns trunc(fbc.capital_gain_threshold/12) capital_gain_threshold_years, mod(fbc.capital_gain_threshold,12) capital_gain_threshold_months, fbc.amortize_flag allow_amortized_changes, fbc.allow_mass_changes, fbc.sorp_enabled_flag uk_local_authority_acc, fbc.allow_cost_sign_change_flag allow_cost_sign_changes, fbc.prevent_prior_period_txns_flag prevent_prev_period_amort_chng, fbc.allow_unallocated_lines_flag allow_unallocated_line_types, fbc.import_alloc_inv_lines_as_new disable_auto_merge_of_ap_lines, --revaluations fbc.allow_reval_flag allow_revaluations, fbc.reval_deprn_reserve_flag revalue_accumulated_dprn, fbc.reval_ytd_deprn_flag revalue_ytd_depreciation, fbc.retire_reval_reserve_flag retire_revaluation_reserve, fbc.amortize_reval_reserve_flag amortize_revaluation_reserve, fbc.default_reval_fully_rsvd_flag revalue_fully_reserved_assets, fbc.default_life_extension_factor life_extension_factor, fbc.default_max_fully_rsvd_revals maximum_revaluations, fbc.default_life_extension_factor life_extension_ceiling, fbc.default_period_end_reval_flag include_curr_period_dprn, --group dprn fbc.allow_cip_member_flag allow_cip_member_in_grp_assets, fbc.allow_cip_dep_group_flag allow_cip_dprn_in_grp_assets, fbc.allow_member_tracking_flag allow_member_asset_track, fbc.allow_interco_group_flag interco_member_asset_assign, --other flags fbc.intercompany_posting_flag create_intercomp_bal_entries, fbc.allow_group_deprn_flag allow_group_depreciation, fbc.allow_deprn_adjustments allow_reserve_adjustments, fbc.allow_cost_ceiling allow_cost_ceilings, fbc.itc_allowed_flag allow_invest_tax_credits, fbc.allow_deprn_exp_ceiling allow_expense_ceilings, fbc.allow_cip_assets_flag allow_cip_assets, fbc.allow_backdated_transfers_flag allow_backdated_transfers, fbc.allow_mass_copy, fbc.copy_additions_flag copy_additions, fbc.copy_adjustments_flag copy_adjustments, fbc.copy_retirements_flag copy_retirements, fbc.copy_amort_adaj_exp_flag copy_amort_add_and_adj_as_exp, LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual F Afficher les règles de comptabilité US Show Accounting Rules 8 70 &natural_account_columns --retirment accounts fbc.proceeds_of_sale_gain_acct proceeds_of_sale_gain, fbc.proceeds_of_sale_loss_acct proceeds_of_sale_loss, fbc.proceeds_of_sale_clearing_acct proceeds_of_sale_clearing, fbc.cost_of_removal_gain_acct cost_of_removal_gain, fbc.cost_of_removal_loss_acct cost_of_removal_loss, fbc.cost_of_removal_clearing_acct cost_of_removal_clearing, fbc.nbv_retired_gain_acct net_book_value_retired_gain, fbc.nbv_retired_loss_acct net_book_value_retired_loss, fbc.reval_rsv_retired_gain_acct reval_reserve_retired_gain, fbc.reval_rsv_retired_loss_acct reval_reserve_retired_loss, -- fbc.deferred_deprn_reserve_acct deferred_depreciation_reserve, fbc.deferred_deprn_expense_acct deferred_depreciation_expense, fbc.deprn_adjustment_acct depreciation_adjustment, (select gcck.concatenated_segments from gl_code_combinations_kfv gcck where gcck.code_combination_id=fbc.flexbuilder_defaults_ccid) account_generator_defaults, LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual F Afficher les comptes naturels US Show Natural Accounts 9 80 &show_additions Y LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y F Afficher les détails de l'actif US Show Asset Details 10 &addition_columns c_additions.tag_number, c_additions.asset_category_code category, c_additions.major_category, c_additions.minor_category, c_additions.major_category_description, c_additions.minor_category_description, c_additions.serial_number, c_additions.asset_key, c_additions.asset_type, c_additions.current_units units, c_additions.parent_asset_number, c_additions.parent_description parent_asset_description, c_additions.manufacturer_name manufacturer, c_additions.model_number model, c_additions.lease_number, c_additions.lease_description, c_additions.lessor, c_additions.in_use_flag in_use, c_additions.inventorial, c_additions.property_type_code property_type, c_additions.owned_leased ownership, c_additions.property_1245_1250_code property_class, c_additions.new_used bought, c_additions.commitment, c_additions.investment_law, c_additions.cost, c_additions.asset_account, c_additions.asset_account_description, c_additions.reserve_account, c_additions.reserve_account_description, c_additions.date_in_service, c_additions.period_retired, F Afficher les détails de l'actif US Show Asset Details 11 &asset_number c_additions.asset_number, c_additions.asset_description description, F Afficher les détails de l'actif US Show Asset Details 12 &order_columns ,c_additions.asset_number, c_additions.asset_description F Afficher les détails de l'actif US Show Asset Details 13 90 &show_dprn Y LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y F Afficher le résumé des amortissements US Show Depreciation Summary 14 &asset_number c_additions.asset_number, c_additions.asset_description description, F Afficher le résumé des amortissements US Show Depreciation Summary 15 &dprn_columns c_dprn.last_deprn_period_name last_depreciation_period, c_dprn.last_deprn_period_close_date, c_dprn.last_deprn_amount last_depreciation_amount, c_dprn.ytd_deprn ytd_depreciation, c_dprn.deprn_reserve depreciation_reserve, c_additions.cost-c_dprn.deprn_reserve net_book_value, c_dprn.deprn_source_code depreciation_source_code, F Afficher le résumé des amortissements US Show Depreciation Summary 16 &order_columns ,c_additions.asset_number, c_additions.asset_description F Afficher le résumé des amortissements US Show Depreciation Summary 17 100 &show_dist Y LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual F Afficher les affectations US Show Assignments 18 &asset_number c_additions.asset_number, c_additions.asset_description description, F Afficher les affectations US Show Assignments 19 &distribution_columns c_dist.assigned_units, case nvl(c_additions.current_units,0) when 0 then to_number(null) else round(c_dist.assigned_units/c_additions.current_units*100,2) end assigned_percent, c_dist.assigned_owner, c_dist.assigned_location, c_dist.expense_account_segments, c_dist.expense_account_description, F Afficher les affectations US Show Assignments 20 &order_columns ,c_additions.asset_number, c_additions.asset_description F Afficher les affectations US Show Assignments 21 110 &show_trx Y LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual F Afficher les transactions financières US Show Fin Transactions 22 &asset_number c_additions.asset_number, c_additions.asset_description description, F Afficher les transactions financières US Show Fin Transactions 23 &order_columns ,c_additions.asset_number, c_additions.asset_description, c_fin_trx.trx_date_entered F Afficher les transactions financières US Show Fin Transactions 24 &trx_columns c_fin_trx.trx_transaction_type, c_fin_trx.trx_period_entered, c_fin_trx.trx_period_effective, c_fin_trx.trx_current_cost, c_fin_trx.trx_date_entered, c_fin_trx.trx_fiscal_year, c_fin_trx.trx_date_effective, c_fin_trx.trx_reference_type, F Afficher les transactions financières US Show Fin Transactions 25 120 &show_inv_src Y LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual F Afficher les factures sources US Show Source Invoices 26 &asset_number c_additions.asset_number, c_additions.asset_description description, F Afficher les factures sources US Show Source Invoices 27 &inv_src_columns c_inv_src.supplier, c_inv_src.supplier_number, c_inv_src.po_number, c_inv_src.invoice_number, c_inv_src.invoice_date, c_inv_src.invoice_line_number, c_inv_src.invoice_description, c_inv_src.invoice_units, c_inv_src.invoice_amount, F Afficher les factures sources US Show Source Invoices 28 &order_columns ,c_additions.asset_number, c_additions.asset_description F Afficher les factures sources US Show Source Invoices 29 130 1=1 nvl(:p_exlc_retired,'N')=nvl(:p_exlc_retired,'N') and (c_additions.period_counter_fully_retired is null or c_additions.period_counter_fully_retired >= nvl2(:p_period, (select fdp2.period_counter from fa_deprn_periods fdp2 where fdp2.book_type_code = c_additions.book_type_code and fdp2.period_name = :p_period), (select max(fdp2.period_counter)-1 from fa_deprn_periods fdp2 where fdp2.book_type_code = c_additions.book_type_code) ) ) LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y US Exclude Retired Assets 30 140 1=1 haouv.name=:org_name LOV FA Organization 8E2FF36EDEDF79D2E0530100007F1FF2 Y select haouv.name value, flvv.meaning description from hr_all_organization_units_vl haouv, fnd_lookup_values_vl flvv where haouv.organization_id in (select hoi.organization_id from hr_organization_information hoi where hoi.org_information1='FA_ORG' and hoi.org_information_context='CLASS' and hoi.org_information2='Y') and haouv.type=flvv.lookup_code(+) and flvv.lookup_type(+)='ORG_TYPE' and flvv.view_application_id(+)=3 and flvv.security_group_id(+)=0 order by haouv.name F Organisation US Organization :$flex$.book Book As of Period :$flex$.ledger Ledger Book