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_ALLOCATION_RULES_PKG dependencies on AP_INVOICES

Line 146: l_inv_curr_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;

142: l_generate_dists AP_INVOICE_LINES.GENERATE_DISTS%TYPE;
143: l_line_group_number AP_INVOICE_LINES.LINE_GROUP_NUMBER%TYPE;
144: l_amount_to_prorate AP_INVOICE_LINES.AMOUNT%TYPE;
145: l_total_prorated AP_INVOICE_LINES.AMOUNT%TYPE;
146: l_inv_curr_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;
147: l_count_non_item_lines NUMBER := 0;
148: l_prorating_total NUMBER := 0;
149: l_other_alloc_rules NUMBER;
150: current_calling_sequence VARCHAR2(2000);

Line 171: ap_invoices ai

167: l_line_group_number,
168: l_amount_to_prorate,
169: l_inv_curr_code
170: FROM ap_invoice_lines ail,
171: ap_invoices ai
172: WHERE ail.invoice_id = X_invoice_id
173: AND ail.line_number = x_line_number
174: AND ai.invoice_id = X_invoice_id;
175:

Line 674: l_inv_curr_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;

670: l_alloc_rule NUMBER;
671: l_alloc_rule_lines NUMBER;
672: l_amount_to_prorate AP_INVOICE_LINES.AMOUNT%TYPE;
673: l_total_prorated AP_INVOICE_LINES.AMOUNT%TYPE;
674: l_inv_curr_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;
675: l_rule_type AP_ALLOCATION_RULES.RULE_TYPE%TYPE;
676: l_rule_status AP_ALLOCATION_RULES.STATUS%TYPE;
677: l_prorating_total NUMBER := 0;
678: l_create_alloc_rule VARCHAR2(1) := 'Y';

Line 703: ap_invoices ai

699: INTO l_generate_dists,
700: l_amount_to_prorate,
701: l_inv_curr_code
702: FROM ap_invoice_lines ail,
703: ap_invoices ai
704: WHERE ail.invoice_id = X_invoice_id
705: AND ail.line_number = x_chrg_line_number
706: AND ai.invoice_id = X_invoice_id;
707:

Line 1425: FROM ap_invoices ai, po_vendors pv

1421: X_vendor_name,
1422: X_invoice_num,
1423: X_invoice_currency_code,
1424: l_org_id
1425: FROM ap_invoices ai, po_vendors pv
1426: WHERE ai.invoice_id = X_invoice_id
1427: AND ai.vendor_id = pv.vendor_id;
1428:
1429:

Line 1644: l_inv_curr_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;

1640: l_generate_dists AP_INVOICE_LINES.GENERATE_DISTS%TYPE;
1641: l_alloc_rule NUMBER;
1642: l_amount_to_prorate AP_INVOICE_LINES.AMOUNT%TYPE;
1643: l_total_prorated AP_INVOICE_LINES.AMOUNT%TYPE;
1644: l_inv_curr_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;
1645: l_rule_type AP_ALLOCATION_RULES.RULE_TYPE%TYPE;
1646: l_rule_status AP_ALLOCATION_RULES.STATUS%TYPE;
1647: l_prorating_total NUMBER := 0;
1648: l_prorated_total NUMBER := 0;

Line 1671: ap_invoices ai

1667: INTO l_generate_dists,
1668: l_amount_to_prorate,
1669: l_inv_curr_code
1670: FROM ap_invoice_lines ail,
1671: ap_invoices ai
1672: WHERE ail.invoice_id = X_invoice_id
1673: AND ail.line_number = x_chrg_line_number
1674: AND ai.invoice_id = X_invoice_id;
1675:

Line 1901: l_inv_curr_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;

1897: l_generate_dists AP_INVOICE_LINES.GENERATE_DISTS%TYPE;
1898: l_alloc_rule NUMBER;
1899: l_amount_to_prorate AP_INVOICE_LINES.AMOUNT%TYPE;
1900: l_total_prorated AP_INVOICE_LINES.AMOUNT%TYPE;
1901: l_inv_curr_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;
1902: l_rule_type AP_ALLOCATION_RULES.RULE_TYPE%TYPE;
1903: l_rule_status AP_ALLOCATION_RULES.STATUS%TYPE;
1904: l_prorating_total NUMBER := 0;
1905: l_prorated_total NUMBER := 0;

Line 1928: ap_invoices ai

1924: INTO l_generate_dists,
1925: l_amount_to_prorate,
1926: l_inv_curr_code
1927: FROM ap_invoice_lines ail,
1928: ap_invoices ai
1929: WHERE ail.invoice_id = X_invoice_id
1930: AND ail.line_number = x_chrg_line_number
1931: AND ai.invoice_id = X_invoice_id;
1932:

Line 2087: l_inv_curr_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;

2083: l_generate_dists AP_INVOICE_LINES.GENERATE_DISTS%TYPE;
2084: l_line_group_number AP_INVOICE_LINES.LINE_GROUP_NUMBER%TYPE;
2085: l_amount_to_prorate AP_INVOICE_LINES.AMOUNT%TYPE;
2086: l_total_prorated AP_INVOICE_LINES.AMOUNT%TYPE;
2087: l_inv_curr_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;
2088: l_count_non_item_lines NUMBER := 0;
2089: l_prorating_total NUMBER := 0;
2090: l_other_alloc_rules NUMBER;
2091: l_other_alloc_rule_line NUMBER;

Line 2115: ap_invoices ai

2111: l_line_group_number,
2112: l_amount_to_prorate,
2113: l_inv_curr_code
2114: FROM ap_invoice_lines ail,
2115: ap_invoices ai
2116: WHERE ail.invoice_id = x_invoice_id
2117: AND ail.line_number = x_chrg_line_number
2118: AND ai.invoice_id = ail.invoice_id;
2119: