APPS.AP_INVOICE_DISTRIBUTIONS_PKG dependencies on AP_INVOICES_ALL

Line 1276: l_org_id ap_invoices_all.org_id%type;

1272: l_round_amt_exists BOOLEAN := FALSE;
1273: l_rounded_amt NUMBER;
1274: --Bug 4539462 DBI logging
1275: l_dbi_key_value_list ap_dbi_pkg.r_dbi_key_value_arr;
1276: l_org_id ap_invoices_all.org_id%type;
1277:
1278: l_base_amt NUMBER; --6892789
1279: l_modified_dist_rounding_amt NUMBER; --6892789
1280: l_round_dist_id_list AP_INVOICE_LINES_PKG.distribution_id_tab_type; --6892789

Line 3589: FROM ap_invoices_all i1, ap_invoice_distributions_all d3

3585: (SELECT d5.invoice_id, MAX(d5.distribution_line_number)
3586: FROM ap_invoice_distributions_all d5
3587: WHERE (d5.invoice_id, abs(d5.amount)) IN
3588: (SELECT i1.invoice_id , MAX(ABS(d3.amount))
3589: FROM ap_invoices_all i1, ap_invoice_distributions_all d3
3590: WHERE i1.invoice_id = X_Invoice_Id
3591: AND i1.invoice_id = d3.invoice_id
3592: AND d3.line_type_lookup_code <> 'TAX'
3593: AND NOT EXISTS

Line 3846: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;

3842: debug_context VARCHAR2(2000);
3843: l_dist_code_concat VARCHAR2(2000);
3844: l_invoice_distribution_id
3845: ap_invoice_distributions.invoice_distribution_id%TYPE;
3846: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;
3847: l_sys_link_function VARCHAR2(2); /* Bug 5102724 */
3848: l_web_parameter_id number; --Bug5003249
3849: l_employee_ccid number;
3850: l_message_text fnd_new_messages.message_text%type;

Line 4053: FROM ap_invoices_all

4049: /* Bug 5102724 */
4050: BEGIN
4051: SELECT invoice_type_lookup_code
4052: INTO l_invoice_type_lookup_code
4053: FROM ap_invoices_all
4054: WHERE invoice_id = X_invoice_id;
4055: EXCEPTION
4056: WHEN no_data_found then
4057: NULL;

Line 4820: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;

4816: l_vendor_id AP_INVOICES.VENDOR_ID%TYPE;
4817: current_calling_sequence VARCHAR2(200);
4818: debug_context VARCHAR2(2000);
4819: debug_info VARCHAR2(100);
4820: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;
4821: l_sys_link_function VARCHAR2(2); /* Bug 5102724 */
4822: l_web_parameter_id number; --Bug5003249
4823: l_employee_ccid number;
4824: l_message_text fnd_new_messages.message_text%TYPE;

Line 4912: FROM ap_invoices_all

4908: /* Bug 5102724 */
4909: BEGIN
4910: SELECT invoice_type_lookup_code
4911: INTO l_invoice_type_lookup_code
4912: FROM ap_invoices_all
4913: WHERE invoice_id = X_invoice_id;
4914: EXCEPTION
4915: WHEN no_data_found then
4916: NULL;

Line 5626: ap_invoices_all ai

5622: 'Y', (SUM(NVL(ail.amount, 0)) + SUM(NVL(retained_amount,0))),
5623: SUM(ail.amount) )
5624: INTO l_sum_lines_amount
5625: FROM ap_invoice_lines_all ail,
5626: ap_invoices_all ai
5627: WHERE ai.invoice_id = ail.invoice_id
5628: AND ail.invoice_id = X_invoice_id
5629: AND ail.line_type_lookup_code NOT IN ('AWT')
5630: /*bugfix:5685469*/

Line 6843: FROM ap_invoices_all AI,

6839: D.dist_match_type, -- l_dist_match_type
6840: D.corrected_invoice_dist_id, -- l_corrected_invoice_dist_id
6841: D.corrected_quantity, -- l_corrected_quantity
6842: PLL.matching_basis -- l_match_basis /* Amount Based Matching */
6843: FROM ap_invoices_all AI,
6844: ap_system_parameters_all ASP,
6845: ap_invoice_distributions D,
6846: po_distributions PD,
6847: po_lines PL,