DBA Data[Home] [Help]

APPS.JL_BR_AP_PAY_SCHED_GDF_PKG dependencies on AP_INVOICE_RELATIONSHIPS

Line 474: ap_invoice_relationships rel,

470:
471: select sum(nvl(int.invoice_amount,0))
472: into int_amt
473: from ap_invoices_all int,
474: ap_invoice_relationships rel,
475: iby_docs_payable_all iby
476: where rel.original_invoice_id = iby.calling_app_doc_unique_ref2 -- ap.invoice_id
477: and rel.original_payment_num = iby.calling_app_doc_unique_ref3 -- ap.payment_num
478: and int.invoice_id = rel.related_invoice_id