ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4722451A9E05362FB09050512 SELECT v.vendor_name, i.invoice_num, i.invoice_currency_code, i.invoice_amount, substr(i.invoice_num, 5, (instr(i.invoice_num,'-', 1, 2) - 5)) corrected_inv_num, NULL corrected_line_numer, c.description, c.displayed_field, &CF_Invoice_Amount3 CF_invoice_amount3 FROM ap_ppa_invoices_gt i, ap_invoices_interface ii, ap_interface_rejections r, po_vendors v, ap_lookup_codes c WHERE i.invoice_id = r.parent_id AND i.instr_status_flag = 'N' AND r.parent_table = 'AP_PPA_INVOICES_GT' AND i.instruction_id = ii.invoice_id AND ii.status = 'REJECTED' AND ii.source = :P_SOURCE_T AND ((:p_group_id_t IS NULL) OR (ii.group_id = :p_group_id_t)) AND v.vendor_id = i.vendor_id AND ((i.org_id IS NOT NULL AND mo_global.check_access(i.org_id) = 'Y') OR i.org_id IS NULL) AND c.lookup_type = 'REJECT CODE' AND r.reject_lookup_code = c.lookup_code UNION ALL SELECT v.vendor_name, i.invoice_num, i.invoice_currency_code, l.amount, AP_RETRO_PRICING_UTIL_PKG.get_invoice_num( l.corrected_inv_id) corrected_inv_num, l.corrected_line_number, c.description, c.displayed_field, &CF_Invoice_Amount3 CF_invoice_amount3 FROM ap_ppa_invoices_gt i, ap_ppa_invoice_lines_gt l, ap_lookup_codes c, po_vendors v, ap_interface_rejections r, ap_invoices_interface ii WHERE l.invoice_line_id = r.parent_id AND r.parent_table = 'AP_PPA_INVOICE_LINES_GT' AND i.invoice_id = l.invoice_id AND i.instr_status_flag = 'N' AND i.instruction_id = ii.invoice_id AND ii.status = 'REJECTED' AND ii.source = :P_SOURCE_T AND (( :p_group_id_t IS NULL ) OR ( ii.group_id = :p_group_id_t)) AND v.vendor_id = i.vendor_id AND mo_global.check_access(i.org_id) = 'Y' AND c.lookup_type = 'REJECT CODE' AND r.reject_lookup_code = c.lookup_code UNION ALL SELECT v.vendor_name, ai.invoice_num, NULL invoice_currency_code, NULL invoice_amount, NULL corrected_inv_num, NULL corrected_line_number, c.description, c.displayed_field, &CF_Invoice_Amount3 CF_invoice_amount3 FROM ap_invoices_interface ii, ap_invoices_all ai, ap_interface_rejections r, po_vendors v, ap_lookup_codes c WHERE ii.invoice_id = r.parent_id AND r.parent_table = 'AP_PPA_INSTRUCTIONS_GT' AND ii.status = 'REJECTED' AND ai.vendor_id = ii.vendor_id AND ai.invoice_id IN (SELECT distinct L.invoice_id FROM ap_invoice_lines_interface IL, ap_invoice_lines_all L WHERE IL.invoice_id = ii.invoice_id AND IL.po_line_location_id = L.po_line_location_id AND L.org_id = ai.org_id AND L.invoice_id = ai.invoice_id AND L.match_type IN ('ITEM_TO_PO', 'ITEM_TO_RECEIPT', 'QTY_CORRECTION', 'PRICE_CORRECTION') AND L.discarded_flag <> 'Y' AND L.cancelled_flag <> 'Y' AND (NVL(L.generate_dists, 'Y') <> 'D' OR EXISTS (SELECT 'Unapproved matched dist' FROM ap_invoice_distributions_all D WHERE D.invoice_id = L.invoice_id AND D.invoice_line_number = L.line_number AND NVL(D.match_status_flag, 'X') NOT IN ('A', 'T')) OR EXISTS (SELECT 'Holds other than Price Hold' FROM ap_holds_all H WHERE H.invoice_id = L.invoice_id AND H.release_lookup_code is null AND H.hold_lookup_code <> 'PRICE') ) ) AND ii.source = :P_SOURCE_T AND ((:p_group_id_t IS NULL) OR (ii.group_id = :p_group_id_t)) AND v.vendor_id = ii.vendor_id AND ((ii.org_id IS NOT NULL AND mo_global.check_access(ii.org_id) = 'Y') OR ii.org_id IS NULL) AND c.lookup_type = 'REJECT CODE' AND r.reject_lookup_code = c.lookup_code ORDER BY 1 ASC,2 ASC Y SQLAP APXIIMPT_XML AR AP استيراد الواجهة المفتوحة للمدفوعات (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Imported from BI Publisher Description: استيراد الوسيط المفتوح للمدفوعات Application: المدفوعات Source: استيراد الواجهة المفتوحة للمدفوعات (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: APXIIMPT_XML DB package: AP_APXIIMPT_XMLP_PKG D AP Offene Kreditorenschnittstelle - Import- Nicht unterstützt: Reserviert für zukünftige Verwendung Imported from BI Publisher Description: Offene Kreditorenschnittstelle - Import Application: Kreditoren Source: Offene Kreditorenschnittstelle - Import (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: APXIIMPT_XML DB package: AP_APXIIMPT_XMLP_PKG E AP Importación de la Interfaz Abierta de Cuentas a Pagar: No Admitido, Reservado para Uso Futuro Imported from BI Publisher Description: Importación de la Interfaz Abierta de Cuentas a Pagar Application: Payables Source: Importación de la Interfaz Abierta de Cuentas a Pagar (XML): No Admitido, Reservado para Uso Futuro Short Name: APXIIMPT_XML DB package: AP_APXIIMPT_XMLP_PKG F AP Programme d'importation de l'interface coopérative de Payables- Non pris en charge : réservé pour une utilisation future Imported from BI Publisher Description: Programme d'importation de l'interface coopérative d'Oracle Payables Application: Payables Source: Programme d'importation de l'interface coopérative de Payables (XML) - Non pris en charge : réservé pour une utilisation future Short Name: APXIIMPT_XML DB package: AP_APXIIMPT_XMLP_PKG I AP Importazione interfaccia aperta di Oracle Payables- non supportato: riservato per usi futuri Imported from BI Publisher Description: Importazione interfaccia aperta di Oracle Payables Application: Payables Source: Importazione interfaccia aperta di Oracle Payables (XML) - non supportato: riservato per usi futuri Short Name: APXIIMPT_XML DB package: AP_APXIIMPT_XMLP_PKG JA AP 買掛/未払金オープン・インタフェース・インポート- 未サポート: 将来の使用のために予約 Imported from BI Publisher Description: 買掛/未払金オープン・インタフェース・インポート Application: Payables Source: 買掛/未払金オープン・インタフェース・インポート(XML) - 未サポート: 将来の使用のために予約 Short Name: APXIIMPT_XML DB package: AP_APXIIMPT_XMLP_PKG KO AP 오픈 인터페이스 임포트- 지원되지 않음: 추후 사용을 위해 예약됨 Imported from BI Publisher Description: AP 오픈 인터페이스 임포트 Application: Payables Source: AP 오픈 인터페이스 임포트(XML) - 지원되지 않음: 추후 사용을 위해 예약됨 Short Name: APXIIMPT_XML DB package: AP_APXIIMPT_XMLP_PKG PTB AP Importação da Interface Aberta do Payables- Não Suportado: Reservado Para Uso Futuro Imported from BI Publisher Description: Importação da Interface Aberta do Payables Application: Payables Source: Importação da Interface Aberta do Payables (XML) - Não Suportado: Reservado Para Uso Futuro Short Name: APXIIMPT_XML DB package: AP_APXIIMPT_XMLP_PKG RU AP Импорт открытого интерфейса КР- не поддерживается: зарезервировано для будущего использования Imported from BI Publisher Description: Импорт открытого интерфейса Кредиторов Application: Кредиторы Source: Импорт открытого интерфейса КР (XML) - не поддерживается: зарезервировано для будущего использования Short Name: APXIIMPT_XML DB package: AP_APXIIMPT_XMLP_PKG S AP Öppet gränssnitt - import- Stöds inte: Reserverad för framtida bruk Imported from BI Publisher Description: Leverantörsreskontra: Öppet gränssnitt - import Application: Payables Source: Leverantörsreskontra: Öppet gränssnitt - import (XML) - Stöds inte: Reserverad för framtida bruk Short Name: APXIIMPT_XML DB package: AP_APXIIMPT_XMLP_PKG TR AP Borçlar Muhasebesi Açık Arayüz İçe Aktarma- Desteklenmez: Gelecekte Kullanım İçin Ayrılmıştır Imported from BI Publisher Description: Borçlar Muhasebesi Açık Arayüz İçe Aktarma Application: Borçlar Muhasebesi Source: Borçlar Muhasebesi Açık Arayüz İçe Aktarma (XML) - Desteklenmez: Gelecekte Kullanım İçin Ayrılmıştır Short Name: APXIIMPT_XML DB package: AP_APXIIMPT_XMLP_PKG US AP Payables Open Interface Import- Not Supported: Reserved For Future Use Imported from BI Publisher Description: Payables Open Interface Import Application: Payables Source: Payables Open Interface Import (XML) - Not Supported: Reserved For Future Use Short Name: APXIIMPT_XML DB package: AP_APXIIMPT_XMLP_PKG ZHS AP Oracle Payables 开放接口导入- 不支持：已保留供将来使用 Imported from BI Publisher Description: 应付款管理系统开放接口导入 Application: 应付帐款 Source: Oracle Payables 开放接口导入 (XML) - 不支持：已保留供将来使用 Short Name: APXIIMPT_XML DB package: AP_APXIIMPT_XMLP_PKG BI Publisher &cf_invoice_amount3 :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_error_flag :c_error_message :c_invoices_created :c_invoices_fetched :c_msg_count :c_msg_data :c_msg_token1 :c_msg_token2 :c_msg_token3 :c_msg_type :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_pa_message :c_print_batch :c_report_start_date :c_total_invoice_amount :c_total_invoices_created :c_total_invoices_rejected :cp_operating_unit :cp_purge_flag :create_retroprice_adjustments :import_invoices :p_allow_recovery_rate_override :p_allow_tax_code_override :p_base_currency_code :p_batch_name :p_batch_name_t :p_commit_cycles :p_conc_request_id :p_debug_switch :p_debug_switch_t :p_enable_non_recoverable_tax :p_flexdata :p_gl_date :p_gl_date_t :p_group_id :p_group_id_t :p_hold_code :p_hold_code_t :p_hold_reason :p_hold_reason_t :p_login_id :p_min_precision :p_org_id :p_org_id_t :p_precision :p_purge_flag :p_purge_flag_t :p_set_of_books_id :p_source :p_source_t :p_summary_flag :p_summary_flag_t :p_trace_switch :p_trace_switch_t :p_user_id :payables_open_interface_import 1 -60 :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 İzlemeyi Değiştir US Trace Switch Trace Switch ZHS 跟踪开关 跟踪开关 2 -40 :p_commit_batch_size Number 1000 AR تثبيت حجم المجموعة تثبيت حجم المجموعة D Stapelgröße speichern Stapelgröße speichern E Tamaño del Lote de Validación Tamaño del Lote de Validación F Valider la taille du lot Valider la taille du lot I Commit dimensioni batch Commit dimensioni batch JA コミット・バッチサイズ コミット・バッチサイズ KO 커밋 뱃치 크기 커밋 뱃치 크기 PTB Fazer Commit do Tamanho do Lote Fazer Commit do Tamanho do Lote RU Размер пакета фиксации Размер пакета фиксации S Sparstorlek för batch Sparstorlek för batch TR İşlem Grubu Boyutunu Kaydet İşlem Grubu Boyutunu Kaydet US Commit Batch Size Commit Batch Size ZHS 提交批大小 提交批大小 3 -30 :p_user_id Number fnd_profile.value('USER_ID') AR معرف المستخدم معرف المستخدم D Benutzerkennung Benutzerkennung E Id Usuario Id Usuario F ID utilisateur ID utilisateur I Id utente ID dell'utente JA ユーザーID ユーザーID KO 사용자 ID 사용자 ID PTB ID do Usuário ID do Usuário RU Идент. пользователя Идент. пользователя S Användar-id Användar-id TR Kullanıcı No Kullanıcı No US User ID User ID ZHS 用户标识 用户标识 4 -20 :p_login_id Number fnd_profile.value('LOGIN_ID') AR معرف الدخول معرف الدخول D Anmeldekennung Anmeldekennung E Id Conexión Id Conexión F ID connexion ID connexion I ID connessione ID della connessione JA ログインID ログインID KO 로그인 ID 로그인 ID PTB ID de Login ID de Login RU Идентификатор входа в систему Идентификатор входа в систему S Inloggnings-id Inloggnings-id TR Giriş No Giriş No US Login ID Login ID ZHS 登录标识 登录标识 5 10 :p_org_id LOV Oracle FND_MO_OU Y select organization_id id, organization_name value, null description from mo_glob_org_access_tmp order by value,description AR وحدة التشغيل وحدة التشغيل D Betriebseinheit Betriebseinheit E Unidad Operativa Unidad operativa F Unité opérationnelle Unité opérationnelle I Unità operativa Unità operativa JA 営業単位 営業単位 KO 운영 단위 운영 단위 PTB Unidade Operacional Unidade Operacional RU Операционная единица Операционная единица S Operativ enhet Operativ enhet TR Faaliyet Birimi Faaliyet Birimi US Operating Unit Operating Unit ZHS 业务实体 业务实体 6 20 :p_source LOV Oracle AP_SRS_OPEN_INTERFACE_SOURCE Y select lookup_code id, displayed_field value, description description from ap_lookup_codes where lookup_type='SOURCE' and lookup_code not in ('XpenseXpress','SelfService') and trunc(sysdate) between nvl(start_date_active,sysdate-1) and nvl(inactive_date,sysdate+1) and enabled_flag='Y' order by displayed_field Y AR المصدر المصدر D Herkunft Herkunft E Origen Origen F Origine Origine I Origine Origine JA ソース ソース KO 출처 출처 PTB Origem Origem RU Источник Источник S Källa Källa TR Kaynak Kaynak US Source Source ZHS 来源 来源 7 30 :p_group_id Char AR المجموعة المجموعة D Gruppe Gruppe E Grupo Grupo F Groupe Groupe I Gruppo Gruppo JA グループ グループ KO 그룹 그룹 PTB Grupo Grupo RU Группа Группа S Grupp Grupp TR Grup Grup US Group Group ZHS 组 组 8 40 :p_batch_name Char select decode(nvl(fpov1.profile_option_value,'N'), 'N', lc.displayed_field) FROM fnd_profile_option_values fpov1,fnd_profile_options fpo1, ap_lookup_codes lc WHERE fpov1.profile_option_id = fpo1.profile_option_id AND fpo1.profile_option_name ='AP_USE_INV_BATCH_CONTROLS' AND fpov1.level_id = 10004 AND lc.lookup_type ='NLS REPORT PARAMETER' and lc.lookup_code = 'NA' Y AR اسم المجموعة اسم المجموعة D Stapelbezeichnung Stapelbezeichnung E Nombre del Lote Nombre del Lote F Nom du lot Nom du lot I Nome batch Nome batch JA バッチ名 バッチ名 KO 뱃치명 뱃치명 PTB Nome do Lote Nome do Lote RU Имя пакета Имя пакета S Bunt Bunt TR İşlem Grubu Adı İşlem Grubu Adı US Batch Name Batch Name ZHS 批名 批名 9 50 :p_hold_code LOV Oracle AP_SRS_HOLD_CODE Y select lookup_code id, displayed_field value, null description from ap_lookup_codes where lookup_type='HOLD CODE' and lookup_code in(select hold_lookup_code from ap_hold_codes where (hold_type like '%REASON' or hold_type in ('INSUFFICIENT INFORMATION','PERIOD HOLD TYPE','PERIOD RELEASE TYPE')) and nvl(inactive_date,sysdate+1)>sysdate and user_releaseable_flag='Y') and enabled_flag='Y' order by value,description AR اسم الإيقاف اسم الإيقاف D Sperre Sperre E Nombre de Retención Nombre de Retención F Code blocage Code blocage I Nome blocco Nome del blocco JA 保留名 保留名 KO 보류명 보류명 PTB Nome da Retenção Nome da Retenção RU Имя блокировки Имя блокировки S Spärr Spärr TR Durdurma Adı Durdurma Adı US Hold Name Hold Name ZHS 暂挂名 暂挂名 10 60 :p_hold_reason Char select description from ap_hold_codes where hold_lookup_code = :$flex$.hold_name AR سبب الإيقاف سبب الإيقاف D Sperrgrund Sperrgrund E Motivo de Retención Motivo de Retención F Motif du blocage Motif du blocage I Motivo blocco Motivo del blocco JA 保留事由 保留事由 KO 보류 사유 보류 사유 PTB Motivo Ret. Motivo Ret. RU Основание блокировки Основание блокировки S Spärrorsak Spärrorsak TR Durdurma Nedeni Durdurma Nedeni US Hold Reason Hold Reason ZHS 暂挂原因 暂挂原因 11 70 :p_gl_date Date AR تاريخ أ/ع تاريخ أ/ع D Buchungsdatum Buchungsdatum E Fecha Contable Fecha Contable F Date GL Date GL I Data GL Data GL JA GL記帳日 GL記帳日 KO GL 일자 GL 일자 PTB Data GL Data GL RU Дата ГК Дата ГК S Bokföringsdatum Bokföringsdatum TR GL Tarihi GL Tarihi US GL Date GL Date ZHS GL 日期 GL 日期 12 80 :p_purge_flag 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 Löschen Löschen E Depurar Depurar F Purger Purger I Rimuovi Rimuove JA パージ パージ KO 삭제 삭제 PTB Expurgar Expurgar RU Очистить Очистить S Rensa Rensa TR Temizle Temizle US Purge Purge ZHS 清除 清除 13 90 :p_summary_flag 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 Nur Summen drucken Nur Summen für Prüfprotokoll drucken E Resumir Informe Resumir Informe para el Informe de Auditoría F Synthétiser l'état Synthétiser l'état pour l'état de contrôle I Riepiloga rapporto Riepiloga rapporto per il rapporto Audit JA 要約レポート 監査レポート用要約レポート KO 보고서 요약 감사 보고서용 보고서 요약 PTB Sumariar Relatório Relatório Sumariar Relatório para Auditoria RU Сводный отчет Сводный отчет для отчета об аудите S Sammanfatta rapport Sammanfatta rapport för kontrollrapport TR Raporu Özetle Denetim raporu için Raporu özetler. US Summarize Report Summarize Report for Audit report ZHS 汇总报表 汇总报告以审核报表