APPS.OKL_CNTRCT_FIN_EXTRACT_PVT dependencies on OKC_K_LINES_B

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 868: from okc_k_lines_b cleb, okc_statuses_b status_asset

864: AND txs.tax_line_status_code = 'ACTIVE'
865: AND txs.tax_call_type_code = 'UPFRONT_TAX') TOTAL_UPFRONT_TAX_ON_ASSETS,
866: -- null TOTAL_NUMBER_OF_ASSETS,
867: (select count(cleb.id)
868: from okc_k_lines_b cleb, okc_statuses_b status_asset
869: where cleb.chr_id = khr.id and cleb.dnz_chr_id = khr.id
870: AND khr.DEAL_TYPE NOT LIKE 'LOAN-REVOLVING'
871: and cleb.sts_code = status_asset.code
872: and status_asset.ste_code not in ('TERMINATED', 'CANCELLED')

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

Line 1901: from okc_k_lines_b cleb, okc_statuses_b status_asset

1897: AND txs.tax_line_status_code = 'ACTIVE'
1898: AND txs.tax_call_type_code = 'UPFRONT_TAX') TOTAL_UPFRONT_TAX_ON_ASSETS,
1899: -- null TOTAL_NUMBER_OF_ASSETS,
1900: (select count(cleb.id)
1901: from okc_k_lines_b cleb, okc_statuses_b status_asset
1902: where cleb.chr_id = khr.id and cleb.dnz_chr_id = khr.id
1903: AND khr.DEAL_TYPE NOT LIKE 'LOAN-REVOLVING'
1904: and cleb.sts_code = status_asset.code
1905: and status_asset.ste_code not in ('TERMINATED', 'CANCELLED')