eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_SPLIT_ASSET_PVT dependencies on OKL_K_LINES

Line 801: from okl_k_lines

797:
798: cursor l_kleb_csr (p_cle_id in number) IS
799: select CAPITALIZE_DOWN_PAYMENT_YN ,
800: CAPITAL_REDUCTION
801: from okl_k_lines
802: where id=p_cle_id ;
803:
804: l_kleb_rec l_kleb_csr%ROWTYPE;
805:

Line 3412: FROM okl_k_lines_full_v kle,

3408:
3409: --chk for asset on asset line
3410: CURSOR asset_chk_curs2 (p_asset_number IN VARCHAR2) IS
3411: SELECT 'Y'
3412: FROM okl_k_lines_full_v kle,
3413: okc_line_styles_b lse
3414: WHERE kle.name = p_asset_number
3415: AND kle.lse_id = lse.id
3416: --and lse.lty_code = 'FIXED_ASSET';

Line 3500: FROM okl_k_lines_full_v kle,

3496:
3497: --chk for asset on asset line
3498: CURSOR asset_chk_curs2 (p_asset_number IN VARCHAR2) IS
3499: SELECT 'Y'
3500: FROM okl_k_lines_full_v kle,
3501: okc_line_styles_b lse
3502: WHERE kle.name = p_asset_number
3503: AND kle.lse_id = lse.id
3504: AND lse.lty_code = 'FIXED_ASSET';

Line 5882: okl_k_lines kle,

5878: cle.sts_code LINE_STATUS
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

Line 7276: -- FUNCTION get_rec for: OKL_K_LINES_V

7272: BEGIN
7273: RETURN(get_cimv_rec(p_cle_id, l_row_notfound));
7274: END get_cimv_rec;
7275: ---------------------------------------------------------------------------
7276: -- FUNCTION get_rec for: OKL_K_LINES_V
7277: ---------------------------------------------------------------------------
7278: FUNCTION get_klev_rec (
7279: p_cle_id IN NUMBER,
7280: x_no_data_found OUT NOCOPY BOOLEAN

Line 7282: CURSOR okl_k_lines_v_csr (p_id IN NUMBER) IS

7278: FUNCTION get_klev_rec (
7279: p_cle_id IN NUMBER,
7280: x_no_data_found OUT NOCOPY BOOLEAN
7281: ) RETURN klev_rec_type IS
7282: CURSOR okl_k_lines_v_csr (p_id IN NUMBER) IS
7283: SELECT
7284: ID,
7285: OBJECT_VERSION_NUMBER,
7286: KLE_ID,

Line 7421: FROM OKL_K_LINES_V

7417: -- Bug#4508050 - smadhava - Added - End
7418: --Bug# 4631549
7419: ,Expected_asset_cost
7420:
7421: FROM OKL_K_LINES_V
7422: WHERE OKL_K_LINES_V.id = p_id;
7423: l_klev_rec klev_rec_type;
7424: BEGIN
7425:

Line 7422: WHERE OKL_K_LINES_V.id = p_id;

7418: --Bug# 4631549
7419: ,Expected_asset_cost
7420:
7421: FROM OKL_K_LINES_V
7422: WHERE OKL_K_LINES_V.id = p_id;
7423: l_klev_rec klev_rec_type;
7424: BEGIN
7425:
7426: x_no_data_found := TRUE;

Line 7428: OPEN okl_k_lines_v_csr (p_cle_id);

7424: BEGIN
7425:
7426: x_no_data_found := TRUE;
7427: -- Get current database values
7428: OPEN okl_k_lines_v_csr (p_cle_id);
7429: FETCH okl_k_lines_v_csr INTO
7430: l_klev_rec.ID,
7431: l_klev_rec.OBJECT_VERSION_NUMBER,
7432: l_klev_rec.KLE_ID,

Line 7429: FETCH okl_k_lines_v_csr INTO

7425:
7426: x_no_data_found := TRUE;
7427: -- Get current database values
7428: OPEN okl_k_lines_v_csr (p_cle_id);
7429: FETCH okl_k_lines_v_csr INTO
7430: l_klev_rec.ID,
7431: l_klev_rec.OBJECT_VERSION_NUMBER,
7432: l_klev_rec.KLE_ID,
7433: l_klev_rec.STY_ID,

Line 7567: x_no_data_found := okl_k_lines_v_csr%NOTFOUND;

7563: -- Bug#4508050 - smadhava - Added - End
7564: --Bug# 4631549
7565: ,l_klev_rec.Expected_Asset_Cost
7566: ;
7567: x_no_data_found := okl_k_lines_v_csr%NOTFOUND;
7568: CLOSE okl_k_lines_v_csr;
7569: RETURN(l_klev_rec);
7570: END get_klev_rec;
7571:

Line 7568: CLOSE okl_k_lines_v_csr;

7564: --Bug# 4631549
7565: ,l_klev_rec.Expected_Asset_Cost
7566: ;
7567: x_no_data_found := okl_k_lines_v_csr%NOTFOUND;
7568: CLOSE okl_k_lines_v_csr;
7569: RETURN(l_klev_rec);
7570: END get_klev_rec;
7571:
7572: FUNCTION get_klev_rec (

Line 8883: okl_k_lines kle_sub,

8879: ,cleb_sub.orig_system_id1 parent_sub_cle_id
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,

Line 14912: from okl_k_lines kle

14908:
14909: --cursor to fetch expected asset cost
14910: cursor l_exp_cost_csr(p_cle_id in number) is
14911: select kle.expected_asset_cost
14912: from okl_k_lines kle
14913: where kle.id = p_cle_id;
14914:
14915: l_exp_cost_rec l_exp_cost_csr%ROWTYPE;
14916: