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 662: FROM oks_level_elements lvl

658:
659: --23-DEC-2005 mchoudha fix for bug#4915367
660: Cursor bill_amount_npr (p_id IN NUMBER,p_hdr_id IN NUMBER,p_date_start IN DATE,p_date_end IN DATE) IS
661: SELECT lvl.amount
662: FROM oks_level_elements lvl
663: WHERE lvl.cle_id = p_id
664: And lvl.dnz_chr_id = p_hdr_id
665: And lvl.date_start = p_date_start
666: And lvl.date_end = p_date_end;

Line 754: -- get the rul_id for oks_level_elements

750: -------------------------------------------------------------------------
751: -- Begin partial period computation logic
752: -- Developer Mani Choudhary
753: -- Date 11-JUN-2005
754: -- get the rul_id for oks_level_elements
755: -------------------------------------------------------------------------
756: IF p_period_type IS NOT NULL AND
757: p_period_start IS NOT NULL
758: THEN

Line 860: UPDATE oks_level_elements

856: Raise USAGE_EXCEPTION;
857: END IF;
858:
859: IF (p_prv <> 2) THEN
860: UPDATE oks_level_elements
861: SET date_completed = l_bill_end_date
862: WHERE id = level_elements_tab(e_ptr).id;
863: END IF;
864:

Line 895: UPDATE oks_level_elements

891: END IF;
892:
893: /*Update date completed in coverage line */
894: IF (P_PRV <> 2) THEN
895: UPDATE oks_level_elements
896: SET date_completed = l_bill_end_date
897: WHERE id = level_coverage(1).id;
898: END IF;
899:

Line 1506: FROM oks_level_elements

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)
1506: FROM oks_level_elements
1507: where CLE_ID= p_cle_id
1508: AND DATE_TO_INTERFACE <= p_date
1509: AND DATE_COMPLETED IS NULL;
1510:

Line 1754: UPDATE oks_level_elements

1750: END IF;
1751:
1752: IF (p_prv <> 2) THEN
1753:
1754: UPDATE oks_level_elements
1755: SET date_Completed = l_calc_rec.l_calc_edate
1756: WHERE id = level_elements_tab(e_ptr).id;
1757:
1758: END IF;

Line 1821: UPDATE oks_level_elements

1817:
1818: /* Following code is to update the date_completed field of top line */
1819:
1820: IF (p_prv <> 2) THEN
1821: UPDATE oks_level_elements
1822: SET date_completed = l_calc_rec.l_calc_edate
1823: WHERE cle_id = p_top_line_id
1824: AND date_completed is null
1825: AND date_start <= l_calc_rec.l_calc_sdate;

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

1825: AND date_start <= l_calc_rec.l_calc_sdate;
1826: END IF;
1827:
1828: IF (l_write_log) THEN
1829: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill_Service_Item => After updating oks_level_elements ');
1830: END IF;
1831:
1832: e_ptr := e_ptr + 1;
1833:

Line 2118: UPDATE oks_level_elements

2114: END IF;
2115:
2116: IF (p_prv <> 2) THEN
2117:
2118: UPDATE oks_level_elements
2119: SET date_completed = l_bill_end_date
2120: WHERE id = level_elements_tab(e_ptr).id;
2121:
2122: END IF;

Line 3118: from oks_level_elements lvl

3114: swap_join_inputs(hdr) swap_join_inputs(sts) */
3115: hdr.id hdr_id, line.id line_id, rownum, hdr.currency_code
3116: from (
3117: Select /*+ FULL (lvl) no_merge */ distinct lvl.parent_cle_id
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,

Line 3161: from oks_level_elements lvl

3157: swap_join_inputs(hdr) swap_join_inputs(sts) */
3158: hdr.id hdr_id, line.id line_id, rownum, hdr.currency_code
3159: from (
3160: Select /*+ FULL (lvl) no_merge */ distinct lvl.parent_cle_id
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,

Line 3205: from oks_level_elements lvl

3201: AND Hdr.scs_code in ('SERVICE','WARRANTY','SUBSCRIPTION')
3202: AND Hdr.Template_yn = 'N'
3203: AND Hdr.id = p_contract_hdr_id
3204: AND line.id IN (Select lvl.parent_cle_id
3205: from oks_level_elements lvl
3206: where lvl.date_completed is null
3207: and trunc(lvl.date_to_interface) <= trunc(p_date) )
3208: AND exists (Select 1 from okc_statuses_b osb
3209: where osb.ste_code <> 'HOLD'

Line 3234: from oks_level_elements lvl

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

Line 3294: from oks_level_elements lvl

3290: (select 1 from OKC_K_GRPINGS okg
3291: where okg.included_chr_id = hdr.id
3292: and okg.cgp_parent_id = nvl(p_grp_id, okg.cgp_parent_id) )
3293: AND line.id IN (Select lvl.parent_cle_id
3294: from oks_level_elements lvl
3295: where lvl.date_completed is null
3296: and trunc(lvl.date_to_interface) <= trunc(p_date) )
3297: AND exists (Select 1 from okc_statuses_b osb
3298: where osb.ste_code <> 'HOLD'