DBA Data[Home] [Help]

APPS.OKL_STREAM_GENERATOR_PVT dependencies on OKL_K_LINES_FULL_V

Line 3989: from okl_k_lines_full_v kle,

3985: /* ,tl.item_description,
3986: tl.name */
3987: --Bug# 9725362
3988: ,sts.ste_code
3989: from okl_k_lines_full_v kle,
3990: okc_line_styles_b lse,
3991: -- okc_k_lines_tl tl,
3992: okc_statuses_b sts
3993: where KLE.LSE_ID = LSE.ID

Line 5381: okl_k_lines_full_v kle,

5377: sty.stream_type_class stream_type_class
5378: from okl_strm_type_tl tl,
5379: okl_strm_type_v sty,
5380: okc_k_items cim,
5381: okl_k_lines_full_v kle,
5382: okc_line_styles_b ls
5383: where tl.id = sty.id
5384: and tl.language = 'US'
5385: and cim.cle_id = kle.id

Line 8340: from okl_k_lines_full_v kle,

8336: Select 'Y'
8337: From dual
8338: where Exists(
8339: select kle.id
8340: from okl_k_lines_full_v kle,
8341: okc_line_styles_b lse,
8342: okc_statuses_b sts
8343: where KLE.LSE_ID = LSE.ID
8344: and lse.lty_code = 'SUBSIDY'

Line 13661: from okl_k_lines_full_v kle,

13657: x_msg_data OUT NOCOPY VARCHAR2) IS
13658:
13659: cursor l_line_csr IS
13660: select kle.id
13661: from okl_k_lines_full_v kle,
13662: okc_line_styles_b lse,
13663: okc_statuses_b sts
13664: where KLE.LSE_ID = LSE.ID
13665: and lse.lty_code in ('FREE_FORM1', 'FEE')