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.OKL_STREAM_BILLING_PVT dependencies on OKL_STRM_ELEMENTS

Line 941: UPDATE okl_strm_elements

937: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'sel_id_tbl.count : ' || sel_id_tbl.COUNT);
938: END IF;
939: IF sel_id_tbl.COUNT > 0 THEN
940: FORALL indx IN sel_id_tbl.FIRST..sel_id_tbl.LAST
941: UPDATE okl_strm_elements
942: SET date_billed = SYSDATE
943: WHERE id = sel_id_tbl(indx);
944: END IF;
945:

Line 954: FROM OKL_STRM_ELEMENTS ste,

950: save exceptions
951: UPDATE okl_k_control nbd
952: set EARLIEST_STRM_BILL_DATE = (
953: SELECT MIN(ste.stream_element_date)
954: FROM OKL_STRM_ELEMENTS ste,
955: OKL_STREAMS stm,
956: okl_strm_type_v sty,
957: okc_k_headers_b khr,
958: OKL_K_HEADERS khl,

Line 1241: l_ste_amount OKL_STRM_ELEMENTS.amount%TYPE := 0;

1237: l_trx_status_code Okl_trx_ar_invoices_v.trx_status_code%TYPE;
1238:
1239:
1240: -- For currecy precision rounded amount
1241: l_ste_amount OKL_STRM_ELEMENTS.amount%TYPE := 0;
1242: l_curr_code okc_k_headers_b.currency_code%TYPE;
1243:
1244: -------------------------------------------------------------------------
1245: -- Account Builder Code

Line 1258: amount OKL_STRM_ELEMENTS.amount%TYPE,

1254: xsi_id NUMBER,
1255: bill_date DATE,
1256: contract_number okc_k_headers_b.contract_number%TYPE,
1257: stream_name okl_strm_type_v.name%TYPE,
1258: amount OKL_STRM_ELEMENTS.amount%TYPE,
1259: error_message VARCHAR2(2000)
1260: );
1261:
1262: TYPE sel_err_tbl_type IS TABLE OF sel_err_rec_type

Line 2393: FROM OKL_STRM_ELEMENTS ste,

2389: sty.name comments,
2390: sty.taxable_default_yn taxable_default_yn,
2391: ste.amount amount,
2392: khr.sts_code sts_code
2393: FROM OKL_STRM_ELEMENTS ste,
2394: OKL_STREAMS stm,
2395: okl_strm_type_v sty,
2396: okc_k_headers_b khr,
2397: OKL_K_HEADERS khl,

Line 2446: FROM OKL_STRM_ELEMENTS ste,

2442: sty.name comments,
2443: sty.taxable_default_yn taxable_default_yn,
2444: ste.amount amount,
2445: khr.sts_code sts_code
2446: FROM OKL_STRM_ELEMENTS ste,
2447: OKL_STREAMS stm,
2448: okl_strm_type_v sty,
2449: okc_k_headers_b khr,
2450: OKL_K_HEADERS khl,

Line 2494: FROM OKL_STRM_ELEMENTS ste,

2490: sty.name comments,
2491: sty.taxable_default_yn taxable_default_yn,
2492: ste.amount amount,
2493: khr.sts_code sts_code
2494: FROM OKL_STRM_ELEMENTS ste,
2495: OKL_STREAMS stm,
2496: okl_strm_type_v sty,
2497: okc_k_headers_b khr,
2498: OKL_K_HEADERS khl,

Line 2555: FROM OKL_STRM_ELEMENTS ste,

2551: sty.name comments,
2552: sty.taxable_default_yn taxable_default_yn,
2553: ste.amount amount,
2554: khr.sts_code sts_code
2555: FROM OKL_STRM_ELEMENTS ste,
2556: OKL_STREAMS stm,
2557: okl_strm_type_v sty,
2558: okc_k_headers_b khr,
2559: OKL_K_HEADERS khl,

Line 2615: FROM OKL_STRM_ELEMENTS ste,

2611: sty.name comments,
2612: sty.taxable_default_yn taxable_default_yn,
2613: ste.amount amount,
2614: khr.sts_code sts_code
2615: FROM OKL_STRM_ELEMENTS ste,
2616: OKL_STREAMS stm,
2617: okl_strm_type_v sty,
2618: okc_k_headers_b khr,
2619: OKL_K_HEADERS khl,

Line 2667: FROM OKL_STRM_ELEMENTS ste,

2663: sty.name comments,
2664: sty.taxable_default_yn taxable_default_yn,
2665: ste.amount amount,
2666: khr.sts_code sts_code
2667: FROM OKL_STRM_ELEMENTS ste,
2668: OKL_STREAMS stm,
2669: okl_strm_type_v sty,
2670: okc_k_headers_b khr,
2671: OKL_K_HEADERS khl,

Line 2716: FROM OKL_STRM_ELEMENTS ste,

2712: sty.name comments,
2713: sty.taxable_default_yn taxable_default_yn,
2714: ste.amount amount,
2715: khr.sts_code sts_code
2716: FROM OKL_STRM_ELEMENTS ste,
2717: OKL_STREAMS stm,
2718: okl_strm_type_v sty,
2719: okc_k_headers_b khr,
2720: OKL_K_HEADERS khl,

Line 2776: FROM OKL_STRM_ELEMENTS ste,

2772: sty.name comments,
2773: sty.taxable_default_yn taxable_default_yn,
2774: ste.amount amount,
2775: khr.sts_code sts_code
2776: FROM OKL_STRM_ELEMENTS ste,
2777: OKL_STREAMS stm,
2778: okl_strm_type_v sty,
2779: okc_k_headers_b khr,
2780: OKL_K_HEADERS khl,

Line 2836: FROM OKL_STRM_ELEMENTS ste,

2832: sty.name comments,
2833: sty.taxable_default_yn taxable_default_yn,
2834: ste.amount amount,
2835: khr.sts_code sts_code
2836: FROM OKL_STRM_ELEMENTS ste,
2837: OKL_STREAMS stm,
2838: okl_strm_type_v sty,
2839: okc_k_headers_b khr,
2840: OKL_K_HEADERS khl,

Line 2891: FROM OKL_STRM_ELEMENTS ste,

2887: sty.name comments,
2888: sty.taxable_default_yn taxable_default_yn,
2889: ste.amount amount,
2890: khr.sts_code sts_code
2891: FROM OKL_STRM_ELEMENTS ste,
2892: OKL_STREAMS stm,
2893: okl_strm_type_v sty,
2894: okc_k_headers_b khr,
2895: OKL_K_HEADERS khl,

Line 2944: FROM OKL_STRM_ELEMENTS ste,

2940: sty.name comments,
2941: sty.taxable_default_yn taxable_default_yn,
2942: ste.amount amount,
2943: khr.sts_code sts_code
2944: FROM OKL_STRM_ELEMENTS ste,
2945: OKL_STREAMS stm,
2946: okl_strm_type_v sty,
2947: okc_k_headers_b khr,
2948: OKL_K_HEADERS khl,

Line 3007: FROM OKL_STRM_ELEMENTS ste,

3003: sty.name comments,
3004: sty.taxable_default_yn taxable_default_yn,
3005: ste.amount amount,
3006: khr.sts_code sts_code
3007: FROM OKL_STRM_ELEMENTS ste,
3008: OKL_STREAMS stm,
3009: okl_strm_type_v sty,
3010: okc_k_headers_b khr,
3011: OKL_K_HEADERS khl,