SELECT acct.bank_account_name, acct.bank_account_num, acct.currency_code, acct.multi_currency_allowed_flag multi_curr, acct.payment_multi_currency_flag pmt_mc, pmtdoc.payment_document_name pmt_doc_name, fmt.format_name, pmtdoc.first_available_document_num first_avail_docno, pmtdoc.last_available_document_number last_avail_docno, pmtdoc.last_issued_document_number last_issued_docno, pmtdoc.payment_document_id pmt_doc_id, pmtdoc.internal_bank_account_id, pmtdoc.paper_stock_type, pmtdoc.attached_remittance_stub_flag attchd_stub, pmtdoc.number_of_lines_per_remit_stub lines_per_stub, pmtdoc.format_code, pmtdoc.inactive_date, fu1.user_name created_by, pmtdoc.creation_date, fu2.user_name last_updated_by, pmtdoc.last_update_date, DECODE (inactive_date, NULL, 'Y', 'N') status FROM ce_payment_documents pmtdoc, iby_formats_vl fmt, ce_bank_accounts acct, fnd_user fu1, fnd_user fu2 WHERE pmtdoc.format_code = fmt.format_code AND pmtdoc.internal_bank_account_id = acct.bank_account_id AND pmtdoc.created_by = fu1.user_id AND pmtdoc.last_updated_by = fu2.user_id AND payment_document_name LIKE '%' ORDER BY acct.bank_account_name, pmtdoc.payment_document_name;
Popular Posts
-
AutoInvoice is used to generate invoices from a wide variety of sources. Oracle Applications such as OKS (Contracts), Projects, Order M...
-
Here is query to Fetch QUERY: Supplier Sites - Payment Details. select s.segment1 "Supplier Number...
-
In Oracle R12, we have E-Business Tax module to maintain the Tax Details. Every TAX_RATE_CODE is attached to a TAX_REGIME and in-turn a T...
-
select s.segment1 "Supplier Number", hps.party_site_name "Address Na...
-
HERE IS SQL QUERY RETRIEVES LIST OF JURISDICTIONS' FOR WHICH TAX RATES HAS BEEN DEFINED IN EBTAX SELECT TAX, TAX_JURISDICTIO...
-
SELECT NVL (SUM (ps.amount_due_remaining), 0) total_uncleared_receipts FROM hz_cust_accounts_all cust_acct, ar_payment_schedu...
-
Here is query to get the Cost History fotr particular asset select fb.book_type_code "Book", fa.asset_number...
-
Full retirement asset select asset_id, a.book_type_code from fa_transaction_headers a where transaction_type_code = 'FULL RETIREMENT...
-
SELECT apt.template_id, apt.template_name, ipmv.payment_method_name pmt_method_name, cba.bank_account_name ...
-
If you need to troubleshoot ebTax setup , you should use the Following query . These are retrived from the main E-Business tax tables that...
Recent Posts
Categories
Unordered List
Text Widget
Blog Archive
Powered by Blogger.