APPS.OKL_GENERATE_ACCRUALS_PVT dependencies on OKC_K_LINES_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 1396: FROM okc_k_lines_b kle_fa,

1392:
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,

Line 1398: okc_k_lines_b kle_ml,

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
1402: WHERE kle_fa.id = cp_cle_id

Line 1416: FROM OKC_K_LINES_B

1412:
1413: -- cursor to get bill-to-site of customer at line level
1414: CURSOR line_bill_to_site_csr (p_chr_id NUMBER, p_cle_id NUMBER) IS
1415: SELECT bill_to_site_use_id
1416: FROM OKC_K_LINES_B
1417: WHERE id = p_cle_id
1418: AND dnz_chr_id = p_chr_id;
1419:
1420: --cursor to get lty_code

Line 1423: FROM OKC_K_LINES_B cle,

1419:
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;

Line 9041: FROM OKC_K_HEADERS_B chr, OKC_K_LINES_B cle, okl_parallel_processes opp

9037:
9038: CURSOR chk_data_volume_csr(p_seq_next VARCHAR2 ) IS
9039: SELECT chr.contract_number contract_number
9040: ,count(cle.id) line_count
9041: FROM OKC_K_HEADERS_B chr, OKC_K_LINES_B cle, okl_parallel_processes opp
9042: WHERE opp.object_value = chr.contract_number
9043: AND opp.assigned_process = p_seq_next
9044: AND opp.object_type = 'ACCRUAL_CONTRACT'
9045: AND chr.scs_code = 'LEASE'

Line 9053: FROM OKC_K_HEADERS_B chr, OKC_K_LINES_B cle, okl_parallel_processes opp

9049: -- modified by zrehman for Bug#6788005 on 04-Feb-2008 start
9050: UNION
9051: SELECT chr.contract_number contract_number
9052: ,count(cle.id) line_count
9053: FROM OKC_K_HEADERS_B chr, OKC_K_LINES_B cle, okl_parallel_processes opp
9054: WHERE opp.object_value = chr.contract_number
9055: AND opp.assigned_process = p_seq_next
9056: AND opp.object_type = 'ACCRUAL_CONTRACT'
9057: AND chr.scs_code = 'INVESTOR'