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 1022: okc_statuses_b khs,

1018: okl_strm_type_v sty,
1019: okc_k_headers_b khr,
1020: OKL_K_HEADERS khl,
1021: okc_k_lines_b kle,
1022: okc_statuses_b khs,
1023: okc_statuses_b kls
1024: WHERE ste.amount <> 0
1025: AND stm.id = ste.stm_id
1026: AND ste.date_billed IS NULL

Line 1023: okc_statuses_b kls

1019: okc_k_headers_b khr,
1020: OKL_K_HEADERS khl,
1021: okc_k_lines_b kle,
1022: okc_statuses_b khs,
1023: okc_statuses_b kls
1024: WHERE ste.amount <> 0
1025: AND stm.id = ste.stm_id
1026: AND ste.date_billed IS NULL
1027: AND stm.active_yn = 'Y'

Line 2583: okc_statuses_b khs,

2579: okl_strm_type_v sty,
2580: okc_k_headers_b khr,
2581: OKL_K_HEADERS khl,
2582: okc_k_lines_b kle,
2583: okc_statuses_b khs,
2584: okc_statuses_b kls
2585: WHERE TRUNC(ste.stream_element_date) >=
2586: TRUNC(NVL (p_from_bill_date, ste.stream_element_date))
2587: AND TRUNC(ste.stream_element_date) <=

Line 2584: okc_statuses_b kls

2580: okc_k_headers_b khr,
2581: OKL_K_HEADERS khl,
2582: okc_k_lines_b kle,
2583: okc_statuses_b khs,
2584: okc_statuses_b kls
2585: WHERE TRUNC(ste.stream_element_date) >=
2586: TRUNC(NVL (p_from_bill_date, ste.stream_element_date))
2587: AND TRUNC(ste.stream_element_date) <=
2588: TRUNC((NVL (p_to_bill_date, SYSDATE) + get_printing_lead_days(stm.khr_id)))

Line 2636: okc_statuses_b khs,

2632: okl_strm_type_v sty,
2633: okc_k_headers_b khr,
2634: OKL_K_HEADERS khl,
2635: okc_k_lines_b kle,
2636: okc_statuses_b khs,
2637: okc_statuses_b kls,
2638: okc_k_lines_b cle
2639: WHERE TRUNC(ste.stream_element_date) >= TRUNC(NVL (p_from_bill_date, ste.stream_element_date))
2640: AND TRUNC(ste.stream_element_date) <= TRUNC((NVL (p_to_bill_date, SYSDATE) + nvl(get_printing_lead_days(stm.khr_id), 0)))

Line 2637: okc_statuses_b kls,

2633: okc_k_headers_b khr,
2634: OKL_K_HEADERS khl,
2635: okc_k_lines_b kle,
2636: okc_statuses_b khs,
2637: okc_statuses_b kls,
2638: okc_k_lines_b cle
2639: WHERE TRUNC(ste.stream_element_date) >= TRUNC(NVL (p_from_bill_date, ste.stream_element_date))
2640: AND TRUNC(ste.stream_element_date) <= TRUNC((NVL (p_to_bill_date, SYSDATE) + nvl(get_printing_lead_days(stm.khr_id), 0)))
2641: AND ste.amount <> 0

Line 2684: okc_statuses_b khs,

2680: okl_strm_type_v sty,
2681: okc_k_headers_b khr,
2682: OKL_K_HEADERS khl,
2683: okc_k_lines_b kle,
2684: okc_statuses_b khs,
2685: okc_statuses_b kls
2686: WHERE TRUNC(ste.stream_element_date) >=
2687: TRUNC(NVL (p_from_bill_date, ste.stream_element_date))
2688: AND TRUNC(ste.stream_element_date) <=

Line 2685: okc_statuses_b kls

2681: okc_k_headers_b khr,
2682: OKL_K_HEADERS khl,
2683: okc_k_lines_b kle,
2684: okc_statuses_b khs,
2685: okc_statuses_b kls
2686: WHERE TRUNC(ste.stream_element_date) >=
2687: TRUNC(NVL (p_from_bill_date, ste.stream_element_date))
2688: AND TRUNC(ste.stream_element_date) <=
2689: TRUNC((NVL (p_to_bill_date, SYSDATE) + get_printing_lead_days(stm.khr_id)))

Line 2745: okc_statuses_b khs,

2741: okl_strm_type_v sty,
2742: okc_k_headers_b khr,
2743: OKL_K_HEADERS khl,
2744: okc_k_lines_b kle,
2745: okc_statuses_b khs,
2746: okc_statuses_b kls
2747: WHERE TRUNC(ste.stream_element_date) >=
2748: TRUNC(NVL (p_from_bill_date, ste.stream_element_date))
2749: AND TRUNC(ste.stream_element_date) <=

Line 2746: okc_statuses_b kls

2742: okc_k_headers_b khr,
2743: OKL_K_HEADERS khl,
2744: okc_k_lines_b kle,
2745: okc_statuses_b khs,
2746: okc_statuses_b kls
2747: WHERE TRUNC(ste.stream_element_date) >=
2748: TRUNC(NVL (p_from_bill_date, ste.stream_element_date))
2749: AND TRUNC(ste.stream_element_date) <=
2750: TRUNC((NVL (p_to_bill_date, SYSDATE) + get_printing_lead_days(stm.khr_id)))

Line 2808: okc_statuses_b khs,

2804: okl_strm_type_v sty,
2805: okc_k_headers_b khr,
2806: OKL_K_HEADERS khl,
2807: okc_k_lines_b kle,
2808: okc_statuses_b khs,
2809: okc_statuses_b kls
2810: WHERE TRUNC(ste.stream_element_date) >=
2811: TRUNC(NVL (p_from_bill_date, ste.stream_element_date))
2812: AND TRUNC(ste.stream_element_date) <=

Line 2809: okc_statuses_b kls

2805: okc_k_headers_b khr,
2806: OKL_K_HEADERS khl,
2807: okc_k_lines_b kle,
2808: okc_statuses_b khs,
2809: okc_statuses_b kls
2810: WHERE TRUNC(ste.stream_element_date) >=
2811: TRUNC(NVL (p_from_bill_date, ste.stream_element_date))
2812: AND TRUNC(ste.stream_element_date) <=
2813: TRUNC((NVL (p_to_bill_date, SYSDATE) + get_printing_lead_days(stm.khr_id)))

Line 2860: okc_statuses_b khs,

2856: okl_strm_type_v sty,
2857: okc_k_headers_b khr,
2858: OKL_K_HEADERS khl,
2859: okc_k_lines_b kle,
2860: okc_statuses_b khs,
2861: okc_statuses_b kls,
2862: okc_k_lines_b cle
2863: WHERE TRUNC(ste.stream_element_date) >=
2864: TRUNC(NVL (p_from_bill_date, ste.stream_element_date))

Line 2861: okc_statuses_b kls,

2857: okc_k_headers_b khr,
2858: OKL_K_HEADERS khl,
2859: okc_k_lines_b kle,
2860: okc_statuses_b khs,
2861: okc_statuses_b kls,
2862: okc_k_lines_b cle
2863: WHERE TRUNC(ste.stream_element_date) >=
2864: TRUNC(NVL (p_from_bill_date, ste.stream_element_date))
2865: AND TRUNC(ste.stream_element_date) <= TRUNC((NVL (p_to_bill_date, SYSDATE) + get_printing_lead_days(stm.khr_id)))

Line 2909: okc_statuses_b khs,

2905: okl_strm_type_v sty,
2906: okc_k_headers_b khr,
2907: OKL_K_HEADERS khl,
2908: okc_k_lines_b kle,
2909: okc_statuses_b khs,
2910: okc_statuses_b kls
2911: WHERE TRUNC(ste.stream_element_date) >=
2912: TRUNC(NVL (p_from_bill_date, ste.stream_element_date))
2913: AND TRUNC(ste.stream_element_date) <=

Line 2910: okc_statuses_b kls

2906: okc_k_headers_b khr,
2907: OKL_K_HEADERS khl,
2908: okc_k_lines_b kle,
2909: okc_statuses_b khs,
2910: okc_statuses_b kls
2911: WHERE TRUNC(ste.stream_element_date) >=
2912: TRUNC(NVL (p_from_bill_date, ste.stream_element_date))
2913: AND TRUNC(ste.stream_element_date) <=
2914: TRUNC((NVL (p_to_bill_date, SYSDATE) + get_printing_lead_days(stm.khr_id)))

Line 2969: okc_statuses_b khs,

2965: okl_strm_type_v sty,
2966: okc_k_headers_b khr,
2967: OKL_K_HEADERS khl,
2968: okc_k_lines_b kle,
2969: okc_statuses_b khs,
2970: okc_statuses_b kls
2971: WHERE TRUNC(ste.stream_element_date) >=
2972: TRUNC(NVL (p_from_bill_date, ste.stream_element_date))
2973: AND TRUNC(ste.stream_element_date) <=

Line 2970: okc_statuses_b kls

2966: okc_k_headers_b khr,
2967: OKL_K_HEADERS khl,
2968: okc_k_lines_b kle,
2969: okc_statuses_b khs,
2970: okc_statuses_b kls
2971: WHERE TRUNC(ste.stream_element_date) >=
2972: TRUNC(NVL (p_from_bill_date, ste.stream_element_date))
2973: AND TRUNC(ste.stream_element_date) <=
2974: TRUNC((NVL (p_to_bill_date, SYSDATE) + get_printing_lead_days(stm.khr_id)))

Line 3032: okc_statuses_b khs,

3028: okl_strm_type_v sty,
3029: okc_k_headers_b khr,
3030: OKL_K_HEADERS khl,
3031: okc_k_lines_b kle,
3032: okc_statuses_b khs,
3033: okc_statuses_b kls,
3034: OKL_PARALLEL_PROCESSES pws
3035: WHERE TRUNC(ste.stream_element_date) >=
3036: TRUNC(NVL (p_from_bill_date, ste.stream_element_date))

Line 3033: okc_statuses_b kls,

3029: okc_k_headers_b khr,
3030: OKL_K_HEADERS khl,
3031: okc_k_lines_b kle,
3032: okc_statuses_b khs,
3033: okc_statuses_b kls,
3034: OKL_PARALLEL_PROCESSES pws
3035: WHERE TRUNC(ste.stream_element_date) >=
3036: TRUNC(NVL (p_from_bill_date, ste.stream_element_date))
3037: AND TRUNC(ste.stream_element_date) <=

Line 3087: okc_statuses_b khs,

3083: okl_strm_type_v sty,
3084: okc_k_headers_b khr,
3085: OKL_K_HEADERS khl,
3086: okc_k_lines_b kle,
3087: okc_statuses_b khs,
3088: okc_statuses_b kls,
3089: okc_k_lines_b cle,
3090: OKL_PARALLEL_PROCESSES pws
3091: WHERE TRUNC(ste.stream_element_date) >=

Line 3088: okc_statuses_b kls,

3084: okc_k_headers_b khr,
3085: OKL_K_HEADERS khl,
3086: okc_k_lines_b kle,
3087: okc_statuses_b khs,
3088: okc_statuses_b kls,
3089: okc_k_lines_b cle,
3090: OKL_PARALLEL_PROCESSES pws
3091: WHERE TRUNC(ste.stream_element_date) >=
3092: TRUNC(NVL (p_from_bill_date, ste.stream_element_date))

Line 3140: okc_statuses_b khs,

3136: okl_strm_type_v sty,
3137: okc_k_headers_b khr,
3138: OKL_K_HEADERS khl,
3139: okc_k_lines_b kle,
3140: okc_statuses_b khs,
3141: okc_statuses_b kls,
3142: OKL_PARALLEL_PROCESSES pws
3143: WHERE TRUNC(ste.stream_element_date) >=
3144: TRUNC(NVL (p_from_bill_date, ste.stream_element_date))

Line 3141: okc_statuses_b kls,

3137: okc_k_headers_b khr,
3138: OKL_K_HEADERS khl,
3139: okc_k_lines_b kle,
3140: okc_statuses_b khs,
3141: okc_statuses_b kls,
3142: OKL_PARALLEL_PROCESSES pws
3143: WHERE TRUNC(ste.stream_element_date) >=
3144: TRUNC(NVL (p_from_bill_date, ste.stream_element_date))
3145: AND TRUNC(ste.stream_element_date) <=

Line 3203: okc_statuses_b khs,

3199: okl_strm_type_v sty,
3200: okc_k_headers_b khr,
3201: OKL_K_HEADERS khl,
3202: okc_k_lines_b kle,
3203: okc_statuses_b khs,
3204: okc_statuses_b kls,
3205: OKL_PARALLEL_PROCESSES pws
3206: WHERE TRUNC(ste.stream_element_date) >=
3207: TRUNC(NVL (p_from_bill_date, ste.stream_element_date))

Line 3204: okc_statuses_b kls,

3200: okc_k_headers_b khr,
3201: OKL_K_HEADERS khl,
3202: okc_k_lines_b kle,
3203: okc_statuses_b khs,
3204: okc_statuses_b kls,
3205: OKL_PARALLEL_PROCESSES pws
3206: WHERE TRUNC(ste.stream_element_date) >=
3207: TRUNC(NVL (p_from_bill_date, ste.stream_element_date))
3208: AND TRUNC(ste.stream_element_date) <=