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.PA_AP_INTEGRATION dependencies on AP_INVOICES_ALL

Line 7: p_paid_inv_flag IN ap_invoices_all.PAYMENT_STATUS_FLAG%type,

3:
4: PROCEDURE UPD_PA_DETAILS_SUPPLIER_MERGE
5: ( p_old_vendor_id IN po_vendors.vendor_id%type,
6: p_new_vendor_id IN po_vendors.vendor_id%type,
7: p_paid_inv_flag IN ap_invoices_all.PAYMENT_STATUS_FLAG%type,
8: x_stage OUT NOCOPY VARCHAR2,
9: x_status OUT NOCOPY VARCHAR2)
10:
11: IS

Line 28: ap_invoices_all i

24: SELECT ---- /*+ LEADING(ei) */
25: ei.expenditure_id
26: FROM pa_cost_distribution_lines_all c,
27: pa_expenditure_items_all ei,
28: ap_invoices_all i
29: WHERE TO_CHAR (i.invoice_id) = c.system_reference2
30: AND c.expenditure_item_id = ei.expenditure_item_id
31: -- AND ei.expenditure_id = e.expenditure_id
32: AND c.system_reference1 = TO_CHAR(p_old_vendor_id)

Line 45: ap_invoices_all i

41: Where Vendor_Id = p_old_vendor_id
42: and exists
43: (select 1
44: from pa_cost_distribution_lines_all c,
45: ap_invoices_all i
46: where i.invoice_id = to_number(c.system_reference2)
47: and c.expenditure_item_id = ei.expenditure_item_id
48: and c.system_reference1 = p_old_vendor_id
49: and i.vendor_id = p_new_vendor_id

Line 61: from pa_cost_distribution_lines_all c, ap_invoices_all i

57:
58: /*Code change for 7125912 */
59: Declare Cursor c1 is
60: Select c.rowid row_id, c.expenditure_item_id, c.line_num
61: from pa_cost_distribution_lines_all c, ap_invoices_all i
62: where to_char(i.invoice_id) = c.system_reference2
63: /*and i.vendor_id = to_number(c.system_reference1)*/ /*Vendor_ID on Invoice is already changed...so this is not needed */
64: and c.system_reference1 = to_char(p_old_vendor_id)
65: and i.vendor_id = p_new_vendor_id