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_STRM_TYPE_V

Line 5379: okl_strm_type_v sty,

5375: kle.id line_id,
5376: sty.id styp_id,
5377: sty.stream_type_class stream_type_class
5378: from okl_strm_type_tl tl,
5379: okl_strm_type_v sty,
5380: okc_k_items cim,
5381: okl_k_lines_full_v kle,
5382: okc_line_styles_b ls
5383: where tl.id = sty.id

Line 10650: okl_strm_type_v sty,

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
10654: and pcn.pol_id = pol.id

Line 10709: okl_strm_type_v sty,

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
10713: and pcn.pol_id = pol.id

Line 10786: okl_strm_type_v sty

10782: Cursor c_stm_name IS
10783: Select sty.stream_type_subclass name,
10784: sty.stream_type_purpose stream_type_purpose
10785: from okl_strm_type_tl tl,
10786: okl_strm_type_v sty
10787: where tl.language = 'US'
10788: and sty.id = tl.id
10789: and tl.id = p_sty_id;
10790:

Line 11320: okl_strm_type_v sty,

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
11324: and pcn.pol_id = pol.id

Line 11382: okl_strm_type_v sty,

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
11386: and pcn.pol_id = pol.id

Line 11453: okl_strm_type_v sty

11449: Cursor c_stm_name IS
11450: Select sty.stream_type_subclass name,
11451: sty.stream_type_purpose stream_type_purpose
11452: from okl_strm_type_tl tl,
11453: okl_strm_type_v sty
11454: where tl.language = 'US'
11455: and sty.id = tl.id
11456: and tl.id = p_sty_id;
11457:

Line 11894: from okl_strm_type_v sty,

11890: l_api_name CONSTANT VARCHAR2(61) := 'gen_pv_disb_streams';
11891:
11892: Cursor l_strms_csr ( khrId NUMBER, kleId NUMBER, strmname VARCHAR2) IS
11893: select stm.id strm_id
11894: from okl_strm_type_v sty,
11895: okl_strm_type_tl stl,
11896: okl_streams stm
11897: where stl.language = 'US'
11898: and stl.name = strmname

Line 11916: okl_strm_type_v sty,

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
11920: and stm.kle_id = pcn.kle_id

Line 11937: okl_strm_type_v sty,

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
11941: and stm.kle_id = pcn.kle_id

Line 11964: okl_strm_type_v sty,

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
11968: and stm.kle_id = pcn.kle_id

Line 11985: okl_strm_type_v sty,

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
11989: and stm.kle_id = pcn.kle_id

Line 12488: from okl_strm_type_v sty,

12484: l_api_name CONSTANT VARCHAR2(61) := 'gen_disbursement_streams';
12485:
12486: Cursor l_strms_csr ( khrId NUMBER, kleId NUMBER, strmname VARCHAR2) IS
12487: select stm.id strm_id
12488: from okl_strm_type_v sty,
12489: okl_strm_type_tl stl,
12490: okl_streams stm
12491: where stl.language = 'US'
12492: and stl.name = strmname

Line 12510: okl_strm_type_v sty,

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
12514: and stm.kle_id = pcn.kle_id

Line 12531: okl_strm_type_v sty,

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
12535: and stm.kle_id = pcn.kle_id

Line 12559: okl_strm_type_v sty,

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
12563: and stm.kle_id = pcn.kle_id

Line 12580: okl_strm_type_v sty,

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
12584: and stm.kle_id = pcn.kle_id

Line 14352: l_sty_name OKL_STRM_TYPE_v.name%TYPE;

14348: -- R12.1.2 end.
14349:
14350: l_sty_purpose okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE;
14351: l_sty_id okl_strm_type_b.ID%TYPE;
14352: l_sty_name OKL_STRM_TYPE_v.name%TYPE;
14353: l_mapped_sty_name OKL_STRM_TYPE_v.name%TYPE;
14354: l_pdt_id okl_products.id%type;
14355: l_currency_code okc_k_headers_all_b.currency_code%type;
14356: l_purpose_code VARCHAR2(30) := '-99';

Line 14353: l_mapped_sty_name OKL_STRM_TYPE_v.name%TYPE;

14349:
14350: l_sty_purpose okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE;
14351: l_sty_id okl_strm_type_b.ID%TYPE;
14352: l_sty_name OKL_STRM_TYPE_v.name%TYPE;
14353: l_mapped_sty_name OKL_STRM_TYPE_v.name%TYPE;
14354: l_pdt_id okl_products.id%type;
14355: l_currency_code okc_k_headers_all_b.currency_code%type;
14356: l_purpose_code VARCHAR2(30) := '-99';
14357: