APPS.OKL_SPLIT_ASSET_PVT dependencies on OKC_K_LINES_TL

Line 5031: FROM okc_k_lines_tl

5027:
5028: --cursor for asset_number
5029: CURSOR asset_num_csr (P_fin_ast_id IN NUMBER) IS
5030: SELECT name
5031: FROM okc_k_lines_tl
5032: WHERE id = p_fin_ast_id;
5033:
5034: l_asset_number OKC_K_LINES_TL.NAME%TYPE;
5035:

Line 5034: l_asset_number OKC_K_LINES_TL.NAME%TYPE;

5030: SELECT name
5031: FROM okc_k_lines_tl
5032: WHERE id = p_fin_ast_id;
5033:
5034: l_asset_number OKC_K_LINES_TL.NAME%TYPE;
5035:
5036: --Bug# 3222804 : serial # control based on leasing inv org setup
5037: --cursor to find serialized item instances in installed base
5038: CURSOR l_srl_no_count_csr(fin_ast_id IN NUMBER) IS

Line 5399: FROM okc_k_lines_tl

5395:
5396: --cursor for asset_number
5397: CURSOR asset_num_csr (P_fin_ast_id IN NUMBER) IS
5398: SELECT name
5399: FROM okc_k_lines_tl
5400: WHERE id = p_fin_ast_id;
5401:
5402: l_asset_number OKC_K_LINES_TL.NAME%TYPE;
5403:

Line 5402: l_asset_number OKC_K_LINES_TL.NAME%TYPE;

5398: SELECT name
5399: FROM okc_k_lines_tl
5400: WHERE id = p_fin_ast_id;
5401:
5402: l_asset_number OKC_K_LINES_TL.NAME%TYPE;
5403:
5404: BEGIN
5405: x_return_status := OKL_API.G_RET_STS_SUCCESS;
5406:

Line 5911: okc_k_lines_tl clet,

5907: FROM okc_k_items cim_fa,
5908: okc_k_lines_b cle_fa,
5909: okc_line_styles_b lse_fa,
5910: okl_k_lines kle,
5911: okc_k_lines_tl clet,
5912: okc_k_lines_b cle
5913: WHERE cim_fa.cle_id = cle_fa.id
5914: AND cle_fa.cle_id = cle.id
5915: AND cle_fa.dnz_chr_id = cle.dnz_chr_id

Line 8937: okc_k_lines_tl clet_sub,

8933: FROM
8934: po_vendors pov,
8935: okc_k_party_roles_b cplb,
8936: okl_k_lines kle_sub,
8937: okc_k_lines_tl clet_sub,
8938: okc_k_lines_b cleb_sub,
8939: okc_line_styles_b lseb_sub,
8940: okc_k_lines_tl clet_asst,
8941: okc_k_lines_b cleb_asst

Line 8940: okc_k_lines_tl clet_asst,

8936: okl_k_lines kle_sub,
8937: okc_k_lines_tl clet_sub,
8938: okc_k_lines_b cleb_sub,
8939: okc_line_styles_b lseb_sub,
8940: okc_k_lines_tl clet_asst,
8941: okc_k_lines_b cleb_asst
8942: WHERE
8943: pov.vendor_id = cplb.object1_id1
8944: AND cplb.object1_id2 = '#'

Line 16218: FROM okc_k_lines_tl

16214:
16215: --cursor for asset_number
16216: CURSOR asset_num_csr (P_fin_ast_id IN NUMBER) IS
16217: SELECT name
16218: FROM okc_k_lines_tl
16219: WHERE id = p_fin_ast_id;
16220:
16221: l_asset_number OKC_K_LINES_TL.NAME%TYPE;
16222:

Line 16221: l_asset_number OKC_K_LINES_TL.NAME%TYPE;

16217: SELECT name
16218: FROM okc_k_lines_tl
16219: WHERE id = p_fin_ast_id;
16220:
16221: l_asset_number OKC_K_LINES_TL.NAME%TYPE;
16222:
16223: --cursor to fetch serial number control code
16224: CURSOR srl_ctrl_csr (PInvItmId IN NUMBER,
16225: P_fin_ast_id IN NUMBER) IS

Line 16735: FROM okc_k_lines_tl

16731:
16732: --cursor for asset_number
16733: CURSOR asset_num_csr (P_fin_ast_id IN NUMBER) IS
16734: SELECT name
16735: FROM okc_k_lines_tl
16736: WHERE id = p_fin_ast_id;
16737:
16738: l_asset_number OKC_K_LINES_TL.NAME%TYPE;
16739:

Line 16738: l_asset_number OKC_K_LINES_TL.NAME%TYPE;

16734: SELECT name
16735: FROM okc_k_lines_tl
16736: WHERE id = p_fin_ast_id;
16737:
16738: l_asset_number OKC_K_LINES_TL.NAME%TYPE;
16739:
16740: BEGIN
16741:
16742: -- dbms_output.put_line('start');