APPS.OKL_VERSION_PVT dependencies on OKC_K_LINES_B

Line 302: okc_k_lines_b cle

298: okc_line_styles_b lse3,
299: okc_line_styles_b lse2,
300: okc_line_styles_b lse1,
301: okc_k_items_v cim,
302: okc_k_lines_b cle
303: WHERE cle.lse_id = lse1.id
304: AND cle.id = cim.cle_id
305: AND cle.dnz_chr_id = cim.dnz_chr_id
306: AND lse1.lty_code = G_IB_LINE_LTY_CODE

Line 317: okc_k_lines_b cle

313: AND cle.cle_id in (SELECT cle.id
314: FROM okc_subclass_top_line stl,
315: okc_line_styles_b lse2,
316: okc_line_styles_b lse1,
317: okc_k_lines_b cle
318: WHERE cle.dnz_chr_id = p_dnz_chr_id
319: AND cle.lse_id = lse1.id
320: AND lse1.lty_code = G_INST_LINE_LTY_CODE
321: AND lse1.lse_parent_id = lse2.id

Line 926: FROM OKC_K_LINES_B

922: WHERE id = p_chr_id;
923: -- Deleting the Lines
924: DELETE FROM OKL_K_LINES
925: WHERE id IN (SELECT id
926: FROM OKC_K_LINES_B
927: WHERE dnz_chr_id = p_chr_id);
928: -- Deleting the supplier Invoice Details
929: DELETE FROM OKL_SUPP_INVOICE_DTLS_H
930: WHERE cle_id in (select id from okc_k_lines_b where dnz_chr_id = p_chr_id);

Line 930: WHERE cle_id in (select id from okc_k_lines_b where dnz_chr_id = p_chr_id);

926: FROM OKC_K_LINES_B
927: WHERE dnz_chr_id = p_chr_id);
928: -- Deleting the supplier Invoice Details
929: DELETE FROM OKL_SUPP_INVOICE_DTLS_H
930: WHERE cle_id in (select id from okc_k_lines_b where dnz_chr_id = p_chr_id);
931: -- Deleting the FA Version
932: DELETE FROM OKL_CONTRACT_ASSET_H
933: WHERE DNZ_CHR_ID = p_chr_id;
934: -- Deleting the IB VERSION

Line 1008: WHERE ID in (select id from okc_k_lines_b where dnz_chr_id = p_chr_id)

1004: AND (major_version >= l_major_version OR
1005: major_version = -1)));
1006: -- Deleting the Lines
1007: DELETE FROM OKL_K_LINES_H
1008: WHERE ID in (select id from okc_k_lines_b where dnz_chr_id = p_chr_id)
1009: AND ((MAJOR_VERSION = -1
1010: AND p_called_from = 'ERASE_SAVED_VERSION') OR
1011: (p_called_from = 'RESTORE_VERSION'
1012: AND (major_version >= l_major_version OR

Line 1016: WHERE cle_id in (select id from okc_k_lines_b where dnz_chr_id = p_chr_id)

1012: AND (major_version >= l_major_version OR
1013: major_version = -1)));
1014: -- Deleting the supplier Invoice Details
1015: DELETE FROM OKL_SUPP_INVOICE_DTLS_H
1016: WHERE cle_id in (select id from okc_k_lines_b where dnz_chr_id = p_chr_id)
1017: AND ((MAJOR_VERSION = -1
1018: AND p_called_from = 'ERASE_SAVED_VERSION') OR
1019: (p_called_from = 'RESTORE_VERSION'
1020: AND (major_version >= l_major_version OR