APPS.OKL_GENERATE_ACCRUALS_PVT dependencies on OKC_K_LINES_B

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

283: SELECT 'x' FROM okc_k_items cim
284: WHERE cim.object1_id1 = to_char(chr.id)
285: AND EXISTS
286: (
287: SELECT 'x' FROM okc_k_lines_b cle, okc_line_styles_b lse
288: WHERE cle.lse_id = lse.id
289: AND lse.lty_code = 'SHARED'
290: AND cle.id = cim.cle_id
291: )

Line 1506: FROM okc_k_lines_b kle_fa,

1502:
1503: -- cursor to get Master Item from Financial Asset Line
1504: CURSOR l_mtl_sys_item_csr (cp_chr_id NUMBER, cp_cle_id NUMBER) IS
1505: SELECT RPAD (ite.object1_id1, 50, ' ') || khr.inv_organization_id
1506: FROM okc_k_lines_b kle_fa,
1507: okc_line_styles_b lse_fa,
1508: okc_k_lines_b kle_ml,
1509: okc_line_styles_b lse_ml,
1510: okc_k_items ite,

Line 1508: okc_k_lines_b kle_ml,

1504: CURSOR l_mtl_sys_item_csr (cp_chr_id NUMBER, cp_cle_id NUMBER) IS
1505: SELECT RPAD (ite.object1_id1, 50, ' ') || khr.inv_organization_id
1506: FROM okc_k_lines_b kle_fa,
1507: okc_line_styles_b lse_fa,
1508: okc_k_lines_b kle_ml,
1509: okc_line_styles_b lse_ml,
1510: okc_k_items ite,
1511: okl_k_headers_full_v khr
1512: WHERE kle_fa.id = cp_cle_id

Line 1526: FROM OKC_K_LINES_B

1522:
1523: -- cursor to get bill-to-site of customer at line level
1524: CURSOR line_bill_to_site_csr (p_chr_id NUMBER, p_cle_id NUMBER) IS
1525: SELECT bill_to_site_use_id
1526: FROM OKC_K_LINES_B
1527: WHERE id = p_cle_id
1528: AND dnz_chr_id = p_chr_id;
1529:
1530: --cursor to get lty_code

Line 1533: FROM OKC_K_LINES_B cle,

1529:
1530: --cursor to get lty_code
1531: CURSOR get_lty_code_csr(p_khr_id NUMBER, p_kle_id NUMBER) IS
1532: SELECT lsy.lty_code
1533: FROM OKC_K_LINES_B cle,
1534: OKC_LINE_STYLES_B lsy
1535: WHERE cle.dnz_chr_id = p_khr_id
1536: AND cle.id = p_kle_id
1537: AND cle.lse_id = lsy.id;

Line 4804: FROM okc_k_lines_b cle,

4800:
4801: --Added by bkatraga for bug 13447258
4802: CURSOR l_assets_csr(p_contract_id NUMBER) IS
4803: SELECT cle.id
4804: FROM okc_k_lines_b cle,
4805: okc_statuses_b sts
4806: WHERE cle.lse_id = 33
4807: AND cle.dnz_chr_id = p_contract_id
4808: AND cle.chr_id = p_contract_id

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

10033:
10034: CURSOR chk_data_volume_csr(p_seq_next VARCHAR2 ) IS
10035: SELECT chr.contract_number contract_number
10036: ,count(cle.id) line_count
10037: FROM OKC_K_HEADERS_B chr, OKC_K_LINES_B cle, okl_parallel_processes opp
10038: WHERE opp.object_value = chr.contract_number
10039: AND opp.assigned_process = p_seq_next
10040: AND opp.object_type = 'ACCRUAL_CONTRACT'
10041: AND chr.scs_code = 'LEASE'

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

10045: -- modified by zrehman for Bug#6788005 on 04-Feb-2008 start
10046: UNION
10047: SELECT chr.contract_number contract_number
10048: ,count(cle.id) line_count
10049: FROM OKC_K_HEADERS_B chr, OKC_K_LINES_B cle, okl_parallel_processes opp
10050: WHERE opp.object_value = chr.contract_number
10051: AND opp.assigned_process = p_seq_next
10052: AND opp.object_type = 'ACCRUAL_CONTRACT'
10053: AND chr.scs_code = 'INVESTOR'