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_STREAMS_RECON_PVT dependencies on OKL_STRM_TYPE_V

Line 219: FROM okl_strm_type_v sty,

215: p_contract_number IN okc_k_headers_b.contract_number%TYPE,
216: p_end_date IN okc_k_headers_b.end_date%TYPE)
217: IS
218: SELECT SUM(ste.amount) amount
219: FROM okl_strm_type_v sty,
220: okl_strm_elements ste,
221: okl_streams stm,
222: okc_statuses_b khs,
223: okc_statuses_b kls,

Line 254: FROM okl_strm_type_v sty,

250: p_contract_number IN okc_k_headers_b.contract_number%TYPE,
251: p_end_date IN okc_k_headers_b.end_date%TYPE)
252: IS
253: SELECT SUM(ste.amount) amount
254: FROM okl_strm_type_v sty,
255: okl_strm_elements ste,
256: okl_streams stm,
257: okc_statuses_b khs,
258: okc_statuses_b kls,

Line 290: FROM okl_strm_type_v sty,

286: p_contract_number IN okc_k_headers_b.contract_number%TYPE,
287: p_end_date IN okc_k_headers_b.end_date%TYPE)
288: IS
289: SELECT SUM(ste.amount) amount
290: FROM okl_strm_type_v sty,
291: okl_strm_elements ste,
292: okl_streams stm,
293: okc_statuses_b khs,
294: okc_statuses_b kls,

Line 330: FROM okl_strm_type_v sty,

326: SELECT khr.currency_code currency_code,
327: fnd.meaning book_class,
328: pdt.name product_name,
329: SUM(ste.amount) amount
330: FROM okl_strm_type_v sty,
331: okl_strm_elements ste,
332: okl_streams stm,
333: okc_statuses_b khs,
334: okc_statuses_b kls,

Line 416: FROM okl_strm_type_v sty,

412: 'Y' billed_streams,
413: 'N' cancelled_streams,
414: 'N' unbilled_streams,
415: SUM(ste.amount) billed_streams
416: FROM okl_strm_type_v sty,
417: okl_strm_elements ste,
418: okl_streams stm,
419: okc_statuses_b khs,
420: okc_statuses_b kls,

Line 452: FROM okl_strm_type_v sty,

448: 'N' billed_streams,
449: 'Y' cancelled_streams,
450: 'N' unbilled_streams,
451: SUM(ste.amount)
452: FROM okl_strm_type_v sty,
453: okl_strm_elements ste,
454: okl_streams stm,
455: okc_statuses_b khs,
456: okc_statuses_b kls,

Line 490: FROM okl_strm_type_v sty,

486: 'N' billed_streams,
487: 'N' cancelled_streams,
488: 'Y' unbilled_streams,
489: SUM(ste.amount)
490: FROM okl_strm_type_v sty,
491: okl_strm_elements ste,
492: okl_streams stm,
493: okc_statuses_b khs,
494: okc_statuses_b kls,

Line 1252: FROM okl_strm_type_v sty,

1248: p_contract_number IN okc_k_headers_b.contract_number%TYPE,
1249: p_end_date IN okc_k_headers_b.end_date%TYPE)
1250: IS
1251: SELECT SUM(ste.amount) amount
1252: FROM okl_strm_type_v sty,
1253: okl_strm_elements ste,
1254: okl_streams stm,
1255: okc_statuses_b khs,
1256: okc_statuses_b kls,

Line 1287: FROM okl_strm_type_v sty,

1283: p_contract_number IN okc_k_headers_b.contract_number%TYPE,
1284: p_end_date IN okc_k_headers_b.end_date%TYPE)
1285: IS
1286: SELECT SUM(ste.amount) amount
1287: FROM okl_strm_type_v sty,
1288: okl_strm_elements ste,
1289: okl_streams stm,
1290: okc_statuses_b khs,
1291: okc_statuses_b kls,

Line 1323: FROM okl_strm_type_v sty,

1319: p_contract_number IN okc_k_headers_b.contract_number%TYPE,
1320: p_end_date IN okc_k_headers_b.end_date%TYPE)
1321: IS
1322: SELECT SUM(ste.amount) amount
1323: FROM okl_strm_type_v sty,
1324: okl_strm_elements ste,
1325: okl_streams stm,
1326: okc_statuses_b khs,
1327: okc_statuses_b kls,

Line 1363: FROM okl_strm_type_v sty,

1359: SELECT khr.currency_code currency_code,
1360: fnd.meaning book_class,
1361: pdt.name product_name,
1362: SUM(ste.amount) amount
1363: FROM okl_strm_type_v sty,
1364: okl_strm_elements ste,
1365: okl_streams stm,
1366: okc_statuses_b khs,
1367: okc_statuses_b kls,

Line 1449: FROM okl_strm_type_v sty,

1445: 'Y' billed_streams,
1446: 'N' cancelled_streams,
1447: 'N' unbilled_streams,
1448: SUM(ste.amount) billed_streams
1449: FROM okl_strm_type_v sty,
1450: okl_strm_elements ste,
1451: okl_streams stm,
1452: okc_statuses_b khs,
1453: okc_statuses_b kls,

Line 1485: FROM okl_strm_type_v sty,

1481: 'N' billed_streams,
1482: 'Y' cancelled_streams,
1483: 'N' unbilled_streams,
1484: SUM(ste.amount)
1485: FROM okl_strm_type_v sty,
1486: okl_strm_elements ste,
1487: okl_streams stm,
1488: okc_statuses_b khs,
1489: okc_statuses_b kls,

Line 1523: FROM okl_strm_type_v sty,

1519: 'N' billed_streams,
1520: 'N' cancelled_streams,
1521: 'Y' unbilled_streams,
1522: SUM(ste.amount)
1523: FROM okl_strm_type_v sty,
1524: okl_strm_elements ste,
1525: okl_streams stm,
1526: okc_statuses_b khs,
1527: okc_statuses_b kls,