APPS.OKL_CNTRCT_FIN_EXTRACT_PVT dependencies on OKC_K_LINES_B

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

850: AND txs.tax_line_status_code = 'ACTIVE'
851: AND txs.tax_call_type_code = 'UPFRONT_TAX') TOTAL_UPFRONT_TAX_ON_ASSETS,
852: -- null TOTAL_NUMBER_OF_ASSETS,
853: (select count(cleb.id)
854: from okc_k_lines_b cleb, okc_statuses_b status_asset
855: where cleb.chr_id = khr.id and cleb.dnz_chr_id = khr.id
856: AND khr.DEAL_TYPE NOT LIKE 'LOAN-REVOLVING'
857: and cleb.sts_code = status_asset.code
858: and status_asset.ste_code not in ('TERMINATED', 'CANCELLED')

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

Line 1887: from okc_k_lines_b cleb, okc_statuses_b status_asset

1883: AND txs.tax_line_status_code = 'ACTIVE'
1884: AND txs.tax_call_type_code = 'UPFRONT_TAX') TOTAL_UPFRONT_TAX_ON_ASSETS,
1885: -- null TOTAL_NUMBER_OF_ASSETS,
1886: (select count(cleb.id)
1887: from okc_k_lines_b cleb, okc_statuses_b status_asset
1888: where cleb.chr_id = khr.id and cleb.dnz_chr_id = khr.id
1889: AND khr.DEAL_TYPE NOT LIKE 'LOAN-REVOLVING'
1890: and cleb.sts_code = status_asset.code
1891: and status_asset.ste_code not in ('TERMINATED', 'CANCELLED')