DBA Data[Home] [Help]

APPS.OKL_STREAM_GENERATOR_PVT dependencies on OKL_K_LINES_FULL_V

Line 4074: from okl_k_lines_full_v kle,

4070: kle.capital_reduction_percent,
4071: NVL(kle.capitalize_down_payment_yn, 'N') capitalize_down_payment_yn
4072: /* ,tl.item_description,
4073: tl.name */
4074: from okl_k_lines_full_v kle,
4075: okc_line_styles_b lse,
4076: -- okc_k_lines_tl tl,
4077: okc_statuses_b sts
4078: where KLE.LSE_ID = LSE.ID

Line 5459: okl_k_lines_full_v kle,

5455: sty.stream_type_class stream_type_class
5456: from okl_strm_type_tl tl,
5457: okl_strm_type_v sty,
5458: okc_k_items cim,
5459: okl_k_lines_full_v kle,
5460: okc_line_styles_b ls
5461: where tl.id = sty.id
5462: and tl.language = 'US'
5463: and cim.cle_id = kle.id

Line 6264: from okl_k_lines_full_v kle,

6260: Select 'Y'
6261: From dual
6262: where Exists(
6263: select kle.id
6264: from okl_k_lines_full_v kle,
6265: okc_line_styles_b lse,
6266: okc_statuses_b sts
6267: where KLE.LSE_ID = LSE.ID
6268: and lse.lty_code = 'SUBSIDY'

Line 11206: from okl_k_lines_full_v kle,

11202: x_msg_data OUT NOCOPY VARCHAR2) IS
11203:
11204: cursor l_line_csr IS
11205: select kle.id
11206: from okl_k_lines_full_v kle,
11207: okc_line_styles_b lse,
11208: okc_statuses_b sts
11209: where KLE.LSE_ID = LSE.ID
11210: and lse.lty_code in ('FREE_FORM1', 'FEE')