APPS.OKL_PROPERTY_TAX_STATEMENT_PVT dependencies on OKC_LINE_STYLES_B

Line 76: okc_line_styles_b ls

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)
80: AND ls.id = asset.lse_id

Line 103: okc_line_styles_b ls,

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,
107: okc_statuses_b kls

Line 148: okc_line_styles_b ls,

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,
152: okc_statuses_b kls

Line 192: okc_line_styles_b ls

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
196: AND ls.id = asset.lse_id

Line 221: okc_line_styles_b ls,

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
225: WHERE ste.amount <> 0