DBA Data[Home] [Help]

APPS.OKL_STREAMS_RECON_PVT dependencies on OKL_STRM_TYPE_B

Line 155: okl_strm_type_b sty,

151: IS
152: SELECT DISTINCT chrb.currency_code
153: FROM okl_strm_elements ele,
154: okl_streams stm,
155: okl_strm_type_b sty,
156: okl_k_headers khr,
157: okc_k_headers_b chrb,
158: okc_k_lines_b kle,
159: okc_statuses_b khs,

Line 188: okl_strm_type_b sty,

184: IS
185: SELECT SUM(ele.amount) amount
186: FROM okl_strm_elements ele,
187: okl_streams stm,
188: okl_strm_type_b sty,
189: okl_k_headers khr,
190: okc_k_headers_b chrb,
191: okc_k_lines_b kle,
192: okc_statuses_b khs,

Line 383: okl_strm_type_b sty,

379: 'N' unbilled_streams,
380: SUM(ele.amount) amount
381: FROM okl_strm_elements ele,
382: okl_streams stm,
383: okl_strm_type_b sty,
384: okl_k_headers khr,
385: okc_k_headers_b chrb,
386: okc_k_lines_b kle,
387: okc_statuses_b khs,

Line 1188: okl_strm_type_b sty,

1184: IS
1185: SELECT DISTINCT chrb.currency_code
1186: FROM okl_strm_elements ele,
1187: okl_streams stm,
1188: okl_strm_type_b sty,
1189: okl_k_headers khr,
1190: okc_k_headers_b chrb,
1191: okc_k_lines_b kle,
1192: okc_statuses_b khs,

Line 1221: okl_strm_type_b sty,

1217: IS
1218: SELECT SUM(ele.amount) amount
1219: FROM okl_strm_elements ele,
1220: okl_streams stm,
1221: okl_strm_type_b sty,
1222: okl_k_headers khr,
1223: okc_k_headers_b chrb,
1224: okc_k_lines_b kle,
1225: okc_statuses_b khs,

Line 1416: okl_strm_type_b sty,

1412: 'N' unbilled_streams,
1413: SUM(ele.amount) amount
1414: FROM okl_strm_elements ele,
1415: okl_streams stm,
1416: okl_strm_type_b sty,
1417: okl_k_headers khr,
1418: okc_k_headers_b chrb,
1419: okc_k_lines_b kle,
1420: okc_statuses_b khs,