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_PRICING_PVT dependencies on OKL_STRM_TYPE_TL

Line 181: okl_strm_type_tl styt

177: FROM okc_rules_b sll,
178: okc_rules_b slh,
179: okc_rule_groups_b rgp,
180: okl_strm_type_b sty,
181: okl_strm_type_tl styt
182: WHERE rgp.dnz_chr_id = p_khr_id
183: AND rgp.cle_id = p_kle_id
184: AND rgp.rgd_code= 'LALEVL'
185: AND rgp.id = slh.rgp_id

Line 208: okl_strm_type_tl styt

204: sel.sel_id se_sel_id
205: FROM okl_strm_elements sel,
206: okl_streams stm,
207: okl_strm_type_b sty,
208: okl_strm_type_tl styt
209: WHERE stm.kle_id = p_kle_id
210: AND stm.say_code = 'CURR'
211: AND stm.purpose_code IS NULL
212: AND stm.sty_id = sty.id

Line 323: okl_strm_type_tl styt

319: FROM okc_rules_b sll,
320: okc_rules_b slh,
321: okc_rule_groups_b rgp,
322: okl_strm_type_b sty,
323: okl_strm_type_tl styt
324: WHERE rgp.dnz_chr_id = p_khr_id
325: AND rgp.cle_id = p_kle_id
326: AND rgp.rgd_code= 'LALEVL'
327: AND rgp.id = slh.rgp_id

Line 1275: okl_strm_type_tl styt

1271: FROM okc_rules_b sll,
1272: okc_rules_b slh,
1273: okc_rule_groups_b rgp,
1274: okl_strm_type_b sty,
1275: okl_strm_type_tl styt
1276: WHERE rgp.dnz_chr_id = p_khr_id
1277: AND rgp.cle_id = p_kle_id
1278: AND rgp.rgd_code= 'LALEVL'
1279: AND rgp.id = slh.rgp_id

Line 1309: okl_strm_type_tl styt

1305: 'RENT' ) cf_purpose
1306: FROM okl_strm_elements sel,
1307: okl_streams stm,
1308: okl_strm_type_b sty,
1309: okl_strm_type_tl styt
1310: WHERE stm.kle_id = p_kle_id
1311: AND stm.say_code = 'WORK'
1312: AND DECODE(stm.purpose_code, NULL, '-99', 'REPORT') = p_purpose_code
1313: AND stm.sty_id = sty.id

Line 1449: okl_strm_type_tl styt

1445: FROM okc_rules_b sll,
1446: okc_rules_b slh,
1447: okc_rule_groups_b rgp,
1448: okl_strm_type_b sty,
1449: okl_strm_type_tl styt
1450: WHERE rgp.dnz_chr_id = p_khr_id
1451: AND rgp.cle_id = p_kle_id
1452: AND rgp.rgd_code= 'LALEVL'
1453: AND rgp.id = slh.rgp_id

Line 7119: from okl_strm_type_tl

7115: l_strms_rec l_strms_csr%ROWTYPE;
7116:
7117: Cursor c_sty ( n VARCHAR2 ) IS
7118: Select id
7119: from okl_strm_type_tl
7120: where language = 'US'
7121: and name = n;
7122:
7123: r_sty c_sty%ROWTYPE;

Line 7158: okl_strm_type_tl stm

7154: okc_line_styles_b lse,
7155: okc_rules_b sll,
7156: okc_rules_b slh,
7157: okc_rule_groups_b rgp,
7158: okl_strm_type_tl stm
7159: WHERE chr_so.id = p_khr_id
7160: and cle.sts_code in( 'INCOMPLETE', 'COMPLETE')--'ENTERED'
7161: AND cle.dnz_chr_id = chr_so.id
7162: AND kle.id = cle.id

Line 9628: from okl_strm_type_tl

9624: l_strms_rec l_strms_csr%ROWTYPE;
9625:
9626: Cursor c_sty ( n VARCHAR2 ) IS
9627: Select id
9628: from okl_strm_type_tl
9629: where language = 'US'
9630: and name = n;
9631:
9632: r_sty c_sty%ROWTYPE;

Line 10771: okl_strm_type_tl styt

10767: FROM okc_rules_b sll,
10768: okc_rules_b slh,
10769: okc_rule_groups_b rgp,
10770: okl_strm_type_b sty,
10771: okl_strm_type_tl styt
10772: WHERE rgp.dnz_chr_id = p_khr_id
10773: AND rgp.rgd_code= 'LALEVL'
10774: AND rgp.id = slh.rgp_id
10775: AND slh.rule_information_category = 'LASLH'

Line 10796: okl_strm_type_tl styt

10792: decode(sty.stream_type_purpose,'LOAN_PAYMENT',1,'UNSCHEDULED_PRINCIPAL_PAYMENT',2,'UNSCHEDULED_LOAN_PAYMENT',2,'VARIABLE_LOAN_PAYMENT',3,4) stream_ordr
10793: FROM okl_strm_elements sel,
10794: okl_streams stm,
10795: okl_strm_type_b sty,
10796: okl_strm_type_tl styt
10797: WHERE stm.khr_id =p_khr_id
10798: AND stm.say_code = 'CURR'
10799: AND DECODE(stm.purpose_code, NULL, '-99', 'REPORT') = '-99'
10800: AND stm.sty_id = sty.id