ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46FE551A9E05362FB09050512 SELECT A.DESCRIPTION CATEGORY, B.ASSET_NUMBER ASSET_NUMBER, C.PERIOD_COUNTER PERIOD_COUNTER, C.PERIOD_NAME PERIOD, DECODE(D.transaction_type_code, 'PARTIAL RETIRE','RETIREMENT', 'FULL RETIREMENT','RETIREMENT', 'REINSTATEMENT','RETIREMENT', D.transaction_type_code) TRANSACTION_TYPE, E.CODE_COMBINATION_ID ACCOUNT, E.AMOUNT AMOUNT, E.DR_CR_FLAG, decode(e.code_combination_Id,NULL,NULL,null) FLEXITEM, A.category_id category_id, IGI_IGIIACAR_XMLP_PKG.cf_data_foundformula(A.category_id) CF_DATA_FOUND, fnd_flex_xml_publisher_apis.process_kff_combination_1('flexitem_dsp', 'SQLGL', 'GL#', GL_ITEM.CHART_OF_ACCOUNTS_ID, NULL, GL_ITEM.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') FLEXITEM_DSP, IGI_IGIIACAR_XMLP_PKG.cf_dr_amountformula(E.DR_CR_FLAG, E.AMOUNT) CF_DR_AMOUNT, IGI_IGIIACAR_XMLP_PKG.cf_cr_amountformula(E.DR_CR_FLAG, E.AMOUNT) CF_CR_AMOUNT, IGI_IGIIACAR_XMLP_PKG.CP_DR_AMOUNT_p CP_DR_AMOUNT, IGI_IGIIACAR_XMLP_PKG.CP_CR_AMOUNT_p CP_CR_AMOUNT, DECODE(DR_CR_FLAG,'DR',E.AMOUNT,0) AMOUNT_DR, DECODE(DR_CR_FLAG,'CR',E.AMOUNT,0) AMOUNT_CR, 'x' DUMMY FROM FA_CATEGORIES A, FA_ADDITIONS B, FA_DEPRN_PERIODS C, IGI_IAC_TRANSACTION_HEADERS D, IGI_IAC_ADJUSTMENTS E, GL_CODE_COMBINATIONS GL_ITEM WHERE A.CATEGORY_ID = NVL(:P_CATEGORY_ID, A.CATEGORY_ID) AND B.ASSET_ID = E.ASSET_ID AND C.BOOK_TYPE_CODE = :P_BOOK_TYPE_CODE AND C.PERIOD_COUNTER = E.PERIOD_COUNTER AND C.PERIOD_COUNTER BETWEEN NVL(:P_PERIOD_COUNTER_FROM, C.PERIOD_COUNTER) AND NVL(:P_PERIOD_COUNTER_TO, C.PERIOD_COUNTER) AND DECODE(D.TRANSACTION_TYPE_CODE, 'PARTIAL RETIRE', 'RETIREMENT', 'FULL RETIREMENT', 'RETIREMENT', 'REINSTATEMENT', 'RETIREMENT', D.TRANSACTION_TYPE_CODE) = NVL(:P_TRANSACTION_TYPE, DECODE(D.TRANSACTION_TYPE_CODE, 'PARTIAL RETIRE', 'RETIREMENT', 'FULL RETIREMENT', 'RETIREMENT', 'REINSTATEMENT', 'RETIREMENT', D.TRANSACTION_TYPE_CODE)) AND D.BOOK_TYPE_CODE = C.BOOK_TYPE_CODE AND D.ASSET_ID = B.ASSET_ID AND D.PERIOD_COUNTER = C.PERIOD_COUNTER AND D.CATEGORY_ID = A.CATEGORY_ID AND E.ADJUSTMENT_ID = D.ADJUSTMENT_ID AND E.BOOK_TYPE_CODE = D.BOOK_TYPE_CODE AND GL_ITEM.CODE_COMBINATION_ID = E.CODE_COMBINATION_ID ORDER BY 1 ASC,10 ASC,2 ASC,3 ASC,5 ASC,9 ASC,6 ASC , A.DESCRIPTION , B.ASSET_NUMBER , D.TRANSACTION_TYPE_CODE , C.PERIOD_COUNTER Y IGI IGIIACAR_XML AR IGI محاسبة التضخم : تقرير التعديلات (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Imported from BI Publisher Description: محاسبة التضخم : تقرير التعديلات Application: الماليات الدولية للقطاع العام Source: محاسبة التضخم : تقرير التعديلات (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: IGIIACAR_XML DB package: IGI_IGIIACAR_XMLP_PKG D IGI Inflation Accounting: Korrekturen- Nicht unterstützt: Reserviert für zukünftige Verwendung Imported from BI Publisher Description: Inflation Accounting: Auswertung "Korrekturen" Application: Public Sector Financials International Source: Inflation Accounting: Korrekturen (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: IGIIACAR_XML DB package: IGI_IGIIACAR_XMLP_PKG E IGI Contabilidad de Inflación: Informe de Ajustes: No Admitido, Reservado para Uso Futuro Imported from BI Publisher Description: Contabilidad de Inflación: Ajustes Application: Public Sector Financials International Source: Contabilidad de Inflación: Informe de Ajustes (XML): No Admitido, Reservado para Uso Futuro Short Name: IGIIACAR_XML DB package: IGI_IGIIACAR_XMLP_PKG F IGI Comptabilité d'inflation : Etat Ajustements- Non pris en charge : réservé pour une utilisation ultérieure Imported from BI Publisher Description: Comptabilité d'inflation : Etat Ajustements Application: Public Sector Financials International Source: Comptabilité d'inflation : Etat Ajustements (XML) - Non pris en charge : réservé pour une utilisation ultérieure Short Name: IGIIACAR_XML DB package: IGI_IGIIACAR_XMLP_PKG I IGI Contabilità dell'inflazione: rapporto Adeguamenti- non supportato: riservato per usi futuri Imported from BI Publisher Description: Contabilità dell'inflazione: rapporto Adeguamenti Application: Public Sector Financials International Source: Contabilità dell'inflazione: rapporto Adeguamenti (XML) - non supportato: riservato per usi futuri Short Name: IGIIACAR_XML DB package: IGI_IGIIACAR_XMLP_PKG KO IGI 인플레이션 회계: 조정 보고서- 지원되지 않음: 추후 사용을 위해 예약됨 Imported from BI Publisher Description: 인플레이션 회계: 조정 보고서 Application: Public Sector Financials International Source: 인플레이션 회계: 조정 보고서(XML) - 지원되지 않음: 추후 사용을 위해 예약됨 Short Name: IGIIACAR_XML DB package: IGI_IGIIACAR_XMLP_PKG RU IGI Учет с поправкой на инфляцию: отчет о корректировках- не поддерживается: зарезервировано для будущего использования Imported from BI Publisher Description: Учет с поправкой на инфляцию: отчет о корректировках Application: Государственный сектор: международные финансы Source: Учет с поправкой на инфляцию: отчет о корректировках (XML) - не поддерживается: зарезервировано для будущего использования Short Name: IGIIACAR_XML DB package: IGI_IGIIACAR_XMLP_PKG S IGI Rapport om justeringar- Stöds inte: Reserverad för framtida bruk Imported from BI Publisher Description: Inflationsredovisning: Rapport om justeringar Application: Public Sector Financials International Source: Inflationsredovisning: Rapport om justeringar (XML) - Stöds inte: Reserverad för framtida bruk Short Name: IGIIACAR_XML DB package: IGI_IGIIACAR_XMLP_PKG US IGI Inflation Accounting : Adjustments Report- Not Supported: Reserved For Future Use Imported from BI Publisher Description: Inflation Accounting : Adjustments Report Application: Public Sector Financials International Source: Inflation Accounting : Adjustments Report (XML) - Not Supported: Reserved For Future Use Short Name: IGIIACAR_XML DB package: IGI_IGIIACAR_XMLP_PKG ZHS IGI 通货膨胀会计：调整报表- 不支持：已保留供将来使用 Imported from BI Publisher Description: 通货膨胀会计：调整报表 Application: Public Sector Financials International Source: 通货膨胀会计：调整报表 (XML) - 不支持：已保留供将来使用 Short Name: IGIIACAR_XML DB package: IGI_IGIIACAR_XMLP_PKG BI Publisher :cp_cr_amount :cp_curr_code :cp_dr_amount :cp_flex_data_item :cp_period_from :cp_period_to :p_book_type_code :p_cat_struct_id :p_category_id :p_conc_request_id :p_period_counter_from :p_period_counter_to :p_transaction_type :rp_data_found :struct_num 1 -20 :p_cat_struct_id Number SELECT CATEGORY_FLEX_STRUCTURE FROM FA_SYSTEM_CONTROLS AR معرف هيكل الفئة هيكل الفئة المرن D Kennung Kategoriestruktur Anlagenkategorien-FlexFeld-Struktur E Id Estructura de Categoría Tipo de Estructura de Categoría F ID structure de catégorie Structure de la clé flexible Catégorie I Id struttura categoria Struttura del flexfield categoria KO 범주 구조 ID 범주 가변 구조 RU Идент. структуры категории Структура ГП категории S Id för kategoristruktur Flexfältstruktur för kategori US Category Struct ID Category Flex Structure ZHS 类别结构标识 类别弹性结构 2 10 :p_book_type_code 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 AfA-Buch E Libro Libro F Livre Livre I Registro Registro KO 장부 장부 RU Книга Книга S Bok Bok US Book Book ZHS 帐簿 帐簿 3 20 :p_period_counter_from LOV Oracle IGI_IAC_PERIOD_FROM Y select period_counter id, period_name value, null description from fa_deprn_periods where book_type_code=:$flex$.igi_iac_valid_books order by period_counter AR الفترة من عداد الفترة من D Periode von Anzahl Perioden von E De Período De Contador de Períodos F Période - De Compteur de périodes - De I Periodo - Da Contatore periodo - Da KO 기간: 부터 기간 계수기 출처 RU Период с Счетчик периодов с S Från period Periodräknare - från US Period From Period Counter From ZHS 期间自 期间计数器自 4 30 :p_period_counter_to LOV Oracle IGI_IAC_PERIOD_TO Y select period_counter id, period_name value, null description from fa_deprn_periods where book_type_code=:$flex$.igi_iac_valid_books and period_counter>=:$flex$.igi_iac_period_from order by period_counter AR الفترة إلى عداد الفترة إلى D Periode bis Anzahl Perioden bis E A Período A Contador de Períodos F Période - A Compteur de périodes - A I Periodo - A Contatore periodo - A KO 기간: 까지 기간 계수기 대상 RU Период по Счетчик периодов по S Till period Periodräknare - till US Period To Period Counter To ZHS 终止期间 期间计数器至 5 40 :p_category_id Char AR الفئة الفئة D Kategorie Kategorie E Categoría Categoría F Catégorie Catégorie I Categoria Categoria KO 범주 범주 RU Категория Категория S Kategori Kategori US Category Category ZHS 类别 类别 6 50 :p_transaction_type LOV Oracle IGI_IAC_TRANSACTION_TYPES Y select lookup_code id, lookup_code value, meaning description from igi_lookups where lookup_type='IGI_IAC_TRANSACTION_TYPES' and enabled_flag='Y' order by lookup_code AR نوع الحركة نوع الحركة D Transaktionsart Transaktionsart E Tipo de Transacción Tipo de Transacción F Type de mouvement Type de mouvement I Tipo di transazione Tipo di transazione KO 트랜잭션 유형 트랜잭션 유형 RU Тип транзакции Тип транзакции S Transaktionstyp Transaktionstyp US Transaction Type Transaction Type ZHS 事务处理类型 事务处理类型