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 OKC_STATUSES_B

Line 960: okc_statuses_b khs,

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,
961: okc_statuses_b kls
962: WHERE ste.amount <> 0
963: AND stm.id = ste.stm_id
964: AND ste.date_billed IS NULL

Line 961: okc_statuses_b kls

957: okc_k_headers_b khr,
958: OKL_K_HEADERS khl,
959: okc_k_lines_b kle,
960: okc_statuses_b khs,
961: okc_statuses_b kls
962: WHERE ste.amount <> 0
963: AND stm.id = ste.stm_id
964: AND ste.date_billed IS NULL
965: AND stm.active_yn = 'Y'

Line 2399: okc_statuses_b khs,

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,
2400: okc_statuses_b kls
2401: WHERE TRUNC(ste.stream_element_date) >=
2402: TRUNC(NVL (p_from_bill_date, ste.stream_element_date))
2403: AND TRUNC(ste.stream_element_date) <=

Line 2400: okc_statuses_b kls

2396: okc_k_headers_b khr,
2397: OKL_K_HEADERS khl,
2398: okc_k_lines_b kle,
2399: okc_statuses_b khs,
2400: okc_statuses_b kls
2401: WHERE TRUNC(ste.stream_element_date) >=
2402: TRUNC(NVL (p_from_bill_date, ste.stream_element_date))
2403: AND TRUNC(ste.stream_element_date) <=
2404: TRUNC((NVL (p_to_bill_date, SYSDATE) + get_printing_lead_days(stm.khr_id)))

Line 2452: okc_statuses_b khs,

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,
2453: okc_statuses_b kls,
2454: okc_k_lines_b cle
2455: WHERE TRUNC(ste.stream_element_date) >= TRUNC(NVL (p_from_bill_date, ste.stream_element_date))
2456: AND TRUNC(ste.stream_element_date) <= TRUNC((NVL (p_to_bill_date, SYSDATE) + nvl(get_printing_lead_days(stm.khr_id), 0)))

Line 2453: okc_statuses_b kls,

2449: okc_k_headers_b khr,
2450: OKL_K_HEADERS khl,
2451: okc_k_lines_b kle,
2452: okc_statuses_b khs,
2453: okc_statuses_b kls,
2454: okc_k_lines_b cle
2455: WHERE TRUNC(ste.stream_element_date) >= TRUNC(NVL (p_from_bill_date, ste.stream_element_date))
2456: AND TRUNC(ste.stream_element_date) <= TRUNC((NVL (p_to_bill_date, SYSDATE) + nvl(get_printing_lead_days(stm.khr_id), 0)))
2457: AND ste.amount <> 0

Line 2500: okc_statuses_b khs,

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,
2501: okc_statuses_b kls
2502: WHERE TRUNC(ste.stream_element_date) >=
2503: TRUNC(NVL (p_from_bill_date, ste.stream_element_date))
2504: AND TRUNC(ste.stream_element_date) <=

Line 2501: okc_statuses_b kls

2497: okc_k_headers_b khr,
2498: OKL_K_HEADERS khl,
2499: okc_k_lines_b kle,
2500: okc_statuses_b khs,
2501: okc_statuses_b kls
2502: WHERE TRUNC(ste.stream_element_date) >=
2503: TRUNC(NVL (p_from_bill_date, ste.stream_element_date))
2504: AND TRUNC(ste.stream_element_date) <=
2505: TRUNC((NVL (p_to_bill_date, SYSDATE) + get_printing_lead_days(stm.khr_id)))

Line 2561: okc_statuses_b khs,

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,
2562: okc_statuses_b kls
2563: WHERE TRUNC(ste.stream_element_date) >=
2564: TRUNC(NVL (p_from_bill_date, ste.stream_element_date))
2565: AND TRUNC(ste.stream_element_date) <=

Line 2562: okc_statuses_b kls

2558: okc_k_headers_b khr,
2559: OKL_K_HEADERS khl,
2560: okc_k_lines_b kle,
2561: okc_statuses_b khs,
2562: okc_statuses_b kls
2563: WHERE TRUNC(ste.stream_element_date) >=
2564: TRUNC(NVL (p_from_bill_date, ste.stream_element_date))
2565: AND TRUNC(ste.stream_element_date) <=
2566: TRUNC((NVL (p_to_bill_date, SYSDATE) + get_printing_lead_days(stm.khr_id)))

Line 2621: okc_statuses_b khs,

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,
2622: okc_statuses_b kls
2623: WHERE TRUNC(ste.stream_element_date) >=
2624: TRUNC(NVL (p_from_bill_date, ste.stream_element_date))
2625: AND TRUNC(ste.stream_element_date) <=

Line 2622: okc_statuses_b kls

2618: okc_k_headers_b khr,
2619: OKL_K_HEADERS khl,
2620: okc_k_lines_b kle,
2621: okc_statuses_b khs,
2622: okc_statuses_b kls
2623: WHERE TRUNC(ste.stream_element_date) >=
2624: TRUNC(NVL (p_from_bill_date, ste.stream_element_date))
2625: AND TRUNC(ste.stream_element_date) <=
2626: TRUNC((NVL (p_to_bill_date, SYSDATE) + get_printing_lead_days(stm.khr_id)))

Line 2673: okc_statuses_b khs,

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,
2674: okc_statuses_b kls,
2675: okc_k_lines_b cle
2676: WHERE TRUNC(ste.stream_element_date) >=
2677: TRUNC(NVL (p_from_bill_date, ste.stream_element_date))

Line 2674: okc_statuses_b kls,

2670: okc_k_headers_b khr,
2671: OKL_K_HEADERS khl,
2672: okc_k_lines_b kle,
2673: okc_statuses_b khs,
2674: okc_statuses_b kls,
2675: okc_k_lines_b cle
2676: WHERE TRUNC(ste.stream_element_date) >=
2677: TRUNC(NVL (p_from_bill_date, ste.stream_element_date))
2678: AND TRUNC(ste.stream_element_date) <= TRUNC((NVL (p_to_bill_date, SYSDATE) + get_printing_lead_days(stm.khr_id)))

Line 2722: okc_statuses_b khs,

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,
2723: okc_statuses_b kls
2724: WHERE TRUNC(ste.stream_element_date) >=
2725: TRUNC(NVL (p_from_bill_date, ste.stream_element_date))
2726: AND TRUNC(ste.stream_element_date) <=

Line 2723: okc_statuses_b kls

2719: okc_k_headers_b khr,
2720: OKL_K_HEADERS khl,
2721: okc_k_lines_b kle,
2722: okc_statuses_b khs,
2723: okc_statuses_b kls
2724: WHERE TRUNC(ste.stream_element_date) >=
2725: TRUNC(NVL (p_from_bill_date, ste.stream_element_date))
2726: AND TRUNC(ste.stream_element_date) <=
2727: TRUNC((NVL (p_to_bill_date, SYSDATE) + get_printing_lead_days(stm.khr_id)))

Line 2782: okc_statuses_b khs,

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,
2783: okc_statuses_b kls
2784: WHERE TRUNC(ste.stream_element_date) >=
2785: TRUNC(NVL (p_from_bill_date, ste.stream_element_date))
2786: AND TRUNC(ste.stream_element_date) <=

Line 2783: okc_statuses_b kls

2779: okc_k_headers_b khr,
2780: OKL_K_HEADERS khl,
2781: okc_k_lines_b kle,
2782: okc_statuses_b khs,
2783: okc_statuses_b kls
2784: WHERE TRUNC(ste.stream_element_date) >=
2785: TRUNC(NVL (p_from_bill_date, ste.stream_element_date))
2786: AND TRUNC(ste.stream_element_date) <=
2787: TRUNC((NVL (p_to_bill_date, SYSDATE) + get_printing_lead_days(stm.khr_id)))

Line 2842: okc_statuses_b khs,

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,
2843: okc_statuses_b kls,
2844: OKL_PARALLEL_PROCESSES pws
2845: WHERE TRUNC(ste.stream_element_date) >=
2846: TRUNC(NVL (p_from_bill_date, ste.stream_element_date))

Line 2843: okc_statuses_b kls,

2839: okc_k_headers_b khr,
2840: OKL_K_HEADERS khl,
2841: okc_k_lines_b kle,
2842: okc_statuses_b khs,
2843: okc_statuses_b kls,
2844: OKL_PARALLEL_PROCESSES pws
2845: WHERE TRUNC(ste.stream_element_date) >=
2846: TRUNC(NVL (p_from_bill_date, ste.stream_element_date))
2847: AND TRUNC(ste.stream_element_date) <=

Line 2897: okc_statuses_b khs,

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,
2898: okc_statuses_b kls,
2899: okc_k_lines_b cle,
2900: OKL_PARALLEL_PROCESSES pws
2901: WHERE TRUNC(ste.stream_element_date) >=

Line 2898: okc_statuses_b kls,

2894: okc_k_headers_b khr,
2895: OKL_K_HEADERS khl,
2896: okc_k_lines_b kle,
2897: okc_statuses_b khs,
2898: okc_statuses_b kls,
2899: okc_k_lines_b cle,
2900: OKL_PARALLEL_PROCESSES pws
2901: WHERE TRUNC(ste.stream_element_date) >=
2902: TRUNC(NVL (p_from_bill_date, ste.stream_element_date))

Line 2950: okc_statuses_b khs,

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,
2951: okc_statuses_b kls,
2952: OKL_PARALLEL_PROCESSES pws
2953: WHERE TRUNC(ste.stream_element_date) >=
2954: TRUNC(NVL (p_from_bill_date, ste.stream_element_date))

Line 2951: okc_statuses_b kls,

2947: okc_k_headers_b khr,
2948: OKL_K_HEADERS khl,
2949: okc_k_lines_b kle,
2950: okc_statuses_b khs,
2951: okc_statuses_b kls,
2952: OKL_PARALLEL_PROCESSES pws
2953: WHERE TRUNC(ste.stream_element_date) >=
2954: TRUNC(NVL (p_from_bill_date, ste.stream_element_date))
2955: AND TRUNC(ste.stream_element_date) <=

Line 3013: okc_statuses_b khs,

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,
3014: okc_statuses_b kls,
3015: OKL_PARALLEL_PROCESSES pws
3016: WHERE TRUNC(ste.stream_element_date) >=
3017: TRUNC(NVL (p_from_bill_date, ste.stream_element_date))

Line 3014: okc_statuses_b kls,

3010: okc_k_headers_b khr,
3011: OKL_K_HEADERS khl,
3012: okc_k_lines_b kle,
3013: okc_statuses_b khs,
3014: okc_statuses_b kls,
3015: OKL_PARALLEL_PROCESSES pws
3016: WHERE TRUNC(ste.stream_element_date) >=
3017: TRUNC(NVL (p_from_bill_date, ste.stream_element_date))
3018: AND TRUNC(ste.stream_element_date) <=