APPS.OKS_BILLING_PUB dependencies on OKC_K_REL_OBJS

Line 630: AND not exists ( select 1 from okc_k_rel_objs rel

626: WHERE sub_line.cle_id = p_cle_id
627: AND sub_line.date_cancelled is NULL --[llc]
628: AND sub_line.id = rul.cle_id
629: AND sub_line.lse_id in (8,7,9,10,11,13,25,35)
630: AND not exists ( select 1 from okc_k_rel_objs rel
631: WHERE rel.cle_id = sub_line.id );
632:
633:
634: /*FOR BILLING REPORT*/

Line 642: AND not exists ( select 1 from okc_k_rel_objs rel

638: FROM OKC_K_LINES_B sub_line
639: WHERE sub_line.cle_id = p_cle_id
640: AND sub_line.lse_id in (8,7,9,10,11,13,25,35)
641: AND sub_line.date_cancelled is NULL --[llc]
642: AND not exists ( select 1 from okc_k_rel_objs rel
643: where rel.cle_id = sub_line.id );
644:
645:
646: Cursor get_counter_qty(p_cle_id Number, p_lock_read number) IS

Line 1473: AND not exists ( select 1 from okc_k_rel_objs rel

1469: FROM OKC_K_LINES_B sub_line
1470: WHERE sub_line.cle_id = p_cle_id
1471: AND sub_line.date_cancelled is NULL -- [llc]
1472: AND sub_line.lse_id in (8,7,9,10,11,13,25,35)
1473: AND not exists ( select 1 from okc_k_rel_objs rel
1474: where rel.cle_id = sub_line.id );
1475:
1476: Cursor qty_uom_csr(p_cle_id Number) Is
1477: SELECT okc.Number_of_items

Line 1501: AND not exists ( select 1 from okc_k_rel_objs rel

1497: FROM OKC_K_LINES_B sub_line
1498: WHERE sub_line.cle_id = p_cle_id
1499: AND sub_line.date_cancelled is NULL -- [llc]
1500: AND sub_line.lse_id in (8,7,9,10,11,13,25,35)
1501: AND not exists ( select 1 from okc_k_rel_objs rel
1502: where rel.cle_id = sub_line.id );
1503: /*FOR BILLING REPORT*/
1504: Cursor top_line_amount(p_cle_id NUMBER) Is
1505: Select sum(AMOUNT)

Line 2389: SELECT 1 from okc_k_rel_objs

2385: AND active_flag = 'Y';
2386:
2387:
2388: Cursor l_okl_contract_csr(p_chr_id IN NUMBER) is
2389: SELECT 1 from okc_k_rel_objs
2390: WHERE rty_code in ('OKLSRV','OKLUBB')
2391: AND jtot_object1_code = 'OKL_SERVICE'
2392: AND object1_id1 = to_char(p_chr_id);
2393:

Line 3144: From okc_k_rel_objs rel

3140: AND line.sts_code = as1.sts_code
3141: AND as1.scs_code = Hdr.scs_code
3142: AND sts.code = Hdr.sts_code
3143: AND line.id not in ( Select /*+ index_ffs (rel) HASH_AJ */ rel.cle_id
3144: From okc_k_rel_objs rel
3145: Where rel.cle_id is not null
3146: );
3147:
3148: Elsif

Line 3188: From okc_k_rel_objs rel

3184: AND line.sts_code = as1.sts_code
3185: AND as1.scs_code = Hdr.scs_code
3186: AND sts.code = Hdr.sts_code
3187: AND line.id not in ( Select /*+ index_ffs (rel) HASH_AJ */ rel.cle_id
3188: From okc_k_rel_objs rel
3189: Where rel.cle_id is not null
3190: );
3191: Elsif
3192: (p_contract_hdr_id is not null) Then

Line 3218: From okc_k_rel_objs rel

3214: and a.opn_code = 'INVOICE'
3215: and a.allowed_yn = 'Y' )
3216: AND line.lse_id in (1,12,19,46)
3217: AND line.id not in ( Select rel.cle_id
3218: From okc_k_rel_objs rel
3219: Where rel.cle_id is not null );
3220:
3221: Elsif
3222: (p_grp_id is not null) and (p_customer_id is null) and

Line 3267: From okc_k_rel_objs rel

3263: AND as1.scs_code = Hdr.scs_code
3264: AND sts.code = Hdr.sts_code
3265: AND cgp.included_chr_id = Hdr.id
3266: AND line.id not in ( Select /*+ index_ffs (rel) HASH_AJ */ rel.cle_id
3267: From okc_k_rel_objs rel
3268: Where rel.cle_id is not null
3269: );
3270:
3271: Else

Line 3307: From okc_k_rel_objs rel

3303: and a.opn_code = 'INVOICE'
3304: and a.allowed_yn = 'Y' )
3305: AND line.lse_id in (1,12,19,46)
3306: AND line.id not in ( Select rel.cle_id
3307: From okc_k_rel_objs rel
3308: Where rel.cle_id is not null );
3309:
3310: End if; -- End if clause for null parameters check
3311: