ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D470EC51A9E05362FB09050512 SELECT &ACCT_FLEX_BAL_SEG COMP_CODE, NVL(&ACCT_FLEX_ACCT_SEG, BAL.Category_Books_Account) ACCOUNT, BAL.Category_Books_Account Category_Books_Account, &ACCT_FLEX_COST_SEG COST_CTR, NVL(SUM (DECODE (BAL.Source_Type_Code, 'BEGIN', NVL(BAL.Amount,0), NULL)), 0) BEGIN, SUM (DECODE (BAL.Source_Type_Code, DECODE(:P_REPORT_TYPE, 'COST', 'ADDITION', 'CIP ADDITION'), NVL(BAL.Amount,0), NULL)) ADDITION, SUM (DECODE (BAL.Source_Type_Code, DECODE(:P_REPORT_TYPE, 'CIP COST', 'ADDITION'), -NVL(BAL.Amount,0), NULL)) CAPITALIZATION, SUM (DECODE (BAL.Source_Type_Code, DECODE(:P_REPORT_TYPE, 'COST', 'ADJUSTMENT', 'CIP ADJUSTMENT'), NVL(BAL.Amount,0), NULL)) ADJUSTMENT, SUM (DECODE (BAL.Source_Type_Code, 'RECLASS', NVL(BAL.Amount,0), NULL)) RECLASS, SUM (DECODE (BAL.Source_Type_Code, DECODE(:P_REPORT_TYPE, 'COST', 'RETIREMENT', 'CIP 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, 'TRANSFER', NVL(BAL.Amount,0), NULL)) TRANSFER, NVL(SUM (DECODE (BAL.Source_Type_Code, 'END', NVL(BAL.Amount,0), NULL)), 0) END, fnd_flex_xml_publisher_apis.process_kff_combination_1('d_comp_code', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') d_comp_code, FA_FASCOSTS_XMLP_PKG.bal_out_of_balanceformula(:BAL_BEGIN, :BAL_ADD, :BAL_REVAL, :BAL_RECLASS, :BAL_RETIRE, :BAL_ADJUST, :BAL_TRANS, :BAL_CAPITAL, :BAL_END) BAL_OUT_OF_BALANCE, --fnd_flex_xml_publisher_apis.process_kff_combination_1('d_account', 'SQLGL', 'GL#', ajcc.CHART_OF_ACCOUNTS_ID, NULL, ajcc.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'Y', 'VALUE') d_account, NVL(fnd_flex_xml_publisher_apis.process_kff_combination_1('d_account', 'SQLGL', 'GL#', ajcc.CHART_OF_ACCOUNTS_ID, NULL, ajcc.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'Y', 'VALUE'), BAL.Category_Books_Account) d_account1, FA_FASCOSTS_XMLP_PKG.acct_out_of_balanceformula(:ACCT_BEGIN, :ACCT_ADD, :ACCT_REVAL, :ACCT_RECLASS, :ACCT_RETIRE, :ACCT_ADJUST, :ACCT_TRANS, :ACCT_CAPITAL, :ACCT_END) ACCT_OUT_OF_BALANCE, fnd_flex_xml_publisher_apis.process_kff_combination_1('d_cost_ctr', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'FA_COST_CTR', 'Y', 'VALUE') d_cost_ctr, FA_FASCOSTS_XMLP_PKG.caprevalformula(SUM ( DECODE ( BAL.Source_Type_Code , 'REVALUATION' , NVL ( BAL.Amount , 0 ) , NULL ) ), SUM ( DECODE ( BAL.Source_Type_Code , DECODE ( :P_REPORT_TYPE , 'CIP COST' , 'ADDITION' ) , - NVL ( BAL.Amount , 0 ) , NULL ) )) CAPREVAL, FA_FASCOSTS_XMLP_PKG.out_of_balanceformula(NVL ( SUM ( DECODE ( BAL.Source_Type_Code , 'BEGIN' , NVL ( BAL.Amount , 0 ) , NULL ) ) , 0 ), SUM ( DECODE ( BAL.Source_Type_Code , DECODE ( :P_REPORT_TYPE , 'COST' , 'ADDITION' , 'CIP ADDITION' ) , NVL ( BAL.Amount , 0 ) , NULL ) ), SUM ( DECODE ( BAL.Source_Type_Code , 'REVALUATION' , NVL ( BAL.Amount , 0 ) , NULL ) ), SUM ( DECODE ( BAL.Source_Type_Code , 'RECLASS' , NVL ( BAL.Amount , 0 ) , NULL ) ), SUM ( DECODE ( BAL.Source_Type_Code , DECODE ( :P_REPORT_TYPE , 'COST' , 'RETIREMENT' , 'CIP RETIREMENT' ) , - NVL ( BAL.Amount , 0 ) , NULL ) ), SUM ( DECODE ( BAL.Source_Type_Code , DECODE ( :P_REPORT_TYPE , 'COST' , 'ADJUSTMENT' , 'CIP ADJUSTMENT' ) , NVL ( BAL.Amount , 0 ) , NULL ) ), SUM ( DECODE ( BAL.Source_Type_Code , 'TRANSFER' , NVL ( BAL.Amount , 0 ) , NULL ) ), SUM ( DECODE ( BAL.Source_Type_Code , DECODE ( :P_REPORT_TYPE , 'CIP COST' , 'ADDITION' ) , - NVL ( BAL.Amount , 0 ) , NULL ) ), NVL ( SUM ( DECODE ( BAL.Source_Type_Code , 'END' , NVL ( BAL.Amount , 0 ) , NULL ) ) , 0 )) OUT_OF_BALANCE FROM FA_BALANCES_REPORT_GT BAL, GL_CODE_COMBINATIONS DHCC, GL_CODE_COMBINATIONS AJCC WHERE 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, --added NVL(fnd_flex_xml_publisher_apis.process_kff_combination_1('d_account', 'SQLGL', 'GL#', ajcc.CHART_OF_ACCOUNTS_ID, NULL, ajcc.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'Y', 'VALUE'), BAL.Category_Books_Account), fnd_flex_xml_publisher_apis.process_kff_combination_1('d_comp_code', '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('d_cost_ctr', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'FA_COST_CTR', 'Y', 'VALUE'), BAL.Category_Books_Account /*ORDER BY D_COMP_CODE,d_account,D_COST_CTR,BEGIN,ADDITION,RECLASS,CAPITALIZATION,RETIREMENT, REVALUATION,ADJUSTMENT,TRANSFER,END -- 1, 2, 3*/ ORDER by 1,2,fnd_flex_xml_publisher_apis.process_kff_combination_1('d_cost_ctr', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'FA_COST_CTR', 'Y', 'VALUE'),4,5,6 OFA FASWIPSR_XML AR FA تقرير إجمالي مشروعات تحت التنفيذ (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Imported from BI Publisher Description: تقرير إجمالي بناء في الإنجاز Application: الأصول Source: تقرير إجمالي مشروعات تحت التنفيذ (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: FASWIPSR_XML DB package: FA_FASCOSTS_XMLP_PKG D FA Im Bau befindliche Anlagen - Übersicht- Nicht unterstützt: Reserviert für zukünftige Verwendung Imported from BI Publisher Description: Im Bau befindliche Anlagen - Übersicht Application: Anlagen Source: Im Bau befindliche Anlagen - Übersicht (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: FASWIPSR_XML DB package: FA_FASCOSTS_XMLP_PKG E FA Informe Resumen de Activos en Curso: No Admitido, Reservado para Uso Futuro Imported from BI Publisher Description: Informe del Resumen de Activos en Curso Application: Assets Source: Informe Resumen de Activos en Curso (XML): No Admitido, Reservado para Uso Futuro Short Name: FASWIPSR_XML DB package: FA_FASCOSTS_XMLP_PKG F FA Balance des productions à soi-même- Non pris en charge : réservé pour une utilisation future Imported from BI Publisher Description: Balance des productions à soi-même Application: Assets Source: Balance des productions à soi-même (XML) - Non pris en charge : réservé pour une utilisation future Short Name: FASWIPSR_XML DB package: FA_FASCOSTS_XMLP_PKG I FA Rapporto Sintetico CIC- non supportato: riservato per usi futuri Imported from BI Publisher Description: Rapporto Sintetico CIC Application: Assets Source: Rapporto Sintetico CIC (XML) - non supportato: riservato per usi futuri Short Name: FASWIPSR_XML DB package: FA_FASCOSTS_XMLP_PKG JA FA 建設仮勘定要約レポート- 未サポート: 将来の使用のために予約 Imported from BI Publisher Description: 建設仮勘定要約レポート Application: Assets Source: 建設仮勘定要約レポート(XML) - 未サポート: 将来の使用のために予約 Short Name: FASWIPSR_XML DB package: FA_FASCOSTS_XMLP_PKG KO FA CIP 요약 보고서- 지원되지 않음: 추후 사용을 위해 예약됨 Imported from BI Publisher Description: CIP 요약 보고서 Application: Assets Source: CIP 요약 보고서(XML) - 지원되지 않음: 추후 사용을 위해 예약됨 Short Name: FASWIPSR_XML DB package: FA_FASCOSTS_XMLP_PKG PTB FA CIP - Relatório Resumido- Não Suportado: Reservado Para Uso Futuro Imported from BI Publisher Description: Relatório de Sumário de Construção em Andamento Application: Assets Source: CIP - Relatório Resumido (XML) - Não Suportado: Reservado Para Uso Futuro Short Name: FASWIPSR_XML DB package: FA_FASCOSTS_XMLP_PKG RU FA Сводный отчет о НзС- не поддерживается: зарезервировано для будущего использования Imported from BI Publisher Description: Сводный отчет о незавершенном строительстве Application: Активы Source: Сводный отчет о НзС (XML) - не поддерживается: зарезервировано для будущего использования Short Name: FASWIPSR_XML DB package: FA_FASCOSTS_XMLP_PKG S FA Pågående arbeten - översiktsrapport- Stöds inte: Reserverad för framtida bruk Imported from BI Publisher Description: Pågående arbeten - översiktsrapport Application: Assets Source: Pågående arbeten - översiktsrapport (XML) - Stöds inte: Reserverad för framtida bruk Short Name: FASWIPSR_XML DB package: FA_FASCOSTS_XMLP_PKG TR FA Devam Eden Yatırım Özet Raporu- Desteklenmez: Gelecekte Kullanım İçin Ayrılmıştır Imported from BI Publisher Description: Devam Eden Yatırım Özet Raporu Application: Duran Varlıklar Source: Devam Eden Yatırım Özet Raporu (XML) - Desteklenmez: Gelecekte Kullanım İçin Ayrılmıştır Short Name: FASWIPSR_XML DB package: FA_FASCOSTS_XMLP_PKG US FA CIP Summary Report- Not Supported: Reserved For Future Use Imported from BI Publisher Description: Construction in Process Summary Report Application: Assets Source: CIP Summary Report (XML) - Not Supported: Reserved For Future Use Short Name: FASWIPSR_XML DB package: FA_FASCOSTS_XMLP_PKG ZHS FA CIP 汇总报表- 不支持：已保留供将来使用 Imported from BI Publisher Description: 在建工程汇总报表 Application: 资产 Source: CIP 汇总报表 (XML) - 不支持：已保留供将来使用 Short Name: FASWIPSR_XML DB package: FA_FASCOSTS_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_capital :acct_cc_aprompt :acct_end :acct_reclass :acct_retire :acct_reval :acct_trans :bal_add :bal_adjust :bal_begin :bal_capital :bal_end :bal_reclass :bal_retire :bal_reval :bal_trans :cat_maj_rprompt :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 :period_from :period_to :rp_bal_lprompt :rp_company_name :rp_ctr_aprompt :rp_report_name 1 -20 :p_report_type Char CIP COST 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_CORP_CIP_TO_TAX Y select book_type_code id, book_type_code value, book_type_name description from fa_book_controls_sec where (book_class='CORPORATE') or (book_class='TAX' and allow_cip_assets_flag='YES') 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_CIP_SOB_CURRENCY_CORP_TAX 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_corp_cip_to_tax union all select set_of_books_id from fa_mc_book_controls where book_type_code=:$flex$.fa_book_corp_cip_to_tax) 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 Buchwährung Buchwährung E Divisa de Libro Mayor Divisa de Libro Mayor F Devise comptable Devise comptable I Divisa libro contabile Divisa del libro contabile JA 元帳通貨 元帳通貨 KO 원장 통화 원장 통화 PTB Moeda do Razão Moeda do Razão RU Валюта книги Валюта книги S Huvudboksvaluta Huvudboksvaluta TR Defter Para Birimi Defter Para Birimi US Ledger Currency Ledger Currency ZHS 分类帐币种 分类帐币种 4 30 :p_period1 LOV Oracle FA_CORP_PERIOD_CLOSED_CORP_TAX Y select period_name id, period_name value, null description from fa_deprn_periods where book_type_code=:$flex$.fa_book_corp_cip_to_tax and period_counter> (select min(dp2.period_counter) from fa_deprn_periods dp2 where dp2.book_type_code=:$flex$.fa_book_corp_cip_to_tax) order by period_counter 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 自期间 起始期间名称 5 40 :p_period2 LOV Oracle FA_CORP_PERIOD_CLOSED_CORP_TAX Y select period_name id, period_name value, null description from fa_deprn_periods where book_type_code=:$flex$.fa_book_corp_cip_to_tax and period_counter> (select min(dp2.period_counter) from fa_deprn_periods dp2 where dp2.book_type_code=:$flex$.fa_book_corp_cip_to_tax) order by period_counter Y AR إلى الفترة اسم فترة النهاية D Bis Periode Bis Periode E A Período Nombre del Período de Finalización F A 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$.book Book Ledger Currency :$flex$.fa_book_corp_cip_to_tax Book From Period :$flex$.fa_book_corp_cip_to_tax Book Ledger Currency :$flex$.fa_book_corp_cip_to_tax Book To Period