APPS.OKS_BILLING_PUB dependencies on OKC_K_REL_OBJS

Line 713: /*AND not exists ( select 1 from okc_k_rel_objs rel

709: WHERE sub_line.cle_id = p_cle_id
710: AND sub_line.date_cancelled is NULL --[llc]
711: AND sub_line.id = rul.cle_id
712: AND sub_line.lse_id in (8,7,9,10,11,13,25,35);
713: /*AND not exists ( select 1 from okc_k_rel_objs rel
714: WHERE rel.cle_id = sub_line.id ); Commented for 16039680 */
715:
716:
717: /*FOR BILLING REPORT*/

Line 725: /*AND not exists ( select 1 from okc_k_rel_objs rel

721: FROM OKC_K_LINES_B sub_line
722: WHERE sub_line.cle_id = p_cle_id
723: AND sub_line.lse_id in (8,7,9,10,11,13,25,35)
724: AND sub_line.date_cancelled is NULL; --[llc]
725: /*AND not exists ( select 1 from okc_k_rel_objs rel
726: where rel.cle_id = sub_line.id ); Commented for 16039680 */
727:
728:
729: Cursor get_counter_qty(p_cle_id Number, p_lock_read number) IS

Line 3086: /*AND not exists ( select 1 from okc_k_rel_objs rel

3082: FROM OKC_K_LINES_B sub_line
3083: WHERE sub_line.cle_id =usage_line_Rec.line_id
3084: AND sub_line.lse_id in (8,7,9,10,11,13,25,35)
3085: AND sub_line.date_cancelled is NULL ; --[llc]
3086: /*AND not exists ( select 1 from okc_k_rel_objs rel
3087: where rel.cle_id = sub_line.id ); Commented for 16039680 */
3088:
3089: for bsl_rec IN bsl_cur(usage_line_rec.line_id,bulk_qp_hdr_id_rec.DNZ_chr_id)
3090: LOOP

Line 3734: /*AND not exists ( select 1 from okc_k_rel_objs rel

3730: WHERE sub_line.cle_id = p_cle_id
3731: AND sub_line.date_cancelled is NULL --[llc]
3732: AND sub_line.id = rul.cle_id
3733: AND sub_line.lse_id in (8,7,9,10,11,13,25,35);
3734: /*AND not exists ( select 1 from okc_k_rel_objs rel
3735: WHERE rel.cle_id = sub_line.id ); Commented for 16039680 */
3736:
3737:
3738: /*FOR BILLING REPORT*/

Line 3746: /*AND not exists ( select 1 from okc_k_rel_objs rel

3742: FROM OKC_K_LINES_B sub_line
3743: WHERE sub_line.cle_id = p_cle_id
3744: AND sub_line.lse_id in (8,7,9,10,11,13,25,35)
3745: AND sub_line.date_cancelled is NULL ; --[llc]
3746: /*AND not exists ( select 1 from okc_k_rel_objs rel
3747: where rel.cle_id = sub_line.id ); Commented for 16039680*/
3748:
3749:
3750: Cursor get_counter_qty(p_cle_id Number, p_lock_read number) IS

Line 4606: /*AND not exists ( select 1 from okc_k_rel_objs rel

4602: FROM OKC_K_LINES_B sub_line
4603: WHERE sub_line.cle_id = p_cle_id
4604: AND sub_line.date_cancelled is NULL -- [llc]
4605: AND sub_line.lse_id in (8,7,9,10,11,13,25,35);
4606: /*AND not exists ( select 1 from okc_k_rel_objs rel
4607: where rel.cle_id = sub_line.id ); Commented for 16039680*/
4608:
4609: Cursor qty_uom_csr(p_cle_id Number) Is
4610: SELECT okc.Number_of_items

Line 4634: /*AND not exists ( select 1 from okc_k_rel_objs rel

4630: FROM OKC_K_LINES_B sub_line
4631: WHERE sub_line.cle_id = p_cle_id
4632: AND sub_line.date_cancelled is NULL -- [llc]
4633: AND sub_line.lse_id in (8,7,9,10,11,13,25,35);
4634: /*AND not exists ( select 1 from okc_k_rel_objs rel
4635: where rel.cle_id = sub_line.id ); Commented for 16039680 */
4636: /*FOR BILLING REPORT*/
4637: Cursor top_line_amount(p_cle_id NUMBER) Is
4638: Select sum(AMOUNT)

Line 5450: SELECT 1 from okc_k_rel_objs

5446: AND active_flag = 'Y';
5447:
5448:
5449: Cursor l_okl_contract_csr(p_chr_id IN NUMBER) is
5450: SELECT 1 from okc_k_rel_objs
5451: WHERE rty_code in ('OKLSRV','OKLUBB')
5452: AND jtot_object1_code = 'OKL_SERVICE'
5453: AND object1_id1 = to_char(p_chr_id);
5454:

Line 6316: From okc_k_rel_objs rel

6312: AND line.sts_code = as1.sts_code
6313: AND as1.scs_code = Hdr.scs_code
6314: AND sts.code = Hdr.sts_code;
6315: /*AND line.id not in ( Select rel.cle_id
6316: From okc_k_rel_objs rel
6317: Where rel.cle_id is not null
6318: );*/ ---Commented for ER 16039680
6319: /*added for bug7668259*/
6320: ELSIF l_hint = 'FULL' THEN /*full parallel processing of data*/

Line 6372: From okc_k_rel_objs rel

6368: AND line.sts_code = as1.sts_code
6369: AND as1.scs_code = Hdr.scs_code
6370: AND sts.code = Hdr.sts_code;
6371: /*AND line.id not in ( Select /*+ nl_aj rel.cle_id
6372: From okc_k_rel_objs rel
6373: Where rel.cle_id is not null
6374: );*/ ---Commented for ER 16039680
6375: ELSE
6376: INSERT /*+ append */ into oks_process_billing

Line 6413: From okc_k_rel_objs rel

6409: AND line.sts_code = as1.sts_code
6410: AND as1.scs_code = Hdr.scs_code
6411: AND sts.code = Hdr.sts_code;
6412: /*AND line.id not in ( Select /*+ nl_aj rel.cle_id
6413: From okc_k_rel_objs rel
6414: Where rel.cle_id is not null
6415: );*/ ---Commented for ER 16039680
6416: END IF;
6417: /*modified for bug7668259*/

Line 6453: From okc_k_rel_objs rel

6449: AND line.sts_code = as1.sts_code
6450: AND as1.scs_code = Hdr.scs_code
6451: AND sts.code = Hdr.sts_code;
6452: /*AND line.id not in ( Select rel.cle_id
6453: From okc_k_rel_objs rel
6454: Where rel.cle_id is not null
6455: ); */ ---Commented for ER 16039680
6456: END IF;
6457: Elsif

Line 6502: From okc_k_rel_objs rel

6498: AND line.sts_code = as1.sts_code
6499: AND as1.scs_code = Hdr.scs_code
6500: AND sts.code = Hdr.sts_code;
6501: /*AND line.id not in ( Select rel.cle_id
6502: From okc_k_rel_objs rel
6503: Where rel.cle_id is not null
6504: );*/ ---Commented for ER 16039680
6505: /*modified for bug7668259*/
6506: ELSE /*l_hook = 0, so parallel processing of data*/

Line 6543: From okc_k_rel_objs rel

6539: AND line.sts_code = as1.sts_code
6540: AND as1.scs_code = Hdr.scs_code
6541: AND sts.code = Hdr.sts_code
6542: /*AND line.id not in ( Select rel.cle_id
6543: From okc_k_rel_objs rel
6544: Where rel.cle_id is not null
6545: ) */ ---Commented for ER 16039680
6546: /*Added for bug 13932146 */
6547: AND EXISTS (

Line 6585: From okc_k_rel_objs rel

6581: and a.opn_code = 'INVOICE'
6582: and a.allowed_yn = 'Y' )
6583: AND line.lse_id in (1,12,19,46);
6584: /* AND line.id not in ( Select rel.cle_id
6585: From okc_k_rel_objs rel
6586: Where rel.cle_id is not null );*/ ---Commented for ER 16039680
6587:
6588: Elsif
6589: (p_grp_id is not null) and (p_customer_id is null) and

Line 6640: From okc_k_rel_objs rel

6636: AND as1.scs_code = Hdr.scs_code
6637: AND sts.code = Hdr.sts_code
6638: AND cgp.included_chr_id = Hdr.id;
6639: /* AND line.id not in ( Select /*+ index_ffs (rel) HASH_AJ rel.cle_id
6640: From okc_k_rel_objs rel
6641: Where rel.cle_id is not null
6642: ); */ ---Commented for ER 16039680
6643: /*modified for bug7668259*/
6644: ELSE /*l_hook = 0, so normal processing of data*/

Line 6688: From okc_k_rel_objs rel

6684: AND as1.scs_code = Hdr.scs_code
6685: AND sts.code = Hdr.sts_code
6686: AND cgp.included_chr_id = Hdr.id;
6687: /*AND line.id not in ( Select /*+ index_ffs (rel) HASH_AJ rel.cle_id
6688: From okc_k_rel_objs rel
6689: Where rel.cle_id is not null
6690: );*/ ---Commented for ER 16039680
6691: END IF;
6692: ELSIF

Line 6729: From okc_k_rel_objs rel

6725: and a.opn_code = 'INVOICE'
6726: and a.allowed_yn = 'Y' )
6727: AND line.lse_id in (1,12,19,46);
6728: /* AND line.id not in ( Select rel.cle_id
6729: From okc_k_rel_objs rel
6730: Where rel.cle_id is not null );*/ ---Commented for ER 16039680
6731:
6732: /*modified for bug7668259*/
6733: ELSE /*l_hook = 0, so normal processing of data*/

Line 6760: From okc_k_rel_objs rel

6756: and a.opn_code = 'INVOICE'
6757: and a.allowed_yn = 'Y' )
6758: AND line.lse_id in (1,12,19,46);
6759: /*AND line.id not in ( Select rel.cle_id
6760: From okc_k_rel_objs rel
6761: Where rel.cle_id is not null ); */ ---Commented for ER 16039680
6762: END IF;
6763: Else
6764: If l_write_log then -- by ansraj for bug 14016663

Line 6800: From okc_k_rel_objs rel

6796: and a.opn_code = 'INVOICE'
6797: and a.allowed_yn = 'Y' )
6798: AND line.lse_id in (1,12,19,46);
6799: /*AND line.id not in ( Select rel.cle_id
6800: From okc_k_rel_objs rel
6801: Where rel.cle_id is not null ); */ ---Commented for ER 16039680
6802:
6803: End if; -- End if clause for null parameters check
6804: