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_TYPE_B

Line 2658: okl_strm_type_b styb

2654: -- start for 11.5.10 by cklee 08/06/03 stream_type_subclass ER
2655: AND NOT EXISTS -- okl_pool_contents
2656: (SELECT '1'
2657: FROM okl_pool_contents pol_cnts,
2658: okl_strm_type_b styb
2659: WHERE pol_cnts.pol_id = pol_id
2660: -- mvasudev, stm_id changes
2661: -- AND pol_cnts.sty_id = styb.id
2662: -- AND pol.dnz_chr_id = pol_cnts.khr_id

Line 2786: okl_strm_type_b styb

2782: -- start for 11.5.10 by cklee 08/06/03 stream_type_subclass ER
2783: AND NOT EXISTS -- okl_pool_contents
2784: (SELECT '1'
2785: FROM okl_pool_contents pol_cnts,
2786: okl_strm_type_b styb
2787: WHERE pol_cnts.pol_id = pol_id
2788: -- mvasudev, stm_id changes
2789: --AND pol_cnts.sty_id = styb.id
2790: --AND pol.dnz_chr_id = pol_cnts.khr_id

Line 3088: ,okl_strm_type_b strm -- added for bug 13997160 :vsgandhi

3084: ,hcp.credit_classification
3085: FROM okl_pool_srch_v pol
3086: ,fnd_lookups lkup
3087: ,hz_customer_profiles hcp
3088: ,okl_strm_type_b strm -- added for bug 13997160 :vsgandhi
3089: WHERE
3090: -- pre-req
3091: pol.currency_code = p_currency_code
3092: AND pol.sts_code IN ('BOOKED','EVERGREEN')

Line 3164: okl_strm_type_b styb,

3160: CURSOR l_okl_dup_pocs_csr(p_stream_type_subclass IN VARCHAR2,p_stm_id IN NUMBER)
3161: IS
3162: SELECT '1'
3163: FROM okl_pool_contents pol_cnts,
3164: okl_strm_type_b styb,
3165: okl_strm_elements sel
3166: WHERE pol_cnts.pol_id = pol_id
3167: AND pol_cnts.stm_id = p_stm_id
3168: AND styb.stream_type_subclass = p_stream_type_subclass

Line 4120: okl_strm_type_b sty,

4116: -- to remove all the rent strms if the contract turns to EVERGREEN--
4117: SELECT poc.id
4118: FROM okl_pool_contents poc,
4119: okl_pools pol,
4120: okl_strm_type_b sty,
4121: okc_k_headers_b CHR
4122: WHERE pol.id = p_pol_id
4123: AND pol.id = poc.pol_id
4124: AND poc.sty_id = sty.id

Line 4306: okl_strm_type_b sty,

4302: -- to remove all the rent strms if the contract turns to EVERGREEN--
4303: SELECT poc.id
4304: FROM okl_pool_contents poc,
4305: okl_pools pol,
4306: okl_strm_type_b sty,
4307: okc_k_headers_b CHR
4308: WHERE pol.id = p_pol_id
4309: AND pol.id = poc.pol_id
4310: AND poc.sty_id = sty.id