DBA Data[Home] [Help]

APPS.AP_MATCHING_UTILS_PKG dependencies on AP_INVOICE_PAYMENTS

Line 1261: ap_invoice_payments aip

1257: max(aip.accounting_date) prepayment_payment_date
1258: FROM ap_invoices ai,
1259: ap_invoice_lines ail,
1260: po_line_locations pll,
1261: ap_invoice_payments aip
1262: WHERE ai.invoice_id = ail.invoice_id
1263: AND ail.po_line_id = p_po_line_id
1264: AND ai.invoice_type_lookup_code = 'PREPAYMENT'
1265: AND ail.line_type_lookup_code = 'ITEM'