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_POOL_PVT dependencies on OKL_STREAMS

Line 1662: okl_streams strm

1658: NVL(SUM(NVL(ele.AMOUNT,0)),0) STREAM_AMOUNT
1659: -- SUM(ele.AMOUNT) STREAM_AMOUNT --fixed cklee 06/05/2003
1660: --for streams
1661: FROM
1662: okl_streams strm
1663: ,okl_strm_elements ele
1664: ,okl_pool_contents cnt
1665: WHERE strm.id = ele.stm_id
1666: AND cnt.ID = p_poc_id

Line 1796: FROM okl_streams strm

1792: --Getting only pending POC stream amounts
1793: CURSOR c_strm_amount ( p_poc_id NUMBER)
1794: IS
1795: SELECT NVL(SUM(NVL(ele.AMOUNT,0)),0) STREAM_AMOUNT
1796: FROM okl_streams strm
1797: ,okl_strm_elements ele
1798: ,okl_pool_contents cnt
1799: WHERE strm.id = ele.stm_id
1800: AND cnt.ID = p_poc_id

Line 3939: FROM okl_streams strm

3935: --Begin - Changes for Bug 6640050 by varangan on 29-Nov-2007
3936: CURSOR c_strm_amount ( p_poc_id NUMBER)
3937: IS
3938: SELECT NVL(SUM(NVL(ele.AMOUNT,0)),0) STREAM_AMOUNT
3939: FROM okl_streams strm
3940: ,okl_strm_elements ele
3941: ,okl_pool_contents cnt
3942: WHERE strm.id = ele.stm_id
3943: AND cnt.ID = p_poc_id

Line 4221: okl_streams stmb

4217: --- or assets that do not have streams
4218: /*
4219: SELECT poc.id
4220: FROM okl_pool_contents poc,
4221: okl_streams stmb
4222: WHERE poc.pol_id = p_pol_id
4223: AND poc.kle_id = stmb.kle_id
4224: AND poc.sty_id = stmb.sty_id
4225: AND (

Line 4273: ,okl_streams stmb

4269: CURSOR l_okl_update_dates_csr(p_pol_id IN NUMBER)
4270: IS
4271: SELECT poc.id, poc.stm_id
4272: FROM okl_pool_contents poc
4273: ,okl_streams stmb
4274: WHERE poc.pol_id = p_pol_id
4275: AND poc.stm_id = stmb.id
4276: AND stmb.say_code = 'CURR'
4277: AND stmb.active_yn = 'Y'

Line 4438: ,okl_streams stmb

4434: CURSOR l_okl_update_dates_pend_csr(p_pol_id IN NUMBER)
4435: IS
4436: SELECT poc.id, poc.stm_id
4437: FROM okl_pool_contents poc
4438: ,okl_streams stmb
4439: WHERE poc.pol_id = p_pol_id
4440: AND poc.stm_id = stmb.id
4441: AND stmb.say_code = 'CURR'
4442: AND stmb.active_yn = 'Y'

Line 4460: ,okl_streams stmb

4456: CURSOR l_okl_valid_dates_csr(p_stm_id IN NUMBER)
4457: IS
4458: SELECT MIN(selb.stream_element_date)
4459: FROM okl_strm_elements selb
4460: ,okl_streams stmb
4461: WHERE selb.stm_id = stmb.id
4462: AND selb.date_billed IS NULL
4463: -- mvasudev, 02/06/2004
4464: --AND selb.stream_element_date > SYSDATE

Line 5290: ,p_stm_id IN okl_streams.id%TYPE

5286: ,x_return_status OUT NOCOPY VARCHAR2
5287: ,x_msg_count OUT NOCOPY NUMBER
5288: ,x_msg_data OUT NOCOPY VARCHAR2
5289: ,p_poc_id IN okl_pool_contents.id%TYPE
5290: ,p_stm_id IN okl_streams.id%TYPE
5291: ,x_amount OUT NOCOPY NUMBER
5292: )
5293: IS
5294:

Line 5303: FROM okl_streams stmb

5299:
5300: CURSOR l_okl_poc_stm_csr
5301: IS
5302: SELECT NVL(SUM(NVL(selb.amount,0)),0) amount
5303: FROM okl_streams stmb
5304: ,okl_strm_elements selb
5305: ,okl_pool_contents pocb
5306: ,okl_strm_type_v styv
5307: ,okc_k_headers_b chrb

Line 5337: FROM okl_streams stmb

5333:
5334: CURSOR l_okl_poc_csr
5335: IS
5336: SELECT NVL(SUM(NVL(selb.amount,0)),0) amount
5337: FROM okl_streams stmb
5338: ,okl_strm_elements selb
5339: ,okl_pool_contents pocb
5340: WHERE pocb.stm_id = stmb.id
5341: AND stmb.id = selb.stm_id