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 3945: FROM okl_streams strm

3941: --Begin - Changes for Bug 6640050 by varangan on 29-Nov-2007
3942: CURSOR c_strm_amount ( p_poc_id NUMBER)
3943: IS
3944: SELECT NVL(SUM(NVL(ele.AMOUNT,0)),0) STREAM_AMOUNT
3945: FROM okl_streams strm
3946: ,okl_strm_elements ele
3947: ,okl_pool_contents cnt
3948: WHERE strm.id = ele.stm_id
3949: AND cnt.ID = p_poc_id

Line 4227: okl_streams stmb

4223: --- or assets that do not have streams
4224: /*
4225: SELECT poc.id
4226: FROM okl_pool_contents poc,
4227: okl_streams stmb
4228: WHERE poc.pol_id = p_pol_id
4229: AND poc.kle_id = stmb.kle_id
4230: AND poc.sty_id = stmb.sty_id
4231: AND (

Line 4279: ,okl_streams stmb

4275: CURSOR l_okl_update_dates_csr(p_pol_id IN NUMBER)
4276: IS
4277: SELECT poc.id, poc.stm_id
4278: FROM okl_pool_contents poc
4279: ,okl_streams stmb
4280: WHERE poc.pol_id = p_pol_id
4281: AND poc.stm_id = stmb.id
4282: AND stmb.say_code = 'CURR'
4283: AND stmb.active_yn = 'Y'

Line 4445: ,okl_streams stmb

4441: CURSOR l_okl_update_dates_pend_csr(p_pol_id IN NUMBER)
4442: IS
4443: SELECT poc.id, poc.stm_id
4444: FROM okl_pool_contents poc
4445: ,okl_streams stmb
4446: WHERE poc.pol_id = p_pol_id
4447: AND poc.stm_id = stmb.id
4448: AND stmb.say_code = 'CURR'
4449: AND stmb.active_yn = 'Y'

Line 4468: ,okl_streams stmb

4464: CURSOR l_okl_valid_dates_csr(p_stm_id IN NUMBER)
4465: IS
4466: SELECT MIN(selb.stream_element_date)
4467: FROM okl_strm_elements selb
4468: ,okl_streams stmb
4469: WHERE selb.stm_id = stmb.id
4470: AND selb.date_billed IS NULL
4471: AND selb.amount <> 0 -- vsgandhi : Bug 13997160
4472: -- mvasudev, 02/06/2004

Line 5299: ,p_stm_id IN okl_streams.id%TYPE

5295: ,x_return_status OUT NOCOPY VARCHAR2
5296: ,x_msg_count OUT NOCOPY NUMBER
5297: ,x_msg_data OUT NOCOPY VARCHAR2
5298: ,p_poc_id IN okl_pool_contents.id%TYPE
5299: ,p_stm_id IN okl_streams.id%TYPE
5300: ,x_amount OUT NOCOPY NUMBER
5301: )
5302: IS
5303:

Line 5312: FROM okl_streams stmb

5308:
5309: CURSOR l_okl_poc_stm_csr
5310: IS
5311: SELECT NVL(SUM(NVL(selb.amount,0)),0) amount
5312: FROM okl_streams stmb
5313: ,okl_strm_elements selb
5314: ,okl_pool_contents pocb
5315: ,okl_strm_type_v styv
5316: ,okc_k_headers_b chrb

Line 5346: FROM okl_streams stmb

5342:
5343: CURSOR l_okl_poc_csr
5344: IS
5345: SELECT NVL(SUM(NVL(selb.amount,0)),0) amount
5346: FROM okl_streams stmb
5347: ,okl_strm_elements selb
5348: ,okl_pool_contents pocb
5349: WHERE pocb.stm_id = stmb.id
5350: AND stmb.id = selb.stm_id