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_STREAM_GENERATOR_PVT dependencies on OKL_POOL_CONTENTS

Line 10649: okl_pool_contents pcn,

10645: ele.amount stream_ele_amount,
10646: sty.name stream_name,
10647: stm.id stm_id
10648: from okl_pools pol,
10649: okl_pool_contents pcn,
10650: okl_strm_type_v sty,
10651: okl_streams stm,
10652: okl_strm_elements ele
10653: where pcn.sty_id = sty.id

Line 10681: okl_pool_contents pcn,

10677: pkhr.contract_number agreement_number,
10678: nvl(pkhr.after_tax_yield, -1) agmnt_yield,
10679: nvl(khr.PRE_TAX_IRR, -1) contract_yield
10680: from okl_pools pol,
10681: okl_pool_contents pcn,
10682: okl_K_headers_full_v pkhr,
10683: okl_k_headers khr
10684: where pcn.pol_id = pol.id
10685: and pcn.khr_id = khr.id

Line 10708: okl_pool_contents pcn,

10704: ele.amount stream_ele_amount,
10705: sty.name stream_name,
10706: stm.id stm_id
10707: from okl_pools pol,
10708: okl_pool_contents pcn,
10709: okl_strm_type_v sty,
10710: okl_streams stm,
10711: okl_strm_elements ele
10712: where pcn.sty_id = sty.id

Line 10740: okl_pool_contents pcn,

10736: pkhr.contract_number agreement_number,
10737: nvl(pkhr.after_tax_yield, -1) agmnt_yield,
10738: nvl(khr.PRE_TAX_IRR, -1) contract_yield
10739: from okl_pools pol,
10740: okl_pool_contents pcn,
10741: okl_K_headers_full_v pkhr,
10742: okl_k_headers khr
10743: where pcn.pol_id = pol.id
10744: and pcn.khr_id = khr.id

Line 11319: okl_pool_contents pcn,

11315: ele.amount stream_ele_amount,
11316: sty.name stream_name,
11317: stm.id stm_id
11318: from okl_pools pol,
11319: okl_pool_contents pcn,
11320: okl_strm_type_v sty,
11321: okl_streams stm,
11322: okl_strm_elements ele
11323: where pcn.sty_id = sty.id

Line 11350: okl_pool_contents pcn,

11346: nvl(pkhr.after_tax_yield, -1) agmnt_yield,
11347: pkhr.contract_number agreement_number,
11348: nvl(khr.PRE_TAX_IRR, -1) contract_yield
11349: from okl_pools pol,
11350: okl_pool_contents pcn,
11351: okl_K_headers_full_v pkhr,
11352: okl_k_headers khr
11353: where pcn.pol_id = pol.id
11354: and pcn.khr_id = khr.id

Line 11381: okl_pool_contents pcn,

11377: ele.amount stream_ele_amount,
11378: sty.name stream_name,
11379: stm.id stm_id
11380: from okl_pools pol,
11381: okl_pool_contents pcn,
11382: okl_strm_type_v sty,
11383: okl_streams stm,
11384: okl_strm_elements ele
11385: where pcn.sty_id = sty.id

Line 11411: okl_pool_contents pcn,

11407: nvl(pkhr.after_tax_yield, -1) agmnt_yield,
11408: pkhr.contract_number agreement_number,
11409: nvl(khr.PRE_TAX_IRR, -1) contract_yield
11410: from okl_pools pol,
11411: okl_pool_contents pcn,
11412: okl_K_headers_full_v pkhr,
11413: okl_k_headers khr
11414: where pcn.pol_id = pol.id
11415: and pcn.khr_id = khr.id

Line 11915: okl_pool_contents pcn,

11911: pcn.sty_id stream_type_id,
11912: sty.stream_type_subclass stream_type_subclass,
11913: sty.stream_type_purpose stream_type_purpose
11914: from okl_pools pol,
11915: okl_pool_contents pcn,
11916: okl_strm_type_v sty,
11917: okl_streams stm
11918: where pcn.sty_id = sty.id
11919: and pcn.pol_id = pol.id

Line 11936: okl_pool_contents pcn,

11932: pcn.sty_id stream_type_id,
11933: sty.stream_type_subclass stream_type_subclass,
11934: sty.stream_type_purpose stream_type_purpose
11935: from okl_pools pol,
11936: okl_pool_contents pcn,
11937: okl_strm_type_v sty,
11938: okl_streams stm
11939: where pcn.sty_id = sty.id
11940: and pcn.pol_id = pol.id

Line 11963: okl_pool_contents pcn,

11959: pcn.sty_id stream_type_id,
11960: sty.stream_type_subclass stream_type_subclass,
11961: sty.stream_type_purpose stream_type_purpose
11962: from okl_pools pol,
11963: okl_pool_contents pcn,
11964: okl_strm_type_v sty,
11965: okl_streams stm
11966: where pcn.sty_id = sty.id
11967: and pcn.pol_id = pol.id

Line 11984: okl_pool_contents pcn,

11980: pcn.sty_id stream_type_id,
11981: sty.stream_type_subclass stream_type_subclass,
11982: sty.stream_type_purpose stream_type_purpose
11983: from okl_pools pol,
11984: okl_pool_contents pcn,
11985: okl_strm_type_v sty,
11986: okl_streams stm
11987: where pcn.sty_id = sty.id
11988: and pcn.pol_id = pol.id

Line 12509: okl_pool_contents pcn,

12505: pcn.sty_id stream_type_id,
12506: sty.stream_type_subclass stream_type_subclass,
12507: sty.stream_type_purpose stream_type_purpose
12508: from okl_pools pol,
12509: okl_pool_contents pcn,
12510: okl_strm_type_v sty,
12511: okl_streams stm
12512: where pcn.sty_id = sty.id
12513: and pcn.pol_id = pol.id

Line 12530: okl_pool_contents pcn,

12526: pcn.sty_id stream_type_id,
12527: sty.stream_type_subclass stream_type_subclass,
12528: sty.stream_type_purpose stream_type_purpose
12529: from okl_pools pol,
12530: okl_pool_contents pcn,
12531: okl_strm_type_v sty,
12532: okl_streams stm
12533: where pcn.sty_id = sty.id
12534: and pcn.pol_id = pol.id

Line 12558: okl_pool_contents pcn,

12554: pcn.sty_id stream_type_id,
12555: sty.stream_type_subclass stream_type_subclass,
12556: sty.stream_type_purpose stream_type_purpose
12557: from okl_pools pol,
12558: okl_pool_contents pcn,
12559: okl_strm_type_v sty,
12560: okl_streams stm
12561: where pcn.sty_id = sty.id
12562: and pcn.pol_id = pol.id

Line 12579: okl_pool_contents pcn,

12575: pcn.sty_id stream_type_id,
12576: sty.stream_type_subclass stream_type_subclass,
12577: sty.stream_type_purpose stream_type_purpose
12578: from okl_pools pol,
12579: okl_pool_contents pcn,
12580: okl_strm_type_v sty,
12581: okl_streams stm
12582: where pcn.sty_id = sty.id
12583: and pcn.pol_id = pol.id