APPS.OKL_SPLIT_ASSET_PVT dependencies on OKC_K_LINES_TL

Line 5003: FROM okc_k_lines_tl

4999:
5000: --cursor for asset_number
5001: CURSOR asset_num_csr (P_fin_ast_id IN NUMBER) IS
5002: SELECT name
5003: FROM okc_k_lines_tl
5004: WHERE id = p_fin_ast_id;
5005:
5006: l_asset_number OKC_K_LINES_TL.NAME%TYPE;
5007:

Line 5006: l_asset_number OKC_K_LINES_TL.NAME%TYPE;

5002: SELECT name
5003: FROM okc_k_lines_tl
5004: WHERE id = p_fin_ast_id;
5005:
5006: l_asset_number OKC_K_LINES_TL.NAME%TYPE;
5007:
5008: --Bug# 3222804 : serial # control based on leasing inv org setup
5009: --cursor to find serialized item instances in installed base
5010: CURSOR l_srl_no_count_csr(fin_ast_id IN NUMBER) IS

Line 5371: FROM okc_k_lines_tl

5367:
5368: --cursor for asset_number
5369: CURSOR asset_num_csr (P_fin_ast_id IN NUMBER) IS
5370: SELECT name
5371: FROM okc_k_lines_tl
5372: WHERE id = p_fin_ast_id;
5373:
5374: l_asset_number OKC_K_LINES_TL.NAME%TYPE;
5375:

Line 5374: l_asset_number OKC_K_LINES_TL.NAME%TYPE;

5370: SELECT name
5371: FROM okc_k_lines_tl
5372: WHERE id = p_fin_ast_id;
5373:
5374: l_asset_number OKC_K_LINES_TL.NAME%TYPE;
5375:
5376: BEGIN
5377: x_return_status := OKL_API.G_RET_STS_SUCCESS;
5378:

Line 5883: okc_k_lines_tl clet,

5879: FROM okc_k_items cim_fa,
5880: okc_k_lines_b cle_fa,
5881: okc_line_styles_b lse_fa,
5882: okl_k_lines kle,
5883: okc_k_lines_tl clet,
5884: okc_k_lines_b cle
5885: WHERE cim_fa.cle_id = cle_fa.id
5886: AND cle_fa.cle_id = cle.id
5887: AND cle_fa.dnz_chr_id = cle.dnz_chr_id

Line 8884: okc_k_lines_tl clet_sub,

8880: FROM
8881: po_vendors pov,
8882: okc_k_party_roles_b cplb,
8883: okl_k_lines kle_sub,
8884: okc_k_lines_tl clet_sub,
8885: okc_k_lines_b cleb_sub,
8886: okc_line_styles_b lseb_sub,
8887: okc_k_lines_tl clet_asst,
8888: okc_k_lines_b cleb_asst

Line 8887: okc_k_lines_tl clet_asst,

8883: okl_k_lines kle_sub,
8884: okc_k_lines_tl clet_sub,
8885: okc_k_lines_b cleb_sub,
8886: okc_line_styles_b lseb_sub,
8887: okc_k_lines_tl clet_asst,
8888: okc_k_lines_b cleb_asst
8889: WHERE
8890: pov.vendor_id = cplb.object1_id1
8891: AND cplb.object1_id2 = '#'

Line 16126: FROM okc_k_lines_tl

16122:
16123: --cursor for asset_number
16124: CURSOR asset_num_csr (P_fin_ast_id IN NUMBER) IS
16125: SELECT name
16126: FROM okc_k_lines_tl
16127: WHERE id = p_fin_ast_id;
16128:
16129: l_asset_number OKC_K_LINES_TL.NAME%TYPE;
16130:

Line 16129: l_asset_number OKC_K_LINES_TL.NAME%TYPE;

16125: SELECT name
16126: FROM okc_k_lines_tl
16127: WHERE id = p_fin_ast_id;
16128:
16129: l_asset_number OKC_K_LINES_TL.NAME%TYPE;
16130:
16131: --cursor to fetch serial number control code
16132: CURSOR srl_ctrl_csr (PInvItmId IN NUMBER,
16133: P_fin_ast_id IN NUMBER) IS

Line 16643: FROM okc_k_lines_tl

16639:
16640: --cursor for asset_number
16641: CURSOR asset_num_csr (P_fin_ast_id IN NUMBER) IS
16642: SELECT name
16643: FROM okc_k_lines_tl
16644: WHERE id = p_fin_ast_id;
16645:
16646: l_asset_number OKC_K_LINES_TL.NAME%TYPE;
16647:

Line 16646: l_asset_number OKC_K_LINES_TL.NAME%TYPE;

16642: SELECT name
16643: FROM okc_k_lines_tl
16644: WHERE id = p_fin_ast_id;
16645:
16646: l_asset_number OKC_K_LINES_TL.NAME%TYPE;
16647:
16648: BEGIN
16649:
16650: -- dbms_output.put_line('start');