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 5183: FROM OKL_BPD_LEASING_PAYMENT_TRX_V

5179:
5180: -- Cursor to get the balances of contract
5181: CURSOR k_balances_csr (p_khr_id IN NUMBER, p_trn_date DATE) IS -- rmunjulu EDAT
5182: SELECT SUM(amount_due_remaining)
5183: FROM OKL_BPD_LEASING_PAYMENT_TRX_V
5184: WHERE contract_id = p_khr_id
5185: AND invoice_date <= p_trn_date; -- rmunjulu EDAT -- Added condition to get only
5186: --those invoices which are before quote effective date
5187:

Line 5197: FROM OKL_BPD_LEASING_PAYMENT_TRX_V OBLP,

5193: OBLP.payment_schedule_id SCHEDULE_ID,
5194: OBLP.receivables_invoice_number AR_INVOICE_NUMBER,
5195: OTIL.id TIL_ID,
5196: -999 TLD_ID
5197: FROM OKL_BPD_LEASING_PAYMENT_TRX_V OBLP,
5198: OKL_TXL_AR_INV_LNS_V OTIL,
5199: OKL_STRM_TYPE_V OSTY
5200: WHERE OBLP.contract_id = p_khr_id
5201: AND OBLP.receivables_invoice_id = OTIL.receivables_invoice_id

Line 5214: FROM OKL_BPD_LEASING_PAYMENT_TRX_V OBLP,

5210: OBLP.payment_schedule_id SCHEDULE_ID,
5211: OBLP.receivables_invoice_number AR_INVOICE_NUMBER,
5212: OTAI.til_id_details TIL_ID,
5213: OTAI.id TLD_ID
5214: FROM OKL_BPD_LEASING_PAYMENT_TRX_V OBLP,
5215: OKL_TXD_AR_LN_DTLS_V OTAI,
5216: OKL_STRM_TYPE_V OSTY
5217: WHERE OBLP.contract_id = p_khr_id
5218: AND OBLP.receivables_invoice_id = OTAI.receivables_invoice_id