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_INVOICE_CORRECTIONS_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 610: ap_invoice_distributions_s.nextval

606: round ((((x_line_amount - x_included_tax_amount) * aid.amount/p_proration_total)/
607: g_min_acct_unit) * g_min_acct_unit)
608: ) ,
609:
610: ap_invoice_distributions_s.nextval
611: FROM ap_invoice_lines ail,
612: ap_invoice_distributions aid
613: WHERE ail.invoice_id = x_corrected_invoice_id
614: AND ail.line_number = x_corrected_line_number

Line 612: ap_invoice_distributions aid

608: ) ,
609:
610: ap_invoice_distributions_s.nextval
611: FROM ap_invoice_lines ail,
612: ap_invoice_distributions aid
613: WHERE ail.invoice_id = x_corrected_invoice_id
614: AND ail.line_number = x_corrected_line_number
615: AND aid.invoice_id = ail.invoice_id
616: AND aid.invoice_line_number = ail.line_number

Line 621: l_corrected_inv_dist_id ap_invoice_distributions.invoice_distribution_id%TYPE;

617: -- Bug 5597409. Add the restriction for Item distribution only
618: AND aid.line_type_lookup_code = 'ITEM'
619: AND aid.prepay_distribution_id IS NULL;
620:
621: l_corrected_inv_dist_id ap_invoice_distributions.invoice_distribution_id%TYPE;
622: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
623: l_amount ap_invoice_distributions.amount%TYPE;
624: l_max_dist_amount ap_invoice_distributions.amount%TYPE := 0;
625: l_rounding_index ap_invoice_distributions.invoice_distribution_id%TYPE;

Line 622: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;

618: AND aid.line_type_lookup_code = 'ITEM'
619: AND aid.prepay_distribution_id IS NULL;
620:
621: l_corrected_inv_dist_id ap_invoice_distributions.invoice_distribution_id%TYPE;
622: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
623: l_amount ap_invoice_distributions.amount%TYPE;
624: l_max_dist_amount ap_invoice_distributions.amount%TYPE := 0;
625: l_rounding_index ap_invoice_distributions.invoice_distribution_id%TYPE;
626: l_sum_prorated_amount ap_invoice_distributions.amount%TYPE := 0;

Line 623: l_amount ap_invoice_distributions.amount%TYPE;

619: AND aid.prepay_distribution_id IS NULL;
620:
621: l_corrected_inv_dist_id ap_invoice_distributions.invoice_distribution_id%TYPE;
622: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
623: l_amount ap_invoice_distributions.amount%TYPE;
624: l_max_dist_amount ap_invoice_distributions.amount%TYPE := 0;
625: l_rounding_index ap_invoice_distributions.invoice_distribution_id%TYPE;
626: l_sum_prorated_amount ap_invoice_distributions.amount%TYPE := 0;
627: l_base_amount ap_invoice_distributions.base_amount%TYPE := 0;

Line 624: l_max_dist_amount ap_invoice_distributions.amount%TYPE := 0;

620:
621: l_corrected_inv_dist_id ap_invoice_distributions.invoice_distribution_id%TYPE;
622: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
623: l_amount ap_invoice_distributions.amount%TYPE;
624: l_max_dist_amount ap_invoice_distributions.amount%TYPE := 0;
625: l_rounding_index ap_invoice_distributions.invoice_distribution_id%TYPE;
626: l_sum_prorated_amount ap_invoice_distributions.amount%TYPE := 0;
627: l_base_amount ap_invoice_distributions.base_amount%TYPE := 0;
628: l_sum_base_amount ap_invoice_distributions.base_amount%TYPE := 0;

Line 625: l_rounding_index ap_invoice_distributions.invoice_distribution_id%TYPE;

621: l_corrected_inv_dist_id ap_invoice_distributions.invoice_distribution_id%TYPE;
622: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
623: l_amount ap_invoice_distributions.amount%TYPE;
624: l_max_dist_amount ap_invoice_distributions.amount%TYPE := 0;
625: l_rounding_index ap_invoice_distributions.invoice_distribution_id%TYPE;
626: l_sum_prorated_amount ap_invoice_distributions.amount%TYPE := 0;
627: l_base_amount ap_invoice_distributions.base_amount%TYPE := 0;
628: l_sum_base_amount ap_invoice_distributions.base_amount%TYPE := 0;
629: i NUMBER;

Line 626: l_sum_prorated_amount ap_invoice_distributions.amount%TYPE := 0;

622: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
623: l_amount ap_invoice_distributions.amount%TYPE;
624: l_max_dist_amount ap_invoice_distributions.amount%TYPE := 0;
625: l_rounding_index ap_invoice_distributions.invoice_distribution_id%TYPE;
626: l_sum_prorated_amount ap_invoice_distributions.amount%TYPE := 0;
627: l_base_amount ap_invoice_distributions.base_amount%TYPE := 0;
628: l_sum_base_amount ap_invoice_distributions.base_amount%TYPE := 0;
629: i NUMBER;
630: l_debug_info VARCHAR2(100);

Line 627: l_base_amount ap_invoice_distributions.base_amount%TYPE := 0;

623: l_amount ap_invoice_distributions.amount%TYPE;
624: l_max_dist_amount ap_invoice_distributions.amount%TYPE := 0;
625: l_rounding_index ap_invoice_distributions.invoice_distribution_id%TYPE;
626: l_sum_prorated_amount ap_invoice_distributions.amount%TYPE := 0;
627: l_base_amount ap_invoice_distributions.base_amount%TYPE := 0;
628: l_sum_base_amount ap_invoice_distributions.base_amount%TYPE := 0;
629: i NUMBER;
630: l_debug_info VARCHAR2(100);
631: current_calling_sequence VARCHAR2(2000);

Line 628: l_sum_base_amount ap_invoice_distributions.base_amount%TYPE := 0;

624: l_max_dist_amount ap_invoice_distributions.amount%TYPE := 0;
625: l_rounding_index ap_invoice_distributions.invoice_distribution_id%TYPE;
626: l_sum_prorated_amount ap_invoice_distributions.amount%TYPE := 0;
627: l_base_amount ap_invoice_distributions.base_amount%TYPE := 0;
628: l_sum_base_amount ap_invoice_distributions.base_amount%TYPE := 0;
629: i NUMBER;
630: l_debug_info VARCHAR2(100);
631: current_calling_sequence VARCHAR2(2000);
632: l_api_name VARCHAR2(30);

Line 762: FROM ap_invoice_distributions_all aid

758: l_debug_info := 'Get the total dist proration total';
759:
760: SELECT sum(aid.amount)
761: INTO l_dist_total
762: FROM ap_invoice_distributions_all aid
763: WHERE aid.invoice_id = x_corrected_invoice_id
764: AND aid.invoice_line_number = x_corrected_line_number
765: AND aid.line_type_lookup_code = 'ITEM' -- Bug 5597409. Restrict to 'ITEM' type only
766: AND aid.prepay_distribution_id IS NULL;

Line 1319: l_rounded_index ap_invoice_distributions.invoice_distribution_id%type;

1315: X_Calling_Sequence IN VARCHAR2) IS
1316: l_distribution_line_number NUMBER := 1;
1317: l_rounding_amount NUMBER;
1318: l_sum_prorated_amount NUMBER := 0;
1319: l_rounded_index ap_invoice_distributions.invoice_distribution_id%type;
1320: i NUMBER;
1321: l_max_dist_amount NUMBER := 0;
1322: l_max_distribution_id ap_invoice_distributions.invoice_distribution_id%type;
1323: l_debug_info VARCHAR2(100);

Line 1322: l_max_distribution_id ap_invoice_distributions.invoice_distribution_id%type;

1318: l_sum_prorated_amount NUMBER := 0;
1319: l_rounded_index ap_invoice_distributions.invoice_distribution_id%type;
1320: i NUMBER;
1321: l_max_dist_amount NUMBER := 0;
1322: l_max_distribution_id ap_invoice_distributions.invoice_distribution_id%type;
1323: l_debug_info VARCHAR2(100);
1324: current_calling_sequence VARCHAR2(2000);
1325: l_api_name VARCHAR2(30);
1326:

Line 1352: INSERT INTO ap_invoice_distributions(

1348: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1349: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1350: END IF;
1351:
1352: INSERT INTO ap_invoice_distributions(
1353: batch_id,
1354: invoice_id,
1355: invoice_line_number,
1356: invoice_distribution_id,

Line 1511: ap_invoice_distributions_s.nextval), --invoice_distribution_id

1507: SELECT g_batch_id, --batch_id
1508: x_invoice_id, --invoice_id
1509: x_invoice_line_number, --invoice_line_number
1510: NVL(x_dist_tab(i).invoice_distribution_id,
1511: ap_invoice_distributions_s.nextval), --invoice_distribution_id
1512: l_distribution_line_number, --distribution_line_number
1513: aid.line_type_lookup_code, --line_type_lookup_code
1514: ail.item_description, --description
1515: 'DIST_CORRECTION', --dist_match_type

Line 1671: FROM ap_invoice_distributions aid,

1667: NULL, --request_id
1668: --ETAX: Invwkb
1669: aid.intended_use, --intended_use
1670: 'N'
1671: FROM ap_invoice_distributions aid,
1672: ap_invoice_lines ail,
1673: gl_code_combinations gcc
1674: WHERE ail.invoice_id = x_invoice_id
1675: AND ail.line_number = x_invoice_line_number