ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F1633869E053B46B63588994 select i.invoice_num , ps.payment_num,ps.due_date,ps.gross_amount,curr.currency_code,fnd.meaning,pov.vendor_name, bank.bank_name,bank.bank_branch_name,acc.bank_account_num bank_account_num from ap_invoices i, ap_payment_schedules ps, FND_CURRENCIES_VL curr, po_vendors pov, FND_LOOKUPS fnd,ce_bank_branches_v bank, iby_payee_all_bankacct_v acc where (fnd.lookup_type = 'YES_NO' and fnd.lookup_code = ps.hold_flag) and ps.invoice_id = i.invoice_id and i.vendor_id = pov.vendor_id and i.invoice_currency_code= curr.currency_code and ps.payment_status_flag <> 'Y' and ps.global_attribute11 is null and ps.external_bank_account_id = acc.ext_bank_account_id (+) and acc.branch_id = bank.branch_party_id (+) and acc.bank_id = bank.bank_party_id (+) and invoice_num between nvl(:p_inv_num_ini , invoice_num) and nvl(:p_inv_num_fin, invoice_num) and due_date between nvl(:p_due_date_ini, due_date) and nvl( :p_due_date_fin ,due_date) and gross_amount between nvl( :p_gross_amt_ini ,gross_amount) and nvl(:p_gross_amt_fin, gross_amount) order by :p_inv_sort Y JL JLBRPCDN_XML US JL Brazilian Payables Non-Associated Trade Notes and Bank Collection Documents - draft Application: Latin America Localizations Source: Brazilian Payables Non-Associated Trade Notes and Bank Collection Documents Report (XML) - Not Supported: Reserved For Future Use Short Name: JLBRPCDN_XML DB package: JL_JLBRPCDN_XMLP_PKG BI Publisher :c_company_name_header :c_currency_code :operating_unit :p_conc_request_id :p_doc_amount_fin :p_doc_amount_ini :p_doc_docnum_fin :p_doc_docnum_ini :p_doc_duedate_fin :p_doc_duedate_ini :p_docno_sup_date :p_due_date_fin :p_due_date_ini :p_gross_amt_fin :p_gross_amt_ini :p_inv_num_fin :p_inv_num_ini :p_inv_sort :p_set_of_books_id 1 10 :p_sort_by LOV Oracle JLBR_SRS_COLL_DOC_SORT_OPTION Y select lookup_code id, meaning value, null description from fnd_lookups where sysdate between nvl(start_date_active,sysdate-1) and nvl(end_date_active,sysdate+1) and lookup_type='JLBR_SRS_COLL_DOC_SORT_OPTION' order by value,description select meaning from fnd_lookups where lookup_type = 'JLBR_SRS_COLL_DOC_SORT_OPTION' and lookup_code = 'DOCUMENT NUMBER' Y US Sort Documents By 2 20 :p_doc_docnum_ini Char US Collection Document Number Range: From 3 30 :p_doc_docnum_fin Char US Collection Document Number Range: To 4 40 :p_doc_duedate_ini Date US Collection Document Due Date Range: Begin Date 5 50 :p_doc_duedate_fin Date US Collection Document Due Date Range: End Date 6 60 :p_doc_amount_fin Number US Collection Document Amount Range: To 7 70 :p_due_date_ini Date US Invoice Due Date Range: Begin Date 8 80 :p_due_date_fin Date US Invoice Due Date Range: End Date 9 90 :p_gross_amt_ini Number US Invoice Amount Range: From 10 100 :p_gross_amt_fin Number US Invoice Amount Range: To