APPS.OKL_UBB_PVT dependencies on OKL_CNTR_LVLNG_LNS_V

Line 153: OKC_K_ITEMS ITEMS, OKL_CNTR_LVLNG_LNS_V CNTR, okc_k_lines_v cov_asset

149: OKS_LNS.AMOUNT ASSET_AMOUNT, OKS_LNS.ID OKS_DETAIL_ID,
150: chr.contract_number contract_number
151: from okc_k_rel_objs rel, okc_k_lines_v lns, oks_bill_cont_lines_v oks_cont,
152: OKS_BILL_SUB_LINES_V OKS_LNS, OKC_K_HEADERS_B chr,
153: OKC_K_ITEMS ITEMS, OKL_CNTR_LVLNG_LNS_V CNTR, okc_k_lines_v cov_asset
154: where rel.rty_code = 'OKLUBB'
155: and lns.chr_id = rel.object1_id1
156: and lns.id = cov_asset.cle_id
157: and lns.id = oks_cont.cle_id

Line 167: AND not exists(select 'x' from okl_trx_ar_invoices_v tai, OKL_CNTR_LVLNG_LNS_V CNTR

163: AND rel.chr_id = chr.id
164: AND OKS_LNS.DATE_BILLED_FROM > (select NVL(max(tai.date_invoiced),add_months(sysdate,-1000))
165: from okl_trx_ar_invoices_v tai where tai.khr_id = rel.chr_id
166: and tai.description = 'OKS Usage')
167: AND not exists(select 'x' from okl_trx_ar_invoices_v tai, OKL_CNTR_LVLNG_LNS_V CNTR
168: where tai.khr_id = rel.chr_id
169: and CNTR.clg_id = tai.clg_id);
170:
171: