APPS.OKS_BILLING_PUB dependencies on OKC_K_LINES_B

Line 624: FROM OKC_K_LINES_B sub_line ,

620: ,rul.usage_type usage_Type
621: ,rul.usage_est_yn usage_est_yn
622: ,rul.usage_est_method usage_est_method
623: ,rul.usage_est_start_date usage_est_start_date
624: FROM OKC_K_LINES_B sub_line ,
625: OKS_K_LINES_B rul
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

Line 638: FROM OKC_K_LINES_B sub_line

634: /*FOR BILLING REPORT*/
635:
636: Cursor subline_count(p_cle_id Number) Is
637: SELECT count(sub_line.id)
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

Line 1469: FROM OKC_K_LINES_B sub_line

1465: ,sub_line.start_date start_date
1466: ,sub_line.end_date end_date
1467: ,sub_line.date_terminated date_terminated
1468: ,sub_line.line_number line_number /* Report */
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

Line 1497: FROM OKC_K_LINES_B sub_line

1493:
1494: /*FOR BILLING REPORT*/
1495: Cursor subline_count(p_cle_id Number) Is
1496: SELECT count(sub_line.id)
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

Line 2335: ,OKC_K_LINES_B line

2331: ,nvl(rul.summary_trx_yn,'N') summary_yn
2332: ,rline.settlement_interval
2333: FROM
2334: OKC_K_PARTY_ROLES_B okp
2335: ,OKC_K_LINES_B line
2336: ,OKS_K_LINES_B rline
2337: ,OKC_K_HEADERS_B Hdr
2338: ,OKS_K_HEADERS_B rul
2339: WHERE Hdr.id = p_hdr_id

Line 3122: okc_k_lines_b line,

3118: from oks_level_elements lvl
3119: where lvl.date_completed is null
3120: and trunc(lvl.date_to_interface) <= trunc(p_date)
3121: ) lvl,
3122: okc_k_lines_b line,
3123: (
3124: Select /*+ FULL (a) no_merge */ distinct scs_code,sts_code
3125: from okc_assents a
3126: where a.opn_code = 'INVOICE'

Line 3165: okc_k_lines_b line,

3161: from oks_level_elements lvl
3162: where lvl.date_completed is null
3163: and trunc(lvl.date_to_interface) <= trunc(p_date)
3164: ) lvl,
3165: okc_k_lines_b line,
3166: (
3167: Select /*+ FULL (a) no_merge */ distinct scs_code,sts_code
3168: from okc_assents a
3169: where a.opn_code = 'INVOICE'

Line 3199: from okc_k_headers_b hdr, okc_k_lines_b line

3195:
3196: INSERT into oks_process_billing (chr_id,cle_id,line_no,currency_code)
3197:
3198: SELECT hdr.id hdr_id,line.id line_id,rownum,hdr.currency_code
3199: from okc_k_headers_b hdr, okc_k_lines_b line
3200: WHERE Hdr.id = line.dnz_chr_id
3201: AND Hdr.scs_code in ('SERVICE','WARRANTY','SUBSCRIPTION')
3202: AND Hdr.Template_yn = 'N'
3203: AND Hdr.id = p_contract_hdr_id

Line 3238: okc_k_lines_b line,

3234: from oks_level_elements lvl
3235: where lvl.date_completed is null
3236: and trunc(lvl.date_to_interface) <= trunc(p_date)
3237: ) lvl,
3238: okc_k_lines_b line,
3239: (
3240: Select /*+ FULL (a) no_merge */ distinct scs_code,sts_code
3241: from okc_assents a
3242: where a.opn_code = 'INVOICE'

Line 3278: from okc_k_headers_b hdr, okc_k_lines_b line

3274:
3275: INSERT into oks_process_billing (chr_id,cle_id,line_no,currency_code)
3276:
3277: SELECT hdr.id hdr_id,line.id line_id,rownum,hdr.currency_code
3278: from okc_k_headers_b hdr, okc_k_lines_b line
3279: WHERE Hdr.id = line.dnz_chr_id
3280: AND Hdr.scs_code in ('SERVICE','WARRANTY','SUBSCRIPTION')
3281: AND Hdr.Template_yn = 'N'
3282: AND Hdr.Authoring_Org_Id = nvl(l_org_id, hdr.authoring_org_id)

Line 3499: okc_k_lines_b line

3495: line.lse_id bcl_lse_id
3496: FROM okc_k_headers_b hdr,
3497: oks_bill_sub_lines bsl,
3498: oks_bill_cont_lines bcl,
3499: okc_k_lines_b line
3500: WHERE line.id = bcl.cle_id
3501: AND hdr.id = line.dnz_chr_id
3502: AND hdr.id = nvl(p_contract_hdr_id,hdr.id) --Full Table Scan due to nvl condition
3503: AND hdr.scs_code = nvl(p_category,hdr.scs_code)

Line 3525: okc_k_lines_b line

3521: line.lse_id bcl_lse_id
3522: FROM okc_k_headers_b hdr,
3523: oks_bill_sub_lines bsl,
3524: oks_bill_cont_lines bcl,
3525: okc_k_lines_b line
3526: WHERE line.id = bcl.cle_id
3527: AND hdr.id = line.dnz_chr_id
3528: AND hdr.id = p_contract_hdr_id
3529: AND hdr.scs_code = nvl(p_category,hdr.scs_code)

Line 3549: okc_k_lines_b line

3545: line.lse_id bcl_lse_id
3546: FROM okc_k_headers_b hdr,
3547: oks_bill_sub_lines bsl,
3548: oks_bill_cont_lines bcl,
3549: okc_k_lines_b line
3550: WHERE line.id = bcl.cle_id
3551: AND hdr.id = line.dnz_chr_id
3552: AND hdr.scs_code = nvl(p_category,hdr.scs_code)
3553: AND hdr.org_id = nvl(p_org_id,hdr.org_id)

Line 3618: okc_k_lines_b line

3614: WHERE bcl.btn_id = -44
3615: AND bcl.bill_Action = 'TR'
3616: AND EXISTS
3617: (SELECT 1 from okc_k_headers_b hdr,
3618: okc_k_lines_b line
3619: WHERE line.id = bcl.cle_id
3620: AND hdr.id = line.dnz_chr_id
3621: AND hdr.id = p_contract_hdr_id
3622: AND hdr.scs_code = nvl(p_category,hdr.scs_code)

Line 3661: okc_k_lines_b line

3657: WHERE bcl.btn_id = -44
3658: AND bcl.bill_Action = 'TR'
3659: AND EXISTS
3660: (SELECT 1 from okc_k_headers_b hdr,
3661: okc_k_lines_b line
3662: WHERE line.id = bcl.cle_id
3663: AND hdr.id = line.dnz_chr_id
3664: AND hdr.scs_code = nvl(p_category,hdr.scs_code)
3665: AND hdr.org_id = nvl(l_org_id,hdr.org_id));

Line 3685: okc_k_lines_b line

3681: WHERE bcl.btn_id = -44
3682: AND bcl.bill_Action = 'TR'
3683: AND EXISTS
3684: (SELECT 1 from okc_k_headers_b hdr,
3685: okc_k_lines_b line
3686: WHERE line.id = bcl.cle_id
3687: AND hdr.id = line.dnz_chr_id
3688: AND hdr.id = nvl(p_contract_hdr_id,hdr.id)
3689: AND hdr.scs_code = nvl(p_category,hdr.scs_code)