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_VENDORS_PKG dependencies on AP_SELECTED_INVOICES

Line 1983: -- will appear on check - denormalised into AP_SELECTED_INVOICES

1979: p_warning_flag in out NOCOPY varchar2,
1980: X_calling_sequence in varchar2) is
1981: --
1982: -- If invoices for this vendor have been selected, warn user, old name
1983: -- will appear on check - denormalised into AP_SELECTED_INVOICES
1984: -- join to sites so that index AP_SELECTED_INVOICES_N2 can be used
1985: -- there is no index on vendor_id in AP_SELECTED_INVOICES
1986: --
1987: l_overlap_count number;

Line 1984: -- join to sites so that index AP_SELECTED_INVOICES_N2 can be used

1980: X_calling_sequence in varchar2) is
1981: --
1982: -- If invoices for this vendor have been selected, warn user, old name
1983: -- will appear on check - denormalised into AP_SELECTED_INVOICES
1984: -- join to sites so that index AP_SELECTED_INVOICES_N2 can be used
1985: -- there is no index on vendor_id in AP_SELECTED_INVOICES
1986: --
1987: l_overlap_count number;
1988: current_calling_sequence VARCHAR2(2000);

Line 1985: -- there is no index on vendor_id in AP_SELECTED_INVOICES

1981: --
1982: -- If invoices for this vendor have been selected, warn user, old name
1983: -- will appear on check - denormalised into AP_SELECTED_INVOICES
1984: -- join to sites so that index AP_SELECTED_INVOICES_N2 can be used
1985: -- there is no index on vendor_id in AP_SELECTED_INVOICES
1986: --
1987: l_overlap_count number;
1988: current_calling_sequence VARCHAR2(2000);
1989: debug_info VARCHAR2(100);

Line 2001: ap_selected_invoices i

1997: debug_info := 'Count overlap count for the vendor_id and site_id';
1998: SELECT count(1)
1999: INTO L_overlap_count
2000: FROM po_vendor_sites s,
2001: ap_selected_invoices i
2002: WHERE s.vendor_id = p_vendor_id
2003: AND i.vendor_site_id = s.vendor_site_id;
2004: --
2005: --

Line 2101: debug_info := 'Count from AP_selected_invoices';

2097: --
2098: current_calling_sequence := 'AP_VENDORS_PKG.CHECK_SELECTED_INVOICES<-' ||
2099: X_calling_sequence;
2100:
2101: debug_info := 'Count from AP_selected_invoices';
2102: select count(1)
2103: into x_return_count
2104: from AP_selected_invoices
2105: where vendor_id = x_vendor_id;

Line 2104: from AP_selected_invoices

2100:
2101: debug_info := 'Count from AP_selected_invoices';
2102: select count(1)
2103: into x_return_count
2104: from AP_selected_invoices
2105: where vendor_id = x_vendor_id;
2106:
2107: EXCEPTION
2108: WHEN OTHERS THEN