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 1178: l_amount_invoiced ap_invoice_distributions_all.amount%TYPE;

1174:
1175:
1176: l_total_quantity number;
1177: l_po_distribution_id po_distributions_all.po_distribution_id%TYPE;
1178: l_amount_invoiced ap_invoice_distributions_all.amount%TYPE;
1179: l_quantity_invoiced ap_invoice_distributions_all.quantity_invoiced%TYPE;
1180: l_po_dist_ccid po_distributions.code_combination_id%TYPE;
1181: l_accrue_on_receipt_flag po_distributions.accrue_on_receipt_flag%TYPE;
1182: l_project_id po_distributions.project_id%TYPE;

Line 1179: l_quantity_invoiced ap_invoice_distributions_all.quantity_invoiced%TYPE;

1175:
1176: l_total_quantity number;
1177: l_po_distribution_id po_distributions_all.po_distribution_id%TYPE;
1178: l_amount_invoiced ap_invoice_distributions_all.amount%TYPE;
1179: l_quantity_invoiced ap_invoice_distributions_all.quantity_invoiced%TYPE;
1180: l_po_dist_ccid po_distributions.code_combination_id%TYPE;
1181: l_accrue_on_receipt_flag po_distributions.accrue_on_receipt_flag%TYPE;
1182: l_project_id po_distributions.project_id%TYPE;
1183: l_unbuilt_flex varchar2(240):='';

Line 1185: l_dist_ccid ap_invoice_distributions_all.dist_code_combination_id%TYPE;

1181: l_accrue_on_receipt_flag po_distributions.accrue_on_receipt_flag%TYPE;
1182: l_project_id po_distributions.project_id%TYPE;
1183: l_unbuilt_flex varchar2(240):='';
1184: l_reason_unbuilt_flex varchar2(2000):='';
1185: l_dist_ccid ap_invoice_distributions_all.dist_code_combination_id%TYPE;
1186: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
1187: l_task_id po_distributions.task_id%TYPE;
1188: l_award_set_id po_distributions_all.award_id%TYPE;
1189: l_expenditure_type po_distributions.expenditure_type%TYPE;

Line 3722: FROM ap_invoice_distributions_all

3718: --Commented for bug#11886930
3719: /* BEGIN
3720: SELECT nvl(sum(amount),0) -- Bug 5629985. Added the NVL
3721: INTO l_price_variance
3722: FROM ap_invoice_distributions_all
3723: WHERE invoice_id = x_corrected_invoice_id
3724: AND invoice_line_number = x_corrected_line_number
3725: AND line_type_lookup_code = 'IPV';
3726: EXCEPTION