APPS.JGRX_WT dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 481: from ap_invoice_distributions_all ind

477: l_amount NUMBER := 0;
478: begin
479: select sum(nvl(ind.base_amount,ind.amount))
480: into l_amount
481: from ap_invoice_distributions_all ind
482: where ind.invoice_id = jgrx_wt.var.invoice_id
483: and ind.line_type_lookup_code = 'AWT'
484: and ind.org_id = jgrx_wt.var.org_id;
485: jgrx_wt.var.net_amount:= jgrx_wt.var.invoice_amount + l_amount;

Line 879: ap_invoice_distributions_all ind,

875: BEGIN
876: -- Assign the FROM clause
877: fa_rx_util_pkg.debug('jgrx_wt.construct_from()-');
878: fa_rx_util_pkg.From_clause := 'ap_invoices_all ap_inv,
879: ap_invoice_distributions_all ind,
880: po_vendors pov,
881: po_vendors pv1,
882: po_vendor_sites_all pvs,
883: ap_tax_codes_all atc,