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

Line 209: FROM ap_invoices_all ai, ap_payment_schedules_all aps1

205: aps.last_updated_by = FND_GLOBAL.user_id,
206: aps.last_update_login = FND_GLOBAL.login_id
207: WHERE aps.invoice_id IN
208: (SELECT DISTINCT ai.invoice_id
209: FROM ap_invoices_all ai, ap_payment_schedules_all aps1
210: WHERE aps1.external_bank_account_id = P_bank_account_id
211: AND ai.invoice_id = aps1.invoice_id
212: AND ai.org_id = l_org_id
213: AND ai.payment_status_flag IN ('N','P')

Line 234: FROM ap_invoices_all ai, ap_payment_schedules_all aps1

230: aps.last_updated_by = FND_GLOBAL.user_id,
231: aps.last_update_login = FND_GLOBAL.login_id
232: WHERE aps.invoice_id IN
233: (SELECT DISTINCT ai.invoice_id
234: FROM ap_invoices_all ai, ap_payment_schedules_all aps1
235: WHERE aps1.external_bank_account_id = P_bank_account_id
236: AND ai.invoice_id = aps1.invoice_id
237: AND ai.payment_status_flag IN ('N','P')
238: AND ai.cancelled_date IS NULL

Line 260: FROM ap_invoices_all ai, ap_payment_schedules_all aps1

256: aps.last_updated_by = FND_GLOBAL.user_id,
257: aps.last_update_login = FND_GLOBAL.login_id
258: WHERE aps.invoice_id IN
259: (SELECT DISTINCT ai.invoice_id
260: FROM ap_invoices_all ai, ap_payment_schedules_all aps1
261: WHERE aps1.external_bank_account_id = P_bank_account_id
262: AND ai.invoice_id = aps1.invoice_id
263: AND ai.payment_status_flag IN ('N','P')
264: AND ai.cancelled_date IS NULL