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 OKS_LEVEL_ELEMENTS

Line 745: FROM oks_level_elements lvl

741:
742: --23-DEC-2005 mchoudha fix for bug#4915367
743: Cursor bill_amount_npr (p_id IN NUMBER,p_hdr_id IN NUMBER,p_date_start IN DATE,p_date_end IN DATE) IS
744: SELECT lvl.amount
745: FROM oks_level_elements lvl
746: WHERE lvl.cle_id = p_id
747: And lvl.dnz_chr_id = p_hdr_id
748: And lvl.date_start = p_date_start
749: And lvl.date_end = p_date_end;

Line 838: -- get the rul_id for oks_level_elements

834: -------------------------------------------------------------------------
835: -- Begin partial period computation logic
836: -- Developer Mani Choudhary
837: -- Date 11-JUN-2005
838: -- get the rul_id for oks_level_elements
839: -------------------------------------------------------------------------
840: IF p_period_type IS NOT NULL AND
841: p_period_start IS NOT NULL
842: THEN

Line 944: UPDATE oks_level_elements

940: Raise USAGE_EXCEPTION;
941: END IF;
942:
943: IF (p_prv <> 2) THEN
944: UPDATE oks_level_elements
945: SET date_completed = l_bill_end_date
946: WHERE id = level_elements_tab(e_ptr).id;
947: END IF;
948:

Line 979: UPDATE oks_level_elements

975: END IF;
976:
977: /*Update date completed in coverage line */
978: IF (P_PRV <> 2) THEN
979: UPDATE oks_level_elements
980: SET date_completed = l_bill_end_date
981: WHERE id = level_coverage(1).id;
982: END IF;
983:

Line 1489: UPDATE oks_level_elements

1485: Delete from OKS_BILL_CONT_LINES
1486: where id in
1487: (select usg_bcl_id from oks_usg_qp_call_tbl where line_id=Nvl(p_line_id,LINE_ID) and dnz_chr_id=p_dnz_chr_id);
1488:
1489: UPDATE oks_level_elements
1490: SET date_completed = null
1491: WHERE id in
1492: (select level_element_id from oks_usg_qp_call_tbl where line_id=Nvl(p_line_id,LINE_ID) and dnz_chr_id=p_dnz_chr_id);
1493:

Line 1494: UPDATE oks_level_elements

1490: SET date_completed = null
1491: WHERE id in
1492: (select level_element_id from oks_usg_qp_call_tbl where line_id=Nvl(p_line_id,LINE_ID) and dnz_chr_id=p_dnz_chr_id);
1493:
1494: UPDATE oks_level_elements
1495: SET date_completed = null
1496: WHERE id in
1497: (select level_coverage_id from oks_usg_qp_call_tbl where line_id=Nvl(p_line_id,LINE_ID) and dnz_chr_id=p_dnz_chr_id);
1498:

Line 3766: FROM oks_level_elements lvl

3762:
3763: --23-DEC-2005 mchoudha fix for bug#4915367
3764: Cursor bill_amount_npr (p_id IN NUMBER,p_hdr_id IN NUMBER,p_date_start IN DATE,p_date_end IN DATE) IS
3765: SELECT lvl.amount
3766: FROM oks_level_elements lvl
3767: WHERE lvl.cle_id = p_id
3768: And lvl.dnz_chr_id = p_hdr_id
3769: And lvl.date_start = p_date_start
3770: And lvl.date_end = p_date_end;

Line 3859: -- get the rul_id for oks_level_elements

3855: -------------------------------------------------------------------------
3856: -- Begin partial period computation logic
3857: -- Developer Mani Choudhary
3858: -- Date 11-JUN-2005
3859: -- get the rul_id for oks_level_elements
3860: -------------------------------------------------------------------------
3861: IF p_period_type IS NOT NULL AND
3862: p_period_start IS NOT NULL
3863: THEN

Line 3965: UPDATE oks_level_elements

3961: Raise USAGE_EXCEPTION;
3962: END IF;
3963:
3964: IF (p_prv <> 2) THEN
3965: UPDATE oks_level_elements
3966: SET date_completed = l_bill_end_date
3967: WHERE id = level_elements_tab(e_ptr).id;
3968: END IF;
3969:

Line 4000: UPDATE oks_level_elements

3996: END IF;
3997:
3998: /*Update date completed in coverage line */
3999: IF (P_PRV <> 2) THEN
4000: UPDATE oks_level_elements
4001: SET date_completed = l_bill_end_date
4002: WHERE id = level_coverage(1).id;
4003: END IF;
4004:

Line 4639: FROM oks_level_elements

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)
4639: FROM oks_level_elements
4640: where CLE_ID= p_cle_id
4641: AND DATE_TO_INTERFACE <= p_date
4642: AND DATE_COMPLETED IS NULL;
4643:

Line 4887: UPDATE oks_level_elements

4883: END IF;
4884:
4885: IF (p_prv <> 2) THEN
4886:
4887: UPDATE oks_level_elements
4888: SET date_Completed = l_calc_rec.l_calc_edate
4889: WHERE id = level_elements_tab(e_ptr).id;
4890:
4891: END IF;

Line 4954: UPDATE oks_level_elements

4950:
4951: /* Following code is to update the date_completed field of top line */
4952:
4953: IF (p_prv <> 2) THEN
4954: UPDATE oks_level_elements
4955: SET date_completed = l_calc_rec.l_calc_edate
4956: WHERE cle_id = p_top_line_id
4957: AND date_completed is null
4958: AND date_start <= l_calc_rec.l_calc_sdate;

Line 4962: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill_Service_Item => After updating oks_level_elements ');

4958: AND date_start <= l_calc_rec.l_calc_sdate;
4959: END IF;
4960:
4961: IF (l_write_log) THEN
4962: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill_Service_Item => After updating oks_level_elements ');
4963: END IF;
4964:
4965: e_ptr := e_ptr + 1;
4966:

Line 5251: UPDATE oks_level_elements

5247: END IF;
5248:
5249: IF (p_prv <> 2) THEN
5250:
5251: UPDATE oks_level_elements
5252: SET date_completed = l_bill_end_date
5253: WHERE id = level_elements_tab(e_ptr).id;
5254:
5255: END IF;

Line 6290: from oks_level_elements lvl

6286: swap_join_inputs(sts) */
6287: hdr.id hdr_id, line.id line_id, rownum, hdr.currency_code
6288: from (
6289: Select distinct lvl.parent_cle_id
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,

Line 6344: from oks_level_elements lvl

6340: hdr.id hdr_id, line.id line_id, rownum, hdr.currency_code
6341: from (
6342: Select /*+ parallel(lvl) no_merge */ distinct
6343: lvl.parent_cle_id
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,

Line 6387: from oks_level_elements lvl

6383: hdr.id hdr_id, line.id line_id, rownum, hdr.currency_code
6384: from (
6385: Select /*+ parallel(lvl) no_merge */ distinct
6386: lvl.parent_cle_id
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,

Line 6427: from oks_level_elements lvl

6423: INSERT /*+ append */ into oks_process_billing(chr_id,cle_id,line_no,currency_code)
6424: SELECT /*+ leading(lvl,line,as1,hdr,sts) use_nl(line,hdr) use_hash(as1,sts) swap_join_inputs(as1) swap_join_inputs(sts) */
6425: hdr.id hdr_id, line.id line_id, rownum, hdr.currency_code
6426: from (Select /*+ parallel(lvl) no_merge */ distinct lvl.parent_cle_id
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,

Line 6475: from oks_level_elements lvl

6471: INSERT into oks_process_billing (chr_id,cle_id,line_no,currency_code)
6472: SELECT hdr.id hdr_id, line.id line_id, rownum, hdr.currency_code
6473: from (
6474: Select distinct lvl.parent_cle_id
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,

Line 6516: from oks_level_elements lvl

6512: INSERT into oks_process_billing (chr_id,cle_id,line_no,currency_code)
6513: SELECT hdr.id hdr_id, line.id line_id, rownum, hdr.currency_code
6514: from /*(
6515: Select /*+ parallel(lvl) distinct lvl.parent_cle_id
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,

Line 6550: FROM oks_level_elements lvl

6546: /*Added for bug 13932146 */
6547: AND EXISTS (
6548: SELECT /*+ no_unnest push_subq */
6549: 'x'
6550: FROM oks_level_elements lvl
6551: WHERE lvl.date_completed IS NULL
6552: AND lvl.date_to_interface < TRUNC (TO_DATE (p_date)) + 1
6553: AND line.ID = lvl.parent_cle_id);
6554: /*Added for bug 13932146 */

Line 6572: from oks_level_elements lvl

6568: AND Hdr.scs_code in ('SERVICE','WARRANTY','SUBSCRIPTION')
6569: AND Hdr.Template_yn = 'N'
6570: AND Hdr.id = p_contract_hdr_id
6571: AND line.id IN (Select lvl.parent_cle_id
6572: from oks_level_elements lvl
6573: where lvl.date_completed is null
6574: and lvl.date_to_interface < trunc(p_date) + 1 )
6575: AND exists (Select 1 from okc_statuses_b osb
6576: where osb.ste_code <> 'HOLD'

Line 6607: from oks_level_elements lvl

6603: swap_join_inputs(hdr) swap_join_inputs(sts) swap_join_inputs(cgp) */
6604: hdr.id hdr_id, line.id line_id, rownum, hdr.currency_code
6605: from (
6606: Select distinct lvl.parent_cle_id
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,

Line 6655: from oks_level_elements lvl

6651: swap_join_inputs(hdr) swap_join_inputs(sts) swap_join_inputs(cgp) */
6652: hdr.id hdr_id, line.id line_id, rownum, hdr.currency_code
6653: from (
6654: Select /*+ FULL (lvl) no_merge */ distinct lvl.parent_cle_id
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,

Line 6715: from oks_level_elements lvl

6711: AND Hdr.Template_yn = 'N'
6712: AND Hdr.Authoring_Org_Id = l_org_id
6713: AND Hdr.Scs_code = p_category
6714: AND line.id IN (Select lvl.parent_cle_id
6715: from oks_level_elements lvl
6716: where lvl.date_completed is null
6717: and (lvl.date_to_interface > TRUNC(l_date_interface_start) -1 AND
6718: lvl.date_to_interface < trunc(p_date) +1))
6719: AND exists (Select 1 from okc_statuses_b osb

Line 6747: from oks_level_elements lvl

6743: AND Hdr.Template_yn = 'N'
6744: AND Hdr.Authoring_Org_Id = l_org_id
6745: AND Hdr.Scs_code = p_category
6746: AND line.id IN (Select lvl.parent_cle_id
6747: from oks_level_elements lvl
6748: where lvl.date_completed is null
6749: and lvl.date_to_interface < trunc(p_date) +1)
6750: AND exists (Select 1 from okc_statuses_b osb
6751: where osb.ste_code <> 'HOLD'

Line 6787: from oks_level_elements lvl

6783: (select 1 from OKC_K_GRPINGS okg
6784: where okg.included_chr_id = hdr.id
6785: and okg.cgp_parent_id = nvl(p_grp_id, okg.cgp_parent_id) )
6786: AND line.id IN (Select lvl.parent_cle_id
6787: from oks_level_elements lvl
6788: where lvl.date_completed is null
6789: and lvl.date_to_interface < trunc(p_date) +1 ) /*13105205*/
6790: AND exists (Select 1 from okc_statuses_b osb
6791: where osb.ste_code <> 'HOLD'