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 2111: FROM ap_invoices_all

2107: ||'Original Invoice';
2108: ---------------------------------------------------------------------------
2109: SELECT NVL(exchange_rate, 1)
2110: INTO l_original_exchange_rate
2111: FROM ap_invoices_all
2112: WHERE invoice_id = p_lines_rec.invoice_id;
2113:
2114: --------------------------------------------------------------------------
2115: debug_info := 'Reverse_Redistribute_IPV Step 3. Check IF Erv Dists Exist';

Line 3043: FROM ap_invoices_all

3039: ||'Original Invoice';
3040: ---------------------------------------------------------------------------
3041: SELECT exchange_rate
3042: INTO l_original_exchange_rate
3043: FROM ap_invoices_all
3044: WHERE invoice_id = p_lines_rec.invoice_id;
3045:
3046:
3047: --------------------------------------------------------------------------

Line 5605: l_vendor_id AP_INVOICES_ALL.vendor_id%TYPE;

5601: AND instr_status_flag = 'Y';
5602:
5603: l_ppa_invoice_id NUMBER;
5604:
5605: l_vendor_id AP_INVOICES_ALL.vendor_id%TYPE;
5606: l_vendor_site_id AP_INVOICES_ALL.vendor_site_id%TYPE;
5607: l_payment_cross_rate AP_INVOICES_ALL.payment_cross_rate%TYPE;
5608: l_invoice_currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE;
5609: l_payment_currency_code AP_INVOICES_ALL.payment_currency_code%TYPE;

Line 5606: l_vendor_site_id AP_INVOICES_ALL.vendor_site_id%TYPE;

5602:
5603: l_ppa_invoice_id NUMBER;
5604:
5605: l_vendor_id AP_INVOICES_ALL.vendor_id%TYPE;
5606: l_vendor_site_id AP_INVOICES_ALL.vendor_site_id%TYPE;
5607: l_payment_cross_rate AP_INVOICES_ALL.payment_cross_rate%TYPE;
5608: l_invoice_currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE;
5609: l_payment_currency_code AP_INVOICES_ALL.payment_currency_code%TYPE;
5610: l_payment_cross_rate_date AP_INVOICES_ALL.payment_cross_rate_date%TYPE;

Line 5607: l_payment_cross_rate AP_INVOICES_ALL.payment_cross_rate%TYPE;

5603: l_ppa_invoice_id NUMBER;
5604:
5605: l_vendor_id AP_INVOICES_ALL.vendor_id%TYPE;
5606: l_vendor_site_id AP_INVOICES_ALL.vendor_site_id%TYPE;
5607: l_payment_cross_rate AP_INVOICES_ALL.payment_cross_rate%TYPE;
5608: l_invoice_currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE;
5609: l_payment_currency_code AP_INVOICES_ALL.payment_currency_code%TYPE;
5610: l_payment_cross_rate_date AP_INVOICES_ALL.payment_cross_rate_date%TYPE;
5611: l_invoice_type_lookup_code AP_INVOICES_ALL.invoice_type_lookup_code%TYPE;

Line 5608: l_invoice_currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE;

5604:
5605: l_vendor_id AP_INVOICES_ALL.vendor_id%TYPE;
5606: l_vendor_site_id AP_INVOICES_ALL.vendor_site_id%TYPE;
5607: l_payment_cross_rate AP_INVOICES_ALL.payment_cross_rate%TYPE;
5608: l_invoice_currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE;
5609: l_payment_currency_code AP_INVOICES_ALL.payment_currency_code%TYPE;
5610: l_payment_cross_rate_date AP_INVOICES_ALL.payment_cross_rate_date%TYPE;
5611: l_invoice_type_lookup_code AP_INVOICES_ALL.invoice_type_lookup_code%TYPE;
5612: l_payment_method_code iby_payment_methods_vl.payment_method_code%TYPE;

Line 5609: l_payment_currency_code AP_INVOICES_ALL.payment_currency_code%TYPE;

5605: l_vendor_id AP_INVOICES_ALL.vendor_id%TYPE;
5606: l_vendor_site_id AP_INVOICES_ALL.vendor_site_id%TYPE;
5607: l_payment_cross_rate AP_INVOICES_ALL.payment_cross_rate%TYPE;
5608: l_invoice_currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE;
5609: l_payment_currency_code AP_INVOICES_ALL.payment_currency_code%TYPE;
5610: l_payment_cross_rate_date AP_INVOICES_ALL.payment_cross_rate_date%TYPE;
5611: l_invoice_type_lookup_code AP_INVOICES_ALL.invoice_type_lookup_code%TYPE;
5612: l_payment_method_code iby_payment_methods_vl.payment_method_code%TYPE;
5613: l_amt_applicable_to_discount AP_INVOICES_ALL.amount_applicable_to_discount%TYPE;

Line 5610: l_payment_cross_rate_date AP_INVOICES_ALL.payment_cross_rate_date%TYPE;

5606: l_vendor_site_id AP_INVOICES_ALL.vendor_site_id%TYPE;
5607: l_payment_cross_rate AP_INVOICES_ALL.payment_cross_rate%TYPE;
5608: l_invoice_currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE;
5609: l_payment_currency_code AP_INVOICES_ALL.payment_currency_code%TYPE;
5610: l_payment_cross_rate_date AP_INVOICES_ALL.payment_cross_rate_date%TYPE;
5611: l_invoice_type_lookup_code AP_INVOICES_ALL.invoice_type_lookup_code%TYPE;
5612: l_payment_method_code iby_payment_methods_vl.payment_method_code%TYPE;
5613: l_amt_applicable_to_discount AP_INVOICES_ALL.amount_applicable_to_discount%TYPE;
5614: l_invoice_amount AP_INVOICES_ALL.invoice_amount%TYPE;

Line 5611: l_invoice_type_lookup_code AP_INVOICES_ALL.invoice_type_lookup_code%TYPE;

5607: l_payment_cross_rate AP_INVOICES_ALL.payment_cross_rate%TYPE;
5608: l_invoice_currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE;
5609: l_payment_currency_code AP_INVOICES_ALL.payment_currency_code%TYPE;
5610: l_payment_cross_rate_date AP_INVOICES_ALL.payment_cross_rate_date%TYPE;
5611: l_invoice_type_lookup_code AP_INVOICES_ALL.invoice_type_lookup_code%TYPE;
5612: l_payment_method_code iby_payment_methods_vl.payment_method_code%TYPE;
5613: l_amt_applicable_to_discount AP_INVOICES_ALL.amount_applicable_to_discount%TYPE;
5614: l_invoice_amount AP_INVOICES_ALL.invoice_amount%TYPE;
5615: l_base_amount AP_INVOICES_ALL.base_amount%TYPE;

Line 5613: l_amt_applicable_to_discount AP_INVOICES_ALL.amount_applicable_to_discount%TYPE;

5609: l_payment_currency_code AP_INVOICES_ALL.payment_currency_code%TYPE;
5610: l_payment_cross_rate_date AP_INVOICES_ALL.payment_cross_rate_date%TYPE;
5611: l_invoice_type_lookup_code AP_INVOICES_ALL.invoice_type_lookup_code%TYPE;
5612: l_payment_method_code iby_payment_methods_vl.payment_method_code%TYPE;
5613: l_amt_applicable_to_discount AP_INVOICES_ALL.amount_applicable_to_discount%TYPE;
5614: l_invoice_amount AP_INVOICES_ALL.invoice_amount%TYPE;
5615: l_base_amount AP_INVOICES_ALL.base_amount%TYPE;
5616: l_exclusive_payment_flag AP_INVOICES_ALL.exclusive_payment_flag%TYPE;
5617: l_terms_id AP_INVOICES_ALL.terms_id%TYPE;

Line 5614: l_invoice_amount AP_INVOICES_ALL.invoice_amount%TYPE;

5610: l_payment_cross_rate_date AP_INVOICES_ALL.payment_cross_rate_date%TYPE;
5611: l_invoice_type_lookup_code AP_INVOICES_ALL.invoice_type_lookup_code%TYPE;
5612: l_payment_method_code iby_payment_methods_vl.payment_method_code%TYPE;
5613: l_amt_applicable_to_discount AP_INVOICES_ALL.amount_applicable_to_discount%TYPE;
5614: l_invoice_amount AP_INVOICES_ALL.invoice_amount%TYPE;
5615: l_base_amount AP_INVOICES_ALL.base_amount%TYPE;
5616: l_exclusive_payment_flag AP_INVOICES_ALL.exclusive_payment_flag%TYPE;
5617: l_terms_id AP_INVOICES_ALL.terms_id%TYPE;
5618: l_terms_date AP_INVOICES_ALL.terms_date%TYPE;

Line 5615: l_base_amount AP_INVOICES_ALL.base_amount%TYPE;

5611: l_invoice_type_lookup_code AP_INVOICES_ALL.invoice_type_lookup_code%TYPE;
5612: l_payment_method_code iby_payment_methods_vl.payment_method_code%TYPE;
5613: l_amt_applicable_to_discount AP_INVOICES_ALL.amount_applicable_to_discount%TYPE;
5614: l_invoice_amount AP_INVOICES_ALL.invoice_amount%TYPE;
5615: l_base_amount AP_INVOICES_ALL.base_amount%TYPE;
5616: l_exclusive_payment_flag AP_INVOICES_ALL.exclusive_payment_flag%TYPE;
5617: l_terms_id AP_INVOICES_ALL.terms_id%TYPE;
5618: l_terms_date AP_INVOICES_ALL.terms_date%TYPE;
5619: l_batch_id AP_INVOICES_ALL.batch_id%TYPE;

Line 5616: l_exclusive_payment_flag AP_INVOICES_ALL.exclusive_payment_flag%TYPE;

5612: l_payment_method_code iby_payment_methods_vl.payment_method_code%TYPE;
5613: l_amt_applicable_to_discount AP_INVOICES_ALL.amount_applicable_to_discount%TYPE;
5614: l_invoice_amount AP_INVOICES_ALL.invoice_amount%TYPE;
5615: l_base_amount AP_INVOICES_ALL.base_amount%TYPE;
5616: l_exclusive_payment_flag AP_INVOICES_ALL.exclusive_payment_flag%TYPE;
5617: l_terms_id AP_INVOICES_ALL.terms_id%TYPE;
5618: l_terms_date AP_INVOICES_ALL.terms_date%TYPE;
5619: l_batch_id AP_INVOICES_ALL.batch_id%TYPE;
5620: l_set_of_books_id AP_INVOICES_ALL.set_of_books_id%TYPE;

Line 5617: l_terms_id AP_INVOICES_ALL.terms_id%TYPE;

5613: l_amt_applicable_to_discount AP_INVOICES_ALL.amount_applicable_to_discount%TYPE;
5614: l_invoice_amount AP_INVOICES_ALL.invoice_amount%TYPE;
5615: l_base_amount AP_INVOICES_ALL.base_amount%TYPE;
5616: l_exclusive_payment_flag AP_INVOICES_ALL.exclusive_payment_flag%TYPE;
5617: l_terms_id AP_INVOICES_ALL.terms_id%TYPE;
5618: l_terms_date AP_INVOICES_ALL.terms_date%TYPE;
5619: l_batch_id AP_INVOICES_ALL.batch_id%TYPE;
5620: l_set_of_books_id AP_INVOICES_ALL.set_of_books_id%TYPE;
5621: l_org_id AP_INVOICES_ALL.org_id%TYPE;

Line 5618: l_terms_date AP_INVOICES_ALL.terms_date%TYPE;

5614: l_invoice_amount AP_INVOICES_ALL.invoice_amount%TYPE;
5615: l_base_amount AP_INVOICES_ALL.base_amount%TYPE;
5616: l_exclusive_payment_flag AP_INVOICES_ALL.exclusive_payment_flag%TYPE;
5617: l_terms_id AP_INVOICES_ALL.terms_id%TYPE;
5618: l_terms_date AP_INVOICES_ALL.terms_date%TYPE;
5619: l_batch_id AP_INVOICES_ALL.batch_id%TYPE;
5620: l_set_of_books_id AP_INVOICES_ALL.set_of_books_id%TYPE;
5621: l_org_id AP_INVOICES_ALL.org_id%TYPE;
5622: l_doc_category_code AP_INVOICES_ALL.doc_category_code%TYPE;

Line 5619: l_batch_id AP_INVOICES_ALL.batch_id%TYPE;

5615: l_base_amount AP_INVOICES_ALL.base_amount%TYPE;
5616: l_exclusive_payment_flag AP_INVOICES_ALL.exclusive_payment_flag%TYPE;
5617: l_terms_id AP_INVOICES_ALL.terms_id%TYPE;
5618: l_terms_date AP_INVOICES_ALL.terms_date%TYPE;
5619: l_batch_id AP_INVOICES_ALL.batch_id%TYPE;
5620: l_set_of_books_id AP_INVOICES_ALL.set_of_books_id%TYPE;
5621: l_org_id AP_INVOICES_ALL.org_id%TYPE;
5622: l_doc_category_code AP_INVOICES_ALL.doc_category_code%TYPE;
5623: l_doc_sequence_id AP_INVOICES_ALL.doc_sequence_id%TYPE;

Line 5620: l_set_of_books_id AP_INVOICES_ALL.set_of_books_id%TYPE;

5616: l_exclusive_payment_flag AP_INVOICES_ALL.exclusive_payment_flag%TYPE;
5617: l_terms_id AP_INVOICES_ALL.terms_id%TYPE;
5618: l_terms_date AP_INVOICES_ALL.terms_date%TYPE;
5619: l_batch_id AP_INVOICES_ALL.batch_id%TYPE;
5620: l_set_of_books_id AP_INVOICES_ALL.set_of_books_id%TYPE;
5621: l_org_id AP_INVOICES_ALL.org_id%TYPE;
5622: l_doc_category_code AP_INVOICES_ALL.doc_category_code%TYPE;
5623: l_doc_sequence_id AP_INVOICES_ALL.doc_sequence_id%TYPE;
5624: l_doc_sequence_value AP_INVOICES_ALL.doc_sequence_value%TYPE;

Line 5621: l_org_id AP_INVOICES_ALL.org_id%TYPE;

5617: l_terms_id AP_INVOICES_ALL.terms_id%TYPE;
5618: l_terms_date AP_INVOICES_ALL.terms_date%TYPE;
5619: l_batch_id AP_INVOICES_ALL.batch_id%TYPE;
5620: l_set_of_books_id AP_INVOICES_ALL.set_of_books_id%TYPE;
5621: l_org_id AP_INVOICES_ALL.org_id%TYPE;
5622: l_doc_category_code AP_INVOICES_ALL.doc_category_code%TYPE;
5623: l_doc_sequence_id AP_INVOICES_ALL.doc_sequence_id%TYPE;
5624: l_doc_sequence_value AP_INVOICES_ALL.doc_sequence_value%TYPE;
5625:

Line 5622: l_doc_category_code AP_INVOICES_ALL.doc_category_code%TYPE;

5618: l_terms_date AP_INVOICES_ALL.terms_date%TYPE;
5619: l_batch_id AP_INVOICES_ALL.batch_id%TYPE;
5620: l_set_of_books_id AP_INVOICES_ALL.set_of_books_id%TYPE;
5621: l_org_id AP_INVOICES_ALL.org_id%TYPE;
5622: l_doc_category_code AP_INVOICES_ALL.doc_category_code%TYPE;
5623: l_doc_sequence_id AP_INVOICES_ALL.doc_sequence_id%TYPE;
5624: l_doc_sequence_value AP_INVOICES_ALL.doc_sequence_value%TYPE;
5625:
5626: l_pay_curr_invoice_amount NUMBER;

Line 5623: l_doc_sequence_id AP_INVOICES_ALL.doc_sequence_id%TYPE;

5619: l_batch_id AP_INVOICES_ALL.batch_id%TYPE;
5620: l_set_of_books_id AP_INVOICES_ALL.set_of_books_id%TYPE;
5621: l_org_id AP_INVOICES_ALL.org_id%TYPE;
5622: l_doc_category_code AP_INVOICES_ALL.doc_category_code%TYPE;
5623: l_doc_sequence_id AP_INVOICES_ALL.doc_sequence_id%TYPE;
5624: l_doc_sequence_value AP_INVOICES_ALL.doc_sequence_value%TYPE;
5625:
5626: l_pay_curr_invoice_amount NUMBER;
5627: l_payment_priority NUMBER;

Line 5624: l_doc_sequence_value AP_INVOICES_ALL.doc_sequence_value%TYPE;

5620: l_set_of_books_id AP_INVOICES_ALL.set_of_books_id%TYPE;
5621: l_org_id AP_INVOICES_ALL.org_id%TYPE;
5622: l_doc_category_code AP_INVOICES_ALL.doc_category_code%TYPE;
5623: l_doc_sequence_id AP_INVOICES_ALL.doc_sequence_id%TYPE;
5624: l_doc_sequence_value AP_INVOICES_ALL.doc_sequence_value%TYPE;
5625:
5626: l_pay_curr_invoice_amount NUMBER;
5627: l_payment_priority NUMBER;
5628: l_invoice_amount_limit NUMBER;

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

5824:
5825: END IF;
5826:
5827: ------------------------------------------------------------------------
5828: debug_info := 'Insert_Ppa_Invoices Step 3. Insert into AP_INVOICES_ALL, l_ppa_invoice_id is'||l_ppa_invoice_id;
5829: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') then
5830: AP_IMPORT_UTILITIES_PKG.Print(
5831: AP_IMPORT_INVOICES_PKG.g_debug_switch,debug_info);
5832: END IF;

Line 5838: INSERT INTO ap_invoices_All(

5834: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5835: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,debug_info);
5836: END IF;
5837: ------------------------------------------------------------------------
5838: INSERT INTO ap_invoices_All(
5839: accts_pay_code_combination_id,
5840: amount_applicable_to_discount,
5841: approval_ready_flag,
5842: attribute_category,

Line 6685: UPDATE ap_invoices_all

6681: WHERE instruction_id = p_instruction_id
6682: AND invoice_id = l_ppa_invoice_id;
6683:
6684: -- Bug 5525506
6685: UPDATE ap_invoices_all
6686: set invoice_amount = (select sum(amount)
6687: from ap_invoice_lines_all
6688: where invoice_id = l_ppa_invoice_id)
6689: where invoice_id = l_ppa_invoice_id;

Line 6903: l_inv_amount ap_invoices_all.invoice_amount%TYPE; /Bug 16450538/

6899: l_invoice_id NUMBER;
6900: l_invoice_amount number;
6901: l_invoice_currency_code VARCHAR2(100);
6902: l_accounting_event_id number;
6903: l_inv_amount ap_invoices_all.invoice_amount%TYPE; /*Bug 16450538*/
6904:
6905: BEGIN
6906: --
6907: current_calling_sequence :=

Line 7701: UPDATE ap_invoices_all ai

7697: /*Bug 16450538 End*/
7698: --We do not have self assessed tax on PPA invoices.
7699: --hence updating only total tax amount.
7700:
7701: UPDATE ap_invoices_all ai
7702: SET ai.total_tax_amount =
7703: (l_inv_amount /*For Bug 16450538*/
7704: +
7705: (SELECT