APPS.OKE_CONTRACT_PUB dependencies on OKC_K_HEADERS_B

Line 1130: FROM OKC_K_HEADERS_B

1126: AND opn_code = 'UPDATE';
1127:
1128: Cursor l_chrv_csr Is
1129: SELECT sts_code, scs_code
1130: FROM OKC_K_HEADERS_B
1131: WHERE id = p_clev_rec.dnz_chr_id;
1132:
1133: BEGIN
1134: -- call START_ACTIVITY to create savepoint, check compatibility

Line 3186: select buy_or_sell from okc_k_headers_b

3182: l_direction VARCHAR2(3);
3183: l_org_id Number;
3184:
3185: cursor l_default_csr(p_id number) is
3186: select buy_or_sell from okc_k_headers_b
3187: where id = p_id;
3188:
3189: cursor l_csr(p_id NUMBER) is
3190: select l.k_line_id,

Line 3222: from oke_k_lines_v l, okc_k_headers_b h, oke_k_headers k

3218: l.copies_required,
3219: l.cdrl_category,
3220: l.data_item_name,
3221: l.export_flag
3222: from oke_k_lines_v l, okc_k_headers_b h, oke_k_headers k
3223: where h.id = p_id
3224: and l.header_id = p_id
3225: and h.id = k.k_header_id
3226: and not exists (select 'x' from okc_k_lines_b s where s.cle_id = l.k_line_id)

Line 3266: from oke_k_lines_v l, okc_k_headers_b h, oke_k_headers k

3262: l.copies_required,
3263: l.cdrl_category,
3264: l.data_item_name,
3265: l.export_flag
3266: from oke_k_lines_v l, okc_k_headers_b h, oke_k_headers k
3267: where h.id = p_id
3268: and l.header_id = p_id
3269: and h.id = k.k_header_id
3270: and not exists (select 'x' from okc_k_lines_b s where s.cle_id = l.k_line_id)

Line 3327: select buy_or_sell from okc_k_headers_b

3323: and rle_code = p_code
3324: and object1_id1 is not null;
3325:
3326: cursor c is
3327: select buy_or_sell from okc_k_headers_b
3328: where id = p_header_id;
3329:
3330: cursor top_line is
3331: select 'x' from okc_ancestrys

Line 3359: from okc_k_headers_b

3355:
3356: BEGIN
3357:
3358: select buy_or_sell into l_buy_or_sell
3359: from okc_k_headers_b
3360: where id = p_header_id;
3361:
3362:
3363: IF p_line_id is not null then

Line 3663: FROM OKC_K_HEADERS_B

3659: end if;
3660:
3661: -- get inventory_org_id from header
3662: SELECT INV_ORGANIZATION_ID INTO l_inventory_org_id
3663: FROM OKC_K_HEADERS_B
3664: WHERE ID = P_HEADER_ID;
3665: IF p_first_default_flag = 'Y' then
3666:
3667: for l_csr_rec in l_csr(p_header_id)

Line 3929: (SELECT STS_CODE FROM OKC_K_HEADERS_B WHERE ID = P_CHR_ID)

3925: CURSOR check_opns IS
3926: SELECT 'X' FROM OKC_ASSENTS
3927: WHERE OPN_CODE ='DELETE'
3928: AND STS_CODE =
3929: (SELECT STS_CODE FROM OKC_K_HEADERS_B WHERE ID = P_CHR_ID)
3930: AND SCS_CODE = 'PROJECT'
3931: AND ALLOWED_YN = 'Y';
3932:
3933: CURSOR check_boa IS

Line 3942: FROM OKC_STATUSES_B ST, OKC_K_HEADERS_B KH

3938: AND K_HEADER_ID IN (SELECT BOA_ID FROM OKE_K_HEADERS);
3939:
3940: CURSOR check_sts IS
3941: SELECT 'x'
3942: FROM OKC_STATUSES_B ST, OKC_K_HEADERS_B KH
3943: WHERE KH.ID = p_chr_id
3944: AND ST.CODE = KH.STS_CODE
3945: AND ST.STE_CODE not in ( 'ENTERED','CANCELLED');
3946: