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_MATCHING_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 1097: l_amount_invoiced ap_invoice_distributions_all.amount%TYPE;

1093:
1094:
1095: l_total_quantity number;
1096: l_po_distribution_id po_distributions_all.po_distribution_id%TYPE;
1097: l_amount_invoiced ap_invoice_distributions_all.amount%TYPE;
1098: l_quantity_invoiced ap_invoice_distributions_all.quantity_invoiced%TYPE;
1099: l_po_dist_ccid po_distributions.code_combination_id%TYPE;
1100: l_accrue_on_receipt_flag po_distributions.accrue_on_receipt_flag%TYPE;
1101: l_project_id po_distributions.project_id%TYPE;

Line 1098: l_quantity_invoiced ap_invoice_distributions_all.quantity_invoiced%TYPE;

1094:
1095: l_total_quantity number;
1096: l_po_distribution_id po_distributions_all.po_distribution_id%TYPE;
1097: l_amount_invoiced ap_invoice_distributions_all.amount%TYPE;
1098: l_quantity_invoiced ap_invoice_distributions_all.quantity_invoiced%TYPE;
1099: l_po_dist_ccid po_distributions.code_combination_id%TYPE;
1100: l_accrue_on_receipt_flag po_distributions.accrue_on_receipt_flag%TYPE;
1101: l_project_id po_distributions.project_id%TYPE;
1102: l_unbuilt_flex varchar2(240):='';

Line 1104: l_dist_ccid ap_invoice_distributions_all.dist_code_combination_id%TYPE;

1100: l_accrue_on_receipt_flag po_distributions.accrue_on_receipt_flag%TYPE;
1101: l_project_id po_distributions.project_id%TYPE;
1102: l_unbuilt_flex varchar2(240):='';
1103: l_reason_unbuilt_flex varchar2(2000):='';
1104: l_dist_ccid ap_invoice_distributions_all.dist_code_combination_id%TYPE;
1105: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
1106: l_task_id po_distributions.task_id%TYPE;
1107: l_award_set_id po_distributions_all.award_id%TYPE;
1108: l_expenditure_type po_distributions.expenditure_type%TYPE;

Line 3613: FROM ap_invoice_distributions_all

3609:
3610: BEGIN
3611: SELECT nvl(sum(amount),0) -- Bug 5629985. Added the NVL
3612: INTO l_price_variance
3613: FROM ap_invoice_distributions_all
3614: WHERE invoice_id = x_corrected_invoice_id
3615: AND invoice_line_number = x_corrected_line_number
3616: AND line_type_lookup_code = 'IPV';
3617: EXCEPTION