DBA Data[Home] [Help]

APPS.OZF_SETTLEMENT_DOC_PVT dependencies on AR_RECEIVABLE_APPLICATIONS

Line 300: FROM ar_receivable_applications rec

296: , pay.trx_number
297: , rec.apply_date
298: , rec.amount_applied
299: , pay.status
300: FROM ar_receivable_applications rec
301: , ar_payment_schedules pay
302: WHERE rec.cash_receipt_id = cv_cash_receipt_id
303: AND rec.applied_payment_schedule_id = pay.payment_schedule_id
304: AND pay.customer_trx_id = cv_customer_trx_id

Line 349: FROM ar_receivable_applications rec

345: , pay.trx_number
346: , rec.apply_date
347: , rec.amount_applied
348: , pay.status
349: FROM ar_receivable_applications rec
350: , ar_payment_schedules pay
351: WHERE rec.cash_receipt_id = cv_cash_receipt_id
352: AND rec.applied_payment_schedule_id = pay.payment_schedule_id
353: AND pay.payment_schedule_id = -1

Line 365: FROM ar_receivable_applications rec

361: , pay.trx_number
362: , rec.apply_date
363: , rec.amount_applied
364: , pay.status
365: FROM ar_receivable_applications rec
366: , ar_payment_schedules pay
367: WHERE rec.cash_receipt_id = cv_cash_receipt_id
368: AND rec.applied_payment_schedule_id = pay.payment_schedule_id
369: AND pay.payment_schedule_id = -3