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_CONT_LINES_V

Line 69: l_btn_id OKS_BILL_CONT_LINES_V.BTN_ID%type;

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;
73: l_currency_code OKS_BILL_CONT_LINES_V.CURRENCY_CODE%TYPE;

Line 70: l_date_billed_from OKS_BILL_CONT_LINES_V.DATE_BILLED_FROM%TYPE;

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;
73: l_currency_code OKS_BILL_CONT_LINES_V.CURRENCY_CODE%TYPE;
74: l_cont_id OKS_BILL_CONT_LINES_V.ID%TYPE;

Line 71: l_date_billed_to OKS_BILL_CONT_LINES_V.DATE_BILLED_TO%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;
73: l_currency_code OKS_BILL_CONT_LINES_V.CURRENCY_CODE%TYPE;
74: l_cont_id OKS_BILL_CONT_LINES_V.ID%TYPE;
75: l_try_id okl_trx_types_tl.id%TYPE;

Line 72: l_amount OKS_BILL_CONT_LINES_V.AMOUNT%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;
73: l_currency_code OKS_BILL_CONT_LINES_V.CURRENCY_CODE%TYPE;
74: l_cont_id OKS_BILL_CONT_LINES_V.ID%TYPE;
75: l_try_id okl_trx_types_tl.id%TYPE;
76: l_clg_id okl_trx_ar_invoices_v.clg_id%TYPE;

Line 73: l_currency_code OKS_BILL_CONT_LINES_V.CURRENCY_CODE%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;
73: l_currency_code OKS_BILL_CONT_LINES_V.CURRENCY_CODE%TYPE;
74: l_cont_id OKS_BILL_CONT_LINES_V.ID%TYPE;
75: l_try_id okl_trx_types_tl.id%TYPE;
76: l_clg_id okl_trx_ar_invoices_v.clg_id%TYPE;
77: l_sty_id okl_strm_type_v.id%TYPE;

Line 74: l_cont_id OKS_BILL_CONT_LINES_V.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;
73: l_currency_code OKS_BILL_CONT_LINES_V.CURRENCY_CODE%TYPE;
74: l_cont_id OKS_BILL_CONT_LINES_V.ID%TYPE;
75: l_try_id okl_trx_types_tl.id%TYPE;
76: l_clg_id okl_trx_ar_invoices_v.clg_id%TYPE;
77: l_sty_id okl_strm_type_v.id%TYPE;
78: l_first_line CONSTANT NUMBER := 1;

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