[Home] [Help]
115: csi_counters_vl cc,
116: okc_k_items cim,
117: okc_k_lines_b cleb,
118: okc_line_styles_b lseb,
119: okc_k_headers_b chrb
120: where cle_ib.id = cim_ib.cle_id
121: and cle_ib.dnz_chr_id = cim_ib.dnz_chr_id
122: --
123: and cle_inst.id = cle_ib.cle_id
149: OKS_LNS.DATE_BILLED_TO DATE_BILLED_TO, CNTR.CLG_ID,
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
175: select distinct rel.chr_id okl_khr_id,
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
748:
749: CURSOR c_oks_last_sch_bill_date_10(c_khr_id in NUMBER, c_transaction_date DATE) IS
750: select max(schd.date_to_interface) last_sche_bill_date
751: from okc_k_rel_objs rel,
752: okc_k_headers_b hdr,
753: okc_k_headers_b oks,
754: okc_k_lines_b oks_line,
755: OKS_LEVEL_ELEMENTS_V schd, OKS_STREAM_LEVELS_B strm
756: where hdr.id = c_khr_id
749: CURSOR c_oks_last_sch_bill_date_10(c_khr_id in NUMBER, c_transaction_date DATE) IS
750: select max(schd.date_to_interface) last_sche_bill_date
751: from okc_k_rel_objs rel,
752: okc_k_headers_b hdr,
753: okc_k_headers_b oks,
754: okc_k_lines_b oks_line,
755: OKS_LEVEL_ELEMENTS_V schd, OKS_STREAM_LEVELS_B strm
756: where hdr.id = c_khr_id
757: and rty_code = 'OKLSRV'
767:
768: CURSOR c_oks_last_sch_bill_date_9(c_khr_id in NUMBER, c_transaction_date DATE) IS
769: select max(schd.date_to_interface) last_sche_bill_date
770: from okc_k_rel_objs rel,
771: okc_k_headers_b hdr,
772: okc_k_headers_b oks,
773: okc_k_lines_b oks_line,
774: OKS_LEVEL_ELEMENTS_V schd,
775: okc_rules_b rules,
768: CURSOR c_oks_last_sch_bill_date_9(c_khr_id in NUMBER, c_transaction_date DATE) IS
769: select max(schd.date_to_interface) last_sche_bill_date
770: from okc_k_rel_objs rel,
771: okc_k_headers_b hdr,
772: okc_k_headers_b oks,
773: okc_k_lines_b oks_line,
774: OKS_LEVEL_ELEMENTS_V schd,
775: okc_rules_b rules,
776: okc_rule_groups_b rgp
821: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
822: RAISE OKL_API.G_EXCEPTION_ERROR;
823: END IF;
824:
825: -- select id into l_khr_id from okc_k_headers_b where contract_number = p_contract_number;
826:
827: i := 0;
828:
829: FOR l_last_sch_bill_date IN c_last_sch_bill_date(p_khr_id, p_transaction_date)
1010: l_bill_date okl_trx_ar_invoices_v.date_invoiced%TYPE;
1011: l_trx_type okl_trx_ar_invoices_v.try_id%TYPE;
1012: l_kle_id okl_txl_ar_inv_lns_v.kle_id%TYPE;
1013:
1014: l_curr_code okc_k_headers_b.currency_code%TYPE;
1015: l_ste_amount okl_strm_elements.amount%type;
1016:
1017:
1018: l_line_number okl_txl_ar_inv_lns_v.line_number%TYPE;
1056: rel.object1_id1 oks_line_id, OKS_LNS.DATE_BILLED_FROM DATE_BILLED_FROM,
1057: OKS_LNS.DATE_BILLED_TO DATE_BILLED_TO, OKS_LNS.AMOUNT asset_amount,
1058: OKS_CONT.AMOUNT line_amount, OKS_CONT.CURRENCY_CODE CURRENCY_CODE,
1059: okll.sty_id sty_id
1060: from okc_k_rel_objs rel, okl_k_headers hdr, okc_k_headers_b chr, okc_k_lines_b lns,
1061: okc_line_styles_b lse, okc_k_lines_b lnsb, OKS_BILL_CONT_LINES_V OKS_CONT,
1062: OKS_BILL_SUB_LINES_V OKS_LNS, okl_k_lines okll
1063: where rty_code = 'OKLSRV'
1064: and rel.jtot_object1_code = 'OKL_COV_PROD'