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）限制的操作单元。 C6E085D4722651A9E05362FB09050512 SELECT hp.party_name C_VENDOR_NAME, v.segment1 C_VENDOR_NUMBER, decode(upper(:P_SORT_OPTION), 'VENDOR NAME',decode(:C_VENDOR_NAME_SELECT, '%',upper(hp.party_name), hp.party_name), i.invoice_type_lookup_code) C_PRIMARY_BRK, decode(upper(:P_SORT_OPTION), 'VENDOR NAME',decode(:C_VENDOR_NAME_SELECT, '%', decode(:SORT_BY_ALTERNATE, 'Y', upper(hp.organization_name_phonetic), upper(hp.party_name)), decode(:SORT_BY_ALTERNATE, 'Y', hp.organization_name_phonetic, hp.party_name)), i.invoice_type_lookup_code) C_PRIMARY_BRK_REAL, hp.party_name C_SHORT_VENDOR_NAME, v.vendor_id C_VENDOR_ID, i.vendor_site_id C_CONTACT_SITE_ID, vs.vendor_site_code C_VENDOR_SITE_CODE, decode(:SORT_BY_ALTERNATE, 'Y', vs.vendor_site_code_alt, vs.vendor_site_code) C_VENDOR_SITE_CODE_BRK, nvl(vs.state,' ') C_VENDOR_STATE, nvl(substr(vs.city,1,15),' ') C_VENDOR_CITY, ps.payment_num C_REFERENCE_NUMBER, i.vendor_site_id C_ADDRESS_ID, nvl(substr(i.invoice_type_lookup_code,1,20), ' ') C_INVOICE_TYPE, i.invoice_id C_PAYMENT_SCHED_ID, nvl(to_char(ps.due_date,'DD-MON-RR'),' ') C_DUE_DATE, decode(i.invoice_currency_code,:C_BASE_CURRENCY_CODE, decode(:C_BASE_MIN_ACCT_UNIT, 0,round(((nvl(ps.amount_remaining, 0)/(nvl(i.payment_cross_rate,1))) * nvl(i.exchange_rate,1)),:C_BASE_PRECISION), round(((nvl(ps.amount_remaining, 0)/(nvl(i.payment_cross_rate,1))) * nvl(i.exchange_rate,1))/:C_BASE_MIN_ACCT_UNIT) * :C_BASE_MIN_ACCT_UNIT), decode(i.exchange_rate,NULL,0, decode(:C_BASE_MIN_ACCT_UNIT, 0,round(((nvl(ps.amount_remaining, 0)/(nvl(i.payment_cross_rate,1))) * nvl(i.exchange_rate,1)),:C_BASE_PRECISION), round(((nvl(ps.amount_remaining, 0)/(nvl(i.payment_cross_rate,1))) * nvl(i.exchange_rate,1))/:C_BASE_MIN_ACCT_UNIT) * :C_BASE_MIN_ACCT_UNIT))) C_AMT_DUE_REMAINING, decode(i.invoice_currency_code,:C_BASE_CURRENCY_CODE, decode(:C_BASE_MIN_ACCT_UNIT, 0,round(((nvl(ps.gross_amount, 0)/(nvl(i.payment_cross_rate,1))) * nvl(i.exchange_rate,1)),:C_BASE_PRECISION), round(((nvl(ps.gross_amount, 0)/(nvl(i.payment_cross_rate,1))) * nvl(i.exchange_rate,1))/:C_BASE_MIN_ACCT_UNIT) * :C_BASE_MIN_ACCT_UNIT), decode(i.exchange_rate,NULL,0, decode(:C_BASE_MIN_ACCT_UNIT, 0,round(((nvl(ps.gross_amount, 0)/(nvl(i.payment_cross_rate,1))) * nvl(i.exchange_rate,1)),:C_BASE_PRECISION), round(((nvl(ps.gross_amount, 0)/(nvl(i.payment_cross_rate,1))) * nvl(i.exchange_rate,1))/:C_BASE_MIN_ACCT_UNIT) * :C_BASE_MIN_ACCT_UNIT))) C_AMT_DUE_ORIGINAL, i.accts_pay_code_combination_id C_VENDOR_TRX_ID, i.invoice_num C_INVOICE_NUMBER, i.invoice_num C_INVOICE_NUM_SHORT, to_char(i.invoice_date,'DD-MON-RR') C_INVOICE_DATE, ceil(to_date(to_char(SYSDATE,'DD-MON-RR'),'DD-MON-RR') - to_date(ps.due_date,'DD-MON-RR')) C_DAYS_PAST_DUE, decode(i.invoice_currency_code, :C_BASE_CURRENCY_CODE, ' ', decode(i.exchange_rate, NULL,'*', ' ')) C_DATA_CONVERTED, nvl(i.exchange_rate, 1) C_EXCHANGE_RATE, decode(:C_VENDOR_NAME_SELECT, '%',decode(:SORT_BY_ALTERNATE, 'Y', upper(hp.organization_name_phonetic), upper(hp.party_name)), decode(:SORT_BY_ALTERNATE, 'Y', hp.organization_name_phonetic, hp.party_name)) C_VENDOR_NAME_BRK, AP_APXINAGE_XMLP_PKG.c_per_inv_due_amt_1formula(:C_SUM_INV_DUE_AMT_1, :C_SUM_AMT_REMAINING) C_PER_INV_DUE_AMT_1, AP_APXINAGE_XMLP_PKG.c_pgbrk_data_convertedformula(:C_SUM_DATA_CONVERTED) C_PGBRK_DATA_CONVERTED, AP_APXINAGE_XMLP_PKG.c_per_inv_due_amt_2formula(:C_SUM_INV_DUE_AMT_2, :C_SUM_AMT_REMAINING) C_PER_INV_DUE_AMT_2, AP_APXINAGE_XMLP_PKG.c_per_inv_due_amt_3formula(:C_SUM_INV_DUE_AMT_3, :C_SUM_AMT_REMAINING) C_PER_INV_DUE_AMT_3, AP_APXINAGE_XMLP_PKG.c_per_inv_due_amt_4formula(:C_SUM_INV_DUE_AMT_4, :C_SUM_AMT_REMAINING) C_PER_INV_DUE_AMT_4, AP_APXINAGE_XMLP_PKG.c_per_v_inv_amt_1formula(:C_SUM_V_INV_AMT_1, :C_SUM_V_DUE_REMAINING) C_PER_V_INV_AMT_1, AP_APXINAGE_XMLP_PKG.c_per_v_inv_amt_2formula(:C_SUM_V_INV_AMT_2, :C_SUM_V_DUE_REMAINING) C_PER_V_INV_AMT_2, AP_APXINAGE_XMLP_PKG.c_per_v_inv_amt_3formula(:C_SUM_V_INV_AMT_3, :C_SUM_V_DUE_REMAINING) C_PER_V_INV_AMT_3, AP_APXINAGE_XMLP_PKG.c_per_v_inv_amt_4formula(:C_SUM_V_INV_AMT_4, :C_SUM_V_DUE_REMAINING) C_PER_V_INV_AMT_4, AP_APXINAGE_XMLP_PKG.c_v_data_convertedformula(:C_SUM_V_DATA_CONVERTED) C_V_DATA_CONVERTED, AP_APXINAGE_XMLP_PKG.c_contact_lineformula(i.vendor_site_id) C_CONTACT_LINE, AP_APXINAGE_XMLP_PKG.c_percent_remainingformula(decode ( i.invoice_currency_code , :C_BASE_CURRENCY_CODE , decode ( :C_BASE_MIN_ACCT_UNIT , 0 , round ( ( ( nvl ( ps.gross_amount , 0 ) / ( nvl ( i.payment_cross_rate , 1 ) ) ) * nvl ( i.exchange_rate , 1 ) ) , :C_BASE_PRECISION ) , round ( ( ( nvl ( ps.gross_amount , 0 ) / ( nvl ( i.payment_cross_rate , 1 ) ) ) * nvl ( i.exchange_rate , 1 ) ) / :C_BASE_MIN_ACCT_UNIT ) * :C_BASE_MIN_ACCT_UNIT ) , decode ( i.exchange_rate , NULL , 0 , decode ( :C_BASE_MIN_ACCT_UNIT , 0 , round ( ( ( nvl ( ps.gross_amount , 0 ) / ( nvl ( i.payment_cross_rate , 1 ) ) ) * nvl ( i.exchange_rate , 1 ) ) , :C_BASE_PRECISION ) , round ( ( ( nvl ( ps.gross_amount , 0 ) / ( nvl ( i.payment_cross_rate , 1 ) ) ) * nvl ( i.exchange_rate , 1 ) ) / :C_BASE_MIN_ACCT_UNIT ) * :C_BASE_MIN_ACCT_UNIT ) ) ), decode ( i.invoice_currency_code , :C_BASE_CURRENCY_CODE , decode ( :C_BASE_MIN_ACCT_UNIT , 0 , round ( ( ( nvl ( ps.amount_remaining , 0 ) / ( nvl ( i.payment_cross_rate , 1 ) ) ) * nvl ( i.exchange_rate , 1 ) ) , :C_BASE_PRECISION ) , round ( ( ( nvl ( ps.amount_remaining , 0 ) / ( nvl ( i.payment_cross_rate , 1 ) ) ) * nvl ( i.exchange_rate , 1 ) ) / :C_BASE_MIN_ACCT_UNIT ) * :C_BASE_MIN_ACCT_UNIT ) , decode ( i.exchange_rate , NULL , 0 , decode ( :C_BASE_MIN_ACCT_UNIT , 0 , round ( ( ( nvl ( ps.amount_remaining , 0 ) / ( nvl ( i.payment_cross_rate , 1 ) ) ) * nvl ( i.exchange_rate , 1 ) ) , :C_BASE_PRECISION ) , round ( ( ( nvl ( ps.amount_remaining , 0 ) / ( nvl ( i.payment_cross_rate , 1 ) ) ) * nvl ( i.exchange_rate , 1 ) ) / :C_BASE_MIN_ACCT_UNIT ) * :C_BASE_MIN_ACCT_UNIT ) ) )) C_PERCENT_REMAINING, AP_APXINAGE_XMLP_PKG.c_inv_due_amt_1formula(ceil ( to_date ( to_char ( SYSDATE , 'DD-MON-RR' ) , 'DD-MON-RR' ) - ps.due_date ), decode ( i.invoice_currency_code , :C_BASE_CURRENCY_CODE , decode ( :C_BASE_MIN_ACCT_UNIT , 0 , round ( ( ( nvl ( ps.amount_remaining , 0 ) / ( nvl ( i.payment_cross_rate , 1 ) ) ) * nvl ( i.exchange_rate , 1 ) ) , :C_BASE_PRECISION ) , round ( ( ( nvl ( ps.amount_remaining , 0 ) / ( nvl ( i.payment_cross_rate , 1 ) ) ) * nvl ( i.exchange_rate , 1 ) ) / :C_BASE_MIN_ACCT_UNIT ) * :C_BASE_MIN_ACCT_UNIT ) , decode ( i.exchange_rate , NULL , 0 , decode ( :C_BASE_MIN_ACCT_UNIT , 0 , round ( ( ( nvl ( ps.amount_remaining , 0 ) / ( nvl ( i.payment_cross_rate , 1 ) ) ) * nvl ( i.exchange_rate , 1 ) ) , :C_BASE_PRECISION ) , round ( ( ( nvl ( ps.amount_remaining , 0 ) / ( nvl ( i.payment_cross_rate , 1 ) ) ) * nvl ( i.exchange_rate , 1 ) ) / :C_BASE_MIN_ACCT_UNIT ) * :C_BASE_MIN_ACCT_UNIT ) ) )) C_INV_DUE_AMT_1, AP_APXINAGE_XMLP_PKG.c_inv_due_amt_2formula(ceil ( to_date ( to_char ( SYSDATE , 'DD-MON-RR' ) , 'DD-MON-RR' ) - ps.due_date ), decode ( i.invoice_currency_code , :C_BASE_CURRENCY_CODE , decode ( :C_BASE_MIN_ACCT_UNIT , 0 , round ( ( ( nvl ( ps.amount_remaining , 0 ) / ( nvl ( i.payment_cross_rate , 1 ) ) ) * nvl ( i.exchange_rate , 1 ) ) , :C_BASE_PRECISION ) , round ( ( ( nvl ( ps.amount_remaining , 0 ) / ( nvl ( i.payment_cross_rate , 1 ) ) ) * nvl ( i.exchange_rate , 1 ) ) / :C_BASE_MIN_ACCT_UNIT ) * :C_BASE_MIN_ACCT_UNIT ) , decode ( i.exchange_rate , NULL , 0 , decode ( :C_BASE_MIN_ACCT_UNIT , 0 , round ( ( ( nvl ( ps.amount_remaining , 0 ) / ( nvl ( i.payment_cross_rate , 1 ) ) ) * nvl ( i.exchange_rate , 1 ) ) , :C_BASE_PRECISION ) , round ( ( ( nvl ( ps.amount_remaining , 0 ) / ( nvl ( i.payment_cross_rate , 1 ) ) ) * nvl ( i.exchange_rate , 1 ) ) / :C_BASE_MIN_ACCT_UNIT ) * :C_BASE_MIN_ACCT_UNIT ) ) )) C_INV_DUE_AMT_2, AP_APXINAGE_XMLP_PKG.c_inv_due_amt_3formula(ceil ( to_date ( to_char ( SYSDATE , 'DD-MON-RR' ) , 'DD-MON-RR' ) - ps.due_date ), decode ( i.invoice_currency_code , :C_BASE_CURRENCY_CODE , decode ( :C_BASE_MIN_ACCT_UNIT , 0 , round ( ( ( nvl ( ps.amount_remaining , 0 ) / ( nvl ( i.payment_cross_rate , 1 ) ) ) * nvl ( i.exchange_rate , 1 ) ) , :C_BASE_PRECISION ) , round ( ( ( nvl ( ps.amount_remaining , 0 ) / ( nvl ( i.payment_cross_rate , 1 ) ) ) * nvl ( i.exchange_rate , 1 ) ) / :C_BASE_MIN_ACCT_UNIT ) * :C_BASE_MIN_ACCT_UNIT ) , decode ( i.exchange_rate , NULL , 0 , decode ( :C_BASE_MIN_ACCT_UNIT , 0 , round ( ( ( nvl ( ps.amount_remaining , 0 ) / ( nvl ( i.payment_cross_rate , 1 ) ) ) * nvl ( i.exchange_rate , 1 ) ) , :C_BASE_PRECISION ) , round ( ( ( nvl ( ps.amount_remaining , 0 ) / ( nvl ( i.payment_cross_rate , 1 ) ) ) * nvl ( i.exchange_rate , 1 ) ) / :C_BASE_MIN_ACCT_UNIT ) * :C_BASE_MIN_ACCT_UNIT ) ) )) C_INV_DUE_AMT_3, AP_APXINAGE_XMLP_PKG.c_inv_due_amt_4formula(ceil ( to_date ( to_char ( SYSDATE , 'DD-MON-RR' ) , 'DD-MON-RR' ) - ps.due_date ), decode ( i.invoice_currency_code , :C_BASE_CURRENCY_CODE , decode ( :C_BASE_MIN_ACCT_UNIT , 0 , round ( ( ( nvl ( ps.amount_remaining , 0 ) / ( nvl ( i.payment_cross_rate , 1 ) ) ) * nvl ( i.exchange_rate , 1 ) ) , :C_BASE_PRECISION ) , round ( ( ( nvl ( ps.amount_remaining , 0 ) / ( nvl ( i.payment_cross_rate , 1 ) ) ) * nvl ( i.exchange_rate , 1 ) ) / :C_BASE_MIN_ACCT_UNIT ) * :C_BASE_MIN_ACCT_UNIT ) , decode ( i.exchange_rate , NULL , 0 , decode ( :C_BASE_MIN_ACCT_UNIT , 0 , round ( ( ( nvl ( ps.amount_remaining , 0 ) / ( nvl ( i.payment_cross_rate , 1 ) ) ) * nvl ( i.exchange_rate , 1 ) ) , :C_BASE_PRECISION ) , round ( ( ( nvl ( ps.amount_remaining , 0 ) / ( nvl ( i.payment_cross_rate , 1 ) ) ) * nvl ( i.exchange_rate , 1 ) ) / :C_BASE_MIN_ACCT_UNIT ) * :C_BASE_MIN_ACCT_UNIT ) ) )) C_INV_DUE_AMT_4, AP_APXINAGE_XMLP_PKG.c_check_data_convertedformula(decode ( i.invoice_currency_code , :C_BASE_CURRENCY_CODE , ' ' , decode ( i.exchange_rate , NULL , '*' , ' ' ) )) C_CHECK_DATA_CONVERTED FROM ap_payment_schedules ps, ap_invoices i, hz_parties hp, ap_suppliers v, po_vendor_sites vs WHERE i.invoice_id = ps.invoice_id AND i.party_id = hp.party_id AND hp.party_id = v.party_id (+) AND i.vendor_site_id = vs.vendor_site_id (+) &P_PARTY_PREDICATE AND ((to_date(to_char(SYSDATE,'DD-MON-RR'),'DD-MON-RR') - ps.due_date) between :C_MINDAYS and :C_MAXDAYS) AND i.invoice_type_lookup_code like :C_INVOICE_TYPE_SELECT AND i.cancelled_date IS NULL AND (nvl(ps.amount_remaining, 0) * nvl(i.exchange_rate,1)) != 0 &P_AMOUNT_PREDICATE AND i.payment_status_flag in ('N','P') &P_ORDER_BY Y SQLAP APXINAGE_XML AR AP تقرير تقادم الفواتير (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Imported from BI Publisher Description: تقرير تقادم الفواتير Application: المدفوعات Source: تقرير تقادم الفواتير (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: APXINAGE_XML DB package: AP_APXINAGE_XMLP_PKG D AP Rechnungsfälligkeiten- Nicht unterstützt: Reserviert für zukünftige Verwendung Imported from BI Publisher Description: Rechnungsfälligkeiten Application: Kreditoren Source: Rechnungsfälligkeiten (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: APXINAGE_XML DB package: AP_APXINAGE_XMLP_PKG E AP Informe Facturas por Antigüedad: No Admitido, Reservado para Uso Futuro Imported from BI Publisher Description: Informe de facturas por antigüedad Application: Payables Source: Informe Facturas por Antigüedad (XML): No Admitido, Reservado para Uso Futuro Short Name: APXINAGE_XML DB package: AP_APXINAGE_XMLP_PKG F AP Balance âgée fournisseurs- Non pris en charge : réservé pour une utilisation future Imported from BI Publisher Description: Balance âgée fournisseurs Application: Payables Source: Balance âgée fournisseurs (XML) - Non pris en charge : réservé pour une utilisation future Short Name: APXINAGE_XML DB package: AP_APXINAGE_XMLP_PKG I AP Rapporto Scadenzario fatture- non supportato: riservato per usi futuri Imported from BI Publisher Description: Rapporto Scadenzario fatture Application: Payables Source: Rapporto Scadenzario fatture (XML) - non supportato: riservato per usi futuri Short Name: APXINAGE_XML DB package: AP_APXINAGE_XMLP_PKG JA AP 請求書年齢調べレポート- 未サポート: 将来の使用のために予約 Imported from BI Publisher Description: 請求書年齢調べレポート Application: Payables Source: 請求書年齢調べレポート(XML) - 未サポート: 将来の使用のために予約 Short Name: APXINAGE_XML DB package: AP_APXINAGE_XMLP_PKG KO AP 송장 연체 보고서- 지원되지 않음: 추후 사용을 위해 예약됨 Imported from BI Publisher Description: 송장 연체 보고서 Application: Payables Source: 송장 연체 보고서(XML) - 지원되지 않음: 추후 사용을 위해 예약됨 Short Name: APXINAGE_XML DB package: AP_APXINAGE_XMLP_PKG PTB AP Relatório de Vencimento da NFF- Não Suportado: Reservado Para Uso Futuro Imported from BI Publisher Description: Relatório de Aging da NFF Application: Payables Source: Relatório de Vencimento da NFF (XML) - Não Suportado: Reservado Para Uso Futuro Short Name: APXINAGE_XML DB package: AP_APXINAGE_XMLP_PKG RU AP Отчет о временном распределении счетов-фактур- не поддерживается: зарезервировано для будущего использования Imported from BI Publisher Description: Отчет о временном распределении счетов-фактур Application: Кредиторы Source: Отчет о временном распределении счетов-фактур (XML) - не поддерживается: зарезервировано для будущего использования Short Name: APXINAGE_XML DB package: AP_APXINAGE_XMLP_PKG S AP Åldersanalys - rapport- Stöds inte: Reserverad för framtida bruk Imported from BI Publisher Description: Fakturor: Åldersanalys - rapport Application: Payables Source: Fakturor: Åldersanalys - rapport (XML) - Stöds inte: Reserverad för framtida bruk Short Name: APXINAGE_XML DB package: AP_APXINAGE_XMLP_PKG TR AP Fatura Yaşlandırma Raporu- Desteklenmez: Gelecekte Kullanım İçin Ayrılmıştır Imported from BI Publisher Description: Fatura Yaşlandırma Raporu Application: Borçlar Muhasebesi Source: Fatura Yaşlandırma Raporu (XML) - Desteklenmez: Gelecekte Kullanım İçin Ayrılmıştır Short Name: APXINAGE_XML DB package: AP_APXINAGE_XMLP_PKG US AP Invoice Aging Report- Not Supported: Reserved For Future Use Imported from BI Publisher Description: Invoice Aging Report Application: Payables Source: Invoice Aging Report (XML) - Not Supported: Reserved For Future Use Short Name: APXINAGE_XML DB package: AP_APXINAGE_XMLP_PKG ZHS AP 发票帐龄报表- 不支持：已保留供将来使用 Imported from BI Publisher Description: 发票帐龄报表 Application: 应付帐款 Source: 发票帐龄报表 (XML) - 不支持：已保留供将来使用 Short Name: APXINAGE_XML DB package: AP_APXINAGE_XMLP_PKG BI Publisher &p_amount_predicate &p_order_by &p_party_predicate :c_base_currency_code :c_base_description :c_base_min_acct_unit :c_base_precision :c_chart_of_accounts_id :c_company_name_header :c_head_format_option :c_head_invoice_type :c_head_sort_option :c_head_summary_option :c_head_vendor_name :c_inv_due_1_head_1 :c_inv_due_1_head_2 :c_inv_due_1_range_fr :c_inv_due_1_range_to :c_inv_due_2_head_1 :c_inv_due_2_head_2 :c_inv_due_2_range_fr :c_inv_due_2_range_to :c_inv_due_3_head_1 :c_inv_due_3_head_2 :c_inv_due_3_range_fr :c_inv_due_3_range_to :c_inv_due_4_head_1 :c_inv_due_4_head_2 :c_inv_due_4_range_fr :c_inv_due_4_range_to :c_invoice_type_select :c_maxdays :c_mindays :c_nls_all :c_nls_end_of_report :c_nls_no :c_nls_no_data_exists :c_nls_yes :c_rep_data_converted :c_report_run_time :c_report_start_date :c_sum_amt_remaining :c_sum_data_converted :c_sum_inv_due_amt_1 :c_sum_inv_due_amt_2 :c_sum_inv_due_amt_3 :c_sum_inv_due_amt_4 :c_sum_v_data_converted :c_sum_v_due_remaining :c_sum_v_inv_amt_1 :c_sum_v_inv_amt_2 :c_sum_v_inv_amt_3 :c_sum_v_inv_amt_4 :c_vendor_name_select :operating_unit :p_amount_due_high :p_amount_due_low :p_amount_predicate :p_amt_due_high :p_amt_due_low :p_conc_request_id :p_debug_switch :p_flexdata :p_format_option :p_format_option_upper :p_invoice_type :p_min_precision :p_order_by :p_party_id :p_party_predicate :p_period_type :p_set_of_books_id :p_sort_option :p_sort_option_upper :p_summary_option :p_trace_switch :sort_by_alternate 1 -30 :p_set_of_books_id Char fnd_profile.value('GL_SET_OF_BKS_ID') AR دفتر الأستاذ معرف دفتر الأستاذ D Buch Buchkennung E Libro Mayor Identificador de libro mayor F Livre ID livre I Libro contabile Id del libro contabile JA 元帳 元帳ID KO 원장 원장 ID PTB Razão Id do Razão RU Книга Идентификатор книги S Huvudbok Huvudboks-id TR Defter Defter No US Ledger_id Ledger Id ZHS 分类帐 分类帐标识 2 -20 :p_trace_switch LOV Oracle AP_SRS_YES_NO_OPT Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' order by value,description select meaning from fnd_lookups where lookup_type = 'YES_NO' and lookup_code = 'N' AR تحويل التتبع تحويل التتبع D Trace-Schalter Trace-Schalter E Conmutador de Rastreo conmutador de rastreo F Activer analyse Activer analyse I Parametro di individuazione Parametro di individuazione JA トレース切替 トレース・切替 KO 추적 전환 추적 전환 PTB Chave de Rastreamento chave de rastreamento RU Ключ трассировки Ключ трассировки S Spårningsväxel spårningsväxel TR İzlemeyi Değiştir izlemeyi değiştirir US Trace Switch trace switch ZHS 跟踪开关 跟踪开关 3 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 4 10 :p_sort_option LOV Oracle AP_SRS_AGING_ORDER Y select lookup_code id, displayed_field value, null description from ap_lookup_codes where nvl(inactive_date,sysdate+1)>sysdate and lookup_type='AGING_SORT_OPTION' order by value,description select displayed_field from ap_lookup_codes where lookup_type = 'AGING_SORT_OPTION' and lookup_code = 'Vendor Name' Y AR فرز الفواتير بواسطة فرز الفواتير بواسطة D Rechnungen sortieren nach Rechnungen sortieren nach E Ordenar Facturas Por ordenar facturas por F Trier factures par Trier factures par I Ordina fatture per Ordina fatture per JA 請求書のソート 請求書のソート KO 송장 정렬 기준 송장 정렬 기준 PTB Classificar NFFs Por classificar NFFs por RU Сортировка счетов-фактур Сортировка счетов-фактур S Sortera fakturor efter sortera fakturor efter TR Fatura Sıralama Bazı faturaları sıralama bazı US Sort Invoices By sort invoices by ZHS 发票排序依据 发票排序依据 5 20 :p_summary_option LOV Oracle AP_SRS_YES_NO_OPT Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' order by value,description select meaning from fnd_lookups where lookup_code='N' and lookup_type='YES_NO' Y AR تضمين تفاصيل الفاتورة تضمين تفاصيل الفاتورة (نوع الإجمالي) D Mit Rechnungsdetails Mit Rechnungsdetails (Übersichtsart) E Incluir Detalles de Factura Incluir Detalles de Factura (Tipo de Resumen) F Inclure les détails des factures Inclure les détails des factures (type de synthèse) I Includi dettagli fattura Includi dettagli fattura (tipo sintetico) JA 請求書詳細を含む 請求書詳細を含む (要約タイプ) KO 송장 상세내역 포함 송장 상세내역 포함 (요약 유형) PTB Incluir Detalhe da NFF Incluir Detalhe da NFF (tipo de sumário) RU Включить сведения о счетах-фактурах Включить сведения о счетах-фактурах (тип сводки) S Inkludera fakturainformation Inkludera fakturainformation (översiktlig) TR Fatura Detayını Dahil Et Fatura Detayını Dahil Eder (özet tipi) US Include Invoice Detail Include Invoice Detail (summary type) ZHS 包括发票详细信息 包括发票详细信息（汇总类型） 6 30 :p_format_option LOV Oracle AP_SRS_YES_NO_OPT Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' order by value,description select meaning from fnd_lookups where lookup_code='N' and lookup_type='YES_NO' Y AR تضمين تفاصيل الموقع تضمين تفاصيل الموقع D Mit Adressdetails Mit Adressdetails E Incluir Detalles de Ubicación Incluir Detalles de Ubicación F Inclure les détails des sites Inclure les détails des sites I Includi dettagli sede Includi dettagli sede JA サイト詳細を含む サイト詳細を含む KO 지점 상세내역 포함 지점 상세내역 포함 PTB Incluir Detalhe do Local Incluir Detalhe do Local RU Включить сведения об отделениях Включить сведения об отделениях S Inkludera ortsinformation Inkludera ortsinformation TR İşletme Birimi Detayını Dahil Et İşletme Birimi Detayını Dahil Et US Include Site Detail Include Site Detail ZHS 包括地点详细信息 包括地点详细信息 7 40 :p_amount_due_low Number AR الحد الأدنى لمبلغ الاستحقاق الحد الأدنى لمبلغ الاستحقاق D Fälliger Mindestbetrag Fälliger Mindestbetrag E Importe Pendiente Mínimo Importe Pendiente Mínimo F Solde minimum Solde minimum I Importo minimo dovuto Importo minimo dovuto JA 最小支払額 最小支払額 KO 최소 만기 금액 최소 만기 금액 PTB Quantia Mínima Devida Quantia mínima devida RU Минимальная причитающаяся сумма Минимальная причитающаяся сумма S Minsta belopp att betala Minsta belopp att betala TR Minimum Ödenecek Tutar Minimum ödenecek tutar US Minimum Amount Due Minimum amount due ZHS 最小到期额 最小到期额 8 50 :p_amount_due_high Number AR الحد الأقصى لمبلغ الاستحقاق الحد الأقصى لمبلغ الاستحقاق D Fälliger Höchstbetrag Fälliger Höchstbetrag E Importe Pendiente Máximo Importe Pendiente Máximo F Solde maximum Solde maximum I Importo massimo dovuto Importo massimo dovuto JA 最大支払額 最大支払額 KO 최대 만기 금액 최대 만기 금액 PTB Quantia Máxima Devida Quantia máxima devida RU Максимальная причитающаяся сумма Максимальная причитающаяся сумма S Högsta belopp att betala Högsta belopp att betala TR Maksimum Ödenecek Tutar Maksimum ödenecek tutar US Maximum Amount Due Maximum amount due ZHS 最大到期额 最大到期额 9 60 :p_invoice_type LOV Oracle AP_SRS_INVOICE_TYPE Y select lookup_code id, displayed_field value, null description from ap_lookup_codes where nvl(inactive_date,sysdate+1)>sysdate and lookup_type='INVOICE TYPE' and lookup_code not in ('QUICKMATCH','QUICKDEFAULT') order by value,description AR نوع الفاتورة نوع الفاتورة D Rechnungsart Rechnungsart E Tipo de Factura Tipo de Factura F Type de facture Type de facture I Tipo di fattura Tipo di fattura JA 請求書タイプ 請求書タイプ KO 송장 유형 송장 유형 PTB Tipo de NFF tipo de NFF RU Тип счета-фактуры тип счета-фактуры S Fakturatyp fakturatyp TR Fatura Tipi fatura tipi US Invoice Type invoice type ZHS 发票类型 发票类型 10 70 :p_party_id LOV Oracle AP_SRS_PARTY_NAME Y select party_id id, party_name value, null description from hz_parties hp where exists (select 'Payee Party' from iby_external_payees_v ibp where ibp.payee_party_id=hp.party_id and payment_function in ('PAYABLES_DISB','EMPLOYEE_EXP','LOANS_PAYMENTS','AR_CUSTOMER_REFUNDS')) order by value,description AR الشريك التجاري الشريك التجاري D Geschäftspartner Geschäftspartner E Partner Comercial Partner comercial F Partenaire commercial Partenaire commercial I Partner commerciale Partner commerciale JA 取引先 取引先 KO 거래처 거래처 PTB Parceiro Comercial parceiro comercial RU Торговый партнер Торговый партнер S Handelspartner handelspartner TR Ticari Ortak ticari ortak US Trading Partner trading partner ZHS 贸易伙伴 贸易伙伴 11 80 :p_period_type LOV Oracle AP_SRS_AGING_PERIOD_TYPE Y select period_name id, period_name value, description description from ap_aging_periods where status='A' order by upper(period_name) Y AR اسم فترة التقادم اسم فترة التقادم D Bezeichnung Fälligkeitsperiode Bezeichnung Fälligkeitsperiode E Nombre de Período de Antigüedad Nombre de Período de Antigüedad F Nom de période de balance âgée Nom de période de balance âgée I Nome periodo scadenzario Nome periodo scadenzario JA 年齢調べ期間名 年齢調べ期間名 KO 월령 기간명 월령 기간명 PTB Nome do Período de Aging nome do período de aging RU Имя периода распределения Имя периода распределения S Namn på åldersfördelningsperiod namn på åldersfördelningsperiod TR Yaşlandırma Dönemi Adı yaşlandırma dönemi adı US Aging Period Name aging period name ZHS 帐龄期间名称 帐龄期间名称