DBA Data[Home] [Help]

APPS.OKL_PROPERTY_TAX_STATEMENT_PVT dependencies on OKL_STRM_TYPE_V

Line 99: okl_strm_type_v sty,

95: decode(date_billed,NULL,0,ste.amount) amount_billed,
96: decode(date_billed,NULL,0,ste.amount) amount
97: FROM okl_strm_elements ste,
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,

Line 145: okl_strm_type_v sty,

141: trunc(ste.stream_element_date) stream_element_date,
142: ste.amount amount
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,

Line 190: okl_strm_type_v sty,

186: til.amount amount
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

Line 217: okl_strm_type_v sty,

213: trunc(ste.stream_element_date) stream_element_date,
214: ste.amount amount
215: FROM okl_strm_elements ste,
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,