ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 203E8CE5C5A06502E0630100007FC2F4 select -- payment batch gsob.name set_of_books, aisc.checkrun_name payment_batch_name, aisc.bank_account_name bank_account, acs.name payment_document, trunc(aisc.check_date) payment_date, xxen_util.meaning(aisc.status,'CHECK BATCH STATUS',200) payment_batch_status, xxen_util.meaning(aisc.document_order_lookup_code,'DOCUMENT ORDER',200) document_order, aisc.max_outlay maximum_outlay, aisc.max_payment_amount maximum_payment, aisc.min_check_amount minimum_payment, xxen_util.meaning(aisc.payment_method_lookup_code,'PAYMENT METHOD',200) payment_method, xxen_util.meaning(aisc.pay_only_when_due_flag,'YES_NO',0) pay_only_when_due, aisc.pay_thru_date pay_through_date, xxen_util.meaning(aisc.zero_amounts_allowed,'YES_NO',0) zero_payments_allowed, xxen_util.meaning(aisc.zero_invoices_allowed,'YES_NO',0) zero_invoices_allowed, aba.currency_code bank_account_currency, aisc.currency_code payment_batch_currency, aisc.vendor_pay_group pay_group, aisc.low_payment_priority priority_range_low, aisc.hi_payment_priority priority_range_high, gdct.user_conversion_type exchange_rate_type, aisc.exchange_rate exchange_rate, -- payment batch totals sum(ac.amount) over (partition by aisc.checkrun_name) payment_batch_total, sum(decode(ac.status_lookup_code,'SET UP',1,0)) over (partition by aisc.checkrun_name) setup_document_count, sum(decode(ac.status_lookup_code,'OVERFLOW',1,0)) over (partition by aisc.checkrun_name) overflow_documnent_count, sum(decode(ac.status_lookup_code,'SPOILED',0, 'SET UP', 0, 'OVERFLOW',0,1)) over (partition by aisc.checkrun_name) negotiable_document_count, -- checks ac.check_number document_number, nvl(ac.doc_sequence_value,ac.check_voucher_num) voucher_number, xxen_util.meaning(ac.status_lookup_code,'CHECK STATE',200) document_status, decode(ac.status_lookup_code, 'SET UP',xxen_util.meaning(ac.status_lookup_code,'CHECK STATE',200), ac.vendor_name) supplier_name, decode(ac.status_lookup_code, 'SET UP',xxen_util.meaning(ac.status_lookup_code,'CHECK STATE',200), ac.vendor_site_code) supplier_site, decode(ac.status_lookup_code, 'SET UP',xxen_util.meaning(ac.status_lookup_code,'CHECK STATE',200), ac.address_line1) address1, decode(ac.status_lookup_code,'SET UP','',ac.address_line2) address2, decode(ac.status_lookup_code,'SET UP','',ac.address_line3) address3, decode(ac.status_lookup_code,'SET UP','',ac.city) city, decode(ac.status_lookup_code,'SET UP','',ac.state) state, decode(ac.status_lookup_code,'SET UP','', ac.zip) zip, decode(ac.status_lookup_code,'SET UP','',ac.province) province, decode(ac.status_lookup_code,'SET UP','',ft.territory_short_name) territory, nvl(ac.bank_account_num, aba2.bank_account_num) supplier_bank_account, ac.amount document_amount from ap_invoice_selection_criteria aisc, ap_check_stocks acs, ap_bank_accounts aba, ap_system_parameters asp, gl_sets_of_books gsob, gl_daily_conversion_types gdct, -- ap_checks ac, fnd_territories_vl ft, ap_bank_accounts aba2 where 1=1 and aisc.status = 'CONFIRMED' and acs.check_stock_id = aisc.check_stock_id and aba.bank_account_id = acs.bank_account_id and asp.set_of_books_id = gsob.set_of_books_id and gdct.conversion_type(+) = aisc.exchange_rate_type and -- aisc.checkrun_name = ac.checkrun_name (+) and ac.country = ft.territory_code(+) and ac.external_bank_account_id = aba2.bank_account_id(+) order by gsob.name, aisc.check_date, aisc.checkrun_name, ac.check_number Y :Payment_Batch is not null or :Payment_Date_From is not null or :Payment_Date_To is not null AR AP مسجل السداد النهائي Imported from Concurrent Program Application: المدفوعات Source: مسجل السداد النهائي Short Name: APXPBFPR D AP Zahlungsliste - endgültig Imported from Concurrent Program Application: Kreditoren Source: Zahlungsliste - endgültig Short Name: APXPBFPR E AP Registro Final de Pagos Imported from Concurrent Program Application: Payables Source: Registro Final de Pagos Short Name: APXPBFPR F AP Registre des règlements effectués Imported from Concurrent Program Application: Payables Source: Registre des règlements effectués Short Name: APXPBFPR I AP Registro pagamenti finali Imported from Concurrent Program Description: Registro dei pagamenti finali Application: Payables Source: Registro pagamenti finali Short Name: APXPBFPR JA AP 最終支払台帳 Imported from Concurrent Program Application: Payables Source: 最終支払台帳 Short Name: APXPBFPR KO AP 최종 지급 등록 Imported from Concurrent Program Application: Payables Source: 최종 지급 등록 Short Name: APXPBFPR PTB AP Registro de Pagamento Final Imported from Concurrent Program Application: Payables Source: Registro de Pagamento Final Short Name: APXPBFPR RU AP Конечный реестр платежей Imported from Concurrent Program Application: Кредиторы Source: Конечный реестр платежей Short Name: APXPBFPR S AP Register över slutbetalningar Imported from Concurrent Program Application: Payables Source: Register över slutbetalningar Short Name: APXPBFPR TR AP Son Ödeme Kayıt Listesi Imported from Concurrent Program Application: Borçlar Muhasebesi Source: Son Ödeme Kayıt Listesi Short Name: APXPBFPR US AP Final Payment Register 11i Imported from Concurrent Program Application: Payables Source: Final Payment Register Short Name: APXPBFPR ZHS AP 最终付款登记 Imported from Concurrent Program Application: 应付帐款 Source: 最终付款登记 Short Name: APXPBFPR Enginatics 1=1 1 10 1=1 aisc.checkrun_name = :p_checkrun_name LOV Oracle AP_SRS_FINAL_PAYBATCH Y select checkrun_name id, checkrun_name value, null description from ap_invoice_selection_criteria where status='CONFIRMED' order by value,description AR مجموعة السداد اسم مجموعة السداد D Zahlungslauf Bezeichnung Zahlungslauf E Lote de Pagos Nombre de Lote de Pagos F Lot de règlements Nom du lot de règlements I Batch di pagamenti Nome del batch di pagamenti JA 支払バッチ 支払バッチ名 KO 지급 뱃치 지급 뱃치명 PTB Lote Pagtos. Nome do Lote de Pagamentos RU Пакет платежей Имя пакета платежей S Betalningsbunt Betalningsbuntnamn TR Ödeme İşlem Grubu Ödeme İşlem Grubu Adı US Payment Batch Payment Batch Name ZHS 付款批 付款批名称 2 20 1=1 aisc.check_date >= trunc(:payment_date_from) Date US Payment Date From 3 30 1=1 aisc.check_date < trunc(:payment_date_to) + 1 Date last_day(:$flex$.payment_date_from) US Payment Date To :$flex$.payment_date_from Payment Date From Y Payment Date To