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.FV_IPAC_DISBURSEMENT_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 1848: ap_invoice_distributions_v ali

1844: UNION
1845: SELECT DISTINCT ai.invoice_id,
1846: ai.approval_status_lookup_code
1847: FROM ap_invoices_v ai,
1848: ap_invoice_distributions_v ali
1849: WHERE ali.po_number = c_po_num
1850: AND ai.invoice_id = ali.invoice_id
1851: AND ali.po_line_number = NVL(c_po_line_num,1)
1852: AND ai.invoice_amount = c_amount

Line 1859: ap_invoice_distributions_v ali1

1855: AND ai.source <> 'RECURRING INVOICE'
1856: AND ai.invoice_type_lookup_code = 'STANDARD'
1857: AND ai.invoice_date = (SELECT MIN(invoice_date)
1858: FROM ap_invoices_v ai1,
1859: ap_invoice_distributions_v ali1
1860: WHERE ali1.po_number = c_po_num
1861: AND ai1.invoice_id = ali1.invoice_id
1862: AND ali1.po_line_number = NVL(c_po_line_num,1)
1863: AND ai1.invoice_amount = c_amount

Line 2326: --* : ap_invoice_distributions SELECT *--

2322: --* : fv_utility.log_mesg *--
2323: --* Tables Used : po_headers SELECT *--
2324: --* : po_distributions SELECT *--
2325: --* : po_lines SELECT *--
2326: --* : ap_invoice_distributions SELECT *--
2327: --* : ap_recurring_payments_v SELECT *--
2328: --* Logic : *--
2329: --****************************************************************************************--
2330: PROCEDURE validate_po

Line 2454: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Selecting from po_distributions, lines and ap_invoice_distributions');

2450:
2451: IF (p_error_code = g_SUCCESS AND l_validation_code IS NULL) THEN
2452: BEGIN
2453: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2454: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Selecting from po_distributions, lines and ap_invoice_distributions');
2455: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'po_header_id='||p_ap_inv_lines_rec.po_header_id);
2456: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'set_of_books_id='||g_set_of_books_id);
2457: END IF;
2458:

Line 2461: FROM ap_invoice_distributions aid ,

2457: END IF;
2458:
2459: SELECT COUNT(*)
2460: INTO l_count_matched_disb_lines
2461: FROM ap_invoice_distributions aid ,
2462: po_distributions pd ,
2463: po_lines pl
2464: WHERE aid.po_distribution_id = pd.po_distribution_id
2465: AND pd.po_header_id = p_ap_inv_lines_rec.po_header_id

Line 2600: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Selecting from po_distributions and ap_invoice_distributions');

2596:
2597: IF (p_error_code = g_SUCCESS AND l_validation_code IS NULL) THEN
2598: BEGIN
2599: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2600: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Selecting from po_distributions and ap_invoice_distributions');
2601: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'po_line_id = '||p_ap_inv_lines_rec.po_line_id);
2602: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'set_of_books_id = '||g_set_of_books_id);
2603: END IF;
2604: SELECT COUNT(*)

Line 2606: FROM ap_invoice_distributions aid ,

2602: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'set_of_books_id = '||g_set_of_books_id);
2603: END IF;
2604: SELECT COUNT(*)
2605: INTO l_count_matched_disb_lines
2606: FROM ap_invoice_distributions aid ,
2607: po_distributions pd
2608: WHERE aid.po_distribution_id = pd.po_distribution_id
2609: AND pd.po_line_id = p_ap_inv_lines_rec.po_line_id
2610: AND aid.final_match_flag = 'D'