ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4722051A9E05362FB09050512 SELECT decode(asp.SORT_BY_ALTERNATE_FIELD, 'Y', (nvl((UPPER(v.vendor_name_alt)), (UPPER(v.vendor_name)))), UPPER(v.vendor_name)) upp_vend_name_pmt, v.segment1 vendor_num_pmt, ac.check_number pmt_num, ac.check_date pmt_date, ac.currency_code pmt_curr, ac.amount pmt_amt, alc.displayed_field exception_pmt, ac.check_id pmt_id, v.vendor_name vendor_name_pmt, fc.precision precision FROM ap_checks_all ac, po_vendors v, ap_lookup_codes alc, ap_system_parameters_all asp, fnd_currencies fc WHERE ac.vendor_id = v.vendor_id AND ac.check_id in (select aip.check_id from ap_invoice_payments_all aip, ap_system_parameters_all asp, &C_ORG_FROM_TABLES where nvl(asp.org_id, -99) = nvl(aip.org_id, -99) and asp.recon_accounting_flag = 'N' and nvl(asp.when_to_account_pmt, 'ALWAYS') = 'ALWAYS' and aip.posted_flag IN ('N','S') &C_DATE_FILTER_PAY &C_AIP_MULTI_ORG_WHERE &P_AIP_ORG_WHERE) AND alc.lookup_type = 'NLS TRANSLATION' AND alc.lookup_code = decode(ac.currency_code, :c_base_currency_code, 'UNACCOUNTED', decode(ac.exchange_rate, null,'NO RATE', 'UNACCOUNTED')) AND asp.org_id = ac.org_id AND asp.base_currency_code = fc.currency_code UNION SELECT decode(asp.SORT_BY_ALTERNATE_FIELD, 'Y', (nvl((UPPER(v.vendor_name_alt)), (UPPER(v.vendor_name)))), UPPER(v.vendor_name)) upp_vend_name_pmt, v.segment1 vendor_num_pmt, ac.check_number pmt_num, ac.check_date pmt_date, ac.currency_code pmt_curr, ac.amount pmt_amt, alc.displayed_field exception_pmt, ac.check_id pmt_id, v.vendor_name vendor_name_pmt, fc.precision precision FROM ap_checks_all ac, po_vendors v, ap_lookup_codes alc, ap_system_parameters_all asp, fnd_currencies fc WHERE ac.vendor_id = v.vendor_id AND (NVL(:P_SWEEP_NOW_1, 'N') = 'Y' OR NVL(:P_UNACCT_RPT, 'Y') = 'Y') AND ac.check_id in (select aph.check_id from ap_payment_history_all aph, ap_system_parameters_all asp, &C_ORG_FROM_TABLES where nvl(asp.org_id, -99) = nvl(aph.org_id, -99) and aph.posted_flag IN ('N','S') and asp.recon_accounting_flag = 'Y' and aph.transaction_type IN ('PAYMENT CLEARING', 'PAYMENT UNCLEARING') and nvl(asp.when_to_account_pmt, 'ALWAYS') = 'CLEARING ONLY' &C_DATE_FILTER_PAYHIST &C_APH_MULTI_ORG_WHERE &P_APH_ORG_WHERE) AND alc.lookup_type = 'NLS TRANSLATION' AND alc.lookup_code = decode(ac.currency_code, :c_base_currency_code, 'UNACCOUNTED', decode(ac.exchange_rate, null,'NO RATE', 'UNACCOUNTED')) AND asp.org_id = ac.org_id AND asp.base_currency_code = fc.currency_code UNION SELECT decode(asp.SORT_BY_ALTERNATE_FIELD, 'Y', (nvl((UPPER(v.vendor_name_alt)), (UPPER(v.vendor_name)))), UPPER(v.vendor_name)) upp_vend_name_pmt, v.segment1 vendor_num_pmt, ac.check_number pmt_num, ac.check_date pmt_date, ac.currency_code pmt_curr, ac.amount pmt_amt, alc.displayed_field exception_pmt, ac.check_id pmt_id, v.vendor_name vendor_name_pmt, fc.precision precision FROM ap_checks_all ac, po_vendors v, ap_lookup_codes alc, ap_system_parameters_all asp, fnd_currencies fc WHERE ac.vendor_id = v.vendor_id AND (NVL(:P_SWEEP_NOW_1, 'N') = 'Y' OR NVL(:P_UNACCT_RPT, 'Y') = 'Y') AND ac.check_id in (select aip.check_id from ap_invoice_payments_all aip, ap_system_parameters_all asp, &C_ORG_FROM_TABLES where nvl(asp.org_id, -99) = nvl(aip.org_id, -99) and asp.recon_accounting_flag = 'Y' and nvl(asp.when_to_account_pmt, 'ALWAYS') = 'ALWAYS' and aip.posted_flag IN ('N','S') &C_DATE_FILTER_PAY &C_AIP_MULTI_ORG_WHERE &P_AIP_ORG_WHERE) AND alc.lookup_type = 'NLS TRANSLATION' AND alc.lookup_code = decode(ac.currency_code, :c_base_currency_code, 'UNACCOUNTED', decode(ac.exchange_rate, null,'NO RATE', 'UNACCOUNTED')) AND asp.org_id = ac.org_id AND asp.base_currency_code = fc.currency_code UNION SELECT decode(asp.SORT_BY_ALTERNATE_FIELD, 'Y', (nvl((UPPER(v.vendor_name_alt)), (UPPER(v.vendor_name)))), UPPER(v.vendor_name)) upp_vend_name_pmt, v.segment1 vendor_num_pmt, ac.check_number pmt_num, ac.check_date pmt_date, ac.currency_code pmt_curr, ac.amount pmt_amt, alc.displayed_field exception_pmt, ac.check_id pmt_id, v.vendor_name vendor_name_pmt, fc.precision precision FROM ap_checks_all ac, po_vendors v, ap_lookup_codes alc, ap_system_parameters_all asp, fnd_currencies fc WHERE ac.vendor_id = v.vendor_id AND (NVL(:P_SWEEP_NOW_1, 'N') = 'Y' OR NVL(:P_UNACCT_RPT, 'Y') = 'Y') AND ac.check_id in (select aph.check_id from ap_payment_history_all aph, ap_system_parameters_all asp, &C_ORG_FROM_TABLES where nvl(asp.org_id, -99) = nvl(aph.org_id, -99) and aph.posted_flag IN ('N','S') and asp.recon_accounting_flag = 'Y' and nvl(asp.when_to_account_pmt, 'ALWAYS') = 'ALWAYS' &C_DATE_FILTER_PAYHIST &C_APH_MULTI_ORG_WHERE &P_APH_ORG_WHERE) AND alc.lookup_type = 'NLS TRANSLATION' AND alc.lookup_code = decode(ac.currency_code, :c_base_currency_code, 'UNACCOUNTED', decode(ac.exchange_rate, null,'NO RATE', 'UNACCOUNTED')) AND asp.org_id = ac.org_id AND asp.base_currency_code = fc.currency_code ORDER BY 7, 1, 4, 3 Y SQLAP APXCLEXP_XML AR AP تقرير استثناءات إقفال الفترة (بتنسيق XML) - حذف - غير مدعم: محجوز للاستخدام الآجل Imported from BI Publisher Description: تقرير استثناءات إقفال الفترة Application: المدفوعات Source: تقرير استثناءات إقفال الفترة (بتنسيق XML) - حذف - غير مدعم: محجوز للاستخدام الآجل Short Name: APXCLEXP_XML DB package: AP_APXTRSWP_XMLP_PKG D AP Periodenabschluss - Unstimmigkeiten- Löschen - Nicht unterstützt: Reserviert für zukünftige Verwendung Imported from BI Publisher Description: Auswertung "Periodenabschluss - Unstimmigkeiten" Application: Kreditoren Source: Periodenabschluss - Unstimmigkeiten (XML) - Löschen - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: APXCLEXP_XML DB package: AP_APXTRSWP_XMLP_PKG E AP Informe Excepciones de Cierre de Período- Eliminar: No Admitido, Reservado para Uso Futuro Imported from BI Publisher Description: Informe de excepciones de cierre de período Application: Payables Source: Informe Excepciones de Cierre de Período (XML) - Eliminar: No Admitido, Reservado para Uso Futuro Short Name: APXCLEXP_XML DB package: AP_APXTRSWP_XMLP_PKG F AP Etat des exceptions de clôture de période- Supprimer - Non pris en charge : réservé pour une utilisation future Imported from BI Publisher Description: Etat des exceptions de clôture de période Application: Payables Source: Etat des exceptions de clôture de période (XML) - Supprimer - Non pris en charge : réservé pour une utilisation future Short Name: APXCLEXP_XML DB package: AP_APXTRSWP_XMLP_PKG I AP Rapporto Eccezioni chiusura periodo- Elimina - non supportato: riservato per usi futuri Imported from BI Publisher Description: Rapporto Eccezioni chiusura periodo Application: Payables Source: Rapporto Eccezioni chiusura periodo (XML) - Elimina - non supportato: riservato per usi futuri Short Name: APXCLEXP_XML DB package: AP_APXTRSWP_XMLP_PKG JA AP 期間クローズ例外レポート- 削除 - 未サポート: 将来の使用のために予約 Imported from BI Publisher Description: 期間クローズ例外レポート Application: Payables Source: 期間クローズ例外レポート(XML) - 削除 - 未サポート: 将来の使用のために予約 Short Name: APXCLEXP_XML DB package: AP_APXTRSWP_XMLP_PKG KO AP 기간 마감 예외 보고서- 삭제 - 지원되지 않음: 추후 사용을 위해 예약됨 Imported from BI Publisher Description: 기간 마감 예외 보고서 Application: Payables Source: 기간 마감 예외 보고서(XML) - 삭제 - 지원되지 않음: 추후 사용을 위해 예약됨 Short Name: APXCLEXP_XML DB package: AP_APXTRSWP_XMLP_PKG PTB AP Relatório de Exceções de Fechamento do Período- Excluir - Não Suportado: Reservado Para Uso Futuro Imported from BI Publisher Description: Relatório de Exceções do Fechamento de Período Application: Payables Source: Relatório de Exceções de Fechamento do Período (XML) - Excluir - Não Suportado: Reservado Para Uso Futuro Short Name: APXCLEXP_XML DB package: AP_APXTRSWP_XMLP_PKG RU AP Отчет об исключениях при закрытии периода- не поддерживается: зарезервировано для будущего использования Imported from BI Publisher Description: Отчет об исключениях закрытия периода Application: Кредиторы Source: Отчет об исключениях при закрытии периода (XML) - не поддерживается: зарезервировано для будущего использования Short Name: APXCLEXP_XML DB package: AP_APXTRSWP_XMLP_PKG S AP Undantagsrapport för periodstängning- Ta bort - Stöds inte: Reserverad för framtida bruk Imported from BI Publisher Description: Undantagsrapport för periodstängning Application: Payables Source: Undantagsrapport för periodstängning (XML) - Ta bort - Stöds inte: Reserverad för framtida bruk Short Name: APXCLEXP_XML DB package: AP_APXTRSWP_XMLP_PKG TR AP Dönem Kapanışı İstisnalar Raporu- Sil - Desteklenmez: Gelecekte Kullanım İçin Ayrılmıştır Imported from BI Publisher Description: Dönem Kapanışı İstisnalar Raporu Application: Borçlar Muhasebesi Source: Dönem Kapanışı İstisnalar Raporu (XML) - Sil - Desteklenmez: Gelecekte Kullanım İçin Ayrılmıştır Short Name: APXCLEXP_XML DB package: AP_APXTRSWP_XMLP_PKG US AP Period Close Exceptions Report- Delete - Not Supported: Reserved For Future Use Imported from BI Publisher Description: Period Close Exceptions Report Application: Payables Source: Period Close Exceptions Report (XML) - Delete - Not Supported: Reserved For Future Use Short Name: APXCLEXP_XML DB package: AP_APXTRSWP_XMLP_PKG ZHS AP 期间关闭例外报表- 删除 - 不支持：已保留供将来使用 Imported from BI Publisher Description: 期间关闭例外报表 Application: 应付帐款 Source: 期间关闭例外报表 (XML) - 删除 - 不支持：已保留供将来使用 Short Name: APXCLEXP_XML DB package: AP_APXTRSWP_XMLP_PKG BI Publisher &c_aip_multi_org_where &c_aph_multi_org_where &c_date_filter_pay &c_date_filter_payhist &c_org_from_tables &p_aip_org_where &p_aph_org_where :applications_template_report :c_accrual_basis_in_use :c_aip_multi_org_where :c_aph_acctg_date :c_aph_multi_org_where :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_date_filter_inv :c_date_filter_pay :c_date_filter_payhist :c_from_acctg_date :c_inv_multi_org_where :c_ledger_partial_ou :c_nls_all :c_nls_end_of_report :c_nls_na :c_nls_no :c_nls_no_data_exists :c_nls_void :c_nls_yes :c_org_from_tables :c_pmts_multi_org_where :c_rep_title :c_report_start_date :c_select_le :c_select_ou :c_sweep_now :c_sweep_to_date :c_to_acctg_date :ledger_part :p_ac_org_where :p_acct_method :p_ah_org_where :p_ai_org_where :p_aid_org_where :p_aip_org_where :p_aph_org_where :p_conc_request_id :p_debug_switch :p_end_date :p_entity_name :p_flexdata :p_from_acctg_date :p_level_name :p_min_precision :p_period_name :p_ph_org_where :p_pll_org_where :p_reporting_entity_id :p_reporting_level :p_set_of_books_id :p_start_date :p_sweep_now :p_sweep_now_1 :p_to_acctg_date :p_to_period :p_trace_switch :p_unacc_swp_rev :p_unacc_trans_rep :p_unacc_trans_swp :p_unacct_rpt 1 -70 :p_reporting_level LOV Oracle FND_MO_REPORTING_LEVEL Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='FND_MO_REPORTING_LEVEL' and lookup_code in (1000,3000) order by value,description SELECT MEANING FROM FND_LOOKUPS WHERE LOOKUP_TYPE = 'FND_MO_REPORTING_LEVEL' AND rownum=1 Y US FND_MO_REPORTING_LEVEL 2 -60 :p_reporting_entity_id LOV Oracle FND_MO_REPORTING_ENTITY Y select entity_id id, entity_name value, null description from fnd_mo_reporting_entities_v where reporting_level=:$flex$.fnd_mo_reporting_level order by value,description SELECT entity_name, entity_id FROM FND_MO_REPORTING_ENTITIES_V WHERE reporting_level = :$FLEX$.FND_MO_REPORTING_LEVEL and rownum=1 Y AR سياق إعداد التقرير D Auswertungskontext E Contexto del Informe F Contexte de reporting I Contesto dichiarazione JA レポート・コンテキスト KO 보고 컨텍스트 PTB Contexto do Relatório RU Контекст отчетности S Rapporteringssammanhang TR Raporlama İçeriği US Reporting Context ZHS 报告上下文 3 -50 :p_set_of_books_id Number fnd_profile.value('GL_SET_OF_BKS_ID') Y AR معرف دفتر الأستاذ D Buchkennung E Id Libro Mayor F ID livre I Id libro contabile JA 元帳ID KO 원장 ID PTB Id do Razão RU Идентификатор книги S Huvudboks-id TR Defter No US Ledger Id ZHS 分类帐标识 4 -40 :p_sweep_now LOV Oracle AP_SRS_YES_NO_MAND 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 Jetzt übertragen? E Transferir Ahora F Transférer I Trasferisci ora JA ここでスイープ処理実行 KO 지금 이월 PTB Efetuar varredura agora RU Выполнить перенос S Överför nu TR Şimdi Temizle US Sweep Now ZHS 现在转移 5 -20 :p_trace_switch LOV Oracle AP_SRS_YES_NO_MAND 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' Y AR تحويل التتبع D Trace-Schalter E Conmutador de Rastreo F Activer analyse I Parametro di individuazione JA トレース切替 KO 추적 전환 PTB Chave de Rastreamento RU Ключ трассировки S Spårningsväxel TR İzlemeyi Değiştir US Trace Switch ZHS 跟踪开关 6 10 :p_from_acctg_date Date Y AR من تاريخ المحاسبة D Von Buchungsdatum E De Fecha de Creación de Asiento F Date comptable - Du I Data registrazione - Da JA 会計日:自 KO 회계 일자:부터 PTB Data Contábil - De RU Начальная дата учета S Från bokföringsdatum TR Muhasebeleşme Başlangıç Tarihi US From Accounting Date ZHS 自会计结算日期 7 20 :p_to_acctg_date Date Y AR إلى تاريخ المحاسبة D Bis Buchungsdatum E A Fecha de Creación de Asiento F Date comptable - Au I Data registrazione - A JA 会計日:至 KO 회계 일자-까지 PTB Data Contábil - Até RU Конечная дата учета S Till bokföringsdatum TR Muhasebeleşme Bitiş Tarihi US To Accounting Date ZHS 至会计结算日期 8 30 :p_period_name LOV Oracle AP_SRS_ACCOUNTING_PERIOD_OPT Y select period_name id, period_name value, null description from gl_period_statuses where application_id=200 and adjustment_period_flag<>'Y' and set_of_books_id=fnd_profile.value('gl_set_of_bks_id') order by period_year desc,period_num desc Y AR اسم الفترة D Periodenbezeichnung E Nombre del Período F Nom de la période I Nome periodo JA 期間名 KO 기간명 PTB Nome do Período RU Имя периода S Periodnamn TR Dönem Adı US Period Name ZHS 期间名称