APPS.OKL_FUNDING_PVT dependencies on OKC_LINE_STYLES_B

Line 2311: okc_line_styles_b ls,

2307: cle.id,
2308: nvl(cle.start_date,k.start_date)
2309: from OKL_K_LINES_FULL_V cle,
2310: okc_k_party_roles_b cpl,
2311: okc_line_styles_b ls,
2312: okc_k_headers_b k
2313: where k.id = cle.dnz_chr_id
2314: and cle.dnz_chr_id = p_contract_id
2315: and cle.lse_id = ls.id

Line 2549: okc_line_styles_b ls,

2545: cle.id,
2546: nvl(cle.start_date,k.start_date)
2547: from OKL_K_LINES_FULL_V cle,
2548: okc_k_party_roles_b cpl,
2549: okc_line_styles_b ls,
2550: okc_k_headers_b k
2551: where k.id = cle.dnz_chr_id
2552: and cle.dnz_chr_id = p_contract_id
2553: and cle.lse_id = ls.id

Line 7110: FROM okc_line_styles_b model_lse

7106: AND cpl.rle_code = 'OKL_VENDOR'
7107: AND cpl.object1_id1 = TO_CHAR(p_vendor_id)
7108: AND cpl.object1_id2 = '#'
7109: AND EXISTS(SELECT NULL
7110: FROM okc_line_styles_b model_lse
7111: WHERE model_lse.ID = cle.lse_id AND model_lse.lty_code = 'ITEM' AND cle.cle_id = p_kle_id)
7112: ) -- end of model lines
7113: -- re lease flag check
7114: AND EXISTS(SELECT NULL

Line 7148: FROM okc_line_styles_b adon_lse

7144: AND cpl.object1_id1 = TO_CHAR(p_vendor_id)
7145: AND cpl.object1_id2 = '#'
7146: -- end: okl.h: cklee
7147: AND EXISTS(SELECT NULL
7148: FROM okc_line_styles_b adon_lse
7149: WHERE adon_lse.ID = cle.lse_id AND adon_lse.lty_code = 'ADD_ITEM'
7150: -- ADD_ITEM has one parent ITEM only
7151: AND EXISTS(SELECT NULL
7152: FROM okc_k_lines_b mdl_parent

Line 7184: FROM okc_line_styles_b model_lse

7180: AND cpl.rle_code = 'OKL_VENDOR'
7181: --and cpl.object1_id1 = to_char(p_vendor_id)
7182: --and cpl.object1_id2 = '#'
7183: AND EXISTS(SELECT NULL
7184: FROM okc_line_styles_b model_lse
7185: WHERE model_lse.ID = cle.lse_id AND model_lse.lty_code = 'ITEM' AND cle.cle_id = p_kle_id)
7186: ) -- end of model lines
7187: OR
7188: --for add on lines: don't care the vendor association, but care if it has vendor association!

Line 7199: FROM okc_line_styles_b adon_lse

7195: AND cpl.rle_code = 'OKL_VENDOR'
7196: --and cpl.object1_id1 = to_char(p_vendor_id)
7197: --and cpl.object1_id2 = '#'
7198: AND EXISTS(SELECT NULL
7199: FROM okc_line_styles_b adon_lse
7200: WHERE adon_lse.ID = cle.lse_id AND adon_lse.lty_code = 'ADD_ITEM'
7201: -- ADD_ITEM has one parent ITEM only
7202: AND EXISTS(SELECT NULL
7203: FROM okc_k_lines_b mdl_parent

Line 7230: FROM okc_line_styles_b model_lse

7226: AND cpl.dnz_chr_id = p_khr_id
7227: AND cpl.chr_id IS NULL
7228: AND cpl.rle_code = 'OKL_VENDOR'
7229: AND EXISTS(SELECT NULL
7230: FROM okc_line_styles_b model_lse
7231: WHERE model_lse.ID = cle.lse_id
7232: AND model_lse.lty_code = 'ITEM')
7233: )
7234: OR (

Line 7242: FROM okc_line_styles_b adon_lse

7238: AND cpl.dnz_chr_id = p_khr_id
7239: AND cpl.chr_id IS NULL
7240: AND cpl.rle_code = 'OKL_VENDOR'
7241: AND EXISTS(SELECT NULL
7242: FROM okc_line_styles_b adon_lse
7243: WHERE adon_lse.ID = cle.lse_id
7244: AND adon_lse.lty_code = 'ADD_ITEM'
7245: AND EXISTS(SELECT NULL
7246: FROM okc_k_lines_b mdl_parent

Line 7294: okc_line_styles_b model_lse

7290: and exists (
7291: SELECT 1
7292: FROM okc_k_party_roles_b cpl,
7293: okc_k_lines_b cle,
7294: okc_line_styles_b model_lse
7295: WHERE cpl.rle_code = 'OKL_VENDOR'
7296: AND cpl.chr_id IS NULL
7297: and model_lse.ID = cle.lse_id
7298: and model_lse.lty_code = 'ITEM'

Line 8476: okc_line_styles_b ls,

8472: cle.id,
8473: nvl(cle.start_date,k.start_date)
8474: from OKL_K_LINES_FULL_V cle,
8475: okc_k_party_roles_b cpl,
8476: okc_line_styles_b ls,
8477: okc_k_headers_b k
8478: where k.id = cle.dnz_chr_id
8479: and cle.dnz_chr_id = p_contract_id
8480: and cle.lse_id = ls.id