DBA Data[Home] [Help]

APPS.JAI_AP_TDS_PROCESSING_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 409: ap_invoice_distributions_all aida,

405: aida_prepayment.invoice_id prepay_invoice_id ,
406: -1 * sum(aida.amount) prepaid_amount
407: from
408: ap_invoices_all aia,
409: ap_invoice_distributions_all aida,
410: ap_invoice_distributions_all aida_prepayment
411: where aia.invoice_id = aida.invoice_id
412: and aida.prepay_distribution_id = aida_prepayment.invoice_distribution_id
413: and aida.line_type_lookup_code = lv_line_type_lookup_code

Line 410: ap_invoice_distributions_all aida_prepayment

406: -1 * sum(aida.amount) prepaid_amount
407: from
408: ap_invoices_all aia,
409: ap_invoice_distributions_all aida,
410: ap_invoice_distributions_all aida_prepayment
411: where aia.invoice_id = aida.invoice_id
412: and aida.prepay_distribution_id = aida_prepayment.invoice_distribution_id
413: and aida.line_type_lookup_code = lv_line_type_lookup_code
414: and aia.source = lv_source