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_DISTRIBUTIONS_PKG dependencies on AP_INVOICES_ALL

Line 1360: l_org_id ap_invoices_all.org_id%type;

1356: l_round_amt_exists BOOLEAN := FALSE;
1357: l_rounded_amt NUMBER;
1358: --Bug 4539462 DBI logging
1359: l_dbi_key_value_list ap_dbi_pkg.r_dbi_key_value_arr;
1360: l_org_id ap_invoices_all.org_id%type;
1361:
1362: l_base_amt NUMBER; --6892789
1363: l_modified_dist_rounding_amt NUMBER; --6892789
1364: l_round_dist_id_list AP_INVOICE_LINES_PKG.distribution_id_tab_type; --6892789

Line 3758: FROM ap_invoices_all i1, ap_invoice_distributions_all d3

3754: (SELECT d5.invoice_id, MAX(d5.distribution_line_number)
3755: FROM ap_invoice_distributions_all d5
3756: WHERE (d5.invoice_id, abs(d5.amount)) IN
3757: (SELECT i1.invoice_id , MAX(ABS(d3.amount))
3758: FROM ap_invoices_all i1, ap_invoice_distributions_all d3
3759: WHERE i1.invoice_id = X_Invoice_Id
3760: AND i1.invoice_id = d3.invoice_id
3761: AND d3.line_type_lookup_code NOT IN ('NONREC_TAX','REC_TAX','TRV','TERV','TIPV','IPV', 'ERV') -- Bug 11654030 <> 'TAX', Bug 12691958: Added excluding 'IPV' and 'ERV' lines
3762: AND d3.related_id IS NULL -- Bug 13864403

Line 4018: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;

4014: debug_context VARCHAR2(2000);
4015: l_dist_code_concat VARCHAR2(2000);
4016: l_invoice_distribution_id
4017: ap_invoice_distributions.invoice_distribution_id%TYPE;
4018: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;
4019: l_sys_link_function VARCHAR2(2); /* Bug 5102724 */
4020: l_web_parameter_id number; --Bug5003249
4021: l_employee_ccid number;
4022: l_message_text fnd_new_messages.message_text%type;

Line 4332: FROM ap_invoices_all

4328: /* Bug 5102724 */
4329: BEGIN
4330: SELECT invoice_type_lookup_code
4331: INTO l_invoice_type_lookup_code
4332: FROM ap_invoices_all
4333: WHERE invoice_id = X_invoice_id;
4334: EXCEPTION
4335: WHEN no_data_found then
4336: NULL;

Line 5261: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;

5257: debug_info VARCHAR2(2000); --Bug 8725625-Increased width
5258: debug_context VARCHAR2(2000);
5259: l_dist_code_concat VARCHAR2(2000);
5260: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
5261: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;
5262: l_sys_link_function VARCHAR2(2);
5263: l_web_parameter_id number;
5264: l_employee_ccid number;
5265: l_message_text fnd_new_messages.message_text%type;

Line 6103: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;

6099: l_vendor_id AP_INVOICES.VENDOR_ID%TYPE;
6100: current_calling_sequence VARCHAR2(200);
6101: debug_context VARCHAR2(2000);
6102: debug_info VARCHAR2(100);
6103: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;
6104: l_sys_link_function VARCHAR2(2); /* Bug 5102724 */
6105: l_web_parameter_id number; --Bug5003249
6106: l_employee_ccid number;
6107: l_message_text fnd_new_messages.message_text%TYPE;

Line 6260: FROM ap_invoices_all

6256: l_invoice_attribute_rec.attribute12,
6257: l_invoice_attribute_rec.attribute13,
6258: l_invoice_attribute_rec.attribute14,
6259: l_invoice_attribute_rec.attribute15
6260: FROM ap_invoices_all
6261: WHERE invoice_id = X_invoice_id;
6262: EXCEPTION
6263: WHEN no_data_found then
6264: NULL;

Line 7063: ap_invoices_all ai

7059: 'Y', (SUM(NVL(ail.amount, 0)) + SUM(NVL(retained_amount,0))),
7060: SUM(ail.amount) )
7061: INTO l_sum_lines_amount
7062: FROM ap_invoice_lines_all ail,
7063: ap_invoices_all ai
7064: WHERE ai.invoice_id = ail.invoice_id
7065: AND ail.invoice_id = X_invoice_id
7066: AND ail.line_type_lookup_code NOT IN ('AWT')
7067: /*bugfix:5685469*/

Line 8344: FROM ap_invoices_all AI,

8340: D.corrected_invoice_dist_id, -- l_corrected_invoice_dist_id
8341: D.corrected_quantity, -- l_corrected_quantity
8342: PLL.matching_basis, -- l_match_basis /* Amount Based Matching */
8343: ail.line_source --Bug#10416960
8344: FROM ap_invoices_all AI,
8345: ap_system_parameters_all ASP,
8346: ap_invoice_distributions D,
8347: po_distributions PD,
8348: po_lines PL,

Line 8415: FROM ap_invoices_all AI,

8411: D.corrected_invoice_dist_id, -- l_corrected_invoice_dist_id
8412: D.corrected_quantity, -- l_corrected_quantity
8413: PLL.matching_basis, -- l_match_basis /* Amount Based Matching */
8414: NULL --line_source
8415: FROM ap_invoices_all AI,
8416: ap_invoices retain_ai, --bug 9242891 retained invoice
8417: ap_system_parameters_all ASP,
8418: ap_invoice_distributions D,
8419: ap_invoice_distributions retain_d, --bug 9242891 retainage inv dists

Line 8466: FROM AP_INVOICES_ALL ai,

8462:
8463: --bug 9242891 select added to determine which cursor to open.
8464: SELECT COUNT(*)
8465: INTO l_cnt
8466: FROM AP_INVOICES_ALL ai,
8467: AP_INVOICE_DISTRIBUTIONS aid
8468: WHERE aid.Invoice_Distribution_Id = X_DISTRIBUTION_ID
8469: AND ai.invoice_id = aid.invoice_id
8470: AND ai.invoice_type_lookup_code = 'RETAINAGE RELEASE';