[Home] [Help]
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:
1014: set EARLIEST_STRM_BILL_DATE = (
1015: SELECT MIN(ste.stream_element_date)
1016: FROM OKL_STRM_ELEMENTS ste,
1017: OKL_STREAMS stm,
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,
1315: tld_id NUMBER,
1316: xsi_id NUMBER,
1317: bill_date DATE,
1318: contract_number okc_k_headers_b.contract_number%TYPE,
1319: stream_name okl_strm_type_v.name%TYPE,
1320: amount OKL_STRM_ELEMENTS.amount%TYPE,
1321: error_message VARCHAR2(2000)
1322: );
1323:
2575: ste.amount amount,
2576: khr.sts_code sts_code
2577: FROM OKL_STRM_ELEMENTS ste,
2578: OKL_STREAMS stm,
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,
2628: ste.amount amount,
2629: khr.sts_code sts_code
2630: FROM OKL_STRM_ELEMENTS ste,
2631: OKL_STREAMS stm,
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,
2676: ste.amount amount,
2677: khr.sts_code sts_code
2678: FROM OKL_STRM_ELEMENTS ste,
2679: OKL_STREAMS stm,
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,
2737: ste.amount amount,
2738: khr.sts_code sts_code
2739: FROM OKL_STRM_ELEMENTS ste,
2740: OKL_STREAMS stm,
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,
2800: ste.amount amount,
2801: khr.sts_code sts_code
2802: FROM OKL_STRM_ELEMENTS ste,
2803: OKL_STREAMS stm,
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,
2852: ste.amount amount,
2853: khr.sts_code sts_code
2854: FROM OKL_STRM_ELEMENTS ste,
2855: OKL_STREAMS stm,
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,
2901: ste.amount amount,
2902: khr.sts_code sts_code
2903: FROM OKL_STRM_ELEMENTS ste,
2904: OKL_STREAMS stm,
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,
2961: ste.amount amount,
2962: khr.sts_code sts_code
2963: FROM OKL_STRM_ELEMENTS ste,
2964: OKL_STREAMS stm,
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,
3024: ste.amount amount,
3025: khr.sts_code sts_code
3026: FROM OKL_STRM_ELEMENTS ste,
3027: OKL_STREAMS stm,
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,
3079: ste.amount amount,
3080: khr.sts_code sts_code
3081: FROM OKL_STRM_ELEMENTS ste,
3082: OKL_STREAMS stm,
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,
3132: ste.amount amount,
3133: khr.sts_code sts_code
3134: FROM OKL_STRM_ELEMENTS ste,
3135: OKL_STREAMS stm,
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,
3195: ste.amount amount,
3196: khr.sts_code sts_code
3197: FROM OKL_STRM_ELEMENTS ste,
3198: OKL_STREAMS stm,
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,