APPS.OKE_CONTRACT_PUB dependencies on OKC_K_HEADERS_B

Line 1129: FROM OKC_K_HEADERS_B

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

Line 3184: select buy_or_sell from okc_k_headers_b

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

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

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

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

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

Line 3325: select buy_or_sell from okc_k_headers_b

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

Line 3357: from okc_k_headers_b

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

Line 3661: FROM OKC_K_HEADERS_B

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

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

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

Line 3940: FROM OKC_STATUSES_B ST, OKC_K_HEADERS_B KH

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