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_CS_PRINCIPAL_PAYDOWN_PVT dependencies on OKL_STRMTYP_SOURCE_V

Line 1222: okl_strmtyp_source_v sttyp,

1218: CURSOR l_stream_type_csr(p_stream_type IN VARCHAR2
1219: ,p_khr_id IN NUMBER) IS
1220: SELECT COUNT(*)
1221: FROM okc_rules_b sll_rul,
1222: okl_strmtyp_source_v sttyp,
1223: okc_rules_b slh_rul,
1224: okc_rule_groups_b rgp
1225: WHERE sll_rul.object2_id1 = to_char(slh_rul.id)
1226: AND sll_rul.rgp_id = rgp.id

Line 1264: okl_strmtyp_source_v sttyp,

1260: sll_rul.rule_information8 stub_amount,
1261: rgp.dnz_chr_id khr_id
1262: FROM okl_time_units_v tuom,
1263: okc_rules_b sll_rul,
1264: okl_strmtyp_source_v sttyp,
1265: okc_rules_b slh_rul,
1266: okc_rule_groups_b rgp
1267: WHERE tuom.id1 = sll_rul.object1_id1
1268: AND sll_rul.object2_id1 = to_char(slh_rul.id)

Line 2471: okl_strmtyp_source_v sttyp,

2467: ,c_sty_id NUMBER)
2468: IS
2469: SELECT sum(sll_rul.rule_information8)
2470: FROM okc_rules_b sll_rul,
2471: okl_strmtyp_source_v sttyp,
2472: okc_rules_b slh_rul,
2473: okc_rule_groups_b rgp
2474: WHERE sll_rul.object2_id1 = to_char(slh_rul.id)
2475: AND sll_rul.rgp_id = rgp.id

Line 4697: okl_strmtyp_source_v sttyp,

4693: CURSOR l_stream_type_csr(p_stream_type IN VARCHAR2
4694: ,p_khr_id IN NUMBER) IS
4695: SELECT COUNT(*)
4696: FROM okc_rules_b sll_rul,
4697: okl_strmtyp_source_v sttyp,
4698: okc_rules_b slh_rul,
4699: okc_rule_groups_b rgp
4700: WHERE sll_rul.object2_id1 = to_char(slh_rul.id)
4701: AND sll_rul.rgp_id = rgp.id

Line 7219: okl_strmtyp_source_v sttyp,

7215: sll_rul.rule_information8 stub_amount,
7216: rgp.dnz_chr_id khr_id
7217: FROM okl_time_units_v tuom,
7218: okc_rules_b sll_rul,
7219: okl_strmtyp_source_v sttyp,
7220: okc_rules_b slh_rul,
7221: okc_rule_groups_b rgp
7222: WHERE tuom.id1 = sll_rul.object1_id1
7223: AND sll_rul.object2_id1 = to_char(slh_rul.id)

Line 7238: okl_strmtyp_source_v sttyp,

7234: p_sty_id IN NUMBER) IS
7235: SELECT COUNT(*)
7236: FROM okl_time_units_v tuom,
7237: okc_rules_b sll_rul,
7238: okl_strmtyp_source_v sttyp,
7239: okc_rules_b slh_rul,
7240: okc_rule_groups_b rgp
7241: WHERE tuom.id1 = sll_rul.object1_id1
7242: AND sll_rul.object2_id1 = to_char(slh_rul.id)

Line 7257: okl_strmtyp_source_v sttyp,

7253: p_sty_id IN NUMBER) IS
7254: SELECT max(to_date(sll_rul.rule_information2,'YYYY/MM/DD HH24:MI:SS')) start_date
7255: FROM okl_time_units_v tuom,
7256: okc_rules_b sll_rul,
7257: okl_strmtyp_source_v sttyp,
7258: okc_rules_b slh_rul,
7259: okc_rule_groups_b rgp
7260: WHERE tuom.id1 = sll_rul.object1_id1
7261: AND sll_rul.object2_id1 = to_char(slh_rul.id)