DBA Data[Home] [Help]

APPS.OKL_GENERATE_ACCRUALS_PVT dependencies on OKC_LINE_STYLES_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 1507: okc_line_styles_b lse_fa,

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,
1511: okl_k_headers_full_v khr

Line 1509: okc_line_styles_b lse_ml,

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
1513: AND kle_fa.chr_id = cp_chr_id

Line 1534: OKC_LINE_STYLES_B lsy

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