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）限制的操作单元。 C6E085D46FF651A9E05362FB09050512 SELECT distinct gsob.NAME "sob_name" , sc.description "Standing_Charge" , sc.charge_reference "Charge_Reference" , ty.NAME "Transaction" , sc.status "Status" , sc.standing_charge_date "Date" , bs.name "Batch_Source" , sr.name "Sales_Person" , hp1.party_name Bill_to_name , cu2.party_name Ship_to_name , sc.suppress_inv_print "Suppress_Inv_Prt" , ca1.account_number Bill_to_num , cu2.account_number Ship_to_num , sc.review_date , sc.reminder_days , sc.period_name frequency , sc.next_due_date , sc.start_date , sc.end_date , decode(bb.instrument_type, 'CREDITCARD',bb.card_issuer_name,'BANKACCOUNT', bb.bank_name, NULL) bcname , rm.name Payment_Method , decode(bb.instrument_type, 'CREDITCARD',bb.card_holder_name,'BANKACCOUNT', bb.bank_branch_name, NULL) brholname , decode(bb.instrument_type, 'CREDITCARD',bb.card_number,'BANKACCOUNT', bb.account_number, NULL) num , ld.Charge_item_number , it.item_code , it.description , ld.price Current_Price , ld.current_effective_date , ld.revised_price , ld.revised_effective_date , ld.previous_price , ld.period_name unit_of_measure , ld.Quantity , tx.tax_rate_code ,fcv.name currency_name ,fcv.currency_code currency_code FROM ZX_SCO_RATES tx , iby_trxn_extensions_v bb , IGI_RPI_ITEMS it , IGI_RPI_LINE_DETAILS ld , AR_RECEIPT_METHODS rm , HZ_PARTIES hp1 , HZ_CUST_ACCOUNTS ca1 , (select party_name, cust_account_id customer_id, account_number from hz_parties, hz_cust_accounts where hz_parties.party_id = hz_cust_accounts.party_id) cu2 , RA_CUST_TRX_TYPES ty , RA_SALESREPS sr , IGI_RPI_STANDING_CHARGES sc , RA_BATCH_SOURCES bs , GL_SETS_OF_BOOKS gsob ,FND_CURRENCIES_VL fcv WHERE hp1.party_id = ca1.party_id AND gsob.SET_OF_BOOKS_ID = :P_SOB_ID AND bs.BATCH_SOURCE_ID LIKE nvl(:P_BATCH_SOURCE_ID, '%') AND ((:P_REVIEW_DATE IS NOT NULL AND sc.REVIEW_DATE <= :P_REVIEW_DATE) OR :P_REVIEW_DATE IS NULL) AND ((:P_DUE_DATE IS NOT NULL AND sc.NEXT_DUE_DATE <= :P_DUE_DATE) OR :P_DUE_DATE IS NULL) AND ((:P_REMIND_FLAG = 'Y' AND sysdate >= (sc.END_DATE - sc.REMINDER_DAYS)) OR :P_REMIND_FLAG = 'N') AND sc.BATCH_SOURCE_ID = bs.BATCH_SOURCE_ID AND sc.CUST_TRX_TYPE_ID = ty.CUST_TRX_TYPE_ID AND sc.PAYMENT_TRXN_EXTENSION_ID = bb.trxn_extension_id(+) AND sc.SALESREP_ID = sr.SALESREP_ID AND sc.BILL_TO_CUSTOMER_ID = ca1.CUST_ACCOUNT_ID AND sc.SHIP_TO_CUSTOMER_ID = cu2.CUSTOMER_ID(+) AND sc.RECEIPT_METHOD_ID = rm.RECEIPT_METHOD_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 gsob.currency_code = fcv.currency_code ORDER BY bs.NAME , hp1.PARTY_NAME , sc.CHARGE_REFERENCE Y IGI IGIRRSCL_XML AR IGI المصروفات الدورية: القائمة (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Imported from BI Publisher Description: المصروفات الدورية: قائمة Application: الماليات الدولية للقطاع العام Source: المصروفات الدورية: القائمة (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: IGIRRSCL_XML DB package: IGI_IGIRRSCL_XMLP_PKG D IGI Wiederkehrende Gebühren: Liste- Nicht unterstützt: Reserviert für zukünftige Verwendung Imported from BI Publisher Description: Wiederkehrende Gebühren: Liste Application: Public Sector Financials International Source: Wiederkehrende Gebühren: Liste (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: IGIRRSCL_XML DB package: IGI_IGIRRSCL_XMLP_PKG E IGI Cargos Fijos: Listado: No Admitido, Reservado para Uso Futuro Imported from BI Publisher Description: Cargos Fijos: Listado Application: Public Sector Financials International Source: Cargos Fijos: Listado (XML): No Admitido, Reservado para Uso Futuro Short Name: IGIRRSCL_XML DB package: IGI_IGIRRSCL_XMLP_PKG F IGI Règlements répétitifs : Listes- Non pris en charge : réservé en vue d'une utilisation future Imported from BI Publisher Description: Règlements répétitifs: Listes Application: Public Sector Financials International Source: Règlements répétitifs : Listes (XML) - Non pris en charge : réservé en vue d'une utilisation future Short Name: IGIRRSCL_XML DB package: IGI_IGIRRSCL_XMLP_PKG I IGI Addebiti fissi: Elenco- non supportato: riservato per usi futuri Imported from BI Publisher Description: Addebiti fissi: Elenco Application: Public Sector Financials International Source: Addebiti fissi: Elenco (XML) - non supportato: riservato per usi futuri Short Name: IGIRRSCL_XML DB package: IGI_IGIRRSCL_XMLP_PKG KO IGI 목록- 지원되지 않음: 추후 사용을 위해 예약됨 Imported from BI Publisher Description: 고정비: 목록 Application: Public Sector Financials International Source: 고정비: 목록(XML) - 지원되지 않음: 추후 사용을 위해 예약됨 Short Name: IGIRRSCL_XML DB package: IGI_IGIRRSCL_XMLP_PKG RU IGI Регулярные сборы: список- не поддерживается: зарезервировано для будущего использования Imported from BI Publisher Description: Регулярные сборы: список Application: Государственный сектор: международные финансы Source: Регулярные сборы: список (XML) - не поддерживается: зарезервировано для будущего использования Short Name: IGIRRSCL_XML DB package: IGI_IGIRRSCL_XMLP_PKG S IGI Löpande avgifter: Lista- Stöds inte: Reserverad för framtida bruk Imported from BI Publisher Description: Löpande avgifter: Lista Application: Public Sector Financials International Source: Löpande avgifter: Lista (XML) - Stöds inte: Reserverad för framtida bruk Short Name: IGIRRSCL_XML DB package: IGI_IGIRRSCL_XMLP_PKG US IGI Standing Charges: Listing- Not Supported: Reserved For Future Use Imported from BI Publisher Description: Standing Charges: Listing Application: Public Sector Financials International Source: Standing Charges: Listing (XML) - Not Supported: Reserved For Future Use Short Name: IGIRRSCL_XML DB package: IGI_IGIRRSCL_XMLP_PKG ZHS IGI 固定费用：列表- 不支持：已保留供将来使用 Imported from BI Publisher Description: 固定费用：列表 Application: Public Sector Financials International Source: 固定费用：列表 (XML) - 不支持：已保留供将来使用 Short Name: IGIRRSCL_XML DB package: IGI_IGIRRSCL_XMLP_PKG BI Publisher :operating_unit :p_batch_source_id :p_conc_request_id :p_debug_switch :p_due_date :p_remind_flag :p_review_date :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 SOB ID معرف دفاتر الحسابات D SOB ID Kennung Buchungsstruktur E SOB ID Id Juego de Libros F SOB ID ID entité comptable I SOB ID ID set of books KO SOB ID SOB ID RU SOB ID Идент. набора книг S SOB ID Räkenskaps-id US SOB ID SOB Id ZHS SOB ID SOB 标识 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_due_date Date AR تاريخ الاستحقاق تاريخ الاستحقاق D Fällig am Fällig am E Fecha de Vencimiento Fecha de Vencimiento F Date d'échéance Date d'échéance I Data scadenza Data scadenza KO 만기 일자 만기 일자 RU Срок Срок S Sista giltighetsdatum Sista giltighetsdatum US Due Date Due Date ZHS 到期日 到期日 5 30 :p_review_date Date AR تاريخ المراجعة تاريخ المراجعة D Geprüft am Geprüft am E Fecha de Revisión Fecha de Revisión F Date modification Date modification I Data revisione Data revisione KO 검토 일자 검토 일자 RU Дата рассмотрения Дата рассмотрения S Granskningsdatum Granskningsdatum US Review Date Review Date ZHS 复核日期 复核日期 6 40 :p_remind_flag LOV Oracle IGI_AR_YES_NO Y select lookup_code id, meaning value, null description from igi_lookups where lookup_type='YES_NO' order by value,description select meaning from igi_lookups where lookup_type = 'YES_NO' and lookup_code = 'N' Y AR علامة التذكير علامة التذكير D Erinnern Erinnern E Indicador de Recordatorio Indicador de Recordatorio F Indicateur Rappel Indicateur Rappel I Flag Promemoria Flag Promemoria KO 상기 플래그 상기 플래그 RU Флаг напоминания Флаг напоминания S Påminn-flaggan Påminn-flaggan US Remind Flag Remind Flag ZHS 提醒标志 提醒标志