how will you find out check no's for a particular invoice
Answer Posted / muneer
in front end:
Payment 'document numbers' displaying in the payment window.
in back end:
> select ac.check_num
from ap_invoices_all aia
,ap_invoice_payments_all aip
,ap_checks_all ac
where aia.invoice_id=aip.invoice_id
and aip.check_id=ac.check_id
and aia.invoice_number='xxxxxxxx';
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Write Test Scripts for a telecummunication project on the basis of priority with some examples with regard to AP,GL,FA.
explain your project plan with exam pal? i am preparing inter view .............
How to Reconciliation AP to CM ? How to Reconciliation AR to CM ?
encumbrence set ups?
what is the difference between before pages trigger and after parameter trigger in reports ?
I am working on PPR process to print checks. Currently the checks are printing for each supplier, supplier site and payment method group. My requirement is the invoice level one DFF is available (like A and B are the input values). Please let me know how include this DFF at invoice grouping level.
What are register in India localisation?
Do you track and record relationships between customers e.g. franchises, subsidiaries etc.?
What is the db number of a particular customer TCA?
What is the use of gl set of books name, while configure multiorg?
what is the meaning of purchase default and what are the types
SLA usage ans how to define setups?
Explain about Localization (IND & US ) in Oracle Apps ?
Provide an overview of AR cash receipt processing.
What is the Invoicing System in Oracle R12