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.OKL_AM_LEASE_TRMNT_PVT dependencies on OKL_BPD_LEASING_PAYMENT_TRX_V

Line 5349: FROM OKL_BPD_LEASING_PAYMENT_TRX_V

5345:
5346: -- Cursor to get the balances of contract
5347: CURSOR k_balances_csr (p_khr_id IN NUMBER, p_trn_date DATE) IS -- rmunjulu EDAT
5348: SELECT SUM(amount_due_remaining)
5349: FROM OKL_BPD_LEASING_PAYMENT_TRX_V
5350: WHERE contract_id = p_khr_id
5351: AND invoice_date <= p_trn_date; -- rmunjulu EDAT -- Added condition to get only
5352: --those invoices which are before quote effective date
5353:

Line 5363: FROM OKL_BPD_LEASING_PAYMENT_TRX_V OBLP,

5359: OBLP.payment_schedule_id SCHEDULE_ID,
5360: OBLP.receivables_invoice_number AR_INVOICE_NUMBER,
5361: OTIL.id TIL_ID,
5362: -999 TLD_ID
5363: FROM OKL_BPD_LEASING_PAYMENT_TRX_V OBLP,
5364: OKL_TXL_AR_INV_LNS_V OTIL,
5365: OKL_STRM_TYPE_V OSTY
5366: WHERE OBLP.contract_id = p_khr_id
5367: AND OBLP.receivables_invoice_id = OTIL.receivables_invoice_id

Line 5380: FROM OKL_BPD_LEASING_PAYMENT_TRX_V OBLP,

5376: OBLP.payment_schedule_id SCHEDULE_ID,
5377: OBLP.receivables_invoice_number AR_INVOICE_NUMBER,
5378: OTAI.til_id_details TIL_ID,
5379: OTAI.id TLD_ID
5380: FROM OKL_BPD_LEASING_PAYMENT_TRX_V OBLP,
5381: OKL_TXD_AR_LN_DTLS_V OTAI,
5382: OKL_STRM_TYPE_V OSTY
5383: WHERE OBLP.contract_id = p_khr_id
5384: AND OBLP.receivables_invoice_id = OTAI.receivables_invoice_id