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.

[Home] [Help]

APPS.OKL_STREAM_GENERATOR_PVT dependencies on OKL_STRM_TYPE_TL

Line 1639: okl_strm_type_tl styt

1635: sel.stream_element_date income_date
1636: FROM okl_strm_elements sel,
1637: okl_streams stm,
1638: okl_strm_type_b sty,
1639: okl_strm_type_tl styt
1640: WHERE stm.khr_id = p_khr_id
1641: AND stm.say_code = 'WORK'
1642: AND stm.id = sel.stm_id
1643: AND stm.sty_id = sty.id

Line 1889: okl_strm_type_tl styt

1885:
1886: CURSOR c_sty_name IS
1887: SELECT styt.name
1888: FROM okl_strm_type_b sty,
1889: okl_strm_type_tl styt
1890: WHERE sty.id = p_sty_id
1891: AND sty.version = '1.0' -- not really needed in 1159
1892: AND sty.id = styt.id
1893: AND styt.language = 'US'

Line 1900: okl_strm_type_tl styt

1896:
1897: CURSOR c_sty_id IS
1898: SELECT sty.id
1899: FROM okl_strm_type_b sty,
1900: okl_strm_type_tl styt
1901: WHERE styt.name = p_sty_name
1902: AND styt.language = 'US'
1903: AND styt.id = sty.id
1904: AND sty.version = '1.0' -- not really needed in 1159

Line 4091: from okl_strm_type_tl

4087: and object1_id1 = to_char( styId );
4088:
4089: Cursor c_strm_name ( styId NUMBER ) IS
4090: Select name
4091: from okl_strm_type_tl
4092: where language = 'US'
4093: and id = styId;
4094:
4095: l_subsidy_stream VARCHAR2(256);

Line 5378: from okl_strm_type_tl tl,

5374: sty.capitalize_yn capitalize_yn,
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

Line 7075: ,okl_strm_type_tl styt

7071: ,SUM(sel.amount) income_amount
7072: FROM okl_strm_elements sel
7073: ,okl_streams stm
7074: ,okl_strm_type_b sty
7075: ,okl_strm_type_tl styt
7076: WHERE stm.khr_id = p_khr_id
7077: AND stm.say_code = 'WORK'
7078: AND stm.id = sel.stm_id
7079: AND stm.sty_id = sty.id

Line 10362: okl_strm_type_tl sty

10358: TO_NUMBER(NULL) residual_value
10359: FROM okc_rule_groups_b rgp,
10360: okc_rules_b rul1,
10361: okc_rules_b rul2,
10362: okl_strm_type_tl sty
10363: WHERE rul2.dnz_chr_id = khrid
10364: AND rul2.rule_information_category = 'LASLL'
10365: AND rul2.rgp_id = rgp.id
10366: AND rul1.rgp_id = rgp.id

Line 10785: from okl_strm_type_tl tl,

10781:
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;

Line 11452: from okl_strm_type_tl tl,

11448:
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;

Line 11895: okl_strm_type_tl stl,

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
11899: and sty.id = stl.id

Line 12489: okl_strm_type_tl stl,

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
12493: and sty.id = stl.id