121: icip.address_line3,
122: icip.zip,
123: icip.pmt_vch_received_date
124: FROM
125: ap_invoices ai, igi_cis_ci36_payments icip
126: WHERE
127: ai.invoice_id = icip.invoice_id;
128:
129:
229: ac.check_date,
230: aag.group_id
231: FROM
232: igi_cis_invoice_payments icip,
233: ap_invoices ai,
234: ap_awt_groups aag,
235: ap_checks ac
236: WHERE ai.payment_status_flag = 'Y'
237: AND ai.invoice_id = icip.invoice_id