ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEB979D2E0530100007F1FF2 HR Operating Unit Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name Fixed where clause duplication AR وحدة التشغيل مقيدة بالتحكم في الوصول متعدد المنظمات (MOAC) D Bedieneinheit eingeschränkt durch Multi Org Access Control (MOAC) E Unidad operativa restringida por el control de acceso multiorgánico (MOAC) F Unité opérationnelle restreinte par un contrôle d'accès multi-organismes (MOAC) I Unità operativa limitata dal controllo di accesso multiorgano (MOAC) JA 多機関アクセス制御(MOAC)で制限された操作ユニット KO 다중 조직 액세스 제어 (MOAC)에 의해 제한되는 운영 단위 PTB Unidade operacional restrita por controle de acesso multi org (MOAC) RU Операционное устройство, ограниченное мультиорганизованным контролем доступа (MOAC) S Styrenhet begränsad av multi-org access control (MOAC) TR Çoklu kuruluş erişim kontrolü (MOAC) tarafından kısıtlanan işletim birimi US Operating unit restricted by multi org access control (MOAC) ZHS 受多机构访问控制（MOAC）限制的操作单元。 C6E085D46FF451A9E05362FB09050512 SELECT gsob.NAME "sob_name" , bs.name "Batch_Source" , sc.charge_reference "Charge Reference" , hp.party_name "Customer Name" , sc.next_due_date "Due Date" , sc.advance_arrears_ind "Billing Method" , sc.period_name "Billing Period" , sc.suppress_inv_print "Suppress_Inv_Prt" , sr.name "Sales_Person" , sc.start_date , sc.end_date , sc.description "Standing Charge Description" , ld.Charge_item_number , it.item_code , ld.period_name "Charge Period" , ld.Quantity , tx.tax_rate_code , ld.price Current_Price , ld.current_effective_date , ld.revised_price , ld.revised_effective_date , ld.previous_price , it.description FROM ZX_SCO_RATES tx , IGI_RPI_ITEMS it , IGI_RPI_LINE_DETAILS ld , HZ_PARTIES hp , HZ_CUST_ACCOUNTS ca , RA_SALESREPS sr , IGI_RPI_STANDING_CHARGES sc , RA_BATCH_SOURCES bs , GL_SETS_OF_BOOKS gsob WHERE ca.PARTY_ID = hp.PARTY_ID AND gsob.SET_OF_BOOKS_ID = :P_SOB_ID AND bs.BATCH_SOURCE_ID LIKE nvl(:P_BATCH_SOURCE_ID, '%') AND sc.NEXT_DUE_DATE <= :P_RUN_DATE AND sc.SET_OF_BOOKS_ID = gsob.SET_OF_BOOKS_ID AND sc.BATCH_SOURCE_ID = bs.BATCH_SOURCE_ID AND sc.STATUS = 'ACTIVE' AND ((nvl(sc.ADVANCE_ARREARS_IND,sc.DEFAULT_INVOICING_RULE ) = 'ADVANCE' AND sc.NEXT_DUE_DATE <= NVL(sc.END_DATE, sc.NEXT_DUE_DATE)) OR (nvl(sc.ADVANCE_ARREARS_IND,sc.DEFAULT_INVOICING_RULE) = 'ARREARS' AND NVL(sc.PREVIOUS_DUE_DATE, sc.START_DATE) <= NVL(sc.END_DATE, sc.NEXT_DUE_DATE))) AND sc.SALESREP_ID = sr.SALESREP_ID AND sc.BILL_TO_CUSTOMER_ID = ca.CUST_ACCOUNT_ID AND ld.STANDING_CHARGE_ID = sc.STANDING_CHARGE_ID AND ld.VAT_TAX_ID = tx.TAX_RATE_ID(+) AND ld.ITEM_ID = it.ITEM_ID AND nvl(sc.date_synchronized_flag,'Y') = 'Y' AND ca.STATUS = 'A' ORDER BY gsob.NAME, bs.NAME , sc.CHARGE_REFERENCE , hp.PARTY_NAME,sc.next_due_date,sc.advance_arrears_ind,sc.advance_arrears_ind, sr.name,sc.suppress_inv_print, sc.start_date , sc.end_date , sc.description IGI IGIRRPIV_XML AR IGI المصروفات الدورية: مسجل الفواتير الأولية (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Imported from BI Publisher Description: المصروفات الدورية: مسجل الفواتير الأولية Application: الماليات الدولية للقطاع العام Source: المصروفات الدورية: مسجل الفواتير الأولية (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: IGIRRPIV_XML DB package: IGI_IGIRRPIV_XMLP_PKG D IGI Wiederkehrende Gebühren: Vorläufige Rechnungsliste- Nicht unterstützt: Reserviert für zukünftige Verwendung Imported from BI Publisher Description: Wiederkehrende Gebühren: Vorläufige Rechnungen Application: Public Sector Financials International Source: Wiederkehrende Gebühren: Vorläufige Rechnungsliste (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: IGIRRPIV_XML DB package: IGI_IGIRRPIV_XMLP_PKG E IGI Cargos Fijos: Registro Preliminar de Facturas: No Admitido, Reservado para Uso Futuro Imported from BI Publisher Description: Cargos Fijos: Registro Preliminar de Facturas Application: Public Sector Financials International Source: Cargos Fijos: Registro Preliminar de Facturas (XML): No Admitido, Reservado para Uso Futuro Short Name: IGIRRPIV_XML DB package: IGI_IGIRRPIV_XMLP_PKG F IGI Règlements répétitifs : Registre des propositions de facture- Non pris en charge : réservé en vue d'une utilisation future Imported from BI Publisher Description: Règlements répétitifs: Registre des propositions de facture Application: Public Sector Financials International Source: Règlements répétitifs : Registre des propositions de facture (XML) - Non pris en charge : réservé en vue d'une utilisation future Short Name: IGIRRPIV_XML DB package: IGI_IGIRRPIV_XMLP_PKG I IGI Addebiti fissi: registro fatture preliminari- non supportato: riservato per usi futuri Imported from BI Publisher Description: Addebiti fissi: Registrazione fattura preliminare Application: Public Sector Financials International Source: Addebiti fissi: registro fatture preliminari (XML) - non supportato: riservato per usi futuri Short Name: IGIRRPIV_XML DB package: IGI_IGIRRPIV_XMLP_PKG KO IGI 예비 송장 레지스터- 지원되지 않음: 추후 사용을 위해 예약됨 Imported from BI Publisher Description: 고정비: 예비 송장 레지스터 Application: Public Sector Financials International Source: 고정비: 예비 송장 레지스터(XML) - 지원되지 않음: 추후 사용을 위해 예약됨 Short Name: IGIRRPIV_XML DB package: IGI_IGIRRPIV_XMLP_PKG RU IGI Регулярные сборы: предварительный реестр счетов-фактур- не поддерживается: зарезервировано для будущего использования Imported from BI Publisher Description: Регулярные сборы: предварительный реестр счетов-фактур Application: Государственный сектор: международные финансы Source: Регулярные сборы: предварительный реестр счетов-фактур (XML) - не поддерживается: зарезервировано для будущего использования Short Name: IGIRRPIV_XML DB package: IGI_IGIRRPIV_XMLP_PKG S IGI Löpande avgifter: Register över preliminära fakturor- Stöds inte: Reserverad för framtida bruk Imported from BI Publisher Description: Löpande avgifter: Registrering av preliminär faktura Application: Public Sector Financials International Source: Löpande avgifter: Register över preliminära fakturor (XML) - Stöds inte: Reserverad för framtida bruk Short Name: IGIRRPIV_XML DB package: IGI_IGIRRPIV_XMLP_PKG US IGI Standing Charges: Preliminary Invoice Register- Not Supported: Reserved For Future Use Imported from BI Publisher Description: Standing Charges: Preliminary Invoice Register Application: Public Sector Financials International Source: Standing Charges: Preliminary Invoice Register (XML) - Not Supported: Reserved For Future Use Short Name: IGIRRPIV_XML DB package: IGI_IGIRRPIV_XMLP_PKG ZHS IGI 固定费用：初步发票登记表- 不支持：已保留供将来使用 Imported from BI Publisher Description: 固定费用：初步发票登记表 Application: Public Sector Financials International Source: 固定费用：初步发票登记表 (XML) - 不支持：已保留供将来使用 Short Name: IGIRRPIV_XML DB package: IGI_IGIRRPIV_XMLP_PKG BI Publisher :operating_unit :p_batch_source_id :p_conc_request_id :p_debug_switch :p_run_date :p_run_date_1 :p_sob_id 1 -20 :p_sob_id LOV Oracle IGI_AR_PRIMARY_SOB Y select set_of_books_id id, set_of_books_id value, null description from igi_ar_system_options order by value,description select set_of_books_id from ar_system_parameters Y AR معرف دفتر الأستاذ معرف دفتر الأستاذ D Buchkennung Buchkennung E Id Libro Mayor Identificador de libro mayor F ID livre ID livre I Id libro contabile Id del libro contabile KO 원장 ID 원장 ID RU Идентификатор книги Идентификатор книги S Huvudboks-id Huvudboks-id US Ledger Id Ledger Id ZHS 分类帐标识 分类帐标识 2 0 :operating_unit LOV HR Operating Unit 8E2FF36EDEB979D2E0530100007F1FF2 Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name select haouv.name from hr_all_organization_units_vl haouv where haouv.organization_id=nvl((select mgoat.organization_id from mo_glob_org_access_tmp mgoat where mgoat.organization_id=nvl(fnd_profile.value('DEFAULT_ORG_ID'),mgoat.organization_id) and rownum=1),fnd_global.org_id) Y US Operating Unit Required Operating Unit restriction for reports working in single operating unit mode only 3 10 :p_batch_source_id LOV Oracle IGI_AR_RPI_BATCH_SOURCE Y select batch_source_id id, name value, null description from ra_batch_sources where batch_source_id in (select batch_source_id from igi_rpi_standing_charges) order by name AR اسم مصدر المجموعة اسم مصدر المجموعة D Bezeichnung Belegherkunft Bezeichnung Belegherkunft E Nombre de Origen de Lote Nombre de Origen de Lote F Nom de l'origine du lot Nom de l'origine du lot I Nome origine batch Nome origine batch KO 뱃치 출처명 뱃치 출처명 RU Имя источника пакета Имя источника пакета S Buntkälla Buntkälla US Batch Source Name Batch Source Name ZHS 批来源名 批来源名 4 20 :p_run_date Date Y AR تاريخ التشغيل تاريخ التشغيل D Startdatum Startdatum E Fecha de Ejecución Fecha de Ejecución F Date exécution Date exécution I Data esecuzione Data esecuzione KO 실행 일자 실행 일자 RU Дата выполнения Дата выполнения S Körningsdatum Körningsdatum US Run Date Run Date ZHS 运行日期 运行日期