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 808: from okl_k_lines

804:
805: cursor l_kleb_csr (p_cle_id in number) IS
806: select CAPITALIZE_DOWN_PAYMENT_YN ,
807: CAPITAL_REDUCTION
808: from okl_k_lines
809: where id=p_cle_id ;
810:
811: l_kleb_rec l_kleb_csr%ROWTYPE;
812:

Line 3440: FROM okl_k_lines_full_v kle,

3436:
3437: --chk for asset on asset line
3438: CURSOR asset_chk_curs2 (p_asset_number IN VARCHAR2) IS
3439: SELECT 'Y'
3440: FROM okl_k_lines_full_v kle,
3441: okc_line_styles_b lse
3442: WHERE kle.name = p_asset_number
3443: AND kle.lse_id = lse.id
3444: --and lse.lty_code = 'FIXED_ASSET';

Line 3528: FROM okl_k_lines_full_v kle,

3524:
3525: --chk for asset on asset line
3526: CURSOR asset_chk_curs2 (p_asset_number IN VARCHAR2) IS
3527: SELECT 'Y'
3528: FROM okl_k_lines_full_v kle,
3529: okc_line_styles_b lse
3530: WHERE kle.name = p_asset_number
3531: AND kle.lse_id = lse.id
3532: AND lse.lty_code = 'FIXED_ASSET';

Line 5910: okl_k_lines kle,

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

Line 6004: ,okl_k_lines kle

6000:
6001: SELECT NVL(kle.re_lease_yn,'N')
6002: FROM OKC_K_HEADERS_B chr
6003: ,okc_k_lines_b cle
6004: ,okl_k_lines kle
6005: WHERE chr.id = cle.chr_id
6006: and chr.id = cle.dnz_chr_id
6007: and cle.id = kle.id
6008: and chr.id = p_chr_id --p_contract_id;

Line 7329: -- FUNCTION get_rec for: OKL_K_LINES_V

7325: BEGIN
7326: RETURN(get_cimv_rec(p_cle_id, l_row_notfound));
7327: END get_cimv_rec;
7328: ---------------------------------------------------------------------------
7329: -- FUNCTION get_rec for: OKL_K_LINES_V
7330: ---------------------------------------------------------------------------
7331: FUNCTION get_klev_rec (
7332: p_cle_id IN NUMBER,
7333: x_no_data_found OUT NOCOPY BOOLEAN

Line 7335: CURSOR okl_k_lines_v_csr (p_id IN NUMBER) IS

7331: FUNCTION get_klev_rec (
7332: p_cle_id IN NUMBER,
7333: x_no_data_found OUT NOCOPY BOOLEAN
7334: ) RETURN klev_rec_type IS
7335: CURSOR okl_k_lines_v_csr (p_id IN NUMBER) IS
7336: SELECT
7337: ID,
7338: OBJECT_VERSION_NUMBER,
7339: KLE_ID,

Line 7474: FROM OKL_K_LINES_V

7470: -- Bug#4508050 - smadhava - Added - End
7471: --Bug# 4631549
7472: ,Expected_asset_cost
7473:
7474: FROM OKL_K_LINES_V
7475: WHERE OKL_K_LINES_V.id = p_id;
7476: l_klev_rec klev_rec_type;
7477: BEGIN
7478:

Line 7475: WHERE OKL_K_LINES_V.id = p_id;

7471: --Bug# 4631549
7472: ,Expected_asset_cost
7473:
7474: FROM OKL_K_LINES_V
7475: WHERE OKL_K_LINES_V.id = p_id;
7476: l_klev_rec klev_rec_type;
7477: BEGIN
7478:
7479: x_no_data_found := TRUE;

Line 7481: OPEN okl_k_lines_v_csr (p_cle_id);

7477: BEGIN
7478:
7479: x_no_data_found := TRUE;
7480: -- Get current database values
7481: OPEN okl_k_lines_v_csr (p_cle_id);
7482: FETCH okl_k_lines_v_csr INTO
7483: l_klev_rec.ID,
7484: l_klev_rec.OBJECT_VERSION_NUMBER,
7485: l_klev_rec.KLE_ID,

Line 7482: FETCH okl_k_lines_v_csr INTO

7478:
7479: x_no_data_found := TRUE;
7480: -- Get current database values
7481: OPEN okl_k_lines_v_csr (p_cle_id);
7482: FETCH okl_k_lines_v_csr INTO
7483: l_klev_rec.ID,
7484: l_klev_rec.OBJECT_VERSION_NUMBER,
7485: l_klev_rec.KLE_ID,
7486: l_klev_rec.STY_ID,

Line 7620: x_no_data_found := okl_k_lines_v_csr%NOTFOUND;

7616: -- Bug#4508050 - smadhava - Added - End
7617: --Bug# 4631549
7618: ,l_klev_rec.Expected_Asset_Cost
7619: ;
7620: x_no_data_found := okl_k_lines_v_csr%NOTFOUND;
7621: CLOSE okl_k_lines_v_csr;
7622: RETURN(l_klev_rec);
7623: END get_klev_rec;
7624:

Line 7621: CLOSE okl_k_lines_v_csr;

7617: --Bug# 4631549
7618: ,l_klev_rec.Expected_Asset_Cost
7619: ;
7620: x_no_data_found := okl_k_lines_v_csr%NOTFOUND;
7621: CLOSE okl_k_lines_v_csr;
7622: RETURN(l_klev_rec);
7623: END get_klev_rec;
7624:
7625: FUNCTION get_klev_rec (

Line 8936: okl_k_lines kle_sub,

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

Line 14967: FROM okl_k_lines kle

14963: --Bug# 15992711 : Added Cursor to check Re-Lease asset at line level
14964: --Start Modification 120.61.12010000.11 18-Jan-2013 Pratirao
14965: CURSOR l_lin_rel_ast_csr(p_cle_id in number) IS
14966: SELECT KLE.re_lease_yn
14967: FROM okl_k_lines kle
14968: WHERE kle.id = p_cle_id;
14969:
14970: l_lin_rel_ast_rec l_lin_rel_ast_csr%ROWTYPE;
14971:

Line 14977: from okl_k_lines kle

14973:
14974: --cursor to fetch expected asset cost
14975: cursor l_exp_cost_csr(p_cle_id in number) is
14976: select kle.expected_asset_cost
14977: from okl_k_lines kle
14978: where kle.id = p_cle_id;
14979:
14980: l_exp_cost_rec l_exp_cost_csr%ROWTYPE;
14981: