DBA Data[Home] [Help]

APPS.FV_PROMPT_PAY dependencies on AP_INVOICE_PAYMENTS

Line 162: ap_invoice_payments P,

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
166: A.set_of_books_id = v_set_of_books_id

Line 180: FROM ap_invoice_payments I,

176: AND P.invoice_id = S.invoice_id
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 =