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_CNTRCT_FIN_EXTRACT_PVT dependencies on OKL_K_LINES

Line 823: FROM okl_k_lines kle_fee, okc_k_lines_b cleb_fee, OKC_STATUSES_B status_fee

819: status.ste_code CONTRACT_STATUS_TYPE_CODE,
820: status_tl.meaning CONTRACT_STATUS,
821:
822: (select nvl(sum(nvl(kle_fee.amount,0)),0)
823: FROM okl_k_lines kle_fee, okc_k_lines_b cleb_fee, OKC_STATUSES_B status_fee
824: WHERE cleb_fee.chr_id = khr.id
825: AND khr.DEAL_TYPE NOT LIKE 'LOAN-REVOLVING'
826: and cleb_fee.dnz_chr_id = khr.id
827: and cleb_fee.sts_code = status_fee.code

Line 1856: FROM okl_k_lines kle_fee, okc_k_lines_b cleb_fee, OKC_STATUSES_B status_fee

1852: status.ste_code CONTRACT_STATUS_TYPE_CODE,
1853: status_tl.meaning CONTRACT_STATUS,
1854:
1855: (select sum(kle_fee.amount)
1856: FROM okl_k_lines kle_fee, okc_k_lines_b cleb_fee, OKC_STATUSES_B status_fee
1857: WHERE cleb_fee.chr_id = khr.id
1858: AND khr.DEAL_TYPE NOT LIKE 'LOAN-REVOLVING'
1859: and cleb_fee.dnz_chr_id = khr.id
1860: and cleb_fee.sts_code = status_fee.code