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_POOLS

Line 8193: from okl_pools pol,

8189: ele.id stream_ele_id,
8190: ele.amount stream_ele_amount,
8191: sty.name stream_name,
8192: stm.id stm_id
8193: from okl_pools pol,
8194: okl_pool_contents pcn,
8195: okl_strm_type_v sty,
8196: okl_streams stm,
8197: okl_strm_elements ele

Line 8225: from okl_pools pol,

8221: pkhr.start_date contract_start_date,
8222: pkhr.contract_number agreement_number,
8223: nvl(pkhr.after_tax_yield, -1) agmnt_yield,
8224: nvl(khr.PRE_TAX_IRR, -1) contract_yield
8225: from okl_pools pol,
8226: okl_pool_contents pcn,
8227: okl_K_headers_full_v pkhr,
8228: okl_k_headers khr
8229: where pcn.pol_id = pol.id

Line 8252: from okl_pools pol,

8248: ele.id stream_ele_id,
8249: ele.amount stream_ele_amount,
8250: sty.name stream_name,
8251: stm.id stm_id
8252: from okl_pools pol,
8253: okl_pool_contents pcn,
8254: okl_strm_type_v sty,
8255: okl_streams stm,
8256: okl_strm_elements ele

Line 8284: from okl_pools pol,

8280: pkhr.start_date contract_start_date,
8281: pkhr.contract_number agreement_number,
8282: nvl(pkhr.after_tax_yield, -1) agmnt_yield,
8283: nvl(khr.PRE_TAX_IRR, -1) contract_yield
8284: from okl_pools pol,
8285: okl_pool_contents pcn,
8286: okl_K_headers_full_v pkhr,
8287: okl_k_headers khr
8288: where pcn.pol_id = pol.id

Line 8863: from okl_pools pol,

8859: ele.id stream_ele_id,
8860: ele.amount stream_ele_amount,
8861: sty.name stream_name,
8862: stm.id stm_id
8863: from okl_pools pol,
8864: okl_pool_contents pcn,
8865: okl_strm_type_v sty,
8866: okl_streams stm,
8867: okl_strm_elements ele

Line 8894: from okl_pools pol,

8890: pcn.khr_id contract_id,
8891: nvl(pkhr.after_tax_yield, -1) agmnt_yield,
8892: pkhr.contract_number agreement_number,
8893: nvl(khr.PRE_TAX_IRR, -1) contract_yield
8894: from okl_pools pol,
8895: okl_pool_contents pcn,
8896: okl_K_headers_full_v pkhr,
8897: okl_k_headers khr
8898: where pcn.pol_id = pol.id

Line 8925: from okl_pools pol,

8921: ele.id stream_ele_id,
8922: ele.amount stream_ele_amount,
8923: sty.name stream_name,
8924: stm.id stm_id
8925: from okl_pools pol,
8926: okl_pool_contents pcn,
8927: okl_strm_type_v sty,
8928: okl_streams stm,
8929: okl_strm_elements ele

Line 8955: from okl_pools pol,

8951: pcn.khr_id contract_id,
8952: nvl(pkhr.after_tax_yield, -1) agmnt_yield,
8953: pkhr.contract_number agreement_number,
8954: nvl(khr.PRE_TAX_IRR, -1) contract_yield
8955: from okl_pools pol,
8956: okl_pool_contents pcn,
8957: okl_K_headers_full_v pkhr,
8958: okl_k_headers khr
8959: where pcn.pol_id = pol.id

Line 9459: from okl_pools pol,

9455: pcn.kle_id asset_id,
9456: pcn.sty_id stream_type_id,
9457: sty.stream_type_subclass stream_type_subclass,
9458: sty.stream_type_purpose stream_type_purpose
9459: from okl_pools pol,
9460: okl_pool_contents pcn,
9461: okl_strm_type_v sty,
9462: okl_streams stm
9463: where pcn.sty_id = sty.id

Line 9480: from okl_pools pol,

9476: pcn.kle_id asset_id,
9477: pcn.sty_id stream_type_id,
9478: sty.stream_type_subclass stream_type_subclass,
9479: sty.stream_type_purpose stream_type_purpose
9480: from okl_pools pol,
9481: okl_pool_contents pcn,
9482: okl_strm_type_v sty,
9483: okl_streams stm
9484: where pcn.sty_id = sty.id

Line 9507: from okl_pools pol,

9503: pcn.kle_id asset_id,
9504: pcn.sty_id stream_type_id,
9505: sty.stream_type_subclass stream_type_subclass,
9506: sty.stream_type_purpose stream_type_purpose
9507: from okl_pools pol,
9508: okl_pool_contents pcn,
9509: okl_strm_type_v sty,
9510: okl_streams stm
9511: where pcn.sty_id = sty.id

Line 9528: from okl_pools pol,

9524: pcn.kle_id asset_id,
9525: pcn.sty_id stream_type_id,
9526: sty.stream_type_subclass stream_type_subclass,
9527: sty.stream_type_purpose stream_type_purpose
9528: from okl_pools pol,
9529: okl_pool_contents pcn,
9530: okl_strm_type_v sty,
9531: okl_streams stm
9532: where pcn.sty_id = sty.id

Line 10053: from okl_pools pol,

10049: pcn.kle_id asset_id,
10050: pcn.sty_id stream_type_id,
10051: sty.stream_type_subclass stream_type_subclass,
10052: sty.stream_type_purpose stream_type_purpose
10053: from okl_pools pol,
10054: okl_pool_contents pcn,
10055: okl_strm_type_v sty,
10056: okl_streams stm
10057: where pcn.sty_id = sty.id

Line 10074: from okl_pools pol,

10070: pcn.kle_id asset_id,
10071: pcn.sty_id stream_type_id,
10072: sty.stream_type_subclass stream_type_subclass,
10073: sty.stream_type_purpose stream_type_purpose
10074: from okl_pools pol,
10075: okl_pool_contents pcn,
10076: okl_strm_type_v sty,
10077: okl_streams stm
10078: where pcn.sty_id = sty.id

Line 10102: from okl_pools pol,

10098: pcn.kle_id asset_id,
10099: pcn.sty_id stream_type_id,
10100: sty.stream_type_subclass stream_type_subclass,
10101: sty.stream_type_purpose stream_type_purpose
10102: from okl_pools pol,
10103: okl_pool_contents pcn,
10104: okl_strm_type_v sty,
10105: okl_streams stm
10106: where pcn.sty_id = sty.id

Line 10123: from okl_pools pol,

10119: pcn.kle_id asset_id,
10120: pcn.sty_id stream_type_id,
10121: sty.stream_type_subclass stream_type_subclass,
10122: sty.stream_type_purpose stream_type_purpose
10123: from okl_pools pol,
10124: okl_pool_contents pcn,
10125: okl_strm_type_v sty,
10126: okl_streams stm
10127: where pcn.sty_id = sty.id