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 1268: okl_strm_type_tl styt

1264: FROM okc_rules_b sll,
1265: okc_rules_b slh,
1266: okc_rule_groups_b rgp,
1267: okl_strm_type_b sty,
1268: okl_strm_type_tl styt
1269: WHERE rgp.dnz_chr_id = p_khr_id
1270: AND rgp.cle_id = p_kle_id
1271: AND rgp.rgd_code= 'LALEVL'
1272: AND rgp.id = slh.rgp_id

Line 1296: okl_strm_type_tl styt

1292: sty.stream_type_purpose
1293: FROM okl_strm_elements sel,
1294: okl_streams stm,
1295: okl_strm_type_b sty,
1296: okl_strm_type_tl styt
1297: WHERE stm.kle_id = p_kle_id
1298: AND stm.say_code = 'WORK'
1299: AND DECODE(stm.purpose_code, NULL, '-99', 'REPORT') = p_purpose_code
1300: AND stm.sty_id = sty.id

Line 1434: okl_strm_type_tl styt

1430: FROM okc_rules_b sll,
1431: okc_rules_b slh,
1432: okc_rule_groups_b rgp,
1433: okl_strm_type_b sty,
1434: okl_strm_type_tl styt
1435: WHERE rgp.dnz_chr_id = p_khr_id
1436: AND rgp.cle_id = p_kle_id
1437: AND rgp.rgd_code= 'LALEVL'
1438: AND rgp.id = slh.rgp_id

Line 7509: from okl_strm_type_tl

7505: l_strms_rec l_strms_csr%ROWTYPE;
7506:
7507: Cursor c_sty ( n VARCHAR2 ) IS
7508: Select id
7509: from okl_strm_type_tl
7510: where language = 'US'
7511: and name = n;
7512:
7513: r_sty c_sty%ROWTYPE;

Line 7548: okl_strm_type_tl stm

7544: okc_line_styles_b lse,
7545: okc_rules_b sll,
7546: okc_rules_b slh,
7547: okc_rule_groups_b rgp,
7548: okl_strm_type_tl stm
7549: WHERE chr_so.id = p_khr_id
7550: and cle.sts_code in( 'INCOMPLETE', 'COMPLETE')--'ENTERED'
7551: AND cle.dnz_chr_id = chr_so.id
7552: AND kle.id = cle.id

Line 10013: from okl_strm_type_tl

10009: l_strms_rec l_strms_csr%ROWTYPE;
10010:
10011: Cursor c_sty ( n VARCHAR2 ) IS
10012: Select id
10013: from okl_strm_type_tl
10014: where language = 'US'
10015: and name = n;
10016:
10017: r_sty c_sty%ROWTYPE;

Line 11149: okl_strm_type_tl styt

11145: FROM okc_rules_b sll,
11146: okc_rules_b slh,
11147: okc_rule_groups_b rgp,
11148: okl_strm_type_b sty,
11149: okl_strm_type_tl styt
11150: WHERE rgp.dnz_chr_id = p_khr_id
11151: AND rgp.rgd_code= 'LALEVL'
11152: AND rgp.id = slh.rgp_id
11153: AND slh.rule_information_category = 'LASLH'

Line 11174: okl_strm_type_tl styt

11170: decode(sty.stream_type_purpose,'LOAN_PAYMENT',1,'UNSCHEDULED_PRINCIPAL_PAYMENT',2,'UNSCHEDULED_LOAN_PAYMENT',2,'VARIABLE_LOAN_PAYMENT',3,4) stream_ordr
11171: FROM okl_strm_elements sel,
11172: okl_streams stm,
11173: okl_strm_type_b sty,
11174: okl_strm_type_tl styt
11175: WHERE stm.khr_id =p_khr_id
11176: AND stm.say_code = 'CURR'
11177: AND DECODE(stm.purpose_code, NULL, '-99', 'REPORT') = '-99'
11178: AND stm.sty_id = sty.id