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_ELEMENTS

Line 35: okl_strm_elements ele,

31: okc_line_styles_b lse_so,
32: okc_k_lines_b cle_so,
33: okl_strm_type_b sty,
34: okl_streams stm,
35: okl_strm_elements ele,
36: okl_strm_elements rte
37: WHERE stm.khr_id = chr_so.id
38: AND chr_so.id = p_khr_id
39: AND stm.kle_id = cle_so.id

Line 36: okl_strm_elements rte

32: okc_k_lines_b cle_so,
33: okl_strm_type_b sty,
34: okl_streams stm,
35: okl_strm_elements ele,
36: okl_strm_elements rte
37: WHERE stm.khr_id = chr_so.id
38: AND chr_so.id = p_khr_id
39: AND stm.kle_id = cle_so.id
40: AND cle_so.dnz_chr_id = chr_so.id

Line 96: okl_strm_elements ele,

92: okc_line_styles_b lse_so,
93: okc_k_lines_b cle_so,
94: okl_strm_type_b sty,
95: okl_streams stm,
96: okl_strm_elements ele,
97: okl_strm_elements rte
98: WHERE stm.khr_id = chr_so.id
99: AND chr_so.id = p_khr_id
100: AND stm.kle_id = cle_so.id

Line 97: okl_strm_elements rte

93: okc_k_lines_b cle_so,
94: okl_strm_type_b sty,
95: okl_streams stm,
96: okl_strm_elements ele,
97: okl_strm_elements rte
98: WHERE stm.khr_id = chr_so.id
99: AND chr_so.id = p_khr_id
100: AND stm.kle_id = cle_so.id
101: AND cle_so.dnz_chr_id = chr_so.id

Line 205: FROM okl_strm_elements sel,

201: sel.amount se_amount,
202: sel.stream_element_date se_date,
203: sel.comments se_arrears,
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

Line 223: okl_strm_elements sel

219:
220: Cursor c_stub IS
221: Select sel.id
222: from okl_streams stm,
223: okl_strm_elements sel
224: where stm.khr_id = p_khr_id
225: and stm.say_code = 'HIST'
226: and stm.SGN_CODE = 'MANL'
227: and stm.active_yn = 'N'

Line 256: se_arrears okl_strm_elements.comments%type);

252: se_amount NUMBER,
253: se_date DATE,
254: se_days NUMBER,
255: se_stub VARCHAR2(1),
256: se_arrears okl_strm_elements.comments%type);
257:
258: TYPE loan_tbl IS TABLE OF loan_rec INDEX BY BINARY_INTEGER;
259:
260: asset_rents loan_tbl;

Line 1293: FROM okl_strm_elements sel,

1289: sel.stream_element_date se_date,
1290: sel.comments se_arrears,
1291: sel.sel_id se_sel_id,
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

Line 1316: okl_strm_elements sel

1312: /* Commented by prasjain for bug 5474827
1313: Cursor c_stub IS
1314: Select sel.id
1315: from okl_streams stm,
1316: okl_strm_elements sel
1317: where stm.khr_id = p_khr_id
1318: and stm.say_code = 'HIST'
1319: and stm.SGN_CODE = 'MANL'
1320: and stm.active_yn = 'N'

Line 2761: okl_strm_elements sel_amt,

2757: sel_amt.comments se_arrears,
2758: sel_rate.comments payment_missing_yn
2759: FROM okl_streams stm,
2760: okl_strm_type_b sty,
2761: okl_strm_elements sel_amt,
2762: okl_strm_elements sel_rate,
2763: okc_k_headers_b chr_so,
2764: okc_k_lines_b cle,
2765: okc_line_styles_b lse

Line 2762: okl_strm_elements sel_rate,

2758: sel_rate.comments payment_missing_yn
2759: FROM okl_streams stm,
2760: okl_strm_type_b sty,
2761: okl_strm_elements sel_amt,
2762: okl_strm_elements sel_rate,
2763: okc_k_headers_b chr_so,
2764: okc_k_lines_b cle,
2765: okc_line_styles_b lse
2766: WHERE stm.khr_id = p_khr_id

Line 3294: okl_strm_elements sel_rate,

3290: chr_so.start_date,
3291: chr_so.end_date
3292: FROM okl_streams stm,
3293: okl_strm_type_b sty,
3294: okl_strm_elements sel_rate,
3295: okl_strm_elements sel_amt,
3296: okc_k_headers_b chr_so,
3297: okc_k_lines_b cle,
3298: okl_k_lines kle,

Line 3295: okl_strm_elements sel_amt,

3291: chr_so.end_date
3292: FROM okl_streams stm,
3293: okl_strm_type_b sty,
3294: okl_strm_elements sel_rate,
3295: okl_strm_elements sel_amt,
3296: okc_k_headers_b chr_so,
3297: okc_k_lines_b cle,
3298: okl_k_lines kle,
3299: okc_line_styles_b lse,

Line 3346: okl_strm_elements sel_rate,

3342: chr_so.start_date,
3343: lse.lty_code
3344: FROM okl_streams stm,
3345: okl_strm_type_b sty,
3346: okl_strm_elements sel_rate,
3347: okl_strm_elements sel_amt,
3348: okc_k_headers_b chr_so,
3349: okc_k_lines_b cle,
3350: okl_k_lines kle,

Line 3347: okl_strm_elements sel_amt,

3343: lse.lty_code
3344: FROM okl_streams stm,
3345: okl_strm_type_b sty,
3346: okl_strm_elements sel_rate,
3347: okl_strm_elements sel_amt,
3348: okc_k_headers_b chr_so,
3349: okc_k_lines_b cle,
3350: okl_k_lines kle,
3351: okc_line_styles_b lse,

Line 3398: okl_strm_elements sel_rate,

3394: DECODE(sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year,
3395: chr_so.start_date
3396: FROM okl_streams stm,
3397: okl_strm_type_b sty,
3398: okl_strm_elements sel_rate,
3399: okl_strm_elements sel_amt,
3400: okc_k_headers_b chr_so,
3401: okc_k_lines_b cle,
3402: okc_line_styles_b lse,

Line 3399: okl_strm_elements sel_amt,

3395: chr_so.start_date
3396: FROM okl_streams stm,
3397: okl_strm_type_b sty,
3398: okl_strm_elements sel_rate,
3399: okl_strm_elements sel_amt,
3400: okc_k_headers_b chr_so,
3401: okc_k_lines_b cle,
3402: okc_line_styles_b lse,
3403: okc_rules_b sll,

Line 3510: okl_strm_elements sel_amt,

3506: NVL(TO_NUMBER(laptpr.rule_information1), 100) pass_through_percentage,
3507: sll.rule_information10 arrears_yn
3508: FROM okl_streams stm,
3509: okl_strm_type_b sty,
3510: okl_strm_elements sel_amt,
3511: okl_strm_elements sel,
3512: okc_k_headers_b chr_so,
3513: okc_k_lines_b cle,
3514: okc_line_styles_b lse,

Line 3511: okl_strm_elements sel,

3507: sll.rule_information10 arrears_yn
3508: FROM okl_streams stm,
3509: okl_strm_type_b sty,
3510: okl_strm_elements sel_amt,
3511: okl_strm_elements sel,
3512: okc_k_headers_b chr_so,
3513: okc_k_lines_b cle,
3514: okc_line_styles_b lse,
3515: okl_k_lines kle,

Line 3602: miss_amt okl_strm_elements.comments%TYPE);

3598: cf_dpp NUMBER,
3599: cf_ppy NUMBER,
3600: cf_days NUMBER,
3601: rate NUMBER,
3602: miss_amt okl_strm_elements.comments%TYPE);
3603: TYPE cash_flow_tbl_type IS TABLE OF cash_flow_rec_type INDEX BY BINARY_INTEGER;
3604: hdr_inflow_tbl cash_flow_tbl_type;
3605: inflow_tbl cash_flow_tbl_type;
3606: rv_tbl cash_flow_tbl_type;

Line 4624: okl_strm_elements sel,

4620: DECODE(sll.object1_id1, 'M', 30, 'Q', 90, 'S', 180, 'A', 360) days_per_period,
4621: DECODE(sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year
4622: FROM okl_streams stm,
4623: okl_strm_type_b sty,
4624: okl_strm_elements sel,
4625: okc_rules_b sll,
4626: okc_rules_b slh,
4627: okc_rule_groups_b rgp
4628: WHERE stm.khr_id = p_khr_id

Line 4675: okl_strm_elements sel,

4671: cle.id kleId,
4672: lse.lty_code
4673: FROM okl_streams stm,
4674: okl_strm_type_b sty,
4675: okl_strm_elements sel,
4676: okc_k_lines_b cle,
4677: okc_line_styles_b lse,
4678: okc_rules_b sll,
4679: okc_rules_b slh,

Line 4846: okl_strm_elements sel,

4842: DECODE(sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year,
4843: NVL(TO_NUMBER(laptpr.rule_information1), 100) pass_through_percentage
4844: FROM okl_streams stm,
4845: okl_strm_type_b sty,
4846: okl_strm_elements sel,
4847: okc_k_lines_b cle,
4848: okc_line_styles_b lse,
4849: okc_rules_b sll,
4850: okc_rules_b slh,

Line 6258: FROM okl_strm_elements sel,

6254: SELECT sel.id se_id,
6255: sel.amount se_amount,
6256: sel.stream_element_date se_date,
6257: sel.comments se_arrears
6258: FROM okl_strm_elements sel,
6259: okl_streams stm,
6260: okl_strm_type_b sty
6261: WHERE stm.kle_id = p_kle_id
6262: AND stm.say_code = 'CURR'

Line 6720: okl_strm_elements sel_rate,

6716: DECODE(sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year,
6717: chr_so.start_date
6718: FROM okl_streams stm,
6719: okl_strm_type_b sty,
6720: okl_strm_elements sel_rate,
6721: okl_strm_elements sel_amt,
6722: okc_k_headers_b chr_so,
6723: okc_k_lines_b cle,
6724: okc_line_styles_b lse,

Line 6721: okl_strm_elements sel_amt,

6717: chr_so.start_date
6718: FROM okl_streams stm,
6719: okl_strm_type_b sty,
6720: okl_strm_elements sel_rate,
6721: okl_strm_elements sel_amt,
6722: okc_k_headers_b chr_so,
6723: okc_k_lines_b cle,
6724: okc_line_styles_b lse,
6725: okc_rules_b sll,

Line 6805: miss_amt okl_strm_elements.comments%TYPE);

6801: cf_dpp NUMBER,
6802: cf_ppy NUMBER,
6803: cf_days NUMBER,
6804: rate NUMBER,
6805: miss_amt okl_strm_elements.comments%TYPE);
6806:
6807: TYPE cash_flow_tbl_type IS TABLE OF cash_flow_rec_type INDEX BY BINARY_INTEGER;
6808: hdr_inflow_tbl cash_flow_tbl_type;
6809: inflow_tbl cash_flow_tbl_type;

Line 8180: okl_strm_elements ele,

8176: AND lse.lty_code = 'FREE_FORM1'
8177: AND cle.id IN (
8178: SELECT distinct stm.kle_id
8179: FROM okl_streams stm,
8180: okl_strm_elements ele,
8181: okl_strm_type_b sty
8182: WHERE stm.khr_id = p_khr_id
8183: AND stm.say_code = 'CURR'
8184: AND stm.active_yn = 'Y'

Line 8193: okl_strm_elements sel

8189:
8190: Cursor c_stub IS
8191: Select sel.id
8192: from okl_streams stm,
8193: okl_strm_elements sel
8194: where stm.khr_id = p_khr_id
8195: and stm.say_code = 'HIST'
8196: and stm.SGN_CODE = 'MANL'
8197: and stm.active_yn = 'N'

Line 8549: okl_strm_elements sel,

8545: DECODE(sll.object1_id1, 'M', 30, 'Q', 90, 'S', 180, 'A', 360) days_per_period,
8546: DECODE(sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year
8547: FROM okl_streams stm,
8548: okl_strm_type_b sty,
8549: okl_strm_elements sel,
8550: okc_rules_b sll,
8551: okc_rules_b slh,
8552: okc_rule_groups_b rgp
8553: WHERE stm.khr_id = p_khr_id

Line 8598: okl_strm_elements sel,

8594: DECODE(sll.object1_id1, 'M', 30, 'Q', 90, 'S', 180, 'A', 360) days_per_period,
8595: DECODE(sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year
8596: FROM okl_streams stm,
8597: okl_strm_type_b sty,
8598: okl_strm_elements sel,
8599: okc_k_lines_b cle,
8600: okc_line_styles_b lse,
8601: okc_rules_b sll,
8602: okc_rules_b slh,

Line 8642: okl_strm_elements sel,

8638: lse.lty_code,
8639: kle.fee_type
8640: FROM okl_streams stm,
8641: okl_strm_type_b sty,
8642: okl_strm_elements sel,
8643: okc_k_lines_b cle,
8644: okl_k_lines kle,
8645: okc_line_styles_b lse,
8646: okc_rules_b sll,

Line 11171: FROM okl_strm_elements sel,

11167: sel.stream_element_date se_date,
11168: sel.comments se_arrears,
11169: sty.stream_type_purpose,
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

Line 11206: se_arrears okl_strm_elements.comments%type,

11202:
11203: TYPE loan_rec IS RECORD (se_amount NUMBER,
11204: se_date DATE,
11205: se_days NUMBER,
11206: se_arrears okl_strm_elements.comments%type,
11207: se_purpose okl_strm_type_b.stream_type_purpose%type);
11208:
11209: TYPE loan_tbl IS TABLE OF loan_rec INDEX BY BINARY_INTEGER;
11210: