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

Line 167: from ar_receivable_applications rap

163: ,rac.exchange_rate_type
164: ,lam.interest_trx_id -- get this in order to create new interest document
165: ,lam.principal_trx_id
166: ,lam.fee_trx_id
167: from ar_receivable_applications rap
168: ,ar_cash_receipts rac
169: ,lns_amortization_scheds lam
170: ,ar_payment_schedules trx
171: where rap.cash_receipt_id = rac.cash_receipt_id

Line 595: from ar_receivable_applications rap

591:
592: Begin
593: select 'X'
594: into l_found
595: from ar_receivable_applications rap
596: where rap.cash_receipt_id = l_cash_receipt_ids(j).cash_receipt_id
597: and rap.applied_payment_schedule_id = l_invoices_tbl(k).payment_schedule_id
598: and rap.display = 'Y'
599: and rap.status = 'APP';

Line 1361: (select SUM(DECODE(app.status,'UNAPP',NVL(app.amount_applied,0),0)) amt from AR_RECEIVABLE_APPLICATIONS app where app.cash_receipt_id = CR.CASH_RECEIPT_ID) RECEIPT_CURRENCY_AMOUNT,

1357: IS
1358:
1359: Cursor getReceiptCurrencyBalance(p_recpt_id number) is
1360: select CR.CURRENCY_CODE RECEIPT_CURRENCY_CODE,
1361: (select SUM(DECODE(app.status,'UNAPP',NVL(app.amount_applied,0),0)) amt from AR_RECEIVABLE_APPLICATIONS app where app.cash_receipt_id = CR.CASH_RECEIPT_ID) RECEIPT_CURRENCY_AMOUNT,
1362: CR.EXCHANGE_RATE_TYPE,
1363: CR.EXCHANGE_DATE,
1364: CR.EXCHANGE_RATE
1365: from AR_CASH_RECEIPTS CR