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.OZF_SETTLEMENT_DOC_PVT dependencies on AR_RECEIVABLE_APPLICATIONS

Line 153: FROM ar_receivable_applications rec

149: , pay.trx_number
150: , rec.apply_date
151: , rec.amount_applied
152: , pay.status
153: FROM ar_receivable_applications rec
154: , ar_payment_schedules pay
155: WHERE rec.cash_receipt_id = cv_cash_receipt_id
156: AND rec.applied_payment_schedule_id = pay.payment_schedule_id
157: AND pay.customer_trx_id = cv_customer_trx_id

Line 202: FROM ar_receivable_applications rec

198: , pay.trx_number
199: , rec.apply_date
200: , rec.amount_applied
201: , pay.status
202: FROM ar_receivable_applications rec
203: , ar_payment_schedules pay
204: WHERE rec.cash_receipt_id = cv_cash_receipt_id
205: AND rec.applied_payment_schedule_id = pay.payment_schedule_id
206: AND pay.payment_schedule_id = -1

Line 218: FROM ar_receivable_applications rec

214: , pay.trx_number
215: , rec.apply_date
216: , rec.amount_applied
217: , pay.status
218: FROM ar_receivable_applications rec
219: , ar_payment_schedules pay
220: WHERE rec.cash_receipt_id = cv_cash_receipt_id
221: AND rec.applied_payment_schedule_id = pay.payment_schedule_id
222: AND pay.payment_schedule_id = -3