APPS.OKL_UBB_PVT dependencies on OKC_K_HEADERS_B

Line 119: okc_k_headers_b chrb

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

Line 152: OKS_BILL_SUB_LINES_V OKS_LNS, OKC_K_HEADERS_B chr,

148: OKS_LNS.DATE_BILLED_TO DATE_BILLED_TO, CNTR.CLG_ID,
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

Line 665: okc_k_headers_b hdr,

661:
662: CURSOR c_oks_last_sch_bill_date_10(c_khr_id in NUMBER, c_transaction_date DATE) IS
663: select max(schd.date_to_interface) last_sche_bill_date
664: from okc_k_rel_objs rel,
665: okc_k_headers_b hdr,
666: okc_k_headers_b oks,
667: okc_k_lines_b oks_line,
668: OKS_LEVEL_ELEMENTS_V schd, OKS_STREAM_LEVELS_B strm
669: where hdr.id = c_khr_id

Line 666: okc_k_headers_b oks,

662: CURSOR c_oks_last_sch_bill_date_10(c_khr_id in NUMBER, c_transaction_date DATE) IS
663: select max(schd.date_to_interface) last_sche_bill_date
664: from okc_k_rel_objs rel,
665: okc_k_headers_b hdr,
666: okc_k_headers_b oks,
667: okc_k_lines_b oks_line,
668: OKS_LEVEL_ELEMENTS_V schd, OKS_STREAM_LEVELS_B strm
669: where hdr.id = c_khr_id
670: and rty_code = 'OKLSRV'

Line 684: okc_k_headers_b hdr,

680:
681: CURSOR c_oks_last_sch_bill_date_9(c_khr_id in NUMBER, c_transaction_date DATE) IS
682: select max(schd.date_to_interface) last_sche_bill_date
683: from okc_k_rel_objs rel,
684: okc_k_headers_b hdr,
685: okc_k_headers_b oks,
686: okc_k_lines_b oks_line,
687: OKS_LEVEL_ELEMENTS_V schd,
688: okc_rules_b rules,

Line 685: okc_k_headers_b oks,

681: CURSOR c_oks_last_sch_bill_date_9(c_khr_id in NUMBER, c_transaction_date DATE) IS
682: select max(schd.date_to_interface) last_sche_bill_date
683: from okc_k_rel_objs rel,
684: okc_k_headers_b hdr,
685: okc_k_headers_b oks,
686: okc_k_lines_b oks_line,
687: OKS_LEVEL_ELEMENTS_V schd,
688: okc_rules_b rules,
689: okc_rule_groups_b rgp

Line 738: -- select id into l_khr_id from okc_k_headers_b where contract_number = p_contract_number;

734: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
735: RAISE OKL_API.G_EXCEPTION_ERROR;
736: END IF;
737:
738: -- select id into l_khr_id from okc_k_headers_b where contract_number = p_contract_number;
739:
740: i := 0;
741:
742: FOR l_last_sch_bill_date IN c_last_sch_bill_date(p_khr_id, p_transaction_date)

Line 927: l_curr_code okc_k_headers_b.currency_code%TYPE;

923: l_bill_date okl_trx_ar_invoices_v.date_invoiced%TYPE;
924: l_trx_type okl_trx_ar_invoices_v.try_id%TYPE;
925: l_kle_id okl_txl_ar_inv_lns_v.kle_id%TYPE;
926:
927: l_curr_code okc_k_headers_b.currency_code%TYPE;
928: l_ste_amount okl_strm_elements.amount%type;
929:
930:
931: l_line_number okl_txl_ar_inv_lns_v.line_number%TYPE;

Line 973: from okc_k_rel_objs rel, okl_k_headers hdr, okc_k_headers_b chr, okc_k_lines_b lns,

969: rel.object1_id1 oks_line_id, OKS_LNS.DATE_BILLED_FROM DATE_BILLED_FROM,
970: OKS_LNS.DATE_BILLED_TO DATE_BILLED_TO, OKS_LNS.AMOUNT asset_amount,
971: OKS_CONT.AMOUNT line_amount, OKS_CONT.CURRENCY_CODE CURRENCY_CODE,
972: okll.sty_id sty_id
973: from okc_k_rel_objs rel, okl_k_headers hdr, okc_k_headers_b chr, okc_k_lines_b lns,
974: okc_line_styles_b lse, okc_k_lines_b lnsb, OKS_BILL_CONT_LINES_V OKS_CONT,
975: OKS_BILL_SUB_LINES_V OKS_LNS, okl_k_lines okll
976: where rty_code = 'OKLSRV'
977: and rel.jtot_object1_code = 'OKL_COV_PROD'