DBA Data[Home] [Help]

APPS.JAI_AP_TDS_PROCESSING_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 396: ap_invoice_distributions_all aida,

392: aida_prepayment.invoice_id prepay_invoice_id ,
393: -1 * sum(aida.amount) prepaid_amount
394: from
395: ap_invoices_all aia,
396: ap_invoice_distributions_all aida,
397: ap_invoice_distributions_all aida_prepayment
398: where aia.invoice_id = aida.invoice_id
399: and aida.prepay_distribution_id = aida_prepayment.invoice_distribution_id
400: and aida.line_type_lookup_code = lv_line_type_lookup_code

Line 397: ap_invoice_distributions_all aida_prepayment

393: -1 * sum(aida.amount) prepaid_amount
394: from
395: ap_invoices_all aia,
396: ap_invoice_distributions_all aida,
397: ap_invoice_distributions_all aida_prepayment
398: where aia.invoice_id = aida.invoice_id
399: and aida.prepay_distribution_id = aida_prepayment.invoice_distribution_id
400: and aida.line_type_lookup_code = lv_line_type_lookup_code
401: and aia.source = lv_source