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）限制的操作单元。 C6E085D4722A51A9E05362FB09050512 SELECT DISTINCT pv1.vendor_name C_VENDOR, pv1.vendor_id C_VENDOR_ID, pvs.vendor_site_code C_VENDOR_SITE, i.invoice_num C_INVOICE_NUMBER, i.invoice_id C_INVOICE_ID1, i.invoice_date C_TRANSACTION_DATE, i.invoice_type_lookup_code C_TRANSACTION_TYPE, alc.displayed_field C_TRANSACTION_TYPE_FIELD, i.payment_currency_code C_CURR, DECODE (i.doc_sequence_value, NULL,i.voucher_num, i.doc_sequence_value) C_DOC_SEQUENCE_NUMBER, f2.name C_DOC_SEQUENCE_NAME, DECODE(i.invoice_type_lookup_code, 'PREPAYMENT', nvl(ap_utilities_pkg.ap_round_currency(i.invoice_amount* i.payment_cross_rate , i.payment_currency_code) ,0), nvl(nvl(i.pay_curr_invoice_amount, i.invoice_amount),0)) - nvl(ap_invoices_pkg.get_amount_withheld(i.invoice_id),0) C_TOTAL_INVOICE_AMT, ck.doc_sequence_value C_DOC_SEQUENCE_NUMBER1, ck.check_number C_TRANSACTION_NUMBER, f.name C_DOC_SEQUENCE_NAME1, aip.accounting_date C_TRANSACTION_DATE2, ael.accounting_class_code C_LINE_TYPE_CODE, DECODE(ael.accounting_class_code, 'CASH', 'Cash', 'DISCOUNT','Discount', 'GAIN','Gain', 'LOSS','Loss', 'CASH CLEARING','Cash Clearing' ) C_TRANSACTION_TYPE2, ck.currency_code C_CURR2, DECODE(ael.accounting_class_code, 'CASH',-1*aip.amount, 'CASH CLEARING',-1*aip.amount, 'GAIN',nvl(aip.invoice_base_amount,aip.amount)- nvl(aip.payment_base_amount,aip.amount), 'LOSS',nvl(aip.invoice_base_amount,aip.amount)- nvl(aip.payment_base_amount,aip.amount), 'DISCOUNT',ap_utilities_pkg.ap_round_currency(-1*nvl(aip.discount_taken,0)*i.payment_cross_rate ,i.payment_currency_code) )C_TRANSACTION_AMT , invoice_payment_id C_INVOICE_PAYMENT_ID, AP_APXINHIS_XMLP_PKG.c_vendor_site_totalformula(:C_TOTAL_INVOICE_AMOUNT_SUM, :C_TOTAL_PAYMENT_AMOUNT_SUM, :C_TOTAL_PREPAY_AMT_SUM) C_VENDOR_SITE_TOTAL, AP_APXINHIS_XMLP_PKG.c_currency_totalformula(:C_TOTAL_INVOICE_AMT_CURR, :C_TOTAL_PAYMENT_AMT_CURR, :C_TOTAL_PREPAY_AMT) C_CURRENCY_TOTAL, AP_APXINHIS_XMLP_PKG.c_prepay_amt_fformula(i.invoice_id) C_PREPAY_AMT_F, AP_APXINHIS_XMLP_PKG.c_transaction_amt1_dumformula(:C_TRANSACTION_TYPE3, DECODE ( ael.accounting_class_code , 'CASH' , - 1 * aip.amount , 'CASH CLEARING' , - 1 * aip.amount , 'GAIN' , nvl ( aip.invoice_base_amount , aip.amount ) - nvl ( aip.payment_base_amount , aip.amount ) , 'LOSS' , nvl ( aip.invoice_base_amount , aip.amount ) - nvl ( aip.payment_base_amount , aip.amount ) , 'DISCOUNT' , ap_utilities_pkg.ap_round_currency ( - 1 * nvl ( aip.discount_taken , 0 ) * i.payment_cross_rate , i.payment_currency_code ) )) C_TRANSACTION_AMT1_DUM, AP_APXINHIS_XMLP_PKG.c_open_balance_amt1formula(:C_TRANSACTION_TYPE3, :C_OPEN_BALANCE_AMT, :C_TRX_AMOUNT_SUM, :C_PREPAY_AMT_F, :C_TRANSACTION_AMT1_DUMMY_SUM) C_open_balance_amt1 FROM po_vendors pv1, po_vendor_sites pvs, ap_invoices i, ap_checks ck, fnd_document_sequences f, fnd_document_sequences f2, ap_invoice_payments aip, xla_transaction_entities ATE, xla_events AAE , xla_ae_headers AEH, xla_ae_lines AEL, ap_lookup_codes alc WHERE pv1.vendor_id = pvs.vendor_id AND i.vendor_id = pv1.vendor_id AND i.vendor_site_id = pvs.vendor_site_id AND i.invoice_id = aip.invoice_id (+) AND i.invoice_type_lookup_code = alc.lookup_code AND alc.lookup_type = 'INVOICE TYPE' AND aip.accounting_event_id = AEH.event_id(+) AND AEH.event_id = AAE.event_id(+) AND AAE.entity_id = ATE.entity_id(+) AND AEH.ae_header_id = AEL.ae_header_id(+) AND ATE.entity_code(+) = 'PAYMENTS' AND ( ( ( AEL.accounting_class_code = 'DISCOUNT' ) AND ( AIP.invoice_payment_id = ATE.source_id_int_1 ) ) OR ( AEL.accounting_class_code IS NULL OR AEL.accounting_class_code <> 'DISCOUNT' ) ) AND aeh.ledger_id(+) = :P_BOOk AND ck.check_id (+)= aip.check_id AND f.doc_sequence_id (+) = ck.doc_sequence_id AND f2.doc_sequence_id(+)= i.doc_sequence_id AND DECODE(i.invoice_type_lookup_code, 'PREPAYMENT',NVL(aip.invoice_payment_type, 'X'),1) <> DECODE(i.invoice_type_lookup_code, 'PREPAYMENT', 'PREPAY' , 2) &LP_VENDOR_ID &LP_VENDOR_SITE &LP_INVOICES &LP_INVOICES_NUMBER_FROM &LP_INVOICES_NUMBER_TO &LP_DOC_SEQUENCE_NAME &LP_DOC_SEQUENCE_NUMBER_FROM &LP_DOC_SEQUENCE_NUMBER_TO &LP_INVOICE_DATE_FROM &LP_INVOICE_DATE_TO UNION SELECT DISTINCT pv1.vendor_name C_VENDOR, pv1.vendor_id C_VENDOR_ID, pvs.vendor_site_code C_VENDOR_SITE, i.invoice_num C_INVOICE_NUMBER, i.invoice_id C_INVOICE_ID1, i.invoice_date C_TRANSACTION_DATE, i.invoice_type_lookup_code C_TRANSACTION_TYPE, alc.displayed_field C_TRANSACTION_TYPE_FIELD, i.payment_currency_code C_CURR, DECODE (i.doc_sequence_value, NULL,i.voucher_num, i.doc_sequence_value) C_DOC_SEQUENCE_NUMBER, f2.name C_DOC_SEQUENCE_NAME, DECODE(i.invoice_type_lookup_code, 'PREPAYMENT', nvl(ap_utilities_pkg.ap_round_currency(i.invoice_amount* i.payment_cross_rate , i.payment_currency_code) ,0), nvl(nvl(i.pay_curr_invoice_amount, i.invoice_amount),0)) - nvl(ap_invoices_pkg.get_amount_withheld(i.invoice_id),0) C_TOTAL_INVOICE_AMT, ck.doc_sequence_value C_DOC_SEQUENCE_NUMBER1, ck.check_number C_TRANSACTION_NUMBER, f.name C_DOC_SEQUENCE_NAME1, aip.accounting_date C_TRANSACTION_DATE2, ael.accounting_class_code C_LINE_TYPE_CODE, DECODE(ael.accounting_class_code, 'CASH', 'Cash', 'DISCOUNT','Discount', 'GAIN','Gain', 'LOSS','Loss', 'CASH CLEARING','Cash Clearing' ) C_TRANSACTION_TYPE2, ck.currency_code C_CURR2, DECODE(ael.accounting_class_code, 'CASH',-1*aip.amount, 'CASH CLEARING',-1*aip.amount, 'GAIN',nvl(aip.invoice_base_amount,aip.amount)- nvl(aip.payment_base_amount,aip.amount), 'LOSS',nvl(aip.invoice_base_amount,aip.amount)- nvl(aip.payment_base_amount,aip.amount), 'DISCOUNT',ap_utilities_pkg.ap_round_currency(-1*nvl(aip.discount_taken,0)*i.payment_cross_rate ,i.payment_currency_code) )C_TRANSACTION_AMT , invoice_payment_id C_INVOICE_PAYMENT_ID, AP_APXINHIS_XMLP_PKG.c_vendor_site_totalformula(:C_TOTAL_INVOICE_AMOUNT_SUM, :C_TOTAL_PAYMENT_AMOUNT_SUM, :C_TOTAL_PREPAY_AMT_SUM) C_VENDOR_SITE_TOTAL, AP_APXINHIS_XMLP_PKG.c_currency_totalformula(:C_TOTAL_INVOICE_AMT_CURR, :C_TOTAL_PAYMENT_AMT_CURR, :C_TOTAL_PREPAY_AMT) C_CURRENCY_TOTAL, AP_APXINHIS_XMLP_PKG.c_prepay_amt_fformula(i.invoice_id) C_PREPAY_AMT_F, AP_APXINHIS_XMLP_PKG.c_transaction_amt1_dumformula(:C_TRANSACTION_TYPE3, DECODE ( ael.accounting_class_code , 'CASH' , - 1 * aip.amount , 'CASH CLEARING' , - 1 * aip.amount , 'GAIN' , nvl ( aip.invoice_base_amount , aip.amount ) - nvl ( aip.payment_base_amount , aip.amount ) , 'LOSS' , nvl ( aip.invoice_base_amount , aip.amount ) - nvl ( aip.payment_base_amount , aip.amount ) , 'DISCOUNT' , ap_utilities_pkg.ap_round_currency ( - 1 * nvl ( aip.discount_taken , 0 ) * i.payment_cross_rate , i.payment_currency_code ) )) C_TRANSACTION_AMT1_DUM, AP_APXINHIS_XMLP_PKG.c_open_balance_amt1formula(:C_TRANSACTION_TYPE3, :C_OPEN_BALANCE_AMT, :C_TRX_AMOUNT_SUM, :C_PREPAY_AMT_F, :C_TRANSACTION_AMT1_DUMMY_SUM) C_open_balance_amt1 FROM po_vendors pv1, po_vendor_sites pvs, ap_invoices i, ap_checks ck, fnd_document_sequences f, fnd_document_sequences f2, ap_invoice_payments aip, xla_transaction_entities ATE, xla_events AAE , xla_ae_headers AEH, xla_ae_lines AEL, ap_lookup_codes alc, ap_payment_history aph WHERE pv1.vendor_id = pvs.vendor_id AND i.vendor_id = pv1.vendor_id AND i.vendor_site_id = pvs.vendor_site_id AND i.invoice_id = aip.invoice_id AND i.invoice_type_lookup_code = alc.lookup_code AND alc.lookup_type = 'INVOICE TYPE' AND aip.accounting_event_id = AEH.event_id AND AEH.event_id = AAE.event_id AND AAE.entity_id = ATE.entity_id AND AEH.ae_header_id = AEL.ae_header_id AND ATE.entity_code = 'PAYMENTS' AND ( ( ( AEL.accounting_class_code = 'DISCOUNT' ) AND ( AIP.invoice_payment_id = ATE.source_id_int_1 ) ) OR ( AEL.accounting_class_code IS NULL OR AEL.accounting_class_code <> 'DISCOUNT' ) ) AND aeh.ledger_id = :P_BOOk AND ck.check_id = aip.check_id AND f.doc_sequence_id (+) = ck.doc_sequence_id AND f2.doc_sequence_id(+)= i.doc_sequence_id AND DECODE(i.invoice_type_lookup_code, 'PREPAYMENT',NVL(aip.invoice_payment_type, 'X'),1) <> DECODE(i.invoice_type_lookup_code, 'PREPAYMENT', 'PREPAY' , 2) AND aph.accounting_event_id = aeh.event_id AND aip.check_id = aph.check_id AND aph.transaction_type = 'PAYMENT MATURITY' &LP_VENDOR_ID &LP_VENDOR_SITE &LP_INVOICES &LP_INVOICES_NUMBER_FROM &LP_INVOICES_NUMBER_TO &LP_DOC_SEQUENCE_NAME &LP_DOC_SEQUENCE_NUMBER_FROM &LP_DOC_SEQUENCE_NUMBER_TO &LP_INVOICE_DATE_FROM &LP_INVOICE_DATE_TO ORDER BY C_VENDOR, C_VENDOR_SITE, C_INVOICE_NUMBER, C_TRANSACTION_DATE, C_TRANSACTION_TYPE, C_TRANSACTION_DATE2, C_LINE_TYPE_CODE, C_INVOICE_PAYMENT_ID Y SQLAP APXINHIS_XML AR AP تقرير تاريخ الفواتير (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Imported from BI Publisher Description: تقرير تاريخ الفواتير Application: المدفوعات Source: تقرير تاريخ الفواتير (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: APXINHIS_XML DB package: AP_APXINHIS_XMLP_PKG D AP Rechnungshistorie- Nicht unterstützt: Reserviert für zukünftige Verwendung Imported from BI Publisher Description: Rechnungshistorie Application: Kreditoren Source: Rechnungshistorie (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: APXINHIS_XML DB package: AP_APXINHIS_XMLP_PKG E AP Informe Historial de Facturas: No Admitido, Reservado para Uso Futuro Imported from BI Publisher Description: Informe del historial de facturas Application: Payables Source: Informe Historial de Facturas (XML): No Admitido, Reservado para Uso Futuro Short Name: APXINHIS_XML DB package: AP_APXINHIS_XMLP_PKG F AP Etat de l'historique des factures- Non pris en charge : réservé pour une utilisation future Imported from BI Publisher Description: Etat de l'historique des factures Application: Payables Source: Etat de l'historique des factures (XML) - Non pris en charge : réservé pour une utilisation future Short Name: APXINHIS_XML DB package: AP_APXINHIS_XMLP_PKG I AP Rapporto Cronologia fatture- non supportato: riservato per usi futuri Imported from BI Publisher Description: Rapporto Cronologia fatture Application: Payables Source: Rapporto Cronologia fatture (XML) - non supportato: riservato per usi futuri Short Name: APXINHIS_XML DB package: AP_APXINHIS_XMLP_PKG JA AP 請求書履歴レポート- 未サポート: 将来の使用のために予約 Imported from BI Publisher Description: 請求書履歴レポート Application: Payables Source: 請求書履歴レポート(XML) - 未サポート: 将来の使用のために予約 Short Name: APXINHIS_XML DB package: AP_APXINHIS_XMLP_PKG KO AP 송장 내역 보고서- 지원되지 않음: 추후 사용을 위해 예약됨 Imported from BI Publisher Description: 송장 내역 보고서 Application: Payables Source: 송장 내역 보고서(XML) - 지원되지 않음: 추후 사용을 위해 예약됨 Short Name: APXINHIS_XML DB package: AP_APXINHIS_XMLP_PKG PTB AP Relatório do Histórico da NFF- Não Suportado: Reservado Para Uso Futuro Imported from BI Publisher Description: Relatório de Histórico da NFF Application: Payables Source: Relatório do Histórico da NFF (XML) - Não Suportado: Reservado Para Uso Futuro Short Name: APXINHIS_XML DB package: AP_APXINHIS_XMLP_PKG RU AP История счетов-фактур- не поддерживается: зарезервировано для будущего использования Imported from BI Publisher Description: История счетов-фактур Application: Кредиторы Source: История счетов-фактур (XML) - не поддерживается: зарезервировано для будущего использования Short Name: APXINHIS_XML DB package: AP_APXINHIS_XMLP_PKG S AP Fakturahistorik - rapport- Stöds inte: Reserverad för framtida bruk Imported from BI Publisher Description: Fakturahistorik - rapport Application: Payables Source: Fakturahistorik - rapport (XML) - Stöds inte: Reserverad för framtida bruk Short Name: APXINHIS_XML DB package: AP_APXINHIS_XMLP_PKG TR AP Fatura Tarihçesi Raporu- Desteklenmez: Gelecekte Kullanım İçin Ayrılmıştır Imported from BI Publisher Description: Fatura Tarihçesi Raporu Application: Borçlar Muhasebesi Source: Fatura Tarihçesi Raporu (XML) - Desteklenmez: Gelecekte Kullanım İçin Ayrılmıştır Short Name: APXINHIS_XML DB package: AP_APXINHIS_XMLP_PKG US AP Invoice History Report- Not Supported: Reserved For Future Use Imported from BI Publisher Description: Invoice History Report Application: Payables Source: Invoice History Report (XML) - Not Supported: Reserved For Future Use Short Name: APXINHIS_XML DB package: AP_APXINHIS_XMLP_PKG ZHS AP 发票历史记录报表- 不支持：已保留供将来使用 Imported from BI Publisher Description: 发票历史记录报表 Application: 应付帐款 Source: 发票历史记录报表 (XML) - 不支持：已保留供将来使用 Short Name: APXINHIS_XML DB package: AP_APXINHIS_XMLP_PKG BI Publisher &lp_doc_sequence_name &lp_doc_sequence_number_from &lp_doc_sequence_number_to &lp_invoice_date_from &lp_invoice_date_to &lp_invoices &lp_invoices_number_from &lp_invoices_number_to &lp_vendor_id &lp_vendor_site :c_nls_all :c_nls_end_of_report :c_nls_no :c_nls_no_data_exists :c_nls_yes :c_open_balance_amt :c_prepay_amt_f :c_total_invoice_amount_sum :c_total_invoice_amt_curr :c_total_payment_amount_sum :c_total_payment_amt_curr :c_total_prepay_amt :c_total_prepay_amt_sum :c_transaction_amt1_dummy_sum :c_transaction_type3 :c_trx_amount_sum :h_company_name :h_functional_currency :lp_doc_sequence_name :lp_doc_sequence_number_from :lp_doc_sequence_number_to :lp_invoice_date_from :lp_invoice_date_to :lp_invoices :lp_invoices_number_from :lp_invoices_number_to :lp_vendor_id :lp_vendor_site :operating_unit :p_allinvoices :p_book :p_conc_request_id :p_debug_switch :p_doc_sequence_name :p_doc_sequence_number_from :p_doc_sequence_number_to :p_invoice_date_from :p_invoice_date_from_t :p_invoice_date_to :p_invoice_date_to_t :p_invoices :p_invoices_number_from :p_invoices_number_to :p_min_precision :p_prepayment :p_trace_switch :p_vendor_id :p_vendor_name :p_vendor_site :struct_num 1 -20 :p_book Number fnd_profile.value('GL_SET_OF_BKS_ID') Y AR معرف دفتر الأستاذ معرف دفتر الأستاذ D Buchkennung Buchkennung E Id Libro Mayor Identificador de libro mayor F ID livre ID livre I Id libro contabile Id del libro contabile JA 元帳ID 元帳ID KO 원장 ID 원장 ID PTB Id do Razão Id do Razão RU Идентификатор книги Идентификатор книги S Huvudboks-id Huvudboks-id TR Defter No Defter No US Ledger Id Ledger Id 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_vendor_id LOV Oracle AP_SRS_VENDOR_NAME Y select vendor_id id, vendor_name value, null description from po_vendors order by value,description AR اسم المورد اسم المورد D Lieferantenname Lieferantenname E Nombre de Proveedor Nombre de Proveedor F Nom du fournisseur Nom du fournisseur I Nome fornitore Nome del fornitore JA 仕入先名 仕入先名 KO 공급자명 공급자명 PTB Nome do Fornecedor Nome do Fornecedor RU Имя поставщика Имя поставщика S Leverantör Leverantör TR Tedarikçi Adı Tedarikçi Adı US Supplier Name Supplier Name ZHS 供应商名称 供应商名称 4 20 :p_vendor_site LOV Oracle AP_SRS_APXINHIS_VENDOR_SITE Y select pvs.vendor_site_code id, pvs.vendor_site_code value, null description from po_vendor_sites pvs,po_vendors pv where pvs.vendor_id=pv.vendor_id and pv.vendor_id=:$flex$.ap_srs_vendor_name order by vendor_site_code AR موقع المورد موقع المورد D Lieferantenadresse Lieferantenadresse E Dirección del Proveedor Dirección de Proveedor F Site fournisseur Site fournisseur I Sede fornitore Sede del fornitore JA 仕入先サイト 仕入先サイト KO 공급자 지점 공급자 지점 PTB Local do Fornecedor Local do Fornecedor RU Отделение поставщика Отделение поставщика S Leverantörsplats Leverantörsplats TR Tedarikçi İşletme Birimi Tedarikçi İşletme Birimi US Supplier Site Supplier Site ZHS 供应商地点 供应商地点 5 30 :p_invoices 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 AR الدفعات المقدمة فقط الدفعات المقدمة فقط D Nur Vorauszahlungen Nur Vorauszahlungen E Sólo Anticipos Sólo Anticipos F Acomptes uniquement Acomptes uniquement I Solo anticipi Solo anticipi JA 前払金のみ 前払金のみ KO 선급금만 선급금만 PTB Apenas Pagamentos Antecipados Apenas Pagamentos Antecipados RU Только предоплата Только предоплата S Endast förskott Endast förskott TR Salt Ön ödemeler Salt Ön ödemeler US Prepayments Only Prepayments Only ZHS 仅限于预付款 仅限于预付款 6 40 :p_invoices_number_from Char AR رقم الفاتورة من رقم الفاتورة من D Von Rechnungsnummer Von Rechnungsnummer E De Número de Factura De Número de Factura F Numéro de facture - De Numéro de facture - De I Numero fattura - Da Numero fattura - Da JA 請求書番号 自 請求書番号 自 KO 송장 번호: 부터 송장 번호: 부터 PTB Número da NFF - De Número da NFF - De RU Начальный номер счета-фактуры Начальный номер счета-фактуры S Från fakturanummer Från fakturanummer TR Fatura Numarası, İlk Fatura Numarası, İlk US Invoice Number From Invoice Number From ZHS 发票编号自 发票编号自 7 50 :p_invoices_number_to Char AR رقم الفاتورة إلى رقم الفاتورة إلى D Bis Rechnungsnummer Bis Rechnungsnummer E A Número de Factura A Número de Factura F Numéro de facture - A Numéro de facture - A I Numero fattura - A Numero fattura - A JA 請求書番号 至 請求書番号 至 KO 송장 번호: 까지 송장 번호: 까지 PTB Número da NFF - Até Número da NFF - Até RU Конечный номер счета-фактуры Конечный номер счета-фактуры S Till fakturanummer Till fakturanummer TR Son Fatura Numarası Son Fatura Numarası US Invoice Number To Invoice Number To ZHS 发票编号至 发票编号至 8 60 :p_doc_sequence_name LOV Oracle AP_SRS_INV_SEQUENCES Y select name id, name value, null description from fnd_document_sequences fds where application_id=200 and (table_name='AP_INVOICES' or table_name='AP_INVOICES_ALL') and exists (select 'CURRENT SOB' from fnd_doc_sequence_assignments fdsa, ap_system_parameters asp where fdsa.doc_sequence_id=fds.doc_sequence_id and (fdsa.set_of_books_id is null or fdsa.set_of_books_id=asp.set_of_books_id)) order by value,description AR اسم المسلسل اسم المسلسل D Folge Folge E Nombre de Secuencia Nombre de Secuencia F Code journal Code journal I Nome sequenza Nome della sequenza JA 連番名 連番名 KO 순서명 순서명 PTB Nome da Sequência Nome da Sequência RU Имя последовательности Имя последовательности S Sekvensnamn Sekvensnamn TR Sıra Adı Sıra Adı US Sequence Name Sequence Name ZHS 序列名 序列名 9 70 :p_doc_sequence_number_from Number AR رقم الإيصال من رقم الإيصال من D Von Belegnummer Von Belegnummer E De Número de Justificante De Número de Justificante F Numéro de pièce - De Numéro de pièce - De I Numero giustificativo - Da Numero giustificativo - Da JA 証憑番号:自 証憑番号:自 KO 증빙 번호: 부터 증빙 번호: 부터 PTB Nr. do Voucher De Nr. do Voucher De RU № квитанции с № квитанции с S Från verifikatnummer Från verifikatnummer TR İlk Makbuz Numarası İlk Makbuz Numarası US Voucher Number From Voucher Number From ZHS 凭证编号自 凭证编号自 10 80 :p_doc_sequence_number_to Number AR رقم الإيصال إلى رقم الإيصال إلى D Bis Belegnummer Bis Belegnummer E A Número de Justificante A Número de Justificante F Numéro de pièce - A Numéro de pièce - A I Numero giustificativo - A Numero giustificativo - A JA 証憑番号:至 証憑番号:至 KO 증빙 번호: 까지 증빙 번호: 까지 PTB Número do Voucher - Até Número do Voucher - Até RU Конечный номер квитанции Конечный номер квитанции S Till verifikatnummer Till verifikatnummer TR Son Makbuz Numarası Son Makbuz Numarası US Voucher Number To Voucher Number To ZHS 凭证编号至 凭证编号至 11 90 :p_invoice_date_from Date AR من تاريخ الفاتورة تاريخ بداية الفاتورة D Von Rechnungsdatum Von Rechnungsdatum E De Fecha de Factura De Fecha de Factura F Date de facture - Du Date début facture I Data fattura - Da Data della fattura iniziale JA 請求書日付:自 開始請求書日付 KO 송장 일자:부터 송장 시작 일자 PTB Data da NFF - De Data da NFF Inicial RU Дата счета-фактуры с Начальная дата счета-фактуры S Från fakturadatum Från fakturadatum TR Fatura Başlangıç Tarihi İlk Fatura Tarihi US From Invoice Date Begin Invoice Date ZHS 自发票日期 发票起始日期 12 100 :p_invoice_date_to Date AR إلى تاريخ الفاتورة تاريخ نهاية الفاتورة D Bis Rechnungsdatum Bis Rechnungsdatum E A Fecha de Factura A Fecha de Factura F Date de facture - Au Date de fin facture I Data fattura - A Data della fattura finale JA 請求日:至 終了請求書日付 KO 송장 일자:까지 송장 종료 일자 PTB Data da NFF - Até Data da NFF Final RU Дата счета-фактуры по Конечная дата счета-фактуры S Till fakturadatum Sista fakturadatum TR Fatura Bitiş Tarihi Son Fatura Tarihi US To Invoice Date End Invoice Date ZHS 至发票日期 终止发票日期