DBA Data[Home] [Help]

APPS.AP_MATCHING_UTILS_PKG dependencies on AP_INVOICE_PAYMENTS

Line 1326: ap_invoice_payments aip

1322: max(aip.accounting_date) prepayment_payment_date
1323: FROM ap_invoices ai,
1324: ap_invoice_lines ail,
1325: po_line_locations pll,
1326: ap_invoice_payments aip
1327: WHERE ai.invoice_id = ail.invoice_id
1328: AND ail.po_line_id = p_po_line_id
1329: AND ai.invoice_type_lookup_code = 'PREPAYMENT'
1330: AND ail.line_type_lookup_code = 'ITEM'