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_PROMPT_PAY dependencies on AP_CHECKS

Line 163: ap_checks K,

159: FROM
160: fv_terms_types T,
161: ap_payment_schedules S,
162: ap_invoice_payments P,
163: ap_checks K,
164: ap_invoices A
165: WHERE
166: A.set_of_books_id = v_set_of_books_id
167: AND A.payment_status_flag = 'Y'

Line 181: ap_checks C

177: AND P.payment_num = S.payment_num
178: AND P.invoice_payment_id =
179: ( SELECT I.invoice_payment_id
180: FROM ap_invoice_payments I,
181: ap_checks C
182: WHERE I.invoice_payment_id = P.invoice_payment_id
183: AND C.check_id = P.check_id
184: AND C.check_date =
185: ( SELECT max(H.check_date)

Line 186: FROM ap_checks H

182: WHERE I.invoice_payment_id = P.invoice_payment_id
183: AND C.check_id = P.check_id
184: AND C.check_date =
185: ( SELECT max(H.check_date)
186: FROM ap_checks H
187: WHERE H.check_id = C.check_id ))
188: AND K.check_id = P.check_id
189: AND K.check_date between v_from_date and v_to_date
190: AND K.void_date is null ;