DBA Data[Home] [Help]

APPS.FV_PROMPT_PAY dependencies on AP_PAYMENT_SCHEDULES

Line 161: ap_payment_schedules S,

157: A.INVOICE_AMOUNT ,
158: A.Invoice_type_lookup_code
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

Line 174: FROM ap_payment_schedules U

170: AND S.invoice_id = A.invoice_id
171: AND S.due_date is not null
172: AND S.due_date =
173: ( SELECT max(U.due_date)
174: FROM ap_payment_schedules U
175: WHERE U.invoice_id = S.invoice_id)
176: AND P.invoice_id = S.invoice_id
177: AND P.payment_num = S.payment_num
178: AND P.invoice_payment_id =