ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F0253869E053B46B63588994 SELECT icl.it_header_id line_header_id , icl.it_line_num , nvl(icl.entered_dr,0) charge_amount , nvl(icl.entered_cr,0) payment_amount , iis.name service_type , iic.name rcv_charge_center , il.meaning, IGI_IGIGITSR_XMLP_PKG.CF_DATA_FOUNDFORMULA(icl.it_line_num) CF_DATA_FOUND FROM igi_itr_charge_lines icl , igi_lookups il , igi_itr_charge_center iic , igi_itr_charge_service ics , igi_itr_service iis WHERE icl.set_of_books_id = :P_SET_OF_BOOKS_ID AND icl.charge_center_id = iic.charge_center_id AND il.lookup_type = 'ITR_SERVICE_STATUS' AND icl.status_flag = il.lookup_code AND icl.charge_service_id = ics.charge_service_id AND ics.service_id = iis.service_id and icl.it_header_id=:it_header_id ORDER BY icl.it_header_id , icl.it_line_num Y IGI IGIGITSR_XML AR IGI التجارة الداخلية: تقرير موقف المصروفات الداخلية (تنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Application: الماليات الدولية للقطاع العام Source: التجارة الداخلية: تقرير موقف المصروفات الداخلية (تنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: IGIGITSR_XML DB package: IGI_IGIGITSR_XMLP_PKG D IGI Interne Leistungsverrechnung: Interne Verrechnungen - Status- Nicht unterstützt: Reserviert für zukünftige Verwendung Application: Public Sector Financials International Source: Interne Leistungsverrechnung: Interne Verrechnungen - Status (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: IGIGITSR_XML DB package: IGI_IGIGITSR_XMLP_PKG F IGI Mouvement interservice : Etat du statut des mouvements interservices- Non pris en charge : réservé pour une utilisation ultérieure Application: Public Sector Financials International Source: Mouvement interservice : Etat du statut des mouvements interservices (XML) - Non pris en charge : réservé pour une utilisation ultérieure Short Name: IGIGITSR_XML DB package: IGI_IGIGITSR_XMLP_PKG US IGI Internal Trading: Internal Charge Status - draft Application: Public Sector Financials International Source: Internal Trading: Internal Charge Status Report (XML) - Not Supported: Reserved For Future Use Short Name: IGIGITSR_XML DB package: IGI_IGIGITSR_XMLP_PKG ZHS IGI 内部交易：内部费用状态报表- 不支持：已保留供将来使用 Application: Public Sector Financials International Source: 内部交易：内部费用状态报表 (XML) - 不支持：已保留供将来使用 Short Name: IGIGITSR_XML DB package: IGI_IGIGITSR_XMLP_PKG BI Publisher :it_header_id :lp_currency_code :p_charge_center :p_conc_request_id :p_debug_switch :p_period_from :p_period_to :p_run_aol :p_set_of_books_id :rp_data_found :rp_report_title 1 10 :p_set_of_books_id LOV Oracle IGI_ITR_LEDGER_NAME Y select ledger_id id, name value, null description from gl_ledgers where ledger_id in (select distinct asl.ledger_id ledger_id from gl_access_set_ledgers_v asl,gl_access_sets_v asv where asl.access_set_id=asv.access_set_id and asl.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and asl.object_type_code='L' and asv.security_segment_code<>'M') order by name Y AR اسم دفتر الأستاذ D Buchbezeichnung F Nom du livre US Ledger Name ZHS 分类帐名称 2 20 :p_charge_center LOV Oracle IGI_ITR_CHARGE_CENTER Y select charge_center_id id, name value, null description from igi_itr_charge_center where set_of_books_id=:$flex$.igi_itr_ledger_name order by value,description AR مركز المصروفات D Verrechnungsbereich F Centre d'imputation US Charge Center ZHS 费用中心 3 30 :p_period_from LOV Oracle IGI_ITR_START_PERIOD Y select period_name id, period_name value, null description from gl_period_statuses where set_of_books_id=:$flex$.igi_itr_ledger_name and nvl(adjustment_period_flag,'N')='N' and application_id= (select application_id from fnd_application where application_short_name='SQLGL') order by period_year,period_num AR فترة البداية D Startperiode F Période de début US Start Period ZHS 起始期间 4 40 :p_period_to LOV Oracle IGI_ITR_END_PERIOD Y select period_name id, period_name value, null description from gl_period_statuses s where s.set_of_books_id=:$flex$.igi_itr_ledger_name and nvl(s.adjustment_period_flag,'N')='N' and s.application_id= (select f1.application_id from fnd_application f1 where f1.application_short_name='SQLGL') and s.period_year*1000+s.period_num>= (select s2.period_year*1000+s2.period_num from gl_period_statuses s2 where s2.set_of_books_id=:$flex$.igi_itr_ledger_name and nvl(s2.adjustment_period_flag,'N')='N' and s2.period_name=:$flex$.igi_itr_start_period and s2.application_id= (select f2.application_id from fnd_application f2 where f2.application_short_name='SQLGL')) order by period_year,period_num AR فترة النهاية D Endperiode F Période de fin US End Period ZHS 终止期间