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_BTCH_EXP_LEASE_LOAN_PVT dependencies on OKL_TRX_CONTRACTS_ALL

Line 3885: FROM okl_trx_contracts_all tcn

3881: WHERE opp.khr_id = kle.dnz_chr_id
3882: AND kle.sts_code = ('BOOKED')
3883: AND opp.khr_id NOT IN (
3884: SELECT NVL (tcn.khr_id, -9999) khr_id
3885: FROM okl_trx_contracts_all tcn
3886: WHERE tcn.tcn_type IN ('TMT', 'ALT', 'EVG')
3887: -- akrangan bug 5354501 fix added 'EVG'
3888: AND tcn.tmt_status_code NOT IN
3889: ('CANCELED', 'PROCESSED')

Line 3903: FROM okl_trx_contracts_all tcn

3899: AND NVL (qte.consolidated_yn, 'N') = 'N'
3900: AND qte.khr_id = opp.khr_id
3901: AND qte.ID NOT IN (
3902: SELECT NVL (tcn.qte_id, -9999) qte_id
3903: FROM okl_trx_contracts_all tcn
3904: WHERE tcn.tcn_type IN ('TMT', 'ALT', 'EVG')
3905: -- akrangan bug 5354501 fix added 'EVG'
3906: --rkuttiya added for 12.1.1 Multi GAAP
3907: AND tcn.representation_type = 'PRIMARY'