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.

[Home] [Help]

APPS.OKL_STREAM_BILLING_PVT dependencies on OKL_STRM_TYPE_V

Line 71: stream_name okl_strm_type_v.name%TYPE,

67: sel_id NUMBER,
68: xsi_id NUMBER,
69: xls_id NUMBER,
70: contract_number okc_k_headers_b.contract_number%TYPE,
71: stream_name okl_strm_type_v.name%TYPE,
72: bill_date DATE,
73: error_status VARCHAR2(10)
74: );
75:

Line 956: okl_strm_type_v sty,

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,
959: okc_k_lines_b kle,
960: okc_statuses_b khs,

Line 1257: stream_name okl_strm_type_v.name%TYPE,

1253: tld_id NUMBER,
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:

Line 2395: okl_strm_type_v sty,

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,
2398: okc_k_lines_b kle,
2399: okc_statuses_b khs,

Line 2448: okl_strm_type_v sty,

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,
2451: okc_k_lines_b kle,
2452: okc_statuses_b khs,

Line 2496: okl_strm_type_v sty,

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,
2499: okc_k_lines_b kle,
2500: okc_statuses_b khs,

Line 2557: okl_strm_type_v sty,

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,
2560: okc_k_lines_b kle,
2561: okc_statuses_b khs,

Line 2617: okl_strm_type_v sty,

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,
2620: okc_k_lines_b kle,
2621: okc_statuses_b khs,

Line 2669: okl_strm_type_v sty,

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,
2672: okc_k_lines_b kle,
2673: okc_statuses_b khs,

Line 2718: okl_strm_type_v sty,

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,
2721: okc_k_lines_b kle,
2722: okc_statuses_b khs,

Line 2778: okl_strm_type_v sty,

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,
2781: okc_k_lines_b kle,
2782: okc_statuses_b khs,

Line 2838: okl_strm_type_v sty,

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,
2841: okc_k_lines_b kle,
2842: okc_statuses_b khs,

Line 2893: okl_strm_type_v sty,

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,
2896: okc_k_lines_b kle,
2897: okc_statuses_b khs,

Line 2946: okl_strm_type_v sty,

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,
2949: okc_k_lines_b kle,
2950: okc_statuses_b khs,

Line 3009: okl_strm_type_v sty,

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,
3012: okc_k_lines_b kle,
3013: okc_statuses_b khs,