eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_BILLING_PUB dependencies on OKC_K_LINES_B

Line 707: FROM OKC_K_LINES_B sub_line ,

703: ,rul.usage_type usage_Type
704: ,rul.usage_est_yn usage_est_yn
705: ,rul.usage_est_method usage_est_method
706: ,rul.usage_est_start_date usage_est_start_date
707: FROM OKC_K_LINES_B sub_line ,
708: OKS_K_LINES_B rul
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

Line 721: FROM OKC_K_LINES_B sub_line

717: /*FOR BILLING REPORT*/
718:
719: Cursor subline_count(p_cle_id Number) Is
720: SELECT count(sub_line.id)
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

Line 3082: FROM OKC_K_LINES_B sub_line

3078: End If;
3079:
3080:
3081: SELECT count(usage_line_rec.line_id) INTO l_subline_count
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

Line 3728: FROM OKC_K_LINES_B sub_line ,

3724: ,rul.usage_type usage_Type
3725: ,rul.usage_est_yn usage_est_yn
3726: ,rul.usage_est_method usage_est_method
3727: ,rul.usage_est_start_date usage_est_start_date
3728: FROM OKC_K_LINES_B sub_line ,
3729: OKS_K_LINES_B rul
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

Line 3742: FROM OKC_K_LINES_B sub_line

3738: /*FOR BILLING REPORT*/
3739:
3740: Cursor subline_count(p_cle_id Number) Is
3741: SELECT count(sub_line.id)
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

Line 4602: FROM OKC_K_LINES_B sub_line

4598: ,sub_line.start_date start_date
4599: ,sub_line.end_date end_date
4600: ,sub_line.date_terminated date_terminated
4601: ,sub_line.line_number line_number /* Report */
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

Line 4630: FROM OKC_K_LINES_B sub_line

4626:
4627: /*FOR BILLING REPORT*/
4628: Cursor subline_count(p_cle_id Number) Is
4629: SELECT count(sub_line.id)
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

Line 5396: ,OKC_K_LINES_B line

5392: ,nvl(rul.summary_trx_yn,'N') summary_yn
5393: ,rline.settlement_interval
5394: FROM
5395: OKC_K_PARTY_ROLES_B okp
5396: ,OKC_K_LINES_B line
5397: ,OKS_K_LINES_B rline
5398: ,OKC_K_HEADERS_B Hdr
5399: ,OKS_K_HEADERS_B rul
5400: WHERE Hdr.id = p_hdr_id

Line 6294: okc_k_lines_b line,

6290: from oks_level_elements lvl
6291: where lvl.date_completed is null
6292: and (lvl.date_to_interface > trunc(l_date_interface_start) -1 and lvl.date_to_interface < trunc(p_date)+1)
6293: ) lvl,
6294: okc_k_lines_b line,
6295: (
6296: Select distinct scs_code,sts_code
6297: from okc_assents a
6298: where a.opn_code = 'INVOICE'

Line 6348: okc_k_lines_b line,

6344: from oks_level_elements lvl
6345: where lvl.date_completed is null
6346: and lvl.date_to_interface < trunc(p_date) + 1
6347: ) lvl,
6348: okc_k_lines_b line,
6349: (
6350: Select distinct scs_code,sts_code
6351: from okc_assents a
6352: where a.opn_code = 'INVOICE'

Line 6391: okc_k_lines_b line,

6387: from oks_level_elements lvl
6388: where lvl.date_completed is null
6389: and lvl.date_to_interface < trunc(p_date) + 1
6390: ) lvl,
6391: okc_k_lines_b line,
6392: (
6393: Select distinct scs_code,sts_code
6394: from okc_assents a
6395: where a.opn_code = 'INVOICE'

Line 6431: okc_k_lines_b line,

6427: from oks_level_elements lvl
6428: where lvl.date_completed is null
6429: and lvl.date_to_interface < trunc(p_date) + 1
6430: ) lvl,
6431: okc_k_lines_b line,
6432: (
6433: Select distinct scs_code,sts_code
6434: from okc_assents a
6435: where a.opn_code = 'INVOICE'

Line 6479: okc_k_lines_b line,

6475: from oks_level_elements lvl
6476: where lvl.date_completed is null
6477: and (lvl.date_to_interface > TRUNC(l_date_interface_start) -1 and lvl.date_to_interface < trunc(p_date)+1)
6478: ) lvl,
6479: okc_k_lines_b line,
6480: (
6481: Select distinct scs_code,sts_code
6482: from okc_assents a
6483: where a.opn_code = 'INVOICE'

Line 6520: okc_k_lines_b line,

6516: from oks_level_elements lvl
6517: where lvl.date_completed is null
6518: and lvl.date_to_interface < trunc(p_date) + 1
6519: ) lvl,*/ /*commented for bug 13932146 */
6520: okc_k_lines_b line,
6521: (
6522: Select distinct scs_code,sts_code
6523: from okc_assents a
6524: where a.opn_code = 'INVOICE'

Line 6566: from okc_k_headers_b hdr, okc_k_lines_b line

6562:
6563: INSERT into oks_process_billing (chr_id,cle_id,line_no,currency_code)
6564:
6565: SELECT hdr.id hdr_id,line.id line_id,rownum,hdr.currency_code
6566: from okc_k_headers_b hdr, okc_k_lines_b line
6567: WHERE Hdr.id = line.dnz_chr_id
6568: AND Hdr.scs_code in ('SERVICE','WARRANTY','SUBSCRIPTION')
6569: AND Hdr.Template_yn = 'N'
6570: AND Hdr.id = p_contract_hdr_id

Line 6611: okc_k_lines_b line,

6607: from oks_level_elements lvl
6608: where lvl.date_completed is null
6609: and (lvl.date_to_interface > TRUNC(l_date_interface_start) -1 AND lvl.date_to_interface < trunc(p_date) +1)
6610: ) lvl,
6611: okc_k_lines_b line,
6612: (
6613: Select /*+ FULL (a) no_merge */ distinct scs_code,sts_code
6614: from okc_assents a
6615: where a.opn_code = 'INVOICE'

Line 6659: okc_k_lines_b line,

6655: from oks_level_elements lvl
6656: where lvl.date_completed is null
6657: and (lvl.date_to_interface) < trunc(p_date)+1
6658: ) lvl,
6659: okc_k_lines_b line,
6660: (
6661: Select /*+ FULL (a) no_merge */ distinct scs_code,sts_code
6662: from okc_assents a
6663: where a.opn_code = 'INVOICE'

Line 6708: from okc_k_headers_b hdr, okc_k_lines_b line

6704: End if;
6705:
6706: INSERT into oks_process_billing (chr_id,cle_id,line_no,currency_code)
6707: SELECT hdr.id hdr_id,line.id line_id,rownum,hdr.currency_code
6708: from okc_k_headers_b hdr, okc_k_lines_b line
6709: WHERE Hdr.id = line.dnz_chr_id
6710: AND Hdr.scs_code in ('SERVICE','WARRANTY','SUBSCRIPTION')
6711: AND Hdr.Template_yn = 'N'
6712: AND Hdr.Authoring_Org_Id = l_org_id

Line 6740: from okc_k_headers_b hdr, okc_k_lines_b line

6736: End if;
6737:
6738: INSERT into oks_process_billing (chr_id,cle_id,line_no,currency_code)
6739: SELECT hdr.id hdr_id,line.id line_id,rownum,hdr.currency_code
6740: from okc_k_headers_b hdr, okc_k_lines_b line
6741: WHERE Hdr.id = line.dnz_chr_id
6742: AND Hdr.scs_code in ('SERVICE','WARRANTY','SUBSCRIPTION')
6743: AND Hdr.Template_yn = 'N'
6744: AND Hdr.Authoring_Org_Id = l_org_id

Line 6771: from okc_k_headers_b hdr, okc_k_lines_b line

6767:
6768: INSERT into oks_process_billing (chr_id,cle_id,line_no,currency_code)
6769:
6770: SELECT hdr.id hdr_id,line.id line_id,rownum,hdr.currency_code
6771: from okc_k_headers_b hdr, okc_k_lines_b line
6772: WHERE Hdr.id = line.dnz_chr_id
6773: AND Hdr.scs_code in ('SERVICE','WARRANTY','SUBSCRIPTION')
6774: AND Hdr.Template_yn = 'N'
6775: AND Hdr.Authoring_Org_Id = nvl(l_org_id, hdr.authoring_org_id)

Line 7001: okc_k_lines_b line

6997: line.lse_id bcl_lse_id
6998: FROM okc_k_headers_b hdr,
6999: oks_bill_sub_lines bsl,
7000: oks_bill_cont_lines bcl,
7001: okc_k_lines_b line
7002: WHERE line.id = bcl.cle_id
7003: AND hdr.id = line.dnz_chr_id
7004: AND hdr.id = nvl(p_contract_hdr_id,hdr.id) --Full Table Scan due to nvl condition
7005: AND hdr.scs_code = nvl(p_category,hdr.scs_code)

Line 7027: okc_k_lines_b line

7023: line.lse_id bcl_lse_id
7024: FROM okc_k_headers_b hdr,
7025: oks_bill_sub_lines bsl,
7026: oks_bill_cont_lines bcl,
7027: okc_k_lines_b line
7028: WHERE line.id = bcl.cle_id
7029: AND hdr.id = line.dnz_chr_id
7030: AND hdr.id = p_contract_hdr_id
7031: AND hdr.scs_code = nvl(p_category,hdr.scs_code)

Line 7051: okc_k_lines_b line

7047: line.lse_id bcl_lse_id
7048: FROM okc_k_headers_b hdr,
7049: oks_bill_sub_lines bsl,
7050: oks_bill_cont_lines bcl,
7051: okc_k_lines_b line
7052: WHERE line.id = bcl.cle_id
7053: AND hdr.id = line.dnz_chr_id
7054: AND hdr.scs_code = nvl(p_category,hdr.scs_code)
7055: AND hdr.org_id = nvl(p_org_id,hdr.org_id)

Line 7120: okc_k_lines_b line

7116: WHERE bcl.btn_id = -44
7117: AND bcl.bill_Action = 'TR'
7118: AND EXISTS
7119: (SELECT 1 from okc_k_headers_b hdr,
7120: okc_k_lines_b line
7121: WHERE line.id = bcl.cle_id
7122: AND hdr.id = line.dnz_chr_id
7123: AND hdr.id = p_contract_hdr_id
7124: AND hdr.scs_code = nvl(p_category,hdr.scs_code)

Line 7163: okc_k_lines_b line

7159: WHERE bcl.btn_id = -44
7160: AND bcl.bill_Action = 'TR'
7161: AND EXISTS
7162: (SELECT 1 from okc_k_headers_b hdr,
7163: okc_k_lines_b line
7164: WHERE line.id = bcl.cle_id
7165: AND hdr.id = line.dnz_chr_id
7166: AND hdr.scs_code = nvl(p_category,hdr.scs_code)
7167: AND hdr.org_id = nvl(l_org_id,hdr.org_id));

Line 7187: okc_k_lines_b line

7183: WHERE bcl.btn_id = -44
7184: AND bcl.bill_Action = 'TR'
7185: AND EXISTS
7186: (SELECT 1 from okc_k_headers_b hdr,
7187: okc_k_lines_b line
7188: WHERE line.id = bcl.cle_id
7189: AND hdr.id = line.dnz_chr_id
7190: AND hdr.id = nvl(p_contract_hdr_id,hdr.id)
7191: AND hdr.scs_code = nvl(p_category,hdr.scs_code)