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 2196: FROM okc_k_party_roles_b rbk

2192: rbk.object1_id1,
2193: rbk.object1_id2,
2194: rbk.jtot_object1_code,
2195: rbk.rle_code
2196: FROM okc_k_party_roles_b rbk
2197: WHERE rbk.chr_id = p_rebook_chr_id
2198: AND rbk.jtot_object1_code = 'OKX_VENDOR' -- Bug# 3311403
2199: AND NOT EXISTS (
2200: SELECT 'Y'

Line 2201: FROM okc_k_party_roles_b orig

2197: WHERE rbk.chr_id = p_rebook_chr_id
2198: AND rbk.jtot_object1_code = 'OKX_VENDOR' -- Bug# 3311403
2199: AND NOT EXISTS (
2200: SELECT 'Y'
2201: FROM okc_k_party_roles_b orig
2202: WHERE orig.object1_id1 = rbk.object1_id1
2203: AND orig.object1_id2 = rbk.object1_id2
2204: AND orig.jtot_object1_code = rbk.jtot_object1_code
2205: AND orig.rle_code = rbk.rle_code

Line 2254: FROM okc_k_party_roles_b party,

2250: pyd.PROCESSING_FEE_BASIS,
2251: pyd.PROCESSING_FEE_FIXED_AMOUNT,
2252: pyd.PROCESSING_FEE_PERCENT,
2253: pyd.PAYMENT_BASIS
2254: FROM okc_k_party_roles_b party,
2255: okl_party_payment_dtls pyd
2256: WHERE party.dnz_chr_id = p_chr_id
2257: AND party.rle_code = 'OKL_VENDOR'
2258: AND party.cle_id IS NULL

Line 2749: p_vendor_id IN OKC_K_PARTY_ROLES_B.OBJECT1_ID1%TYPE,

2745: x_msg_data OUT NOCOPY VARCHAR2,
2746: p_orig_chr_id IN NUMBER,
2747: p_orig_cle_id IN NUMBER,
2748: p_orig_cpl_id IN NUMBER,
2749: p_vendor_id IN OKC_K_PARTY_ROLES_B.OBJECT1_ID1%TYPE,
2750: p_rbk_chr_id IN NUMBER,
2751: p_rbk_cle_id IN NUMBER,
2752: p_rbk_cpl_id IN NUMBER
2753: ) IS

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

2762: WHERE cpl_id = p_cpl_id
2763: AND cle_id = p_cle_id
2764: AND hdr.id = dtl.payment_hdr_id;
2765:
2766: CURSOR orig_pth_detail_csr (p_vendor_id OKC_K_PARTY_ROLES_B.OBJECT1_ID1%TYPE,
2767: p_cle_id NUMBER,
2768: p_term OKL_PARTY_PAYMENT_HDR.PASSTHRU_TERM%TYPE) IS
2769: SELECT dtl.*
2770: FROM okl_party_payment_dtls dtl,

Line 2982: FROM okc_k_party_roles_b

2978: CURSOR pth_vendor_csr (p_chr_id NUMBER,
2979: p_cle_id NUMBER) IS
2980: SELECT object1_id1 vendor_id,
2981: id
2982: FROM okc_k_party_roles_b
2983: WHERE cle_id = p_cle_id
2984: AND rle_code = 'OKL_VENDOR'
2985: AND dnz_chr_id = p_chr_id;
2986:

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

2983: WHERE cle_id = p_cle_id
2984: AND rle_code = 'OKL_VENDOR'
2985: AND dnz_chr_id = p_chr_id;
2986:
2987: CURSOR orig_vendor_csr (p_vendor_id OKC_K_PARTY_ROLES_B.OBJECT1_id1%TYPE,
2988: p_cle_id NUMBER) IS
2989: SELECT id
2990: FROM okc_k_party_roles_b
2991: WHERE cle_id = p_cle_id

Line 2990: FROM okc_k_party_roles_b

2986:
2987: CURSOR orig_vendor_csr (p_vendor_id OKC_K_PARTY_ROLES_B.OBJECT1_id1%TYPE,
2988: p_cle_id NUMBER) IS
2989: SELECT id
2990: FROM okc_k_party_roles_b
2991: WHERE cle_id = p_cle_id
2992: AND object1_id1 = p_vendor_id
2993: AND rle_code = 'OKL_VENDOR';
2994:

Line 3001: FROM okc_k_party_roles_b orig

2997: p_rbk_chr_id NUMBER,
2998: p_rbk_cle_id NUMBER) IS
2999: SELECT orig.object1_id1,
3000: orig.id
3001: FROM okc_k_party_roles_b orig
3002: WHERE orig.cle_id = p_orig_cle_id
3003: AND orig.dnz_chr_id = p_orig_chr_id
3004: AND orig.rle_code = 'OKL_VENDOR'
3005: AND NOT EXISTS (

Line 3007: FROM okc_k_party_roles_b rbk

3003: AND orig.dnz_chr_id = p_orig_chr_id
3004: AND orig.rle_code = 'OKL_VENDOR'
3005: AND NOT EXISTS (
3006: SELECT 'Y'
3007: FROM okc_k_party_roles_b rbk
3008: WHERE rbk.rle_code = 'OKL_VENDOR'
3009: AND rbk.dnz_chr_id = p_rbk_chr_id
3010: AND rbk.cle_id = p_rbk_cle_id
3011: AND orig.object1_id1 = rbk.object1_id1

Line 3161: -- okc_k_party_roles_b and okl_k_party_roles

3157: l_cplv_rec.rle_code := 'OKL_VENDOR';
3158:
3159: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
3160: -- to create records in tables
3161: -- okc_k_party_roles_b and okl_k_party_roles
3162: /*
3163: okl_okc_migration_pvt.create_k_party_role(
3164: p_api_version => 1.0,
3165: p_init_msg_list => OKL_API.G_FALSE,

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

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

Line 3479: --okc_k_party_roles_b partyb

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

Line 3503: FROM okc_k_party_roles_b cpl,

3499:
3500: CURSOR rbk_fee_party_csr (p_line_id NUMBER,
3501: p_chr_id NUMBER) IS
3502: SELECT id, object1_id1, object1_id2,name
3503: FROM okc_k_party_roles_b cpl,
3504: okx_vendors_v ven
3505: WHERE cpl.cle_id = p_line_id
3506: AND cpl.dnz_chr_id = p_chr_id
3507: AND cpl.rle_code = 'OKL_VENDOR'

Line 3513: FROM okc_k_party_roles_b

3509:
3510: CURSOR orig_fee_party_csr (p_line_id NUMBER,
3511: p_chr_id NUMBER) IS
3512: SELECT id, object1_id1
3513: FROM okc_k_party_roles_b
3514: WHERE cle_id = p_line_id
3515: AND dnz_chr_id = p_chr_id
3516: AND rle_code = 'OKL_VENDOR';
3517:

Line 4069: -- okc_k_party_roles_b and okl_k_party_roles

4065: l_cplv_rec.object1_id1 := rbk_fee_party_rec.object1_id1;
4066:
4067: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
4068: -- to update records in tables
4069: -- okc_k_party_roles_b and okl_k_party_roles
4070: /*
4071: okl_okc_migration_pvt.update_k_party_role(
4072: p_api_version => 1.0,
4073: p_init_msg_list => OKL_API.G_FALSE,

Line 4111: -- okc_k_party_roles_b and okl_k_party_roles

4107: l_cplv_rec.rle_code := 'OKL_VENDOR';
4108:
4109: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
4110: -- to create records in tables
4111: -- okc_k_party_roles_b and okl_k_party_roles
4112: /*
4113: okl_okc_migration_pvt.create_k_party_role(
4114: p_api_version => 1.0,
4115: p_init_msg_list => OKL_API.G_FALSE,

Line 5623: FROM okc_k_party_roles_b cpl

5619: cpl.object1_id1,
5620: cpl.object1_id2,
5621: cpl.jtot_object1_code,
5622: cpl.rle_code
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;