ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F48F3869E053B46B63588994 SELECT pv.vendor_name c_vendor_name, upper(pv.vendor_name) c_upper_vendor_name, decode(:SORT_BY_ALTERNATE, 'Y', upper(pv.vendor_name_alt), upper(pv.vendor_name)) c_sort_vendor_name, inv1.invoice_num c_invoice_num, inv1.invoice_date c_invoice_date, &P_dynamic_batch_orderby c_batch_id, &P_invoice_amount c_invoice_amount, decode(inv1.payment_status_flag, 'Y', 0, (nvl(inv1.invoice_amount,0) - nvl(ap_invoices_pkg.get_amount_withheld(inv1.invoice_id),0) -(ap_utilities_pkg.ap_round_currency((nvl(inv1.amount_paid,0)/inv1.payment_cross_rate),inv1.invoice_currency_code)) - (ap_utilities_pkg.ap_round_currency((nvl(inv1.discount_amount_taken,0)/inv1.payment_cross_rate),inv1.invoice_currency_code)))) c_amount_rem, inv1.description c_description, inv1.invoice_type_lookup_code c_invoice_type, null c_expense_accounting_flex, null c_liab_accounting_flex, dist.amount c_dist_amount, dist.accounting_date c_accounting_date, dist.type_1099 c_type_1099, lines.line_number c_line_number, lines.description c_line_description, to_char(lines.amount, fnd_currency.get_format_mask(inv1.invoice_currency_code, 17)) c_line_amount_f, alc1.displayed_field c_posted, nvl(substr(bat.batch_name,1,18), :c_nls_na) c_batch_name, upper(nvl(substr(bat.batch_name,1,18), :c_nls_na)) c_upper_batch_name, inv1.invoice_id c_invoiceid, inv1.vendor_id c_vendor, substr(inv1.invoice_currency_code,1,15) c_currency_code, alc2.displayed_field c_dist_type, alc3.displayed_field c_line_type, dist.distribution_line_number c_dist_number, alc.displayed_field c_nls_invoice_type, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_exp_flexfield', 'SQLGL', 'GL#', GC.CHART_OF_ACCOUNTS_ID, NULL, GC.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_exp_flexfield, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_liab_flexfield', 'SQLGL', 'GL#', GC.CHART_OF_ACCOUNTS_ID, NULL, GC.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') c_liab_flexfield FROM ap_invoices inv1, po_vendors pv, ap_invoice_lines lines, ap_invoice_distributions dist, gl_code_combinations GC, &P_gl_code_combinations2 ap_batches bat, ap_lookup_codes alc, ap_lookup_codes alc1, ap_lookup_codes alc2, ap_lookup_codes alc3 WHERE inv1.vendor_id = pv.vendor_id AND (:P_VENDOR_ID IS NULL OR (:P_VENDOR_ID IS NOT NULL AND pv.vendor_id = :P_VENDOR_ID)) AND bat.batch_id(+) = inv1.batch_id &C_INVOICE_ID_PREDICATE &C_batch_predicate &C_match_status_predicate &C_INV_TYPE_PRED &C_ACCOUNTING_DATE_PREDICATE &C_invoice_cancelled_predicate &C_created_by_predicate &C_start_date_predicate &C_end_date_predicate AND GC.code_combination_id(+) = dist.dist_code_combination_id &C_gl_ccid2_predicate AND alc.lookup_type = 'INVOICE TYPE' AND alc.lookup_code = inv1.invoice_type_lookup_code AND alc1.lookup_type (+) = 'POSTING STATUS' AND alc1.lookup_code (+) = dist.posted_flag AND alc2.lookup_type (+) = 'INVOICE DISTRIBUTION TYPE' AND alc2.lookup_code (+) = dist.line_type_lookup_code AND alc3.lookup_type (+) = 'INVOICE LINE TYPE' AND alc3.lookup_code (+) = lines.line_type_lookup_code ORDER BY inv1.invoice_currency_code,c_batch_name,c_sort_vendor_name,c_invoice_num,c_invoice_amount,c_line_number,c_line_type,c_line_description,c_line_amount_f,c_dist_number,c_batch_id, &C_orderby_batch_id decode(:SORT_BY_ALTERNATE, 'Y', upper(vendor_name_alt), upper(vendor_name)), invoice_num, lines.line_number, dist.distribution_line_number SQLAP APXINRIR_XML AR AP مسجل الفواتير (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Application: المدفوعات Source: مسجل الفواتير (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: APXINRIR_XML DB package: AP_APXINRIR_XMLP_PKG D AP Rechnungsjournal- Nicht unterstützt: Reserviert für zukünftige Verwendung Application: Kreditoren Source: Rechnungsjournal (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: APXINRIR_XML DB package: AP_APXINRIR_XMLP_PKG F AP Registre des factures- Non pris en charge : réservé pour une utilisation future Application: Payables Source: Registre des factures (XML) - Non pris en charge : réservé pour une utilisation future Short Name: APXINRIR_XML DB package: AP_APXINRIR_XMLP_PKG US AP Invoice Register - draft Application: Payables Source: Invoice Register (XML) - Not Supported: Reserved For Future Use Short Name: APXINRIR_XML DB package: AP_APXINRIR_XMLP_PKG ZHS AP 发票登记表- 不支持：已保留供将来使用 Application: 应付帐款 Source: 发票登记表 (XML) - 不支持：已保留供将来使用 Short Name: APXINRIR_XML DB package: AP_APXINRIR_XMLP_PKG BI Publisher &c_accounting_date_predicate &c_batch_predicate &c_created_by_predicate &c_end_date_predicate &c_gl_ccid2_predicate &c_inv_type_pred &c_invoice_cancelled_predicate &c_invoice_id_predicate &c_match_status_predicate &c_orderby_batch_id &c_start_date_predicate &p_dynamic_batch_orderby &p_gl_code_combinations2 &p_invoice_amount :c_accounting_date_predicate :c_base_currency_code :c_base_min_acct_unit :c_base_precision :c_batch_flag :c_batch_id :c_batch_predicate :c_cancelled_invoices_only :c_chart_of_accounts_id :c_company_name_header :c_created_by_predicate :c_end_date_predicate :c_gl_ccid2_predicate :c_inv_type_pred :c_invoice_cancelled_predicate :c_invoice_id_predicate :c_invoice_type1 :c_liability_acct_flex :c_match_status_predicate :c_nls_all :c_nls_end_of_report :c_nls_na :c_nls_no :c_nls_no_data_exists :c_nls_yes :c_orderby_batch_id :c_show_lib_acct :c_start_date_predicate :c_supplier_name :c_unapproved_invoices_only :c_user_id :cp_end_date :cp_start_date :operating_unit :p_accounting_period :p_batch :p_cancelled_flag :p_conc_request_id :p_debug_switch :p_dynamic_batch_orderby :p_end_date :p_entry_person :p_flexdata :p_flexdata1 :p_gl_code_combinations2 :p_invoice_amount :p_invoice_type :p_min_precision :p_sob_id :p_start_date :p_trace_switch :p_unapprove_flag :p_unapprove_flag_1 :p_vendor_id :sort_by_alternate 1 10 :p_vendor_id LOV Oracle AP_SRS_VENDOR_INV_REG Y select vendor_id id, vendor_name value, null description from po_vendors order by value,description AR اسم المورد D Lieferantenname F Nom du fournisseur US Supplier Name ZHS 供应商名称 2 20 :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 F Type de facture US Invoice Type ZHS 发票类型 3 30 :p_batch LOV Oracle AP_SRS_BATCH Y select batch_name id, batch_name value, null description from ap_batches_all where exists (select ai.invoice_id from ap_invoices ai where ai.batch_id=ap_batches_all.batch_id and mo_global.check_access(ai.org_id)='Y') and (ap_batches_all.org_id is null or mo_global.check_access(ap_batches_all.org_id)='Y') order by value,description AR المجموعة D Stapel F Lot US Batch ZHS 批 4 40 :p_entry_person LOV Oracle AP_SRS_USER_NAME Y select user_name id, user_name value, null description from fnd_user order by value,description AR مدخل بواسطة D Eingegeben von F Saisi par US Entered By ZHS 输入者 5 50 :p_start_date Date AR من تاريخ الإدخال D Von Eingabedatum F Date de saisie - Du US From Entered Date ZHS 自输入日期 6 60 :p_end_date Date AR إلى تاريخ الإدخال D Bis Eingabedatum F Date de saisie - Au US To Entered Date ZHS 至输入日期 7 70 :p_accounting_period 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 AR الفترة المحاسبية D Buchungsperiode F Période comptable US Accounting Period ZHS 会计期 8 80 :p_cancelled_flag LOV Oracle AP_CANCELLED_INVOICE 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 Nur stornierte Rechnungen F Factures annulées uniquement US Cancelled Invoices Only ZHS 仅限于取消的发票 9 90 :p_unapprove_flag LOV Oracle AP_UNAPPROVED_INVOICE Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' and ((lookup_code='N' and :$flex$.ap_cancelled_invoice='Y') or :$flex$.ap_cancelled_invoice='N') order by value,description select meaning from fnd_lookups where lookup_type = 'YES_NO' and lookup_code = 'N' Y AR الفواتير غير المراجعة فقط D Nur nicht validierte Rechnungen F Factures non validées uniquement US Unvalidated Invoices Only ZHS 仅限于未验证的发票 :$flex$.ap_cancelled_invoice Cancelled Invoices Only Unvalidated Invoices Only