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_CONTRACT_REBOOK_PVT dependencies on OKC_K_ITEMS

Line 3418: ,okc_k_items item

3414: -- Bug 12938353: RGOOTY: Income Fee Enhancement
3415: ,okl.origination_income
3416: FROM okc_k_lines_b okc
3417: ,okl_k_lines okl
3418: ,okc_k_items item
3419: ,okc_line_styles_b style
3420: --,okc_k_party_roles_b partyb -- change added for Rebook Change Control Enhancement
3421: WHERE okc.id = okl.id
3422: AND okc.id = item.cle_id

Line 3477: okc_k_items item,

3473: -- Bug 12938353: RGOOTY: Income Fee Enhancement
3474: okl.origination_income
3475: FROM okc_k_lines_b okc,
3476: okl_k_lines okl,
3477: okc_k_items item,
3478: okc_line_styles_b style
3479: --okc_k_party_roles_b partyb
3480: WHERE okc.id = okl.id
3481: AND okc.id = item.cle_id

Line 3521: FROM okc_k_items

3517:
3518: CURSOR orig_fee_item_csr (p_line_id NUMBER,
3519: p_chr_id NUMBER) IS
3520: SELECT id
3521: FROM okc_k_items
3522: WHERE cle_id = p_line_id
3523: AND dnz_chr_id = p_chr_id
3524: AND jtot_object1_code = 'OKL_STRMTYP';
3525:

Line 3540: okc_k_items item,

3536: item.id item_id, item.object1_id1, item.object1_id2, item.jtot_object1_code
3537: FROM okc_k_lines_b okc_cov_ast,
3538: okl_k_lines okl,
3539: okc_line_styles_b style,
3540: okc_k_items item,
3541: okc_k_lines_v okc_fin
3542: WHERE okc_cov_ast.cle_id = p_top_line_id
3543: AND okc_cov_ast.dnz_chr_id = p_chr_id
3544: AND okc_cov_ast.id = okl.id

Line 3564: okc_k_items item

3560: item.id item_id, item.object1_id1, item.object1_id2, item.jtot_object1_code
3561: FROM okc_k_lines_v okc,
3562: okl_k_lines okl,
3563: okc_line_styles_b style,
3564: okc_k_items item
3565: WHERE okc.id = p_sub_line_id
3566: AND okc.dnz_chr_id = p_chr_id
3567: AND okc.id = okl.id
3568: AND okc.id = item.cle_id

Line 3588: okc_k_items_v origk

3584: origk.id orig_link_fee_item_id,
3585: origp.id orig_parent_fee_id
3586: from okc_k_lines_b origl,
3587: okc_k_lines_b origp,
3588: okc_k_items_v origk
3589: where origl.dnz_chr_id = p_orig_chr_id
3590: and origl.lse_id = 53 -- LINK_FEE_ASSET
3591: and origl.cle_id = origp.id
3592: and origl.dnz_chr_id = origp.dnz_chr_id

Line 3824: -- item id in okc_k_items remains as of the original contract

3820:
3821: )THEN
3822: l_orig_st_fee_rec.line_id := c_fee_rbk_rec.orig_system_id1;
3823: l_orig_st_fee_rec.dnz_chr_id := p_orig_chr_id;
3824: -- item id in okc_k_items remains as of the original contract
3825: l_orig_st_fee_rec.item_id := c_fee_orig_rec.item_id;
3826: l_orig_st_fee_rec.item_id1 := c_fee_rbk_rec.object1_id1;
3827: l_orig_st_fee_rec.item_id2 := c_fee_rbk_rec.object1_id2;
3828: -- l_orig_st_fee_rec.effective_from := c_fee_rbk_rec.start_date;

Line 4380: ,okc_k_items item

4376: ,okl.attribute14
4377: ,okl.attribute15
4378: FROM okc_k_lines_v okc
4379: ,okl_k_lines okl
4380: ,okc_k_items item
4381: ,okc_line_styles_b style
4382: WHERE okc.id = okl.id
4383: AND okc.id = item.cle_id
4384: AND okc.dnz_chr_id = item.dnz_chr_id

Line 4433: okc_k_items item,

4429: okl.attribute14,
4430: okl.attribute15
4431: FROM okc_k_lines_v okc,
4432: okl_k_lines okl,
4433: okc_k_items item,
4434: okc_line_styles_b style
4435: WHERE okc.id = okl.id
4436: AND okc.id = item.cle_id
4437: AND okc.dnz_chr_id = item.dnz_chr_id

Line 4456: okc_k_items item,

4452: item.id item_id, item.object1_id1, item.object1_id2, item.jtot_object1_code
4453: FROM okc_k_lines_b okc_cov_ast,
4454: okl_k_lines okl,
4455: okc_line_styles_b style,
4456: okc_k_items item,
4457: okc_k_lines_v okc_fin
4458: WHERE okc_cov_ast.cle_id = p_top_line_id
4459: AND okc_cov_ast.dnz_chr_id = p_chr_id
4460: AND okc_cov_ast.id = okl.id

Line 4479: okc_k_items item

4475: item.id item_id, item.object1_id1, item.object1_id2, item.jtot_object1_code
4476: FROM okc_k_lines_v okc,
4477: okl_k_lines okl,
4478: okc_line_styles_b style,
4479: okc_k_items item
4480: WHERE okc.id = p_sub_line_id
4481: AND okc.dnz_chr_id = p_chr_id
4482: AND okc.id = okl.id
4483: AND okc.id = item.cle_id

Line 5602: FROM okc_k_items cim,

5598: cim.object1_id1,
5599: cim.object1_id2,
5600: cim.jtot_object1_code,
5601: cle.lse_id
5602: FROM okc_k_items cim,
5603: okc_k_lines_b cle
5604: WHERE cim.cle_id = cle.id
5605: AND cle.id = p_cle_id;
5606: l_items_rec items_csr%ROWTYPE;

Line 5627: l_item_cle_id_old okc_k_items.cle_id%type;

5623: FROM okc_k_party_roles_b cpl
5624: WHERE cpl.cle_id = p_cle_id
5625: AND cpl.dnz_chr_id = p_chr_id
5626: AND cpl.jtot_object1_code = 'OKX_VENDOR';
5627: l_item_cle_id_old okc_k_items.cle_id%type;
5628: l_item_id_old okc_k_items.id%type;
5629:
5630: l_party_roles_new_rec party_roles_csr%ROWTYPE;
5631: l_party_roles_old_rec party_roles_csr%ROWTYPE;

Line 5628: l_item_id_old okc_k_items.id%type;

5624: WHERE cpl.cle_id = p_cle_id
5625: AND cpl.dnz_chr_id = p_chr_id
5626: AND cpl.jtot_object1_code = 'OKX_VENDOR';
5627: l_item_cle_id_old okc_k_items.cle_id%type;
5628: l_item_id_old okc_k_items.id%type;
5629:
5630: l_party_roles_new_rec party_roles_csr%ROWTYPE;
5631: l_party_roles_old_rec party_roles_csr%ROWTYPE;
5632: