eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_ISP_UTILITIES_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 1981: FROM ap_invoice_distributions_all

1977: rcv_transaction_id,
1978: amount,
1979: quantity_invoiced,
1980: pa_quantity
1981: FROM ap_invoice_distributions_all
1982: WHERE invoice_id = p_invoice_id
1983: AND invoice_line_number = p_line_number;
1984:
1985: l_po_distribution_id PO_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE;

Line 2023: FROM ap_invoice_distributions_all

2019:
2020:
2021: SELECT sum(quantity_invoiced),sum(amount)
2022: INTO l_total_quantity_billed,l_total_amount_billed
2023: FROM ap_invoice_distributions_all
2024: WHERE invoice_id = p_invoice_id
2025: AND invoice_line_number = p_line_number;
2026:
2027: SELECT matching_basis

Line 2137: UPDATE ap_invoice_distributions_all

2133: p_amount_recouped => NULL,
2134: p_retainage_withheld_amt => NULL,
2135: p_retainage_released_amt => NULL);
2136:
2137: UPDATE ap_invoice_distributions_all
2138: SET amount = amount - nvl(x_dist_tab(i).update_amount,0),
2139: quantity_invoiced = quantity_invoiced - nvl(x_dist_tab(i).update_quantity,0),
2140: pa_quantity = pa_quantity - nvl(x_dist_tab(i).update_pa_quantity,0)
2141: WHERE invoice_distribution_id = x_dist_tab(i).invoice_distribution_id;