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_REL_OBJS

Line 66: l_oks_khr_id okc_k_rel_objs.object1_id1%type;

62: l_init_msg_list VARCHAR2(1) ;
63: l_msg_count NUMBER ;
64:
65: i NUMBER := 0;
66: l_oks_khr_id okc_k_rel_objs.object1_id1%type;
67: l_okl_khr_id okc_k_rel_objs.chr_id%type;
68: l_cle_id okc_k_lines_v.cle_id%type;
69: l_btn_id OKS_BILL_CONT_LINES_V.BTN_ID%type;
70: l_date_billed_from OKS_BILL_CONT_LINES_V.DATE_BILLED_FROM%TYPE;

Line 67: l_okl_khr_id okc_k_rel_objs.chr_id%type;

63: l_msg_count NUMBER ;
64:
65: i NUMBER := 0;
66: l_oks_khr_id okc_k_rel_objs.object1_id1%type;
67: l_okl_khr_id okc_k_rel_objs.chr_id%type;
68: l_cle_id okc_k_lines_v.cle_id%type;
69: l_btn_id OKS_BILL_CONT_LINES_V.BTN_ID%type;
70: l_date_billed_from OKS_BILL_CONT_LINES_V.DATE_BILLED_FROM%TYPE;
71: l_date_billed_to OKS_BILL_CONT_LINES_V.DATE_BILLED_TO%TYPE;

Line 152: from okc_k_rel_objs rel, okc_k_lines_v lns, oks_bill_cont_lines_v oks_cont,

148: oks_lns.bcl_id BCL_ID, OKS_LNS.DATE_BILLED_FROM DATE_BILLED_FROM,
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

Line 178: from okc_k_rel_objs rel, okc_k_lines_v lns, oks_bill_cont_lines_v oks_cont,

174: CURSOR distinct_khr_cur IS
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'

Line 751: from okc_k_rel_objs rel,

747:
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

Line 770: from okc_k_rel_objs rel,

766: and schd.date_to_interface <= c_transaction_date;
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,

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'