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.OKE_CONTRACT_PUB dependencies on OKC_K_PARTY_ROLES_B

Line 3305: from okc_k_party_roles_b

3301: x_ship_from_id OUT NOCOPY NUMBER) IS
3302:
3303: cursor party_csr1(p_id Number,p_code varchar2) is
3304: select object1_id1, object1_id2, jtot_object1_code
3305: from okc_k_party_roles_b
3306: where dnz_chr_id = p_header_id and cle_id = p_id
3307: and rle_code = p_code;
3308:
3309: cursor party_csr2(p_id Number,p_code varchar2) is

Line 3311: from okc_k_party_roles_b

3307: and rle_code = p_code;
3308:
3309: cursor party_csr2(p_id Number,p_code varchar2) is
3310: select object1_id1, object1_id2, jtot_object1_code
3311: from okc_k_party_roles_b
3312: where dnz_chr_id = p_id and chr_id = p_id
3313: and rle_code = p_code;
3314:
3315: cursor line_party(p_code Varchar2) is

Line 3318: and exists(select 'x' from okc_k_party_roles_b b where b.cle_id = a.cle_id_ascendant and b.rle_code = p_code and object1_id1 is not null);

3314:
3315: cursor line_party(p_code Varchar2) is
3316: select Max(a.level_sequence) from okc_ancestrys a
3317: where a.cle_id = p_line_id
3318: and exists(select 'x' from okc_k_party_roles_b b where b.cle_id = a.cle_id_ascendant and b.rle_code = p_code and object1_id1 is not null);
3319:
3320: cursor header_party(p_code Varchar2) is
3321: select count(*) from okc_k_party_roles_b
3322: where dnz_chr_id = p_header_id and chr_id = p_header_id

Line 3321: select count(*) from okc_k_party_roles_b

3317: where a.cle_id = p_line_id
3318: and exists(select 'x' from okc_k_party_roles_b b where b.cle_id = a.cle_id_ascendant and b.rle_code = p_code and object1_id1 is not null);
3319:
3320: cursor header_party(p_code Varchar2) is
3321: select count(*) from okc_k_party_roles_b
3322: where dnz_chr_id = p_header_id and chr_id = p_header_id
3323: and rle_code = p_code
3324: and object1_id1 is not null;
3325:

Line 3366: FROM OKC_K_PARTY_ROLES_B

3362:
3363: IF p_line_id is not null then
3364:
3365: SELECT COUNT(*) INTO l_row_count
3366: FROM OKC_K_PARTY_ROLES_B
3367: WHERE dnz_chr_id = p_header_id and cle_id = p_line_id
3368: and rle_code = 'SHIP_FROM'
3369: and object1_id1 is not null;
3370:

Line 3424: from okc_k_party_roles_b

3420: where cle_id = p_line_id
3421: and level_sequence = l_level;
3422:
3423: select count(*) into l_row_count
3424: from okc_k_party_roles_b
3425: where dnz_chr_id = p_header_id and cle_id = l_id
3426: and rle_code = 'SHIP_FROM';
3427:
3428: if l_row_count = 1 then

Line 3499: from okc_k_party_roles_b

3495: l_id1 := null;
3496: end if;
3497:
3498: select count(*) into l_row_count
3499: from okc_k_party_roles_b
3500: where dnz_chr_id = p_header_id and cle_id = p_line_id
3501: and rle_code = 'SHIP_TO';
3502:
3503: if l_row_count = 1 then

Line 3546: from okc_k_party_roles_b

3542: where cle_id = p_line_id
3543: and level_sequence = l_level;
3544:
3545: select count(*) into l_row_count
3546: from okc_k_party_roles_b
3547: where dnz_chr_id = p_header_id and cle_id = l_id
3548: and rle_code = 'SHIP_TO';
3549:
3550: if l_row_count = 1 then

Line 4185: select id from okc_k_party_roles_b

4181: select id from okc_contacts
4182: where dnz_chr_id = p_chr_id;
4183:
4184: cursor c_party is
4185: select id from okc_k_party_roles_b
4186: where dnz_chr_id = p_chr_id;
4187:
4188: cursor c_alloc is
4189: select fund_allocation_id