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_PARTY_ROLES_B

Line 2468: FROM okc_k_party_roles_b rbk

2464: rbk.object1_id1,
2465: rbk.object1_id2,
2466: rbk.jtot_object1_code,
2467: rbk.rle_code
2468: FROM okc_k_party_roles_b rbk
2469: WHERE rbk.chr_id = p_rebook_chr_id
2470: AND rbk.jtot_object1_code = 'OKX_VENDOR' -- Bug# 3311403
2471: AND NOT EXISTS (
2472: SELECT 'Y'

Line 2473: FROM okc_k_party_roles_b orig

2469: WHERE rbk.chr_id = p_rebook_chr_id
2470: AND rbk.jtot_object1_code = 'OKX_VENDOR' -- Bug# 3311403
2471: AND NOT EXISTS (
2472: SELECT 'Y'
2473: FROM okc_k_party_roles_b orig
2474: WHERE orig.object1_id1 = rbk.object1_id1
2475: AND orig.object1_id2 = rbk.object1_id2
2476: AND orig.jtot_object1_code = rbk.jtot_object1_code
2477: AND orig.rle_code = rbk.rle_code

Line 2526: FROM okc_k_party_roles_b party,

2522: pyd.PROCESSING_FEE_BASIS,
2523: pyd.PROCESSING_FEE_FIXED_AMOUNT,
2524: pyd.PROCESSING_FEE_PERCENT,
2525: pyd.PAYMENT_BASIS
2526: FROM okc_k_party_roles_b party,
2527: okl_party_payment_dtls pyd
2528: WHERE party.dnz_chr_id = p_chr_id
2529: AND party.rle_code = 'OKL_VENDOR'
2530: AND party.cle_id IS NULL

Line 2996: p_vendor_id IN OKC_K_PARTY_ROLES_B.OBJECT1_ID1%TYPE,

2992: x_msg_data OUT NOCOPY VARCHAR2,
2993: p_orig_chr_id IN NUMBER,
2994: p_orig_cle_id IN NUMBER,
2995: p_orig_cpl_id IN NUMBER,
2996: p_vendor_id IN OKC_K_PARTY_ROLES_B.OBJECT1_ID1%TYPE,
2997: p_rbk_chr_id IN NUMBER,
2998: p_rbk_cle_id IN NUMBER,
2999: p_rbk_cpl_id IN NUMBER
3000: ) IS

Line 3013: CURSOR orig_pth_detail_csr (p_vendor_id OKC_K_PARTY_ROLES_B.OBJECT1_ID1%TYPE,

3009: WHERE cpl_id = p_cpl_id
3010: AND cle_id = p_cle_id
3011: AND hdr.id = dtl.payment_hdr_id;
3012:
3013: CURSOR orig_pth_detail_csr (p_vendor_id OKC_K_PARTY_ROLES_B.OBJECT1_ID1%TYPE,
3014: p_cle_id NUMBER,
3015: p_term OKL_PARTY_PAYMENT_HDR.PASSTHRU_TERM%TYPE) IS
3016: SELECT dtl.*
3017: FROM okl_party_payment_dtls dtl,

Line 3229: FROM okc_k_party_roles_b

3225: CURSOR pth_vendor_csr (p_chr_id NUMBER,
3226: p_cle_id NUMBER) IS
3227: SELECT object1_id1 vendor_id,
3228: id
3229: FROM okc_k_party_roles_b
3230: WHERE cle_id = p_cle_id
3231: AND rle_code = 'OKL_VENDOR'
3232: AND dnz_chr_id = p_chr_id;
3233:

Line 3234: CURSOR orig_vendor_csr (p_vendor_id OKC_K_PARTY_ROLES_B.OBJECT1_id1%TYPE,

3230: WHERE cle_id = p_cle_id
3231: AND rle_code = 'OKL_VENDOR'
3232: AND dnz_chr_id = p_chr_id;
3233:
3234: CURSOR orig_vendor_csr (p_vendor_id OKC_K_PARTY_ROLES_B.OBJECT1_id1%TYPE,
3235: p_cle_id NUMBER) IS
3236: SELECT id
3237: FROM okc_k_party_roles_b
3238: WHERE cle_id = p_cle_id

Line 3237: FROM okc_k_party_roles_b

3233:
3234: CURSOR orig_vendor_csr (p_vendor_id OKC_K_PARTY_ROLES_B.OBJECT1_id1%TYPE,
3235: p_cle_id NUMBER) IS
3236: SELECT id
3237: FROM okc_k_party_roles_b
3238: WHERE cle_id = p_cle_id
3239: AND object1_id1 = p_vendor_id
3240: AND rle_code = 'OKL_VENDOR';
3241:

Line 3248: FROM okc_k_party_roles_b orig

3244: p_rbk_chr_id NUMBER,
3245: p_rbk_cle_id NUMBER) IS
3246: SELECT orig.object1_id1,
3247: orig.id
3248: FROM okc_k_party_roles_b orig
3249: WHERE orig.cle_id = p_orig_cle_id
3250: AND orig.dnz_chr_id = p_orig_chr_id
3251: AND orig.rle_code = 'OKL_VENDOR'
3252: AND NOT EXISTS (

Line 3254: FROM okc_k_party_roles_b rbk

3250: AND orig.dnz_chr_id = p_orig_chr_id
3251: AND orig.rle_code = 'OKL_VENDOR'
3252: AND NOT EXISTS (
3253: SELECT 'Y'
3254: FROM okc_k_party_roles_b rbk
3255: WHERE rbk.rle_code = 'OKL_VENDOR'
3256: AND rbk.dnz_chr_id = p_rbk_chr_id
3257: AND rbk.cle_id = p_rbk_cle_id
3258: AND orig.object1_id1 = rbk.object1_id1

Line 3408: -- okc_k_party_roles_b and okl_k_party_roles

3404: l_cplv_rec.rle_code := 'OKL_VENDOR';
3405:
3406: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
3407: -- to create records in tables
3408: -- okc_k_party_roles_b and okl_k_party_roles
3409: /*
3410: okl_okc_migration_pvt.create_k_party_role(
3411: p_api_version => 1.0,
3412: p_init_msg_list => OKL_API.G_FALSE,

Line 3663: --,okc_k_party_roles_b partyb -- change added for Rebook Change Control Enhancement

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
3666: AND okc.dnz_chr_id = item.dnz_chr_id
3667: AND okl.id = item.cle_id

Line 3720: --okc_k_party_roles_b partyb

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
3723: AND okc.dnz_chr_id = item.dnz_chr_id
3724: AND okl.id = item.cle_id

Line 3744: FROM okc_k_party_roles_b cpl,

3740:
3741: CURSOR rbk_fee_party_csr (p_line_id NUMBER,
3742: p_chr_id NUMBER) IS
3743: SELECT id, object1_id1, object1_id2,name
3744: FROM okc_k_party_roles_b cpl,
3745: okx_vendors_v ven
3746: WHERE cpl.cle_id = p_line_id
3747: AND cpl.dnz_chr_id = p_chr_id
3748: AND cpl.rle_code = 'OKL_VENDOR'

Line 3754: FROM okc_k_party_roles_b

3750:
3751: CURSOR orig_fee_party_csr (p_line_id NUMBER,
3752: p_chr_id NUMBER) IS
3753: SELECT id, object1_id1
3754: FROM okc_k_party_roles_b
3755: WHERE cle_id = p_line_id
3756: AND dnz_chr_id = p_chr_id
3757: AND rle_code = 'OKL_VENDOR';
3758:

Line 4396: -- okc_k_party_roles_b and okl_k_party_roles

4392: l_cplv_rec.object1_id1 := rbk_fee_party_rec.object1_id1;
4393:
4394: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
4395: -- to update records in tables
4396: -- okc_k_party_roles_b and okl_k_party_roles
4397: /*
4398: okl_okc_migration_pvt.update_k_party_role(
4399: p_api_version => 1.0,
4400: p_init_msg_list => OKL_API.G_FALSE,

Line 4438: -- okc_k_party_roles_b and okl_k_party_roles

4434: l_cplv_rec.rle_code := 'OKL_VENDOR';
4435:
4436: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
4437: -- to create records in tables
4438: -- okc_k_party_roles_b and okl_k_party_roles
4439: /*
4440: okl_okc_migration_pvt.create_k_party_role(
4441: p_api_version => 1.0,
4442: p_init_msg_list => OKL_API.G_FALSE,

Line 4732: FROM okc_k_party_roles_b cpl

4728: cpl.object1_id1,
4729: cpl.object1_id2,
4730: cpl.jtot_object1_code,
4731: cpl.rle_code
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;