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_B

Line 54: okl_strm_type_b sty

50: Select distinct nvl(slh.object1_id1, -1) styId
51: From OKC_RULE_GROUPS_B rgp,
52: OKC_RULES_B sll,
53: okc_rules_b slh,
54: okl_strm_type_b sty
55: Where slh.rgp_id = rgp.id
56: and rgp.RGD_CODE = 'LALEVL'
57: and sll.RULE_INFORMATION_CATEGORY = 'LASLL'
58: and slh.RULE_INFORMATION_CATEGORY = 'LASLH'

Line 778: okl_strm_type_b stm

774: okc_line_styles_b lse,
775: okc_rules_b sll,
776: okc_rules_b slh,
777: okc_rule_groups_b rgp,
778: okl_strm_type_b stm
779: WHERE chr_so.id = p_khr_id
780: and cle.sts_code in( 'COMPLETE', 'INCOMPLETE')--'ENTERED'
781: AND cle.dnz_chr_id = chr_so.id
782: AND cle.id = kle.id

Line 1623: okl_strm_type_b sty,

1619: SELECT sel.amount income_amount,
1620: sel.stream_element_date income_date
1621: FROM okl_strm_elements sel,
1622: okl_streams stm,
1623: okl_strm_type_b sty,
1624: okl_strm_type_tl styt
1625: WHERE stm.khr_id = p_khr_id
1626: AND stm.say_code = 'WORK'
1627: AND stm.id = sel.stm_id

Line 1669: okl_strm_type_b sty

1665: Select distinct nvl(slh.object1_id1, -1) styId
1666: From OKC_RULE_GROUPS_B rgp,
1667: OKC_RULES_B sll,
1668: okc_rules_b slh,
1669: okl_strm_type_b sty
1670: Where slh.rgp_id = rgp.id
1671: and rgp.RGD_CODE = 'LALEVL'
1672: and sll.RULE_INFORMATION_CATEGORY = 'LASLL'
1673: and slh.RULE_INFORMATION_CATEGORY = 'LASLH'

Line 1873: FROM okl_strm_type_b sty,

1869: x_return_status OUT NOCOPY VARCHAR2) IS
1870:
1871: CURSOR c_sty_name IS
1872: SELECT styt.name
1873: FROM okl_strm_type_b sty,
1874: okl_strm_type_tl styt
1875: WHERE sty.id = p_sty_id
1876: AND sty.version = '1.0' -- not really needed in 1159
1877: AND sty.id = styt.id

Line 1884: FROM okl_strm_type_b sty,

1880: AND NVL(sty.end_date, SYSDATE) >= TRUNC(SYSDATE);
1881:
1882: CURSOR c_sty_id IS
1883: SELECT sty.id
1884: FROM okl_strm_type_b sty,
1885: okl_strm_type_tl styt
1886: WHERE styt.name = p_sty_name
1887: AND styt.language = 'US'
1888: AND styt.id = sty.id

Line 2028: okl_strm_type_b sty

2024: Select distinct nvl(slh.object1_id1, -1) styId
2025: From OKC_RULE_GROUPS_B rgp,
2026: OKC_RULES_B sll,
2027: okc_rules_b slh,
2028: okl_strm_type_b sty
2029: Where slh.rgp_id = rgp.id
2030: and rgp.RGD_CODE = 'LALEVL'
2031: and sll.RULE_INFORMATION_CATEGORY = 'LASLL'
2032: and slh.RULE_INFORMATION_CATEGORY = 'LASLH'

Line 3798: okl_strm_type_b sty

3794: sty.stream_type_purpose stm_purpose,
3795: ele.amount amount
3796: FROM okl_streams stm,
3797: okl_strm_elements ele,
3798: okl_strm_type_b sty
3799: WHERE stm.khr_id = p_khr_id
3800: AND ele.stm_id = stm.id
3801: AND stm.say_code = 'WORK'
3802: AND NVL(stm.purpose_code, '-99') = p_purpose_code

Line 4116: okl_strm_type_b sty

4112: Select nvl(slh.object1_id1, -1) styId
4113: From OKC_RULE_GROUPS_B rgp,
4114: OKC_RULES_B sll,
4115: okc_rules_b slh,
4116: okl_strm_type_b sty
4117: Where slh.rgp_id = rgp.id
4118: and rgp.RGD_CODE = 'LALEVL'
4119: and sll.RULE_INFORMATION_CATEGORY = 'LASLL'
4120: and slh.RULE_INFORMATION_CATEGORY = 'LASLH'

Line 4139: okl_strm_type_b sty

4135: okc_rules_b rul2,
4136: okc_k_lines_b cle,
4137: okl_k_lines kle,
4138: okc_line_styles_b lse,
4139: okl_strm_type_b sty
4140: WHERE rul1.rgp_id= rgp.id
4141: ANd rgp.rgd_code = 'LALEVL'
4142: AND rul2.rule_information_category = 'LASLL'
4143: and rul1.RULE_INFORMATION_CATEGORY = 'LASLH'

Line 4193: okl_strm_type_b sty,

4189: sll.object1_id1 cf_frequency,
4190: DECODE(sll.object1_id1, 'M', 30, 'Q', 90, 'S', 180, 'A', 360) days_per_period,
4191: DECODE(sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year
4192: FROM okl_streams stm,
4193: okl_strm_type_b sty,
4194: okl_strm_elements sel,
4195: okc_k_lines_b cle,
4196: okc_line_styles_b lse,
4197: okc_rules_b sll,

Line 6016: okl_strm_type_b sty

6012: okc_rules_b rul2,
6013: okc_k_lines_b cle,
6014: okl_k_lines kle,
6015: okc_line_styles_b lse,
6016: okl_strm_type_b sty
6017: WHERE rul2.dnz_chr_id = p_khr_id
6018: AND rul2.rule_information_category = 'LASLL'
6019: AND rul2.rgp_id = rgp.id
6020: AND TO_NUMBER(rul2.object2_id1) = rul1.id

Line 6054: okl_strm_type_b sty

6050: okc_rules_b rul2,
6051: okc_k_lines_b cle,
6052: okl_k_lines kle,
6053: okc_line_styles_b lse,
6054: okl_strm_type_b sty
6055: WHERE
6056: rul2.dnz_chr_id = p_khr_id
6057: AND rul2.rule_information_category = 'LASLL'
6058: AND rul2.rgp_id = rgp.id

Line 6084: okl_strm_type_b sty

6080: NULL fee_type
6081: FROM okc_rule_groups_b rgp,
6082: okc_rules_b rul1,
6083: okc_rules_b rul2,
6084: okl_strm_type_b sty
6085: WHERE
6086: rul2.dnz_chr_id = p_khr_id
6087: AND rul2.rule_information_category = 'LASLL'
6088: AND rul2.rgp_id = rgp.id

Line 6132: okl_strm_type_b sty

6128: Select nvl(slh.object1_id1, -1) styId
6129: From OKC_RULE_GROUPS_B rgp,
6130: OKC_RULES_B sll,
6131: okc_rules_b slh,
6132: okl_strm_type_b sty
6133: Where slh.rgp_id = rgp.id
6134: and rgp.RGD_CODE = 'LALEVL'
6135: and sll.RULE_INFORMATION_CATEGORY = 'LASLL'
6136: and slh.RULE_INFORMATION_CATEGORY = 'LASLH'

Line 10983: okl_strm_type_b sty

10979: SELECT ele.amount,
10980: ele.stream_element_date
10981: FROM okl_streams stm,
10982: okl_strm_elements ele,
10983: okl_strm_type_b sty
10984: WHERE sty.stream_type_purpose = 'PRINCIPAL_BALANCE'
10985: AND stm.sty_id = sty.id
10986: AND stm.khr_id = p_khr_id
10987: AND stm.kle_id = p_kle_id

Line 10995: okl_strm_type_b sty

10991: AND ele.stream_element_date =
10992: ( SELECT max( ele.stream_element_date)
10993: FROM okl_streams stm,
10994: okl_strm_elements ele,
10995: okl_strm_type_b sty
10996: WHERE sty.stream_type_purpose = 'PRINCIPAL_BALANCE'
10997: AND stm.sty_id = sty.id
10998: AND stm.khr_id = p_khr_id
10999: AND stm.kle_id = p_kle_id

Line 11059: okl_strm_type_b sty

11055: SELECT sty.id
11056: FROM okc_rules_b sll,
11057: okc_rules_b slh,
11058: okc_rule_groups_b rgp,
11059: okl_strm_type_b sty
11060: WHERE rgp.dnz_chr_id = p_khr_id
11061: AND rgp.cle_id = p_kle_id
11062: AND rgp.rgd_code= 'LALEVL'
11063: AND rgp.id = slh.rgp_id

Line 11338: okl_strm_type_b sty

11334: TO_NUMBER(NULL) residual_value
11335: FROM okc_rule_groups_b rgp,
11336: okc_rules_b rul1,
11337: okc_rules_b rul2,
11338: okl_strm_type_b sty
11339: WHERE rul2.dnz_chr_id = khrid
11340: AND rul2.rule_information_category = 'LASLL'
11341: AND rul2.rgp_id = rgp.id
11342: AND rgp.cle_id IS NULL

Line 11845: okl_strm_type_b sty

11841: okc_rules_b rul2,
11842: okc_k_lines_b cle,
11843: okl_k_lines kle,
11844: okc_line_styles_b lse,
11845: okl_strm_type_b sty
11846: WHERE
11847: rul2.dnz_chr_id = p_khr_id
11848: AND rul2.rule_information_category = 'LASLL'
11849: AND rul2.rgp_id = rgp.id

Line 11868: l_sty_purpose okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE;

11864: WHERE khr.id = chr.id
11865: AND chr.id = p_khr_id
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;

Line 11869: l_sty_id okl_strm_type_b.ID%TYPE;

11865: AND chr.id = p_khr_id
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;