ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46FE951A9E05362FB09050512 SELECT BAL.COMPANY COMP_CODE, BAL.ACCOUNT ACCOUNT, BAL.COST_CENTER COST_CTR, BAL.DATA_SOURCE BALANCE_TYPE, BAL.DISPLAY_ORDER DISPLAY_ORDER, SUM(DECODE(BAL.Source_Type_Code, 'ADDITION', NVL(BAL.Amount,0), NULL)) ADDITION, SUM(DECODE(BAL.Source_Type_Code, 'DEPRECIATION', NVL(BAL.Amount,0), NULL)) DEPRECIATION, SUM(DECODE(BAL.Source_Type_Code, '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, 'REVALUATION',NVL(BAL.Amount,0), 'DEPRECIATION',NVL(BAL.Amount,0), NULL)) REVALUATION, SUM(DECODE(BAL.Source_Type_Code, 'TRANSFER', NVL(BAL.Amount,0), NULL)) TRANSFER, IGI_IGIIAOPE_XMLP_PKG.cost_additionformula(BAL.DATA_SOURCE, SUM ( DECODE ( BAL.Source_Type_Code , 'ADDITION' , NVL ( BAL.Amount , 0 ) , NULL ) )) COST_ADDITION, IGI_IGIIAOPE_XMLP_PKG.cost_adjustmentformula(BAL.DATA_SOURCE, SUM ( DECODE ( BAL.Source_Type_Code , 'ADJUSTMENT' , NVL ( BAL.Amount , 0 ) , NULL ) )) COST_ADJUSTMENT, IGI_IGIIAOPE_XMLP_PKG.cost_revaluationformula(BAL.DATA_SOURCE, SUM ( DECODE ( BAL.Source_Type_Code , 'REVALUATION' , NVL ( BAL.Amount , 0 ) , 'DEPRECIATION' , NVL ( BAL.Amount , 0 ) , NULL ) )) COST_REVALUATION, IGI_IGIIAOPE_XMLP_PKG.cost_reclassformula(BAL.DATA_SOURCE, SUM ( DECODE ( BAL.Source_Type_Code , 'RECLASS' , NVL ( BAL.Amount , 0 ) , NULL ) )) COST_RECLASS, IGI_IGIIAOPE_XMLP_PKG.cost_transferformula(BAL.DATA_SOURCE, SUM ( DECODE ( BAL.Source_Type_Code , 'TRANSFER' , NVL ( BAL.Amount , 0 ) , NULL ) )) COST_TRANSFER, IGI_IGIIAOPE_XMLP_PKG.cost_movementformula(BAL.DATA_SOURCE, SUM ( DECODE ( BAL.Source_Type_Code , 'ADDITION' , NVL ( BAL.Amount , 0 ) , NULL ) ), SUM ( DECODE ( BAL.Source_Type_Code , 'ADJUSTMENT' , NVL ( BAL.Amount , 0 ) , NULL ) ), SUM ( DECODE ( BAL.Source_Type_Code , 'RECLASS' , NVL ( BAL.Amount , 0 ) , NULL ) ), SUM ( DECODE ( BAL.Source_Type_Code , 'REVALUATION' , NVL ( BAL.Amount , 0 ) , 'DEPRECIATION' , NVL ( BAL.Amount , 0 ) , NULL ) ), :CC_COST_TRANSFER) COST_MOVEMENT, IGI_IGIIAOPE_XMLP_PKG.blog_additionformula(BAL.DATA_SOURCE, SUM ( DECODE ( BAL.Source_Type_Code , 'ADDITION' , NVL ( BAL.Amount , 0 ) , NULL ) )) BLOG_ADDITION, IGI_IGIIAOPE_XMLP_PKG.blog_adjustmentformula(BAL.DATA_SOURCE, SUM ( DECODE ( BAL.Source_Type_Code , 'ADJUSTMENT' , NVL ( BAL.Amount , 0 ) , NULL ) )) BLOG_ADJUSTMENT, IGI_IGIIAOPE_XMLP_PKG.blog_revaluationformula(BAL.DATA_SOURCE, SUM ( DECODE ( BAL.Source_Type_Code , 'REVALUATION' , NVL ( BAL.Amount , 0 ) , 'DEPRECIATION' , NVL ( BAL.Amount , 0 ) , NULL ) )) BLOG_REVALUATION, IGI_IGIIAOPE_XMLP_PKG.blog_reclassformula(BAL.DATA_SOURCE, SUM ( DECODE ( BAL.Source_Type_Code , 'RECLASS' , NVL ( BAL.Amount , 0 ) , NULL ) )) BLOG_RECLASS, IGI_IGIIAOPE_XMLP_PKG.blog_transferformula(BAL.DATA_SOURCE) BLOG_TRANSFER, IGI_IGIIAOPE_XMLP_PKG.blog_movementformula(BAL.DATA_SOURCE, SUM ( DECODE ( BAL.Source_Type_Code , 'ADDITION' , NVL ( BAL.Amount , 0 ) , NULL ) ), SUM ( DECODE ( BAL.Source_Type_Code , 'ADJUSTMENT' , NVL ( BAL.Amount , 0 ) , NULL ) ), SUM ( DECODE ( BAL.Source_Type_Code , 'RECLASS' , NVL ( BAL.Amount , 0 ) , NULL ) ), SUM ( DECODE ( BAL.Source_Type_Code , 'REVALUATION' , NVL ( BAL.Amount , 0 ) , 'DEPRECIATION' , NVL ( BAL.Amount , 0 ) , NULL ) )) BLOG_MOVEMENT, IGI_IGIIAOPE_XMLP_PKG.net_additionformula(BAL.DATA_SOURCE, SUM ( DECODE ( BAL.Source_Type_Code , 'ADDITION' , NVL ( BAL.Amount , 0 ) , NULL ) )) NET_ADDITION, IGI_IGIIAOPE_XMLP_PKG.net_adjustmentformula(BAL.DATA_SOURCE, SUM ( DECODE ( BAL.Source_Type_Code , 'ADJUSTMENT' , NVL ( BAL.Amount , 0 ) , NULL ) )) NET_ADJUSTMENT, IGI_IGIIAOPE_XMLP_PKG.net_revaluationformula(BAL.DATA_SOURCE, SUM ( DECODE ( BAL.Source_Type_Code , 'REVALUATION' , NVL ( BAL.Amount , 0 ) , 'DEPRECIATION' , NVL ( BAL.Amount , 0 ) , NULL ) )) NET_REVALUATION, IGI_IGIIAOPE_XMLP_PKG.net_reclassformula(BAL.DATA_SOURCE, SUM ( DECODE ( BAL.Source_Type_Code , 'RECLASS' , NVL ( BAL.Amount , 0 ) , NULL ) )) NET_RECLASS, IGI_IGIIAOPE_XMLP_PKG.net_transferformula(BAL.DATA_SOURCE, SUM ( DECODE ( BAL.Source_Type_Code , 'TRANSFER' , NVL ( BAL.Amount , 0 ) , NULL ) )) NET_TRANSFER, IGI_IGIIAOPE_XMLP_PKG.net_movementformula(BAL.DATA_SOURCE, SUM ( DECODE ( BAL.Source_Type_Code , 'ADDITION' , NVL ( BAL.Amount , 0 ) , NULL ) ), SUM ( DECODE ( BAL.Source_Type_Code , 'ADJUSTMENT' , NVL ( BAL.Amount , 0 ) , NULL ) ), SUM ( DECODE ( BAL.Source_Type_Code , 'RECLASS' , NVL ( BAL.Amount , 0 ) , NULL ) ), SUM ( DECODE ( BAL.Source_Type_Code , 'REVALUATION' , NVL ( BAL.Amount , 0 ) , 'DEPRECIATION' , NVL ( BAL.Amount , 0 ) , NULL ) ), SUM ( DECODE ( BAL.Source_Type_Code , 'TRANSFER' , NVL ( BAL.Amount , 0 ) , NULL ) )) NET_MOVEMENT FROM IGI_IAC_BALANCES_REPORT BAL WHERE :DO_INSERT = 1 AND BAL.COMPANY BETWEEN NVL(:P_COMPANY1, BAL.COMPANY) AND NVL(:P_COMPANY2, BAL.COMPANY) AND BAL.COST_CENTER BETWEEN NVL(:P_COST_CENTER1, BAL.COST_CENTER) AND NVL(:P_COST_CENTER2, BAL.COST_CENTER) AND BAL.ACCOUNT BETWEEN NVL(:P_ACCOUNT1, BAL.ACCOUNT) AND NVL(:P_ACCOUNT2, BAL.ACCOUNT) GROUP BY BAL.COMPANY, BAL.ACCOUNT, BAL.COST_CENTER, BAL.DATA_SOURCE, BAL.DISPLAY_ORDER ORDER BY 1,2,3,5 IGI IGIIAOPE_XML AR IGI محاسبة التضخم : تقرير ملخص مصروفات التشغيل (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Imported from BI Publisher Description: محاسبة التضخم : تقرير إجمالي مصروفات التشغيل Application: الماليات الدولية للقطاع العام Source: محاسبة التضخم : تقرير ملخص مصروفات التشغيل (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: IGIIAOPE_XML DB package: IGI_IGIIAOPE_XMLP_PKG D IGI Inflation Accounting: Betriebskosten - Übersicht- Nicht unterstützt: Reserviert für zukünftige Verwendung Imported from BI Publisher Description: Inflation Accounting: Betriebskosten - Übersicht Application: Public Sector Financials International Source: Inflation Accounting: Betriebskosten - Übersicht (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: IGIIAOPE_XML DB package: IGI_IGIIAOPE_XMLP_PKG E IGI Contabilidad de Inflación: Informen de Resumen de Gastos Operativos: No Admitido, Reservado para Uso Futuro Imported from BI Publisher Description: Contabilidad de inflación: Informe de resumen de gastos operativos Application: Public Sector Financials International Source: Contabilidad de Inflación: Informen de Resumen de Gastos Operativos (XML): No Admitido, Reservado para Uso Futuro Short Name: IGIIAOPE_XML DB package: IGI_IGIIAOPE_XMLP_PKG F IGI Comptabilité d'inflation : Etat de synthèse des frais de fonctionnement- Non pris en charge : réservé pour une utilisation ultérieure Imported from BI Publisher Description: Comptabilité d'inflation : Etat de synthèse des frais de fonctionnement Application: Public Sector Financials International Source: Comptabilité d'inflation : Etat de synthèse des frais de fonctionnement (XML) - Non pris en charge : réservé pour une utilisation ultérieure Short Name: IGIIAOPE_XML DB package: IGI_IGIIAOPE_XMLP_PKG I IGI Contabilità dell'inflazione: rapporto Sintetico spese d'esercizio- non supportato: riservato per usi futuri Imported from BI Publisher Description: Contabilità dell'inflazione: rapporto Sintetico spese operative Application: Public Sector Financials International Source: Contabilità dell'inflazione: rapporto Sintetico spese d'esercizio (XML) - non supportato: riservato per usi futuri Short Name: IGIIAOPE_XML DB package: IGI_IGIIAOPE_XMLP_PKG KO IGI 인플레이션 회계: 운영 비용 요약 보고서- 지원되지 않음: 추후 사용을 위해 예약됨 Imported from BI Publisher Description: 인플레이션 회계 : 운영 비용 요약 보고서 Application: Public Sector Financials International Source: 인플레이션 회계: 운영 비용 요약 보고서(XML) - 지원되지 않음: 추후 사용을 위해 예약됨 Short Name: IGIIAOPE_XML DB package: IGI_IGIIAOPE_XMLP_PKG RU IGI Учет инфляции: сводный отчет об эксплуатационных расходах- не поддерживается: зарезервировано для будущего использования Imported from BI Publisher Description: Учет с поправкой на инфляцию: сводный отчет об эксплуатационных расходах Application: Государственный сектор: международные финансы Source: Учет инфляции: сводный отчет об эксплуатационных расходах (XML) - не поддерживается: зарезервировано для будущего использования Short Name: IGIIAOPE_XML DB package: IGI_IGIIAOPE_XMLP_PKG S IGI Översikt över rörelsekostnad - rapport- Stöds inte: Reserverad för framtida bruk Imported from BI Publisher Description: Inflationsredovisning: Översikt över rörelsekostnad - rapport Application: Public Sector Financials International Source: Inflationsredovisning: Översikt över rörelsekostnad - rapport (XML) - Stöds inte: Reserverad för framtida bruk Short Name: IGIIAOPE_XML DB package: IGI_IGIIAOPE_XMLP_PKG US IGI Inflation Accounting : Operating Expense Summary Report- Not Supported: Reserved For Future Use Imported from BI Publisher Description: Inflation Accounting : Operating Expense Summary Report Application: Public Sector Financials International Source: Inflation Accounting : Operating Expense Summary Report (XML) - Not Supported: Reserved For Future Use Short Name: IGIIAOPE_XML DB package: IGI_IGIIAOPE_XMLP_PKG ZHS IGI 通货膨胀会计：营业费用汇总报表- 不支持：已保留供将来使用 Imported from BI Publisher Description: 通货膨胀会计：营业费用汇总报表 Application: Public Sector Financials International Source: 通货膨胀会计：营业费用汇总报表 (XML) - 不支持：已保留供将来使用 Short Name: IGIIAOPE_XML DB package: IGI_IGIIAOPE_XMLP_PKG BI Publisher :acct_bal_aprompt :acct_cc_aprompt :cc_cost_transfer :do_insert :p_account1 :p_account2 :p_book :p_company1 :p_company2 :p_conc_request_id :p_cost_center1 :p_cost_center2 :p_period1 :p_period2 :p_report_type :rp_bal_lprompt :rp_cc_aprompt :rp_cc_lprompt :rp_company_name :rp_report_name 1 -30 :p_report_type Char OP EXPENSE 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 KO 보고서 유형 보고서 유형 RU Тип отчета Тип отчета S Rapporttyp Rapporttyp US Report Type Report Type ZHS 报表类型 报表类型 2 -20 :p_not_reqd Number select accounting_flex_structure from fa_book_controls where book_type_code = :$flex$.book AR الهيكل المحاسبي المرن الهيكل المحاسبي المرن D Konto-FlexFeld-Struktur Konto-FlexFeld-Struktur E Estructura Contable Estructura Contable F Structure clé comptable flexible Structure clé comptable flexible I Struttura flexfield contabile Struttura flexfield contabile KO 계정 가변 구조 계정 가변 구조 RU Структура ГП плана счетов Структура ГП плана счетов S Kodsträngsstruktur Kodsträngsstruktur US Acct Flex Structure Acct Flex Structure ZHS 会计科目弹性域结构 会计科目弹性域结构 3 10 :p_book LOV Oracle IGI_IAC_VALID_BOOKS Y select book_type_code id, book_type_code value, null description from igi_iac_book_controls ib where ib.book_type_code=(select book_type_code from fa_book_controls_sec bc where bc.book_type_code=ib.book_type_code and bc.date_ineffective is null) order by ib.book_type_code Y AR الدفتر دفتر محاسبة التضخم D AfA-Buch Inflation Accounting - AfA-Buch E Libro Libro Contable de Inflación F Livre Comptabilité d'inflation : Livre I Registro Registro di contabilità dell'inflazione KO 장부 인플레이션 회계장부 RU Книга Книга учета с поправкой на инфляцию S Bok Räkenskapsbok för inflationsredovisning US Book Inflation Accounting Book ZHS 帐簿 通货膨胀会计帐簿 4 20 :p_period1 LOV Oracle IGI_IAC_PERIOD_NAME_CLOSED Y select period_name id, period_name value, null description from fa_deprn_periods where book_type_code=:$flex$.igi_iac_valid_books and period_counter>(select min(dp2.period_counter) from fa_deprn_periods dp2 where dp2.book_type_code=:$flex$.igi_iac_valid_books) order by period_counter Y AR الفترة من الفترة من D Periode von Periode von E De Período De Período F Période - De Période - De I Periodo - Da Periodo - Da KO 기간: 부터 기간: 부터 RU Период с Период с S Från period Från period US Period From Period From ZHS 期间自 期间自 5 30 :p_period2 LOV Oracle IGI_IAC_PERIOD_TO_CLOSED Y select period_name id, period_name value, null description from fa_deprn_periods where book_type_code=:$flex$.igi_iac_valid_books and period_counter>=(select dp2.period_counter from fa_deprn_periods dp2 where dp2.book_type_code=:$flex$.igi_iac_valid_books and period_name=:$flex$.igi_iac_period_name_closed) order by period_counter Y AR الفترة إلى الفترة إلى D Periode bis Periode bis E A Período A Período F Période - A Période - A I Periodo - A Periodo - A KO 기간: 까지 기간: 까지 RU Период по Период по S Till period Till period US Period To Period To ZHS 终止期间 终止期间 6 40 :p_company1 Char AR الشركة من الشركة من D Von Firma Von Firma E De Compañía De Compañía F Société - De Société - De I Società - Da Società - Da KO 회사 From 회사 From RU Компания с Компания с S Från företag Från företag US Company From Company From ZHS 公司自 公司自 7 50 :p_company2 Char AR الشركة إلى الشركة إلى D Bis Firma Bis Firma E A Compañía A Compañía F Société - A Société - A I Società - A Società - A KO 회사 To 회사 To RU Компания по Компания по S Till företag Till företag US Company To Company To ZHS 公司至 公司至 8 60 :p_cost_center1 Char AR مركز التكلفة من مركز التكلفة من D Von Kostenstelle Von Kostenstelle E De Centro de Costes De Centro de Costes F Centre de coûts - De Centre de coûts - De I Centro di costo - Da Centro di costo - Da KO 비용 부서 From 비용 부서 From RU Место возникновения затрат с Место возникновения затрат с S Från kostnadsställe Från kostnadsställe US Cost Center From Cost Center From ZHS 成本中心自 成本中心自 9 70 :p_cost_center2 Char AR مركز التكلفة إلى مركز التكلفة إلى D Bis Kostenstelle Bis Kostenstelle E A Centro de Costes A Centro de Costes F Centre de coûts - A Centre de coûts - A I Centro di costo - A Centro di costo - A KO 비용 부서 To 비용 부서 To RU Место возникновения затрат по Место возникновения затрат по S Till kostnadsställe Till kostnadsställe US Cost Center To Cost Center To ZHS 成本中心至 成本中心至 10 80 :p_account1 Char AR الحساب من الحساب من D Von Konto Von Konto E De Cuenta De Cuenta F Compte - De Compte - De I Conto - Da Conto - Da KO 계정 From 계정 From RU Счет с Счет с S Från konto Från konto US Account From Account From ZHS 帐户自 帐户自 11 90 :p_account2 Char AR الحساب إلى الحساب إلى D Bis Konto Bis Konto E A Cuenta A Cuenta F Compte - A Compte - A I Conto - A Conto - A KO 계정 To 계정 To RU Счет по Счет по S Till konto Till konto US Account To Account To ZHS 帐户至 帐户至 :$flex$.book Book Acct Flex Structure :$flex$.igi_iac_period_name_closed Period From Period To :$flex$.igi_iac_valid_books Book Period From :$flex$.igi_iac_valid_books Book Period To