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 OKS_BILL_SUB_LINES_V

Line 153: OKS_BILL_SUB_LINES_V OKS_LNS, OKC_K_HEADERS_B chr,

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

Line 179: OKS_BILL_SUB_LINES_V OKS_LNS, OKC_K_HEADERS_B chr,

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

Line 1062: OKS_BILL_SUB_LINES_V OKS_LNS, okl_k_lines okll

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
1066: and hdr.id = chr.id