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 3303: from okc_k_party_roles_b

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

Line 3309: from okc_k_party_roles_b

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

Line 3316: 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);

3312:
3313: cursor line_party(p_code Varchar2) is
3314: select Max(a.level_sequence) from okc_ancestrys a
3315: where a.cle_id = p_line_id
3316: 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);
3317:
3318: cursor header_party(p_code Varchar2) is
3319: select count(*) from okc_k_party_roles_b
3320: where dnz_chr_id = p_header_id and chr_id = p_header_id

Line 3319: select count(*) from okc_k_party_roles_b

3315: where a.cle_id = p_line_id
3316: 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);
3317:
3318: cursor header_party(p_code Varchar2) is
3319: select count(*) from okc_k_party_roles_b
3320: where dnz_chr_id = p_header_id and chr_id = p_header_id
3321: and rle_code = p_code
3322: and object1_id1 is not null;
3323:

Line 3364: FROM OKC_K_PARTY_ROLES_B

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

Line 3422: from okc_k_party_roles_b

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

Line 3497: from okc_k_party_roles_b

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

Line 3544: from okc_k_party_roles_b

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

Line 4183: select id from okc_k_party_roles_b

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