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_V

Line 68: l_cle_id okc_k_lines_v.cle_id%type;

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;
72: l_amount OKS_BILL_CONT_LINES_V.AMOUNT%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 154: OKC_K_ITEMS ITEMS, OKL_CNTR_LVLNG_LNS_V CNTR, okc_k_lines_v cov_asset

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

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 180: OKC_K_ITEMS ITEMS, OKL_CNTR_LVLNG_LNS_V CNTR, okc_k_lines_v cov_asset,

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'