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

Line 2029: FROM ap_invoices_all

2025: ||'Original Invoice';
2026: ---------------------------------------------------------------------------
2027: SELECT NVL(exchange_rate, 1)
2028: INTO l_original_exchange_rate
2029: FROM ap_invoices_all
2030: WHERE invoice_id = p_lines_rec.invoice_id;
2031:
2032: --------------------------------------------------------------------------
2033: debug_info := 'Reverse_Redistribute_IPV Step 3. Check IF Erv Dists Exist';

Line 2797: FROM ap_invoices_all

2793: ||'Original Invoice';
2794: ---------------------------------------------------------------------------
2795: SELECT exchange_rate
2796: INTO l_original_exchange_rate
2797: FROM ap_invoices_all
2798: WHERE invoice_id = p_lines_rec.invoice_id;
2799:
2800:
2801: --------------------------------------------------------------------------

Line 5250: l_vendor_id AP_INVOICES_ALL.vendor_id%TYPE;

5246: AND instr_status_flag = 'Y';
5247:
5248: l_ppa_invoice_id NUMBER;
5249:
5250: l_vendor_id AP_INVOICES_ALL.vendor_id%TYPE;
5251: l_vendor_site_id AP_INVOICES_ALL.vendor_site_id%TYPE;
5252: l_payment_cross_rate AP_INVOICES_ALL.payment_cross_rate%TYPE;
5253: l_invoice_currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE;
5254: l_payment_currency_code AP_INVOICES_ALL.payment_currency_code%TYPE;

Line 5251: l_vendor_site_id AP_INVOICES_ALL.vendor_site_id%TYPE;

5247:
5248: l_ppa_invoice_id NUMBER;
5249:
5250: l_vendor_id AP_INVOICES_ALL.vendor_id%TYPE;
5251: l_vendor_site_id AP_INVOICES_ALL.vendor_site_id%TYPE;
5252: l_payment_cross_rate AP_INVOICES_ALL.payment_cross_rate%TYPE;
5253: l_invoice_currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE;
5254: l_payment_currency_code AP_INVOICES_ALL.payment_currency_code%TYPE;
5255: l_payment_cross_rate_date AP_INVOICES_ALL.payment_cross_rate_date%TYPE;

Line 5252: l_payment_cross_rate AP_INVOICES_ALL.payment_cross_rate%TYPE;

5248: l_ppa_invoice_id NUMBER;
5249:
5250: l_vendor_id AP_INVOICES_ALL.vendor_id%TYPE;
5251: l_vendor_site_id AP_INVOICES_ALL.vendor_site_id%TYPE;
5252: l_payment_cross_rate AP_INVOICES_ALL.payment_cross_rate%TYPE;
5253: l_invoice_currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE;
5254: l_payment_currency_code AP_INVOICES_ALL.payment_currency_code%TYPE;
5255: l_payment_cross_rate_date AP_INVOICES_ALL.payment_cross_rate_date%TYPE;
5256: l_invoice_type_lookup_code AP_INVOICES_ALL.invoice_type_lookup_code%TYPE;

Line 5253: l_invoice_currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE;

5249:
5250: l_vendor_id AP_INVOICES_ALL.vendor_id%TYPE;
5251: l_vendor_site_id AP_INVOICES_ALL.vendor_site_id%TYPE;
5252: l_payment_cross_rate AP_INVOICES_ALL.payment_cross_rate%TYPE;
5253: l_invoice_currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE;
5254: l_payment_currency_code AP_INVOICES_ALL.payment_currency_code%TYPE;
5255: l_payment_cross_rate_date AP_INVOICES_ALL.payment_cross_rate_date%TYPE;
5256: l_invoice_type_lookup_code AP_INVOICES_ALL.invoice_type_lookup_code%TYPE;
5257: l_payment_method_code iby_payment_methods_vl.payment_method_code%TYPE;

Line 5254: l_payment_currency_code AP_INVOICES_ALL.payment_currency_code%TYPE;

5250: l_vendor_id AP_INVOICES_ALL.vendor_id%TYPE;
5251: l_vendor_site_id AP_INVOICES_ALL.vendor_site_id%TYPE;
5252: l_payment_cross_rate AP_INVOICES_ALL.payment_cross_rate%TYPE;
5253: l_invoice_currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE;
5254: l_payment_currency_code AP_INVOICES_ALL.payment_currency_code%TYPE;
5255: l_payment_cross_rate_date AP_INVOICES_ALL.payment_cross_rate_date%TYPE;
5256: l_invoice_type_lookup_code AP_INVOICES_ALL.invoice_type_lookup_code%TYPE;
5257: l_payment_method_code iby_payment_methods_vl.payment_method_code%TYPE;
5258: l_amt_applicable_to_discount AP_INVOICES_ALL.amount_applicable_to_discount%TYPE;

Line 5255: l_payment_cross_rate_date AP_INVOICES_ALL.payment_cross_rate_date%TYPE;

5251: l_vendor_site_id AP_INVOICES_ALL.vendor_site_id%TYPE;
5252: l_payment_cross_rate AP_INVOICES_ALL.payment_cross_rate%TYPE;
5253: l_invoice_currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE;
5254: l_payment_currency_code AP_INVOICES_ALL.payment_currency_code%TYPE;
5255: l_payment_cross_rate_date AP_INVOICES_ALL.payment_cross_rate_date%TYPE;
5256: l_invoice_type_lookup_code AP_INVOICES_ALL.invoice_type_lookup_code%TYPE;
5257: l_payment_method_code iby_payment_methods_vl.payment_method_code%TYPE;
5258: l_amt_applicable_to_discount AP_INVOICES_ALL.amount_applicable_to_discount%TYPE;
5259: l_invoice_amount AP_INVOICES_ALL.invoice_amount%TYPE;

Line 5256: l_invoice_type_lookup_code AP_INVOICES_ALL.invoice_type_lookup_code%TYPE;

5252: l_payment_cross_rate AP_INVOICES_ALL.payment_cross_rate%TYPE;
5253: l_invoice_currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE;
5254: l_payment_currency_code AP_INVOICES_ALL.payment_currency_code%TYPE;
5255: l_payment_cross_rate_date AP_INVOICES_ALL.payment_cross_rate_date%TYPE;
5256: l_invoice_type_lookup_code AP_INVOICES_ALL.invoice_type_lookup_code%TYPE;
5257: l_payment_method_code iby_payment_methods_vl.payment_method_code%TYPE;
5258: l_amt_applicable_to_discount AP_INVOICES_ALL.amount_applicable_to_discount%TYPE;
5259: l_invoice_amount AP_INVOICES_ALL.invoice_amount%TYPE;
5260: l_base_amount AP_INVOICES_ALL.base_amount%TYPE;

Line 5258: l_amt_applicable_to_discount AP_INVOICES_ALL.amount_applicable_to_discount%TYPE;

5254: l_payment_currency_code AP_INVOICES_ALL.payment_currency_code%TYPE;
5255: l_payment_cross_rate_date AP_INVOICES_ALL.payment_cross_rate_date%TYPE;
5256: l_invoice_type_lookup_code AP_INVOICES_ALL.invoice_type_lookup_code%TYPE;
5257: l_payment_method_code iby_payment_methods_vl.payment_method_code%TYPE;
5258: l_amt_applicable_to_discount AP_INVOICES_ALL.amount_applicable_to_discount%TYPE;
5259: l_invoice_amount AP_INVOICES_ALL.invoice_amount%TYPE;
5260: l_base_amount AP_INVOICES_ALL.base_amount%TYPE;
5261: l_exclusive_payment_flag AP_INVOICES_ALL.exclusive_payment_flag%TYPE;
5262: l_terms_id AP_INVOICES_ALL.terms_id%TYPE;

Line 5259: l_invoice_amount AP_INVOICES_ALL.invoice_amount%TYPE;

5255: l_payment_cross_rate_date AP_INVOICES_ALL.payment_cross_rate_date%TYPE;
5256: l_invoice_type_lookup_code AP_INVOICES_ALL.invoice_type_lookup_code%TYPE;
5257: l_payment_method_code iby_payment_methods_vl.payment_method_code%TYPE;
5258: l_amt_applicable_to_discount AP_INVOICES_ALL.amount_applicable_to_discount%TYPE;
5259: l_invoice_amount AP_INVOICES_ALL.invoice_amount%TYPE;
5260: l_base_amount AP_INVOICES_ALL.base_amount%TYPE;
5261: l_exclusive_payment_flag AP_INVOICES_ALL.exclusive_payment_flag%TYPE;
5262: l_terms_id AP_INVOICES_ALL.terms_id%TYPE;
5263: l_terms_date AP_INVOICES_ALL.terms_date%TYPE;

Line 5260: l_base_amount AP_INVOICES_ALL.base_amount%TYPE;

5256: l_invoice_type_lookup_code AP_INVOICES_ALL.invoice_type_lookup_code%TYPE;
5257: l_payment_method_code iby_payment_methods_vl.payment_method_code%TYPE;
5258: l_amt_applicable_to_discount AP_INVOICES_ALL.amount_applicable_to_discount%TYPE;
5259: l_invoice_amount AP_INVOICES_ALL.invoice_amount%TYPE;
5260: l_base_amount AP_INVOICES_ALL.base_amount%TYPE;
5261: l_exclusive_payment_flag AP_INVOICES_ALL.exclusive_payment_flag%TYPE;
5262: l_terms_id AP_INVOICES_ALL.terms_id%TYPE;
5263: l_terms_date AP_INVOICES_ALL.terms_date%TYPE;
5264: l_batch_id AP_INVOICES_ALL.batch_id%TYPE;

Line 5261: l_exclusive_payment_flag AP_INVOICES_ALL.exclusive_payment_flag%TYPE;

5257: l_payment_method_code iby_payment_methods_vl.payment_method_code%TYPE;
5258: l_amt_applicable_to_discount AP_INVOICES_ALL.amount_applicable_to_discount%TYPE;
5259: l_invoice_amount AP_INVOICES_ALL.invoice_amount%TYPE;
5260: l_base_amount AP_INVOICES_ALL.base_amount%TYPE;
5261: l_exclusive_payment_flag AP_INVOICES_ALL.exclusive_payment_flag%TYPE;
5262: l_terms_id AP_INVOICES_ALL.terms_id%TYPE;
5263: l_terms_date AP_INVOICES_ALL.terms_date%TYPE;
5264: l_batch_id AP_INVOICES_ALL.batch_id%TYPE;
5265:

Line 5262: l_terms_id AP_INVOICES_ALL.terms_id%TYPE;

5258: l_amt_applicable_to_discount AP_INVOICES_ALL.amount_applicable_to_discount%TYPE;
5259: l_invoice_amount AP_INVOICES_ALL.invoice_amount%TYPE;
5260: l_base_amount AP_INVOICES_ALL.base_amount%TYPE;
5261: l_exclusive_payment_flag AP_INVOICES_ALL.exclusive_payment_flag%TYPE;
5262: l_terms_id AP_INVOICES_ALL.terms_id%TYPE;
5263: l_terms_date AP_INVOICES_ALL.terms_date%TYPE;
5264: l_batch_id AP_INVOICES_ALL.batch_id%TYPE;
5265:
5266: l_pay_curr_invoice_amount NUMBER;

Line 5263: l_terms_date AP_INVOICES_ALL.terms_date%TYPE;

5259: l_invoice_amount AP_INVOICES_ALL.invoice_amount%TYPE;
5260: l_base_amount AP_INVOICES_ALL.base_amount%TYPE;
5261: l_exclusive_payment_flag AP_INVOICES_ALL.exclusive_payment_flag%TYPE;
5262: l_terms_id AP_INVOICES_ALL.terms_id%TYPE;
5263: l_terms_date AP_INVOICES_ALL.terms_date%TYPE;
5264: l_batch_id AP_INVOICES_ALL.batch_id%TYPE;
5265:
5266: l_pay_curr_invoice_amount NUMBER;
5267: l_payment_priority NUMBER;

Line 5264: l_batch_id AP_INVOICES_ALL.batch_id%TYPE;

5260: l_base_amount AP_INVOICES_ALL.base_amount%TYPE;
5261: l_exclusive_payment_flag AP_INVOICES_ALL.exclusive_payment_flag%TYPE;
5262: l_terms_id AP_INVOICES_ALL.terms_id%TYPE;
5263: l_terms_date AP_INVOICES_ALL.terms_date%TYPE;
5264: l_batch_id AP_INVOICES_ALL.batch_id%TYPE;
5265:
5266: l_pay_curr_invoice_amount NUMBER;
5267: l_payment_priority NUMBER;
5268: l_invoice_amount_limit NUMBER;

Line 5376: debug_info := 'Insert_Ppa_Invoices Step 3. Insert into AP_INVOICES_ALL, l_ppa_invoice_id is'||l_ppa_invoice_id;

5372: WHERE vendor_id = l_vendor_id
5373: AND vendor_site_id = l_vendor_site_id;
5374: --
5375: ------------------------------------------------------------------------
5376: debug_info := 'Insert_Ppa_Invoices Step 3. Insert into AP_INVOICES_ALL, l_ppa_invoice_id is'||l_ppa_invoice_id;
5377: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') then
5378: AP_IMPORT_UTILITIES_PKG.Print(
5379: AP_IMPORT_INVOICES_PKG.g_debug_switch,debug_info);
5380: END IF;

Line 5386: INSERT INTO ap_invoices_All(

5382: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5383: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,debug_info);
5384: END IF;
5385: ------------------------------------------------------------------------
5386: INSERT INTO ap_invoices_All(
5387: accts_pay_code_combination_id,
5388: amount_applicable_to_discount,
5389: approval_ready_flag,
5390: attribute_category,

Line 6214: UPDATE ap_invoices_all

6210: WHERE instruction_id = p_instruction_id
6211: AND invoice_id = l_ppa_invoice_id;
6212:
6213: -- Bug 5525506
6214: UPDATE ap_invoices_all
6215: set invoice_amount = (select sum(amount)
6216: from ap_invoice_lines_all
6217: where invoice_id = l_ppa_invoice_id)
6218: where invoice_id = l_ppa_invoice_id;