eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_UBB_PVT dependencies on OKC_K_LINES_B

Line 110: okc_k_lines_b cle_inst,

106:
107: CURSOR l_fin_asset_id_cur(c_khr_id in NUMBER, c_kle_id in NUMBER) IS
108: select cle_inst.cle_id financial_asset_id
109: from
110: okc_k_lines_b cle_inst,
111: okc_k_lines_b cle_ib,
112: okc_k_items cim_ib,
113: csi_item_instances cii,
114: cs_csi_counter_groups ccg,

Line 111: okc_k_lines_b cle_ib,

107: CURSOR l_fin_asset_id_cur(c_khr_id in NUMBER, c_kle_id in NUMBER) IS
108: select cle_inst.cle_id financial_asset_id
109: from
110: okc_k_lines_b cle_inst,
111: okc_k_lines_b cle_ib,
112: okc_k_items cim_ib,
113: csi_item_instances cii,
114: cs_csi_counter_groups ccg,
115: csi_counters_vl cc,

Line 117: okc_k_lines_b cleb,

113: csi_item_instances cii,
114: cs_csi_counter_groups ccg,
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

Line 754: okc_k_lines_b oks_line,

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'
758: and rel.jtot_object1_code = 'OKL_SERVICE'

Line 773: okc_k_lines_b oks_line,

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
777: where hdr.id = c_khr_id

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

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'

Line 1061: okc_line_styles_b lse, okc_k_lines_b lnsb, OKS_BILL_CONT_LINES_V OKS_CONT,

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'
1065: and rel.chr_id = hdr.id