APPS.OKL_CONTRACT_REBOOK_PVT dependencies on OKC_K_ITEMS

Line 3661: ,okc_k_items item

3657: ,okl.attribute14
3658: ,okl.attribute15
3659: FROM okc_k_lines_b okc
3660: ,okl_k_lines okl
3661: ,okc_k_items item
3662: ,okc_line_styles_b style
3663: --,okc_k_party_roles_b partyb -- change added for Rebook Change Control Enhancement
3664: WHERE okc.id = okl.id
3665: AND okc.id = item.cle_id

Line 3718: okc_k_items item,

3714: okl.attribute14,
3715: okl.attribute15
3716: FROM okc_k_lines_b okc,
3717: okl_k_lines okl,
3718: okc_k_items item,
3719: okc_line_styles_b style
3720: --okc_k_party_roles_b partyb
3721: WHERE okc.id = okl.id
3722: AND okc.id = item.cle_id

Line 3762: FROM okc_k_items

3758:
3759: CURSOR orig_fee_item_csr (p_line_id NUMBER,
3760: p_chr_id NUMBER) IS
3761: SELECT id
3762: FROM okc_k_items
3763: WHERE cle_id = p_line_id
3764: AND dnz_chr_id = p_chr_id
3765: AND jtot_object1_code = 'OKL_STRMTYP';
3766:

Line 3781: okc_k_items item,

3777: item.id item_id, item.object1_id1, item.object1_id2, item.jtot_object1_code
3778: FROM okc_k_lines_b okc_cov_ast,
3779: okl_k_lines okl,
3780: okc_line_styles_b style,
3781: okc_k_items item,
3782: okc_k_lines_v okc_fin
3783: WHERE okc_cov_ast.cle_id = p_top_line_id
3784: AND okc_cov_ast.dnz_chr_id = p_chr_id
3785: AND okc_cov_ast.id = okl.id

Line 3804: okc_k_items item

3800: item.id item_id, item.object1_id1, item.object1_id2, item.jtot_object1_code
3801: FROM okc_k_lines_v okc,
3802: okl_k_lines okl,
3803: okc_line_styles_b style,
3804: okc_k_items item
3805: WHERE okc.id = p_sub_line_id
3806: AND okc.dnz_chr_id = p_chr_id
3807: AND okc.id = okl.id
3808: AND okc.id = item.cle_id

Line 3828: okc_k_items_v origk

3824: origk.id orig_link_fee_item_id,
3825: origp.id orig_parent_fee_id
3826: from okc_k_lines_b origl,
3827: okc_k_lines_b origp,
3828: okc_k_items_v origk
3829: where origl.dnz_chr_id = p_orig_chr_id
3830: and origl.lse_id = 53 -- LINK_FEE_ASSET
3831: and origl.cle_id = origp.id
3832: and origl.dnz_chr_id = origp.dnz_chr_id

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

4151:
4152: )THEN
4153: l_orig_st_fee_rec.line_id := c_fee_rbk_rec.orig_system_id1;
4154: l_orig_st_fee_rec.dnz_chr_id := p_orig_chr_id;
4155: -- item id in okc_k_items remains as of the original contract
4156: l_orig_st_fee_rec.item_id := c_fee_orig_rec.item_id;
4157: l_orig_st_fee_rec.item_id1 := c_fee_rbk_rec.object1_id1;
4158: l_orig_st_fee_rec.item_id2 := c_fee_rbk_rec.object1_id2;
4159: -- l_orig_st_fee_rec.effective_from := c_fee_rbk_rec.start_date;

Line 4711: FROM okc_k_items cim,

4707: cim.object1_id1,
4708: cim.object1_id2,
4709: cim.jtot_object1_code,
4710: cle.lse_id
4711: FROM okc_k_items cim,
4712: okc_k_lines_b cle
4713: WHERE cim.cle_id = cle.id
4714: AND cle.id = p_cle_id;
4715: l_items_rec items_csr%ROWTYPE;

Line 4736: l_item_cle_id_old okc_k_items.cle_id%type;

4732: FROM okc_k_party_roles_b cpl
4733: WHERE cpl.cle_id = p_cle_id
4734: AND cpl.dnz_chr_id = p_chr_id
4735: AND cpl.jtot_object1_code = 'OKX_VENDOR';
4736: l_item_cle_id_old okc_k_items.cle_id%type;
4737: l_item_id_old okc_k_items.id%type;
4738:
4739: l_party_roles_new_rec party_roles_csr%ROWTYPE;
4740: l_party_roles_old_rec party_roles_csr%ROWTYPE;

Line 4737: l_item_id_old okc_k_items.id%type;

4733: WHERE cpl.cle_id = p_cle_id
4734: AND cpl.dnz_chr_id = p_chr_id
4735: AND cpl.jtot_object1_code = 'OKX_VENDOR';
4736: l_item_cle_id_old okc_k_items.cle_id%type;
4737: l_item_id_old okc_k_items.id%type;
4738:
4739: l_party_roles_new_rec party_roles_csr%ROWTYPE;
4740: l_party_roles_old_rec party_roles_csr%ROWTYPE;
4741: