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_PURGE_PKG dependencies on AP_PAYMENT_SCHEDULES

Line 682: FROM ap_payment_schedules PS,

678: DELETE
679: FROM ap_purge_invoice_list PL
680: WHERE EXISTS (
681: SELECT 'payment schedule not purgeable'
682: FROM ap_payment_schedules PS,
683: ap_invoices I
684: WHERE PS.invoice_id = PL.invoice_id
685: AND PS.invoice_id = I.invoice_id
686: AND ((PS.payment_status_flag <> 'Y'

Line 2783: FROM ap_payment_schedules PS,

2779: SET PL.double_check_flag = 'N'
2780: WHERE PL.double_check_flag = 'Y'
2781: AND EXISTS (
2782: SELECT /*+NO_UNNEST*/ 'payment schedule no longer purgeable'
2783: FROM ap_payment_schedules PS,
2784: ap_invoices I
2785: WHERE PS.invoice_id = PL.invoice_id
2786: AND PS.invoice_id = I.invoice_id
2787: AND ((PS.payment_status_flag <> 'Y'

Line 5097: debug_info := 'ap_payment_schedules';

5093: WHERE PL.double_check_flag = 'Y'
5094: AND PL.invoice_id BETWEEN range_low AND range_high);
5095:
5096:
5097: debug_info := 'ap_payment_schedules';
5098: IF g_debug_switch in ('y','Y') THEN
5099: Print('(Delete_AP_Tables)'||debug_info);
5100: END IF;
5101:

Line 5105: DELETE FROM ap_payment_schedules

5101:
5102:
5103: -- delete_payment_schedules
5104:
5105: DELETE FROM ap_payment_schedules
5106: WHERE invoice_id IN (
5107: SELECT PL.invoice_id
5108: FROM ap_purge_invoice_list PL
5109: WHERE PL.double_check_flag = 'Y'