ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN CA53C651BA83C8D8E0530100007FCCB4 select x.company_name company_name, x.ledger ledger, x.book book, x.currency currency, x.balancing_segment balancing_segment, x.account_segment cip_account, x.cost_center cost_center, x.asset_number asset_number, x.asset_description asset_description, x.begin_amount beginning_balance, x.addition_amount additions, x.adjustment_amount adjustments, x.retirement_amount retirements, x.capitalization_amount capitalized, x.reclass_amount reclassifications, x.transfer_amount transfers, x.end_amount ending_balance, x.out_of_balance_flag, case nvl(x.end_amount,0) - (nvl(x.begin_amount,0) + nvl(x.addition_amount,0) + nvl(x.revaluation_amount,0) + nvl(x.reclass_amount,0) - nvl(x.retirement_amount,0) + nvl(x.adjustment_amount,0) + nvl(x.transfer_amount,0) - nvl(x.capitalization_amount,0)) when 0 then to_number(null) else nvl(x.end_amount,0) - (nvl(x.begin_amount,0) + nvl(x.addition_amount,0) + nvl(x.revaluation_amount,0) + nvl(x.reclass_amount,0) - nvl(x.retirement_amount,0) + nvl(x.adjustment_amount,0) + nvl(x.transfer_amount,0) - nvl(x.capitalization_amount,0)) end out_of_balance_amount, x.company_name || ': ' || x.book || ' (' || x.currency || ')' comp_book_curr_label from ( select fsc.company_name, gl.name ledger, :p_book book, gl.currency_code currency, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_bal_seg','SQLGL','GL#',gcc_dh.chart_of_accounts_id,null,gcc_dh.code_combination_id,'GL_BALANCING','Y','VALUE') balancing_segment, nvl2(gcc_aj.code_combination_id, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_acct_seg','SQLGL','GL#',gcc_aj.chart_of_accounts_id,null,gcc_aj.code_combination_id,'GL_ACCOUNT','Y','VALUE'), fbrg.category_books_account ) account_segment, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_cost_seg','SQLGL','GL#',gcc_dh.chart_of_accounts_id,null,gcc_dh.code_combination_id,'FA_COST_CTR','Y','VALUE') cost_center, fa.asset_number, fa.description asset_description, -- nvl(round(sum(decode(fbrg.source_type_code, 'BEGIN' , nvl(fbrg.amount,0) , null)), fc.precision),0) begin_amount, round(sum(decode(fbrg.source_type_code, decode(:p_report_type,'COST','ADDITION','CIP ADDITION') , nvl(fbrg.amount,0) , null)), fc.precision) addition_amount, round(sum(decode(fbrg.source_type_code, decode(:p_report_type,'COST','ADJUSTMENT','CIP ADJUSTMENT'), nvl(fbrg.amount,0) , null)), fc.precision) adjustment_amount, round(sum(decode(fbrg.source_type_code, decode(:p_report_type,'COST','RETIREMENT','CIP RETIREMENT'), -nvl(fbrg.amount,0), null)), fc.precision) retirement_amount, round(sum(decode(fbrg.source_type_code, decode(:p_report_type,'CIP COST','ADDITION') , -nvl(fbrg.amount,0), null)), fc.precision) capitalization_amount, round(sum(decode(fbrg.source_type_code, 'REVALUATION' , nvl(fbrg.amount,0) , null)), fc.precision) revaluation_amount, round(sum(decode(fbrg.source_type_code, 'RECLASS' , nvl(fbrg.amount,0) , null)), fc.precision) reclass_amount, round(sum(decode(fbrg.source_type_code, 'TRANSFER' , nvl(fbrg.amount,0) , null)), fc.precision) transfer_amount, nvl(round(sum(decode(fbrg.source_type_code, 'END' , nvl(fbrg.amount,0) , null)), fc.precision),0) end_amount, -- fa_fascosts_xmlp_pkg.out_of_balanceformula ( nvl(round(sum(decode(fbrg.source_type_code, 'BEGIN' , nvl(fbrg.amount,0) ,null)), fc.precision),0) , round(sum(decode(fbrg.source_type_code, decode(:p_report_type,'COST','ADDITION','CIP ADDITION' ) , nvl(fbrg.amount,0) ,null)), fc.precision) , round(sum(decode(fbrg.source_type_code, 'REVALUATION' , nvl(fbrg.amount,0) ,null)), fc.precision) , round(sum(decode(fbrg.source_type_code, 'RECLASS' , nvl(fbrg.amount,0) ,null)), fc.precision) , round(sum(decode(fbrg.source_type_code, decode(:p_report_type,'COST','RETIREMENT','CIP RETIREMENT') , -nvl(fbrg.amount,0),null)), fc.precision) , round(sum(decode(fbrg.source_type_code, decode(:p_report_type,'COST','ADJUSTMENT','CIP ADJUSTMENT') , nvl(fbrg.amount,0) ,null)), fc.precision) , round(sum(decode(fbrg.source_type_code, 'TRANSFER' , nvl(fbrg.amount,0) ,null)), fc.precision) , round(sum(decode(fbrg.source_type_code, decode(:p_report_type,'CIP COST','ADDITION') , -nvl(fbrg.amount,0),null)), fc.precision) , nvl(round(sum(decode(fbrg.source_type_code, 'END' , nvl(fbrg.amount,0) ,null)), fc.precision),0) ) out_of_balance_flag from fa_system_controls fsc, gl_ledgers gl, fnd_currencies fc, fa_balances_report_gt fbrg, fa_additions fa, gl_code_combinations gcc_dh, gl_code_combinations gcc_aj where gl.ledger_id = :p_ca_set_of_books_id and fc.currency_code = gl.currency_code and fa.asset_id = fbrg.asset_id and gcc_dh.code_combination_id = fbrg.distribution_ccid and gcc_aj.code_combination_id (+) = fbrg.adjustment_ccid and 1=1 group by fsc.company_name, gl.name, :p_book, gl.currency_code, fc.precision, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_bal_seg','SQLGL','GL#',gcc_dh.chart_of_accounts_id,null,gcc_dh.code_combination_id,'GL_BALANCING','Y','VALUE'), nvl2(gcc_aj.code_combination_id, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_acct_seg','SQLGL','GL#',gcc_aj.chart_of_accounts_id,null,gcc_aj.code_combination_id,'GL_ACCOUNT','Y','VALUE'), fbrg.category_books_account ), fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_cost_seg','SQLGL','GL#',gcc_dh.chart_of_accounts_id,null,gcc_dh.code_combination_id,'FA_COST_CTR','Y','VALUE'), fa.asset_number, fa.description ) x order by x.company_name, x.ledger, x.book, x.balancing_segment, x.account_segment, x.cost_center, x.asset_number Y #,##0.00;[Red]-#,##0.00 XXEN_FA_FAS_XMLP US FA CIP Cost CIP Costs Summary/Detail Report Equivalent to Oracle Standard Reports: CIP Summary Report CIP Detail Report DB package: XXEN_FA_FAS_XMLP Enginatics R12 only 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 -20 :p_fas_code Char FASCOSTS F Code FAS US FAS Code 2 -10 :p_report_type Char CIP COST Y AR نوع التقرير نوع التقرير D Auswertungsart Auswertungsart E Tipo de Informe Tipo de Informe F Type de rapport 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 报表类型 报表类型 3 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 CIP Cost' 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 AfA-Buch E Libro Nombre del Libro F Livre Nom du livre I Registro Nome del registro JA 台帳 台帳名 KO 장부 장부명 PTB Livro Nome do Livro RU Книга Имя книги S Bok Boknamn TR Defter Defter Adı US Book Book Name ZHS 帐簿 帐簿名称 4 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 帐套币种 帐套币种 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 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 自期间 起始期间名称 6 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 :$flex$.fa_period_name_closed 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 至期间 终止期间名称 :$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_closed From Period To Period 15BD4AED8729F0E21FDBBF13D7B6D189 CIP Cost Detail CIP Cost Detail Report by Asset SYSADMIN 11 ADDITIONS 12 ADJUSTMENTS 9 ASSET_DESCRIPTION 8 ASSET_NUMBER 7 5 BALANCING_SEGMENT 4 10 BEGINNING_BALANCE 3 BOOK 3 14 CAPITALIZED 6 CIP_ACCOUNT 5 1 COMPANY_NAME 1 20 COMP_BOOK_CURR_LABEL 7 COST_CENTER 6 4 CURRENCY 17 ENDING_BALANCE 2 LEDGER 2 19 OUT_OF_BALANCE_AMOUNT 18 OUT_OF_BALANCE_FLAG 15 RECLASSIFICATIONS 13 RETIREMENTS 16 TRANSFERS S Site 34AEF745FF0F31BE1D8A907AC48985A0 CIP Cost Summary CIP Cost Summary Report by Balancing Segment, CIP Account, and Cost Center SYSADMIN 9 ADDITIONS SUM 10 ADJUSTMENTS SUM 5 BALANCING_SEGMENT 4 8 BEGINNING_BALANCE SUM 3 BOOK 3 12 CAPITALIZED SUM 6 CIP_ACCOUNT 5 1 COMPANY_NAME 1 7 COST_CENTER 6 4 CURRENCY 15 ENDING_BALANCE SUM 2 LEDGER 2 17 OUT_OF_BALANCE_AMOUNT SUM 16 OUT_OF_BALANCE_FLAG MAX 13 RECLASSIFICATIONS SUM 11 RETIREMENTS SUM 14 TRANSFERS SUM S Site 38D5ED5D1B84BA9B3D5B68728C4583DB Pivot: Default Template CIP Cost Summary (Pivot) with CIP Cost Details by Asset SYSADMIN 11 ADDITIONS 12 ADJUSTMENTS 9 ASSET_DESCRIPTION 8 ASSET_NUMBER 7 5 BALANCING_SEGMENT 4 10 BEGINNING_BALANCE 3 BOOK 3 14 CAPITALIZED 6 CIP_ACCOUNT 5 1 COMPANY_NAME 1 20 COMP_BOOK_CURR_LABEL 7 COST_CENTER 6 4 CURRENCY 17 ENDING_BALANCE 2 LEDGER 2 19 OUT_OF_BALANCE_AMOUNT 18 OUT_OF_BALANCE_FLAG 15 RECLASSIFICATIONS 13 RETIREMENTS 16 TRANSFERS ADDITIONS VALUE 2 SUM ADJUSTMENTS VALUE 3 SUM BALANCING_SEGMENT ROW 2 BEGINNING_BALANCE VALUE 1 SUM CAPITALIZED VALUE 5 SUM CIP_ACCOUNT ROW 3 COMP_BOOK_CURR_LABEL ROW 1 COST_CENTER ROW 4 ENDING_BALANCE VALUE 8 SUM OUT_OF_BALANCE_AMOUNT VALUE 9 SUM RECLASSIFICATIONS VALUE 6 SUM RETIREMENTS VALUE 4 SUM TRANSFERS VALUE 7 SUM S Site ENGINATICS 15BD4AED8729F0E21FDBBF13D7B6D189 38D5ED5D1B84BA9B3D5B68728C4583DB