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_STRM_ELEMENTS

Line 1663: ,okl_strm_elements ele

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
1667: -- mvasudev, 08/11/2003 , Restoring stm_id changes

Line 1797: ,okl_strm_elements ele

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
1801: AND strm.ID = cnt.STM_ID

Line 3159: okl_strm_elements sel

3155: IS
3156: SELECT '1'
3157: FROM okl_pool_contents pol_cnts,
3158: okl_strm_type_b styb,
3159: okl_strm_elements sel
3160: WHERE pol_cnts.pol_id = pol_id
3161: AND pol_cnts.stm_id = p_stm_id
3162: AND styb.stream_type_subclass = p_stream_type_subclass
3163: AND pol_cnts.status_code IN (G_POC_STS_NEW, G_POC_STS_ACTIVE,G_POC_STS_PENDING)

Line 3940: ,okl_strm_elements ele

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
3944: AND strm.ID = cnt.STM_ID

Line 4233: FROM okl_strm_elements selb

4229:
4230: OR NOT EXISTS
4231: (
4232: SELECT '1'
4233: FROM okl_strm_elements selb
4234: WHERE selb.stm_id = stmb.id
4235: )
4236: );
4237: */

Line 4282: FROM okl_strm_elements selb

4278: -- cklee 04/10/2003 never reconcile historical data
4279: AND poc.status_code IN (G_POC_STS_NEW, G_POC_STS_ACTIVE)
4280: -- cklee 04/10/2003 never reconcile historical data
4281: AND TRUNC(poc.streams_from_date) <> ( SELECT TRUNC(MIN(selb.stream_element_date))
4282: FROM okl_strm_elements selb
4283: WHERE selb.stm_id = stmb.id
4284: AND selb.date_billed IS NULL
4285: -- mvasudev, 02/06/2004
4286: --AND selb.stream_element_date > SYSDATE

Line 4447: FROM okl_strm_elements selb

4443: -- cklee 04/10/2003 never reconcile historical data
4444: AND poc.status_code IN (G_POC_STS_PENDING)
4445: -- cklee 04/10/2003 never reconcile historical data
4446: AND TRUNC(poc.streams_from_date) <> ( SELECT TRUNC(MIN(selb.stream_element_date))
4447: FROM okl_strm_elements selb
4448: WHERE selb.stm_id = stmb.id
4449: AND selb.date_billed IS NULL
4450: -- mvasudev, 02/06/2004
4451: --AND selb.stream_element_date > SYSDATE

Line 4459: FROM okl_strm_elements selb

4455:
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

Line 5304: ,okl_strm_elements selb

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
5308: WHERE pocb.stm_id = stmb.id

Line 5338: ,okl_strm_elements selb

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
5342: AND pocb.id = p_poc_id