[Home] [Help]
150: OKS_LNS.AMOUNT ASSET_AMOUNT, OKS_LNS.ID OKS_DETAIL_ID,
151: chr.contract_number contract_number
152: from okc_k_rel_objs rel, okc_k_lines_v lns, oks_bill_cont_lines_v oks_cont,
153: OKS_BILL_SUB_LINES_V OKS_LNS, OKC_K_HEADERS_B chr,
154: OKC_K_ITEMS ITEMS, OKL_CNTR_LVLNG_LNS_V CNTR, okc_k_lines_v cov_asset
155: where rel.rty_code = 'OKLUBB'
156: and lns.chr_id = rel.object1_id1
157: and lns.id = cov_asset.cle_id
158: and lns.id = oks_cont.cle_id
165: AND rel.chr_id = chr.id
166: AND OKS_LNS.DATE_BILLED_FROM > (select NVL(max(tai.date_invoiced),add_months(sysdate,-1000))
167: from okl_trx_ar_invoices_v tai where tai.khr_id = rel.chr_id
168: and tai.description = 'OKS Usage')
169: AND not exists(select 'x' from okl_trx_ar_invoices_v tai, OKL_CNTR_LVLNG_LNS_V CNTR
170: where tai.khr_id = rel.chr_id
171: and CNTR.clg_id = tai.clg_id);
172:
173: -- Below Cursor distinct_khr_cur is added by Venkatho as part of Bug# 14119181
176: chr.contract_number contract_number,
177: iex_wf_ban_status_pub.get_turninvoff(hca.party_id,hca.cust_account_id,SYSDATE) bankruptcy_sts
178: from okc_k_rel_objs rel, okc_k_lines_v lns, oks_bill_cont_lines_v oks_cont,
179: OKS_BILL_SUB_LINES_V OKS_LNS, OKC_K_HEADERS_B chr,
180: OKC_K_ITEMS ITEMS, OKL_CNTR_LVLNG_LNS_V CNTR, okc_k_lines_v cov_asset,
181: hz_cust_accounts hca
182: where rel.rty_code = 'OKLUBB'
183: and chr.cust_acct_id = hca.cust_account_id
184: and hca.status = 'A'
193: AND rel.chr_id = chr.id
194: AND OKS_LNS.DATE_BILLED_FROM > (select NVL(max(tai.date_invoiced),add_months(sysdate,-1000))
195: from okl_trx_ar_invoices_v tai where tai.khr_id = rel.chr_id
196: and tai.description = 'OKS Usage')
197: AND not exists(select 'x' from okl_trx_ar_invoices_v tai, OKL_CNTR_LVLNG_LNS_V CNTR
198: where tai.khr_id = rel.chr_id
199: and CNTR.clg_id = tai.clg_id);
200:
201: