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 5457: okl_strm_type_v sty,

5453: kle.id line_id,
5454: sty.id styp_id,
5455: sty.stream_type_class stream_type_class
5456: from okl_strm_type_tl tl,
5457: okl_strm_type_v sty,
5458: okc_k_items cim,
5459: okl_k_lines_full_v kle,
5460: okc_line_styles_b ls
5461: where tl.id = sty.id

Line 8195: okl_strm_type_v sty,

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
8198: where pcn.sty_id = sty.id
8199: and pcn.pol_id = pol.id

Line 8254: okl_strm_type_v sty,

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
8257: where pcn.sty_id = sty.id
8258: and pcn.pol_id = pol.id

Line 8331: okl_strm_type_v sty

8327: Cursor c_stm_name IS
8328: Select sty.stream_type_subclass name,
8329: sty.stream_type_purpose stream_type_purpose
8330: from okl_strm_type_tl tl,
8331: okl_strm_type_v sty
8332: where tl.language = 'US'
8333: and sty.id = tl.id
8334: and tl.id = p_sty_id;
8335:

Line 8865: okl_strm_type_v sty,

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
8868: where pcn.sty_id = sty.id
8869: and pcn.pol_id = pol.id

Line 8927: okl_strm_type_v sty,

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
8930: where pcn.sty_id = sty.id
8931: and pcn.pol_id = pol.id

Line 8998: okl_strm_type_v sty

8994: Cursor c_stm_name IS
8995: Select sty.stream_type_subclass name,
8996: sty.stream_type_purpose stream_type_purpose
8997: from okl_strm_type_tl tl,
8998: okl_strm_type_v sty
8999: where tl.language = 'US'
9000: and sty.id = tl.id
9001: and tl.id = p_sty_id;
9002:

Line 9439: from okl_strm_type_v sty,

9435: l_api_name CONSTANT VARCHAR2(61) := 'gen_pv_disb_streams';
9436:
9437: Cursor l_strms_csr ( khrId NUMBER, kleId NUMBER, strmname VARCHAR2) IS
9438: select stm.id strm_id
9439: from okl_strm_type_v sty,
9440: okl_strm_type_tl stl,
9441: okl_streams stm
9442: where stl.language = 'US'
9443: and stl.name = strmname

Line 9461: okl_strm_type_v sty,

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
9464: and pcn.pol_id = pol.id
9465: and stm.kle_id = pcn.kle_id

Line 9482: okl_strm_type_v sty,

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
9485: and pcn.pol_id = pol.id
9486: and stm.kle_id = pcn.kle_id

Line 9509: okl_strm_type_v sty,

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
9512: and pcn.pol_id = pol.id
9513: and stm.kle_id = pcn.kle_id

Line 9530: okl_strm_type_v sty,

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
9533: and pcn.pol_id = pol.id
9534: and stm.kle_id = pcn.kle_id

Line 10033: from okl_strm_type_v sty,

10029: l_api_name CONSTANT VARCHAR2(61) := 'gen_disbursement_streams';
10030:
10031: Cursor l_strms_csr ( khrId NUMBER, kleId NUMBER, strmname VARCHAR2) IS
10032: select stm.id strm_id
10033: from okl_strm_type_v sty,
10034: okl_strm_type_tl stl,
10035: okl_streams stm
10036: where stl.language = 'US'
10037: and stl.name = strmname

Line 10055: okl_strm_type_v sty,

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
10058: and pcn.pol_id = pol.id
10059: and stm.kle_id = pcn.kle_id

Line 10076: okl_strm_type_v sty,

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
10079: and pcn.pol_id = pol.id
10080: and stm.kle_id = pcn.kle_id

Line 10104: okl_strm_type_v sty,

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
10107: and pcn.pol_id = pol.id
10108: and stm.kle_id = pcn.kle_id

Line 10125: okl_strm_type_v sty,

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
10128: and pcn.pol_id = pol.id
10129: and stm.kle_id = pcn.kle_id

Line 11870: l_sty_name OKL_STRM_TYPE_v.name%TYPE;

11866: AND khr.pdt_id = pdt.id(+);
11867:
11868: l_sty_purpose okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE;
11869: l_sty_id okl_strm_type_b.ID%TYPE;
11870: l_sty_name OKL_STRM_TYPE_v.name%TYPE;
11871: l_mapped_sty_name OKL_STRM_TYPE_v.name%TYPE;
11872: l_pdt_id okl_products.id%type;
11873: l_currency_code okc_k_headers_all_b.currency_code%type;
11874: l_purpose_code VARCHAR2(30) := '-99';

Line 11871: l_mapped_sty_name OKL_STRM_TYPE_v.name%TYPE;

11867:
11868: l_sty_purpose okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE;
11869: l_sty_id okl_strm_type_b.ID%TYPE;
11870: l_sty_name OKL_STRM_TYPE_v.name%TYPE;
11871: l_mapped_sty_name OKL_STRM_TYPE_v.name%TYPE;
11872: l_pdt_id okl_products.id%type;
11873: l_currency_code okc_k_headers_all_b.currency_code%type;
11874: l_purpose_code VARCHAR2(30) := '-99';
11875: