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 837: FROM okl_k_lines kle_fee, okc_k_lines_b cleb_fee, OKC_STATUSES_B status_fee

833: status.ste_code CONTRACT_STATUS_TYPE_CODE,
834: status_tl.meaning CONTRACT_STATUS,
835:
836: (select nvl(sum(nvl(kle_fee.amount,0)),0)
837: FROM okl_k_lines kle_fee, okc_k_lines_b cleb_fee, OKC_STATUSES_B status_fee
838: WHERE cleb_fee.chr_id = khr.id
839: AND khr.DEAL_TYPE NOT LIKE 'LOAN-REVOLVING'
840: and cleb_fee.dnz_chr_id = khr.id
841: and cleb_fee.sts_code = status_fee.code

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

1866: status.ste_code CONTRACT_STATUS_TYPE_CODE,
1867: status_tl.meaning CONTRACT_STATUS,
1868:
1869: (select sum(kle_fee.amount)
1870: FROM okl_k_lines kle_fee, okc_k_lines_b cleb_fee, OKC_STATUSES_B status_fee
1871: WHERE cleb_fee.chr_id = khr.id
1872: AND khr.DEAL_TYPE NOT LIKE 'LOAN-REVOLVING'
1873: and cleb_fee.dnz_chr_id = khr.id
1874: and cleb_fee.sts_code = status_fee.code