DBA Data[Home] [Help]

APPS.GMF_AP_INVOICE_PAYMENTS_INFO dependencies on AP_CHECKS_ALL

Line 22: AP_CHECKS_ALL ach

18: ach.check_number,
19: ach.check_date,
20: ach.payment_method_lookup_code
21: FROM AP_INVOICE_PAYMENTS_ALL aip,
22: AP_CHECKS_ALL ach
23: WHERE aip.invoice_id = NVL(invoiceid,aip.invoice_id)
24: AND aip.payment_num = NVL(paymentnum,aip.payment_num)
25: AND aip.invoice_payment_id=NVL(invoicepaymentid,aip.invoice_payment_id)
26: AND aip.creation_date BETWEEN