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）限制的操作单元。 C6E085D46F3951A9E05362FB09050512Y select ps.customer_id customer_id, substrb(party.party_name,1,50) customer_name, cust_acct.account_number customer_number, arpt_sql_func_util.get_trx_type_details(ct.cust_trx_type_id,'NAME') name, ps.customer_trx_id customer_trx_id, ps.trx_number Invoice_No, ps.trx_number Full_Invoice_No, ct.purchase_order purchase_order, ps.due_date due_date, ps.amount_due_original Invoice_amt, ps.amount_due_remaining Balance_amt, ps.trx_date trx_date_main, ps.payment_schedule_id payment_schedule_id, ps.invoice_currency_code Currency_Code, ct.doc_sequence_value C_DOCUMENT_NUMBER, &lp_query_show_bill cons_bill_number, --added as fix AR_ARXBPH_XMLP_PKG.D_INVOICE_AMOUNTFormula(substrb(party.party_name,1,50)) from ar_payment_schedules ps, ra_customer_trx ct, hz_cust_accounts cust_acct, hz_parties party, &lp_table_show_bill hz_customer_profiles cp_cust, hz_customer_profiles cp_site where ps.customer_trx_id = ct.customer_trx_id and ct.previous_customer_trx_id is null and cust_acct.party_id = party.party_id &P_WHERE_1 &lp_customer_num_low &lp_customer_num_high &lp_invoice_amount_low &lp_invoice_amount_high &lp_invoice_number_low &lp_invoice_number_high &P_WHERE_11 &P_WHERE_12 &lp_balance_due_low &lp_balance_due_high &lp_trx_date_low &lp_trx_date_high &P_WHERE_2 &lp_where_show_bill and cp_cust.site_use_id is null and ct.bill_to_site_use_id = cp_site.site_use_id(+) and nvl( nvl(ARPT_SQL_FUNC_UTIL.get_lookup_meaning('ACCOUNT_STATUS',cp_site.account_status), ARPT_SQL_FUNC_UTIL.get_lookup_meaning('ACCOUNT_STATUS',cp_cust.account_status)), decode(:P_IN_ACCOUNT_STATUS_LOW_1, 'All', :P_IN_ACCOUNT_STATUS_LOW_1, null)) between decode(:P_IN_ACCOUNT_STATUS_LOW_1, 'All', nvl (nvl(ARPT_SQL_FUNC_UTIL.get_lookup_meaning('ACCOUNT_STATUS',cp_site.account_status), ARPT_SQL_FUNC_UTIL.get_lookup_meaning('ACCOUNT_STATUS',cp_cust.account_status)), decode(:P_IN_ACCOUNT_STATUS_LOW_1, 'All', :P_IN_ACCOUNT_STATUS_LOW_1,null)), :P_IN_ACCOUNT_STATUS_LOW_1) and decode(:P_IN_ACCOUNT_STATUS_high_1, 'All', nvl (nvl(ARPT_SQL_FUNC_UTIL.get_lookup_meaning('ACCOUNT_STATUS',cp_site.account_status), ARPT_SQL_FUNC_UTIL.get_lookup_meaning('ACCOUNT_STATUS',cp_cust.account_status)), decode(:P_IN_ACCOUNT_STATUS_high_1, 'All', :P_IN_ACCOUNT_STATUS_high_1,null)), :P_IN_ACCOUNT_STATUS_high_1) UNION select cr.pay_from_customer customer_id, substrb(party.party_name,1,50) customer_name, cust_acct.account_number customer_number, l_pay.meaning, TO_NUMBER('') customer_trx_id, cr.receipt_number Invoice_No, cr.receipt_number || '-' || cr.cash_receipt_id Full_Invoice_No, '' purchase_order, TO_DATE(NULL) due_date, cr.amount Invoice_amt, TO_NUMBER('') Balance_amt, cr.receipt_date trx_date_main, TO_NUMBER('') payment_schedule_id, cr.currency_code Currency_Code, cr.doc_sequence_value C_DOCUMENT_NUMBER, to_char(NULL) cons_bill_number, --ADDED AS FIX AR_ARXBPH_XMLP_PKG.D_INVOICE_AMOUNTFormula(substrb(party.party_name,1,50)) from ar_cash_receipts cr, hz_cust_accounts cust_acct, hz_parties party, hz_customer_profiles cp_cust, hz_customer_profiles cp_site, ar_lookups l_pay WHERE 1 = DECODE(:p_in_invoice_number_low || :p_in_invoice_number_high || :p_in_invoice_amount_low || :p_in_invoice_amount_high || :p_in_balance_due_low || :p_in_balance_due_high, NULL, 1, 2) AND cr.status IN ('APP','UNAPP') AND 0 < (SELECT NVL(sum(amount_applied),0) FROM ar_receivable_applications app WHERE cr.cash_receipt_id = app.cash_receipt_id AND app.status = 'ACC') and cr.pay_from_customer = cust_acct.cust_account_id and cust_acct.party_id =party.party_id and cr.cash_receipt_id <= nvl(:p_max_id, 999999999999999) &lp_customer_num_low &lp_customer_num_high &P_WHERE_11 &P_WHERE_12 &lp_r_trx_date_low &lp_r_trx_date_high &P_WHERE_2 and cp_cust.site_use_id is null and cr.customer_site_use_id = cp_site.site_use_id(+) and nvl( nvl(ARPT_SQL_FUNC_UTIL.get_lookup_meaning('ACCOUNT_STATUS',cp_site.account_status), ARPT_SQL_FUNC_UTIL.get_lookup_meaning('ACCOUNT_STATUS',cp_cust.account_status)), decode(:P_IN_ACCOUNT_STATUS_LOW_1, 'All', :P_IN_ACCOUNT_STATUS_LOW_1, null)) between decode(:P_IN_ACCOUNT_STATUS_LOW_1, 'All', nvl (nvl(ARPT_SQL_FUNC_UTIL.get_lookup_meaning('ACCOUNT_STATUS',cp_site.account_status), ARPT_SQL_FUNC_UTIL.get_lookup_meaning('ACCOUNT_STATUS',cp_cust.account_status)), decode(:P_IN_ACCOUNT_STATUS_LOW_1, 'All', :P_IN_ACCOUNT_STATUS_LOW_1,null)), :P_IN_ACCOUNT_STATUS_LOW_1) and decode(:P_IN_ACCOUNT_STATUS_high_1, 'All', nvl (nvl(ARPT_SQL_FUNC_UTIL.get_lookup_meaning('ACCOUNT_STATUS',cp_site.account_status), ARPT_SQL_FUNC_UTIL.get_lookup_meaning('ACCOUNT_STATUS',cp_cust.account_status)), decode(:P_IN_ACCOUNT_STATUS_high_1, 'All', :P_IN_ACCOUNT_STATUS_high_1,null)), :P_IN_ACCOUNT_STATUS_high_1) and l_pay.lookup_type = 'PAYMENT_CATEGORY_TYPE' and l_pay.lookup_code = cr.type order by 2, 3, 1, 14, 6, 5, 9 AR ARXBPH_XML AR AR تاريخ الإيصال وتحرير الفواتير (بتنسيق XML) Imported from BI Publisher Description: تاريخ الإيصال وتحرير الفواتير Application: المقبوضات Source: تاريخ الإيصال وتحرير الفواتير (بتنسيق XML) Short Name: ARXBPH_XML DB package: AR_ARXBPH_XMLP_PKG D AR Fakturierungs- und Zahlungshistorie Imported from BI Publisher Description: Fakturierungs- und Zahlungshistorie Application: Debitoren Source: Fakturierungs- und Zahlungshistorie (XML) Short Name: ARXBPH_XML DB package: AR_ARXBPH_XMLP_PKG E AR Historial de Facturación y Cobros Imported from BI Publisher Description: Historial de facturación y cobros Application: Receivables Source: Historial de Facturación y Cobros (XML) Short Name: ARXBPH_XML DB package: AR_ARXBPH_XMLP_PKG F AR Historique de la facturation et des règlements Imported from BI Publisher Description: Historique de la facturation et des règlements Application: Receivables Source: Historique de la facturation et des règlements (XML) Short Name: ARXBPH_XML DB package: AR_ARXBPH_XMLP_PKG I AR Cronologia fatturazione e incassi Imported from BI Publisher Description: Cronologia fatturazione e incassi Application: Receivables Source: Cronologia fatturazione e incassi (XML) Short Name: ARXBPH_XML DB package: AR_ARXBPH_XMLP_PKG JA AR 請求/入金履歴 Imported from BI Publisher Description: 請求/入金履歴 Application: Receivables Source: 請求/入金履歴(XML) Short Name: ARXBPH_XML DB package: AR_ARXBPH_XMLP_PKG KO AR 청구 및 수금 내역 Imported from BI Publisher Description: 청구 및 수금 내역 Application: Receivables Source: 청구 및 수금 내역(XML) Short Name: ARXBPH_XML DB package: AR_ARXBPH_XMLP_PKG PTB AR Histórico de Faturamento e Recebimento Imported from BI Publisher Description: Histórico de Faturamento e Recebimento Application: Receivables Source: Histórico de Faturamento e Recebimento (XML) Short Name: ARXBPH_XML DB package: AR_ARXBPH_XMLP_PKG RU AR Реестр выставленных счетов и поступлений Imported from BI Publisher Description: Реестр выставленных счетов и поступлений Application: Дебиторы Source: Реестр выставленных счетов и поступлений (XML) Short Name: ARXBPH_XML DB package: AR_ARXBPH_XMLP_PKG S AR Faktura- och betalningshistorik Imported from BI Publisher Description: Faktura- och betalningshistorik Application: Receivables Source: Faktura- och betalningshistorik (XML) Short Name: ARXBPH_XML DB package: AR_ARXBPH_XMLP_PKG TR AR Faturalama ve Ödeme Tarihçesi Imported from BI Publisher Description: Faturalama ve Ödeme Tarihçesi Application: Alacaklar Muhasebesi Source: Faturalama ve Ödeme Tarihçesi (XML) Short Name: ARXBPH_XML DB package: AR_ARXBPH_XMLP_PKG US AR Billing and Receipt History Imported from BI Publisher Description: Billing and Receipt History Application: Receivables Source: Billing and Receipt History (XML) Short Name: ARXBPH_XML DB package: AR_ARXBPH_XMLP_PKG ZHS AR 开单和收款历史记录 Imported from BI Publisher Description: 开单和收款历史记录 Application: 应收帐款 Source: 开单和收款历史记录 (XML) Short Name: ARXBPH_XML DB package: AR_ARXBPH_XMLP_PKG BI Publisher &lp_balance_due_high &lp_balance_due_low &lp_customer_num_high &lp_customer_num_low &lp_invoice_amount_high &lp_invoice_amount_low &lp_invoice_number_high &lp_invoice_number_low &lp_query_show_bill &lp_r_trx_date_high &lp_r_trx_date_low &lp_table_show_bill &lp_trx_date_high &lp_trx_date_low &lp_where_show_bill &p_where_1 &p_where_11 &p_where_12 &p_where_2 :adjusts_dummy :adjusts_dummy_cr :credits_dummy :credits_dummy_adj :lp_account_status_high :lp_account_status_low :lp_balance_due_high :lp_balance_due_low :lp_currency_show_bill :lp_customer_name_high :lp_customer_name_low :lp_customer_num_high :lp_customer_num_low :lp_invoice_amount_high :lp_invoice_amount_low :lp_invoice_number_high :lp_invoice_number_low :lp_query_show_bill :lp_r_trx_date_high :lp_r_trx_date_low :lp_table_show_bill :lp_trx_date_high :lp_trx_date_low :lp_where_show_bill :operating_unit :p_conc_request_id :p_cons_profile_value :p_in_account_status_high :p_in_account_status_high_1 :p_in_account_status_low :p_in_account_status_low_1 :p_in_balance_due_high :p_in_balance_due_low :p_in_customer_high :p_in_customer_low :p_in_customer_num_high :p_in_customer_num_low :p_in_invoice_amount_high :p_in_invoice_amount_low :p_in_invoice_number_high :p_in_invoice_number_low :p_in_trx_date_high :p_in_trx_date_low :p_max_id :p_sob :p_where_1 :p_where_11 :p_where_12 :p_where_2 :payment_no_dummy_adj :payment_no_dummy_cr :payments_dummy :payments_dummy_adj :rp_company_name :rp_data_found :rp_report_name :status_high :status_low 1 -20 :p_sob Number select set_of_books_id from ar_system_parameters Y AR دفتر الأستاذ D Buch E Libro Mayor F Livre I Libro contabile JA 元帳 KO 원장 PTB Razão RU Книга S Huvudbok TR Defter US Ledger 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_in_customer_low LOV Oracle AR_CUSTOMER_NAME Y Y select party.party_name id, party.party_name value, null description from hz_cust_accounts cu,hz_parties party where cu.party_id=party.party_id and cu.cust_account_id in (select cu2.cust_account_id from hz_cust_accounts cu2,hz_parties party2 where cu2.party_id=party2.party_id and party2.party_name= party.party_name) order by party.party_name AR اسم العميل من D Von Kundenname E De Nombre de Cliente F Nom de client - De I Nome cliente (min) JA 顧客名:自 KO 고객명 하한 PTB Nome do Cliente - Inferior RU Имя заказчика с S Från kundnamn TR Müşteri Adı Alt Değeri US Customer Name Low ZHS 客户名称下限 4 20 :p_in_customer_high LOV Oracle AR_CUSTOMER_NAME Y Y select party.party_name id, party.party_name value, null description from hz_cust_accounts cu,hz_parties party where cu.party_id=party.party_id and cu.cust_account_id in (select cu2.cust_account_id from hz_cust_accounts cu2,hz_parties party2 where cu2.party_id=party2.party_id and party2.party_name= party.party_name) order by party.party_name AR اسم العميل إلى D Bis Kundenname E A Nombre de Cliente F Nom de client - A I Nome cliente (max) JA 顧客名:至 KO 고객명 상한 PTB Nome do Cliente - Superior RU Имя заказчика по S Till kundnamn TR Müşteri Adı Üst Değeri US Customer Name High ZHS 客户名称上限 5 30 :p_in_customer_num_low LOV Oracle AR_CUSTOMER_NUMBER Y Y select cust.account_number id, cust.account_number value, null description from hz_cust_accounts cust,hz_parties party where cust.party_id=party.party_id order by cust.account_number AR رقم العميل من D Von Kundennummer E De Número de Cliente F Numéro de client - De I Numero cliente (min) JA 顧客番号:自 KO 고객 번호 하한 PTB Número do Cliente - Inferior RU Номер заказчика с S Från kundnummer TR Müşteri Numarası Alt Değeri US Customer Number Low ZHS 客户编号下限 6 40 :p_in_customer_num_high LOV Oracle AR_CUSTOMER_NUMBER Y Y select cust.account_number id, cust.account_number value, null description from hz_cust_accounts cust,hz_parties party where cust.party_id=party.party_id order by cust.account_number AR رقم العميل إلى D Bis Kundennummer E A Número de Cliente F Numéro de client - A I Numero cliente (max) JA 顧客番号:至 KO 고객 번호 상한 PTB Número do Cliente - Superior RU Номер заказчика по S Till kundnummer TR Müşteri Numarası Üst Değeri US Customer Number High ZHS 客户编号上限 7 50 :p_in_invoice_number_low LOV Oracle AR_INVOICE_NUMBER Y Y select ct.trx_number id, ct.trx_number value, null description from ra_customer_trx ct where ct.customer_trx_id in ( select max(ct2.customer_trx_id) from ra_customer_trx ct2 where ct.trx_number=ct2.trx_number) order by ct.trx_number,ct.customer_trx_id AR رقم فاتورة من D Von Rechnungsnummer E De Número de Factura F Numéro de facture - De I Numero fattura (min) JA 請求書番号:自 KO 송장 번호 하한 PTB Número de NFF - Inferior RU Номер счета-фактуры с S Från fakturanummer TR Fatura Numarası Alt Değeri US Invoice Number Low ZHS 发票编号下限 8 60 :p_in_invoice_number_high LOV Oracle AR_INVOICE_NUMBER Y Y select ct.trx_number id, ct.trx_number value, null description from ra_customer_trx ct where ct.customer_trx_id in ( select max(ct2.customer_trx_id) from ra_customer_trx ct2 where ct.trx_number=ct2.trx_number) order by ct.trx_number,ct.customer_trx_id AR رقم فاتورة إلى D Bis Rechnungsnummer E A Número de Factura F Numéro de facture - A I Numero fattura (max) JA 請求書番号:至 KO 송장 번호 상한 PTB Número de NFF - Superior RU Номер счета-фактуры по S Till fakturanummer TR Fatura Numarası Üst Değeri US Invoice Number High ZHS 发票编号上限 9 70 :p_in_invoice_amount_low Number AR مبلغ فاتورة من D Von Rechnungsbetrag E De Importe de la Factura F Montant de facture - De I Importo fattura (min) JA 請求書金額:最小 KO 송장 금액 하한 PTB Quantia da NFF (Inferior) RU Сумма по счету-фактуре с S Från fakturabelopp TR Fatura Tutarı Alt Değeri US Invoice Amount Low ZHS 发票额下限 10 80 :p_in_invoice_amount_high Number AR مبلغ فاتورة إلى D Bis Rechnungsbetrag E A Importe de la Factura F Montant de facture - A I Importo fattura (max) JA 請求書金額:最大 KO 송장 금액 상한 PTB Quantia da NFF (Superior) RU Сумма по счету-фактуре по S Till fakturabelopp TR Fatura Tutarı Üst Değeri US Invoice Amount High ZHS 发票额上限 11 90 :p_in_balance_due_low Number AR رصيد مستحق من D Fälliger Mindestbetrag E De Saldo Pendiente F Solde dû - De I Saldo dovuto (min) JA 未回収残高:自 KO 미수 잔액 하한 PTB Saldo Devido (Inferior) RU Дебетовое сальдо с S Från resterande fordran TR Ödenecek Bakiye Alt Değeri US Balance Due Low ZHS 到期余额下限 12 100 :p_in_balance_due_high Number AR رصيد مستحق إلى D Fälliger Höchstbetrag E A Saldo Pendiente F Solde dû - A I Saldo dovuto (max) JA 未回収残高:至 KO 미수 잔액 상한 PTB Saldo Devido (Superior) RU Дебетовое сальдо по S Till resterande fordran TR Ödenecek Bakiye Üst Değeri US Balance Due High ZHS 到期余额上限 13 110 :p_in_trx_date_low Date AR تاريخ حركة من D Von Transaktionsdatum E De Fecha de Transacción F Date du mouvement - Du I Data transazione (min) JA 取引日:自 KO 거래 일자 하한 PTB Data da Transação - Inferior RU Дата транзакции с S Från transaktionsdatum TR İşlem Tarihi Alt Değeri US Transaction Date Low ZHS 事务处理日期下限 14 120 :p_in_trx_date_high Date AR تاريخ حركة إلى D Bis Transaktionsdatum E A Fecha de Transacción F Date du mouvement - Au I Data transazione (max) JA 取引日:至 KO 거래 일자 상한 PTB Data da Transação - Superior RU Дата транзакции по S Till transaktionsdatum TR İşlem Tarihi Üst Değeri US Transaction Date High ZHS 事务处理日期上限 15 130 :p_in_account_status_low LOV Oracle AR_ACCOUNT_STATUS Y select lookup_code id, lookup_code value, meaning description from ar_lookups where lookup_type='ACCOUNT_STATUS' order by meaning,lookup_code AR موقف الحساب من D Von Kontenstatus E De Estado de la Cuenta F Statut du compte - De I Stato conto (min) JA 勘定ステータス:自 KO 계정 상태 하한 PTB Status da Conta (Inferior) RU Статус счета с S Från kontostatus TR Hesap Statüsü Alt Değeri US Account Status Low ZHS 帐户状态下限 16 140 :p_in_account_status_high LOV Oracle AR_ACCOUNT_STATUS Y select lookup_code id, lookup_code value, meaning description from ar_lookups where lookup_type='ACCOUNT_STATUS' order by meaning,lookup_code AR موقف الحساب إلى D Bis Kontenstatus E A Estado de la Cuenta F Statut du compte - A I Stato conto (max) JA 勘定ステータス:至 KO 계정 상태 상한 PTB Status da Conta - Superior RU Статус счета по S Till kontostatus TR Hesap Statüsü Üst Değeri US Account Status High ZHS 帐户状态上限