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 3802: FROM okl_trx_contracts_all tcn

3798: WHERE opp.khr_id = kle.dnz_chr_id
3799: AND kle.sts_code = ('BOOKED')
3800: AND opp.khr_id NOT IN (
3801: SELECT NVL (tcn.khr_id, -9999) khr_id
3802: FROM okl_trx_contracts_all tcn
3803: WHERE tcn.tcn_type IN ('TMT', 'ALT', 'EVG')
3804: -- akrangan bug 5354501 fix added 'EVG'
3805: AND tcn.tmt_status_code NOT IN
3806: ('CANCELED', 'PROCESSED')

Line 3820: FROM okl_trx_contracts_all tcn

3816: AND NVL (qte.consolidated_yn, 'N') = 'N'
3817: AND qte.khr_id = opp.khr_id
3818: AND qte.ID NOT IN (
3819: SELECT NVL (tcn.qte_id, -9999) qte_id
3820: FROM okl_trx_contracts_all tcn
3821: WHERE tcn.tcn_type IN ('TMT', 'ALT', 'EVG')
3822: -- akrangan bug 5354501 fix added 'EVG'
3823: --rkuttiya added for 12.1.1 Multi GAAP
3824: AND tcn.representation_type = 'PRIMARY'