DBA Data[Home] [Help]

APPS.OKL_GENERATE_ACCRUALS_PVT dependencies on OKC_LINE_STYLES_B

Line 240: SELECT 'x' FROM okc_k_lines_b cle, okc_line_styles_b lse

236: SELECT 'x' FROM okc_k_items cim
237: WHERE cim.object1_id1 = to_char(chr.id)
238: AND EXISTS
239: (
240: SELECT 'x' FROM okc_k_lines_b cle, okc_line_styles_b lse
241: WHERE cle.lse_id = lse.id
242: AND lse.lty_code = 'SHARED'
243: AND cle.id = cim.cle_id
244: )

Line 1397: okc_line_styles_b lse_fa,

1393: -- cursor to get Master Item from Financial Asset Line
1394: CURSOR l_mtl_sys_item_csr (cp_chr_id NUMBER, cp_cle_id NUMBER) IS
1395: SELECT RPAD (ite.object1_id1, 50, ' ') || khr.inv_organization_id
1396: FROM okc_k_lines_b kle_fa,
1397: okc_line_styles_b lse_fa,
1398: okc_k_lines_b kle_ml,
1399: okc_line_styles_b lse_ml,
1400: okc_k_items ite,
1401: okl_k_headers_full_v khr

Line 1399: okc_line_styles_b lse_ml,

1395: SELECT RPAD (ite.object1_id1, 50, ' ') || khr.inv_organization_id
1396: FROM okc_k_lines_b kle_fa,
1397: okc_line_styles_b lse_fa,
1398: okc_k_lines_b kle_ml,
1399: okc_line_styles_b lse_ml,
1400: okc_k_items ite,
1401: okl_k_headers_full_v khr
1402: WHERE kle_fa.id = cp_cle_id
1403: AND kle_fa.chr_id = cp_chr_id

Line 1424: OKC_LINE_STYLES_B lsy

1420: --cursor to get lty_code
1421: CURSOR get_lty_code_csr(p_khr_id NUMBER, p_kle_id NUMBER) IS
1422: SELECT lsy.lty_code
1423: FROM OKC_K_LINES_B cle,
1424: OKC_LINE_STYLES_B lsy
1425: WHERE cle.dnz_chr_id = p_khr_id
1426: AND cle.id = p_kle_id
1427: AND cle.lse_id = lsy.id;
1428: