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_PROPERTY_TAX_STATEMENT_PVT dependencies on OKL_K_LINES_FULL_V

Line 75: okl_k_lines_full_v asset ,

71: cp_asset_name_to okx_asset_lines_v.name%TYPE) IS
72: SELECT asset.chr_id CHR_ID,
73: asset.id KLE_ID
74: FROM okc_k_headers_b chr,
75: okl_k_lines_full_v asset ,
76: okc_line_styles_b ls
77: WHERE chr.contract_number BETWEEN NVL(cp_cont_num_from,chr.contract_number) AND NVL(cp_cont_num_to,chr.contract_number)
78: AND asset.chr_id = chr.id
79: AND asset.name BETWEEN NVL(cp_asset_name_from,asset.name) AND NVL(cp_asset_name_to,asset.name)

Line 102: okl_k_lines_full_v asset,

98: okl_streams stm,
99: okl_strm_type_v sty,
100: okc_k_headers_b khr,
101: okl_k_headers khl,
102: okl_k_lines_full_v asset,
103: okc_line_styles_b ls,
104: okl_property_tax_v ptv,
105: okc_k_lines_b kle,
106: okc_statuses_b khs,

Line 147: okl_k_lines_full_v asset,

143: FROM okl_strm_elements ste,
144: okl_streams stm,
145: okl_strm_type_v sty,
146: okc_k_headers_all_b khr,
147: okl_k_lines_full_v asset,
148: okc_line_styles_b ls,
149: okl_k_headers khl,
150: okc_k_lines_b kle,
151: okc_statuses_b khs,

Line 191: okl_k_lines_full_v asset,

187: FROM okc_k_headers_all_b khr,
188: okl_trx_ar_invoices_b tai,
189: okl_txl_ar_inv_lns_b til,
190: okl_strm_type_v sty,
191: okl_k_lines_full_v asset,
192: okc_line_styles_b ls
193: WHERE khr.id = cp_khr_id
194: AND asset.chr_id = khr.id
195: AND asset.id = til.kle_id

Line 220: okl_k_lines_full_v asset,

216: okl_streams stm,
217: okl_strm_type_v sty,
218: okc_k_headers_b khr,
219: okl_k_headers khl,
220: okl_k_lines_full_v asset,
221: okc_line_styles_b ls,
222: okc_k_lines_b kle,
223: okc_statuses_b khs,
224: okc_statuses_b kls