ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US CA53C651BA88C8D8E0530100007FCCB4 with fa_trx as ( select x.company_name, x.ledger, x.book, x.currency, x.balancing_segment, x.asset_type, x.asset_account, x.cost_center, x.asset_number, x.asset_description, x.category category, x.period, sum(decode(x.unit_sum,x.units,x.old_cost1+x.old_cost-x.old_cost_rsum,x.old_cost1)) old_cost, sum(decode(x.unit_sum,x.units,x.new_cost1+x.new_cost-x.new_cost_rsum,x.new_cost1)) new_cost, sum(decode(x.unit_sum,x.units,x.new_cost1+x.new_cost-x.new_cost_rsum,x.new_cost1) - decode(x.unit_sum,x.units,x.old_cost1+x.old_cost-x.old_cost_rsum,x.old_cost1)) net_change, x.transaction_number, x.invoice_transaction_id from ( select fsc.company_name, gl.name ledger, fdp.book_type_code book, gl.currency_code currency, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_bal_seg','SQLGL','GL#',gcc.chart_of_accounts_id,null,gcc.code_combination_id,'GL_BALANCING','Y','VALUE') balancing_segment, fl.meaning asset_type, decode(fah.asset_type, 'CIP', fcb.cip_cost_acct, fcb.asset_cost_acct) asset_account, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_cost_seg','SQLGL','GL#',gcc.chart_of_accounts_id,null,gcc.code_combination_id,'FA_COST_CTR','Y','VALUE') cost_center, fa.asset_number asset_number, fa.description asset_description, fnd_flex_xml_publisher_apis.process_kff_combination_1('cat_flex_all_seg', 'OFA', 'CAT#', fsc.category_flex_structure, NULL, fc.category_id, 'ALL', 'Y', 'VALUE') category, fdp.period_name period, round((fb_old.cost * nvl(fdh.units_assigned,fah.units)/fah.units), fcu.precision) old_cost1, (round((fb_old.cost * nvl(fdh.units_assigned,fah.units)/fah.units), fcu.precision) + round(((fb_new.cost - fb_old.cost)* nvl(fdh.units_assigned,fah.units)/fah.units), fcu.precision)) new_cost1, sum(round((fb_old.cost * nvl(fdh.units_assigned,fah.units)/fah.units), fcu.precision)) over(partition by fth.transaction_header_id,fdh.asset_id order by fdh.distribution_id) old_cost_rsum, sum((round((fb_old.cost * nvl(fdh.units_assigned,fah.units)/fah.units), fcu.precision) + round(((fb_new.cost - fb_old.cost)* nvl(fdh.units_assigned,fah.units)/fah.units), fcu.precision))) over(partition by fth.transaction_header_id,fdh.asset_id order by fdh.distribution_id) new_cost_rsum, sum(nvl(fdh.units_assigned,fah.units)) over (partition by fth.transaction_header_id,fdh.asset_id order by fdh.distribution_id) unit_sum, fah.units units, fb_old.cost old_cost, fb_new.cost new_cost, fth.transaction_header_id transaction_number, fth.invoice_transaction_id from fa_system_controls fsc, gl_ledgers gl, fnd_currencies fcu, fa_asset_history fah, fa_additions fa, fa_categories fc, fa_category_books fcb, &lp_fa_books fb_old, &lp_fa_books fb_new, fa_lookups fl, &lp_fa_deprn_periods fdp, fa_distribution_history fdh, gl_code_combinations gcc, fa_transaction_headers fth where gl.ledger_id = :p_ca_set_of_books_id and fcu.currency_code = gl.currency_code and fdp.book_type_code = :p_book and fdp.period_counter >= :period1_pc and fdp.period_counter <= nvl(:period2_pc, fdp.period_counter) 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 fth.transaction_type_code in ('ADJUSTMENT','CIP ADJUSTMENT') and fb_old.transaction_header_id_out = fth.transaction_header_id and fb_old.book_type_code = fth.book_type_code and fb_new.transaction_header_id_in = fth.transaction_header_id and fb_new.book_type_code = fth.book_type_code and fa.asset_id = fth.asset_id and fl.lookup_type = 'ASSET TYPE' and fcb.category_id = fah.category_id and fcb.book_type_code = fth.book_type_code and fc.category_id = fcb.category_id and fah.asset_id = fa.asset_id and fah.asset_type = fl.lookup_code and fth.transaction_header_id >= fah.transaction_header_id_in and fth.transaction_header_id < nvl(fah.transaction_header_id_out, fth.transaction_header_id + 1) and fth.asset_id = fdh.asset_id and :p_distribution_source_book = fdh.book_type_code and fth.transaction_header_id >= fdh.transaction_header_id_in and fth.transaction_header_id < nvl(fdh.transaction_header_id_out, fth.transaction_header_id + 1) and fdh.code_combination_id = gcc.code_combination_id and round((fb_old.cost * nvl(fdh.units_assigned,fah.units)/fah.units), fcu.precision) != round((fb_new.cost * nvl(fdh.units_assigned,fah.units)/fah.units), fcu.precision) ) x group by x.company_name, x.ledger, x.book, x.currency, x.balancing_segment, x.asset_type, x.cost_center, x.asset_account, x.asset_number, x.asset_description, x.category, x.period, x.transaction_number, x.invoice_transaction_id ) -- -- -- select ft.company_name, ft.ledger, ft.book, ft.currency, ft.balancing_segment, ft.asset_type, ft.asset_account, ft.cost_center, ft.asset_number, ft.asset_description, ft.category category, ft.period, case when 1 = row_number() over (partition by ft.transaction_number order by ft.transaction_number) then ft.old_cost else null end old_cost, case when 1 = row_number() over (partition by ft.transaction_number order by ft.transaction_number) then ft.new_cost else null end new_cost, case when 1 = row_number() over (partition by ft.transaction_number order by ft.transaction_number) then ft.net_change else null end net_change, ft.transaction_number, -- asu.vendor_name vendor, asu.segment1 vendor_num, fai.po_number, fai.invoice_number, fai.fixed_assets_cost invoice_cost, fai.description invoice_description, -- ft.company_name || ': ' || ft.book || ' (' || ft.currency || ')' comp_book_curr_label from fa_trx ft, fa_asset_invoices fai, ap_suppliers asu where nvl2(:p_show_invoice_details,ft.invoice_transaction_id,null) = fai.invoice_transaction_id_in (+) and fai.po_vendor_id = asu.vendor_id (+) order by ft.company_name, ft.ledger, ft.book, ft.currency, ft.balancing_segment, ft.asset_type, ft.asset_account, ft.cost_center, ft.asset_number, ft.transaction_number Y OFA FAS840_XML #,##0.00;[Red]-#,##0.00 AR FA تقرير تعديلات التكاليف (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل (1) Imported from BI Publisher Description: تقرير تعديلات التكلفة Application: الأصول Source: تقرير تعديلات التكاليف (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: FAS840_XML DB package: FA_FAS840_XMLP_PKG D FA AHK-Berichtigungen- Nicht unterstützt: Reserviert für zukünftige Verwendung (1) Imported from BI Publisher Description: Auswertung "AHK-Berichtigungen" Application: Anlagen Source: AHK-Berichtigungen (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: FAS840_XML DB package: FA_FAS840_XMLP_PKG E FA Informe Ajustes de Costes: No Admitido, Reservado para Uso Futuro Imported from BI Publisher Description: Informe de ajustes de coste Application: Assets Source: Informe Ajustes de Costes (XML): No Admitido, Reservado para Uso Futuro Short Name: FAS840_XML DB package: FA_FAS840_XMLP_PKG F FA Etat des ajustements de coûts- Non pris en charge : réservé pour une utilisation future (1) Imported from BI Publisher Description: Etat des ajustements de coûts Application: Assets Source: Etat des ajustements de coûts (XML) - Non pris en charge : réservé pour une utilisation future Short Name: FAS840_XML DB package: FA_FAS840_XMLP_PKG I FA Rapporto Adeguamenti costi- non supportato: riservato per usi futuri Imported from BI Publisher Description: Rapporto Adeguamenti costi Application: Assets Source: Rapporto Adeguamenti costi (XML) - non supportato: riservato per usi futuri Short Name: FAS840_XML DB package: FA_FAS840_XMLP_PKG JA FA 取得価額修正レポート- 未サポート: 将来の使用のために予約 Imported from BI Publisher Description: 取得価額修正レポート Application: Assets Source: 取得価額修正レポート(XML) - 未サポート: 将来の使用のために予約 Short Name: FAS840_XML DB package: FA_FAS840_XMLP_PKG KO FA 원가 조정 보고서- 지원되지 않음: 추후 사용을 위해 예약됨 Imported from BI Publisher Description: 원가 조정 보고서 Application: Assets Source: 원가 조정 보고서(XML) - 지원되지 않음: 추후 사용을 위해 예약됨 Short Name: FAS840_XML DB package: FA_FAS840_XMLP_PKG PTB FA Relatório de Ajustes de Custo- Não Suportado: Reservado Para Uso Futuro Imported from BI Publisher Description: Relatório de Ajustes de Custo Application: Assets Source: Relatório de Ajustes de Custo (XML) - Não Suportado: Reservado Para Uso Futuro Short Name: FAS840_XML DB package: FA_FAS840_XMLP_PKG RU FA Отчет о корректировках стоимости- не поддерживается: зарезервировано для будущего использования Imported from BI Publisher Description: Отчет о корректировках стоимости Application: Активы Source: Отчет о корректировках стоимости (XML) - не поддерживается: зарезервировано для будущего использования Short Name: FAS840_XML DB package: FA_FAS840_XMLP_PKG S FA Kostnadsjusteringar - rapport- Stöds inte: Reserverad för framtida bruk Imported from BI Publisher Description: Kostnadsjusteringar - rapport Application: Assets Source: Kostnadsjusteringar - rapport (XML) - Stöds inte: Reserverad för framtida bruk Short Name: FAS840_XML DB package: FA_FAS840_XMLP_PKG TR FA Maliyet Düzeltmeleri Raporu- Desteklenmiyor: İleride Kullanılmak Üzere Ayrılmıştır Imported from BI Publisher Description: Maliyet Düzeltmeleri Raporu Application: Duran Varlıklar Source: Maliyet Düzeltmeleri Raporu (XML) - Desteklenmiyor: İleride Kullanılmak Üzere Ayrılmıştır Short Name: FAS840_XML DB package: FA_FAS840_XMLP_PKG US FA Cost Adjustments Imported from BI Publisher Description: Cost Adjustments Report Application: Assets Source: Cost Adjustments Report (XML) Short Name: FAS840_XML DB package: FA_FAS840_XMLP_PKG ZHS FA 成本调整报表- 不支持：已保留供将来使用 (1) Imported from BI Publisher Description: 成本调整报表 Application: 资产 Source: 成本调整报表 (XML) - 不支持：已保留供将来使用 Short Name: FAS840_XML DB package: FA_FAS840_XMLP_PKG Enginatics R12 only &lp_fa_books &lp_fa_deprn_periods :accounting_flex_structure :currency_code :distribution_source_book :lp_currency_code :lp_fa_books :lp_fa_deprn_periods :p_book :p_ca_org_id :p_ca_set_of_books_id :p_conc_request_id :p_distribution_source_book :p_min_precision :p_mrcsobtype :p_period1 :p_period2 :p_show_invoice_details :period1_pc :period2_pc :precision :rp_report_name 1 -40 :p_mrcsobtype Char select nvl( (select decode(gsob.mrc_sob_type_code,'R','R','P') from gl_sets_of_books gsob where gsob.set_of_books_id = :$flex$.Set_Of_Books_Currency ) ,'P' ) from dual F Drapeau MRC US MRC Flag 2 &lp_fa_books fa_books P F Drapeau MRC US MRC Flag 3 &lp_fa_books fa_books_mrc_v R F Drapeau MRC US MRC Flag 4 &lp_fa_deprn_periods fa_deprn_periods P F Drapeau MRC US MRC Flag 5 &lp_fa_deprn_periods fa_deprn_periods_mrc_v R F Drapeau MRC US MRC Flag 6 -30 :period1_pc Number select fdpmv.period_counter from fa_deprn_periods_mrc_v fdpmv where fdpmv.book_type_code = :$flex$.Book and fdpmv.period_name = :$flex$.From_Period and :$flex$.MRC_Flag = 'R' union select fdp.period_counter from fa_deprn_periods fdp where fdp.book_type_code = :$flex$.Book and fdp.period_name = :$flex$.From_Period and nvl(:$flex$.MRC_Flag,'N') != 'R' F Du compteur de périodes US From Period Counter 7 -20 :period2_pc Number select fdpmv.period_counter from fa_deprn_periods_mrc_v fdpmv where fdpmv.book_type_code = :$flex$.Book and fdpmv.period_name = :$flex$.To_Period and :$flex$.MRC_Flag = 'R' union select fdp.period_counter from fa_deprn_periods fdp where fdp.book_type_code = :$flex$.Book and fdp.period_name = :$flex$.To_Period and nvl(:$flex$.MRC_Flag,'N') != 'R' F Vers le compteur de périodes US To Period Counter 8 -10 :p_distribution_source_book Char select fbcmv.distribution_source_book from fa_book_controls_mrc_v fbcmv where fbcmv.book_type_code = :$flex$.Book and :$flex$.MRC_Flag = 'R' union select fbc.distribution_source_book from fa_book_controls fbc where fbc.book_type_code = :$flex$.Book and nvl(:$flex$.MRC_Flag,'N') != 'R' F Livre source de la distribution US Distribution Source Book 9 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 select case when xrpv.parameter_type='LOV Oracle' and xrrpv.value not like '<multiple_values>%' then xxen_report.id_to_value(xrpv.parameter_id,xrrpv.value) else xrrpv.value end value from xxen_report_parameters_v xrpv, (select xrr.report_id,max(xrr.run_id) run_id from xxen_report_runs xrr where xrr.created_by = fnd_global.user_id and xrr.responsibility_id = fnd_global.resp_id group by xrr.report_id) xrr, xxen_report_run_param_values xrrpv where xrpv.report_name = 'FA Cost Adjustments' and xrpv.parameter_name = 'Book' and xrpv.report_id = xrr.report_id and xrr.run_id = xrrpv.run_id and xrpv.parameter_id = xrrpv.parameter_id 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 帐簿 账簿类型 10 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 set_of_books_id from fa_book_controls where book_type_code=:$flex$.fa_book_type Y AR عملة دفاتر الحسابات عملة دفاتر الحسابات D Währung Buchungsstruktur Währung Buchungsstruktur E Divisa de Juego de Libros Divisa de Juego de Libros F Ensemble de livres Monnaie 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 帐套币种 帐套币种 11 30 :p_period1 LOV Oracle FA_PERIOD_NAME 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 select fdp.period_name from fa_deprn_periods fdp where fdp.book_type_code=:$flex$.fa_book_type and fdp.period_counter= (select max(dp2.period_counter) from fa_deprn_periods dp2 where dp2.book_type_code=:$flex$.fa_book_type and dp2.period_close_date is not null) Y AR من الفترة اسم فترة البداية D Von Periode Von Periode E De Período Nombre de Período de Inicio F De la période Nom de la période de début I Periodo - Da Nome del periodo iniziale JA 期間:自 期間名:自 KO 기간: 부터 시작 기간명 PTB Período - De Nome do Período Inicial RU Начальный период Имя начального периода S Från period Namn på startperiod TR İlk Dönem Başlangıç Dönemi Adı US From Period Start Period Name ZHS 自期间 起始期间名称 12 40 :p_period2 LOV Oracle FA_PERIOD_TO 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) order by period_counter :$flex$.fa_period_name Y AR إلى الفترة اسم فترة النهاية D Bis Periode Bis Periode E A Período Nombre del Período de Finalización F À la période Nom de la période de fin I Periodo - A Nome del periodo finale JA 期間:至 期間名:至 KO 기간: 까지 종료 기간명 PTB Período - Até Nome do Período Final RU Конечный период Имя конечного периода S Till period Slutperiod TR Son Dönem Son Dönem Adı US To Period End Period Name ZHS 至期间 终止期间名称 13 50 :p_show_invoice_details LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Show Source Invoice Details :$flex$.Book Book Distribution Source Book :$flex$.Book Book From Period Counter :$flex$.Book Book To Period Counter :$flex$.From_Period From Period From Period Counter :$flex$.MRC_Flag MRC Flag Distribution Source Book :$flex$.MRC_Flag MRC Flag From Period Counter :$flex$.MRC_Flag MRC Flag To Period Counter :$flex$.Set_Of_Books_Currency Set of Books Currency MRC Flag :$flex$.To_Period To Period To Period Counter :$flex$.fa_book_type Book From Period :$flex$.fa_book_type Book Set of Books Currency :$flex$.fa_book_type Book To Period :$flex$.fa_period_name From Period To Period Default Template Y Default Template containing all reportable columns SYSADMIN 7 ASSET_ACCOUNT 6 11 ASSET_DESCRIPTION 9 ASSET_NUMBER 8 6 ASSET_TYPE 5 5 BALANCING_SEGMENT 4 3 BOOK 3 10 CATEGORY 1 COMPANY_NAME 1 COMP_BOOK_CURR_LABEL 8 COST_CENTER 7 4 CURRENCY 21 INVOICE_COST 22 INVOICE_DESCRIPTION 20 INVOICE_NUMBER 2 LEDGER 2 15 NET_CHANGE 14 NEW_COST 13 OLD_COST 12 PERIOD 19 PO_NUMBER 16 TRANSACTION_NUMBER 9 17 VENDOR 18 VENDOR_NUM S Site Pivot: Default Template Asset Cost Adjustments Summary (Pivot) with Asset Cost Adjustment Details summarized by Asset Book, Balancing Segment, Asset Type, Asset Account and Cost Center. SYSADMIN 7 ASSET_ACCOUNT 6 11 ASSET_DESCRIPTION 9 ASSET_NUMBER 8 6 ASSET_TYPE 5 5 BALANCING_SEGMENT 4 3 BOOK 3 10 CATEGORY 1 COMPANY_NAME 1 23 COMP_BOOK_CURR_LABEL 8 COST_CENTER 7 4 CURRENCY 21 INVOICE_COST 22 INVOICE_DESCRIPTION 20 INVOICE_NUMBER 2 LEDGER 2 15 NET_CHANGE 14 NEW_COST 13 OLD_COST 12 PERIOD 19 PO_NUMBER 16 TRANSACTION_NUMBER 9 17 VENDOR 18 VENDOR_NUM ASSET_ACCOUNT ROW 4 ASSET_TYPE ROW 3 BALANCING_SEGMENT ROW 2 COMP_BOOK_CURR_LABEL ROW 1 COST_CENTER ROW 5 NET_CHANGE VALUE 1 SUM PERIOD FILTER 1 S Site SYSADMIN Pivot: Default Template Default Template