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 OKC_LINE_STYLES_B

Line 31: okc_line_styles_b lse_so,

27: SELECT rte.amount rate,
28: ele.stream_element_date ele_date,
29: ele.comments
30: FROM okc_k_headers_b chr_so,
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,

Line 92: okc_line_styles_b lse_so,

88: SELECT rte.amount rate,
89: ele.stream_element_date ele_date,
90: ele.comments
91: FROM okc_k_headers_b chr_so,
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,

Line 1413: okc_line_styles_b lse

1409: SELECT nvl(kle.fee_type, 'XYZ'),
1410: nvl(lse.lty_code, 'XYZ')
1411: FROM okc_k_lines_b cle,
1412: okl_k_lines kle,
1413: okc_line_styles_b lse
1414: WHERE cle.dnz_chr_id = p_khr_id
1415: AND cle.sts_code IN ('PASSED', 'COMPLETE', 'TERMINATED')
1416: AND cle.lse_id = lse.id
1417: AND (kle.fee_type = 'FINANCED' OR kle.fee_type = 'ROLLOVER' OR lse.lty_code = 'LINK_FEE_ASSET')

Line 2723: okc_line_styles_b lse_so,

2719: NVL(rul_sll.rule_information10, 'Y') arrears_yn,
2720: khr_so.term_duration
2721: FROM okc_k_headers_b chr_so,
2722: okl_k_headers khr_so,
2723: okc_line_styles_b lse_so,
2724: okc_k_lines_b cle_so,
2725: okc_rule_groups_b rgp_pay,
2726: okc_rules_b rul_slh,
2727: okc_rules_b rul_sll,

Line 2765: okc_line_styles_b lse

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
2767: AND stm.kle_id = p_kle_id
2768: AND stm.say_code = 'WORK'
2769: AND stm.purpose_code = 'FLOW'

Line 3299: okc_line_styles_b lse,

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,
3300: okc_rules_b sll,
3301: okc_rules_b slh,
3302: okc_rule_groups_b rgp
3303: WHERE stm.khr_id = p_khr_id

Line 3351: okc_line_styles_b lse,

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,
3352: okc_rules_b sll,
3353: okc_rules_b slh,
3354: okc_rule_groups_b rgp
3355: WHERE stm.khr_id = p_khr_id

Line 3402: okc_line_styles_b lse,

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,
3404: okc_rules_b slh,
3405: okc_rule_groups_b rgp
3406: WHERE stm.khr_id = p_khr_id

Line 3438: okc_line_styles_b lse_so,

3434: DECODE(rul_sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year,
3435: DECODE(rul_sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) months_per_period,
3436: cle_so.END_DATE
3437: FROM okc_k_headers_b chr_so,
3438: okc_line_styles_b lse_so,
3439: okc_k_lines_b cle_so,
3440: okc_rule_groups_b rgp_pay,
3441: okc_rules_b rul_slh,
3442: okc_rules_b rul_sll,

Line 3467: okc_line_styles_b lse

3463: cle.start_date
3464: FROM okc_k_headers_b chr_so,
3465: okl_k_lines kle,
3466: okc_k_lines_b cle,
3467: okc_line_styles_b lse
3468: WHERE cle.chr_id = p_khr_id
3469: AND cle.lse_id = lse.id
3470: AND nvl(kle.fee_type, 'XXX') not in ( 'SECDEPOSIT', 'INCOME', 'CAPITALIZED' )
3471: AND lse.lty_code = 'FEE'

Line 3514: okc_line_styles_b lse,

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,
3516: okc_rules_b sll,
3517: okc_rules_b slh,
3518: okc_rule_groups_b rgp,

Line 3561: okc_line_styles_b lse

3557: okc_rules_b rul2,
3558: okc_rule_groups_b rgp,
3559: okc_k_headers_b chr_so,
3560: okc_k_lines_b cle,
3561: okc_line_styles_b lse
3562: WHERE cle.chr_id = p_khr_id
3563: AND cle.lse_id = lse.id
3564: AND lse.lty_code = 'FEE'
3565: AND cle.id = rgp.cle_id

Line 4677: okc_line_styles_b lse,

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,
4680: okc_rule_groups_b rgp
4681: WHERE stm.khr_id = p_khr_id

Line 4719: okc_line_styles_b lse,

4715: cle.date_terminated,
4716: cle.sts_code
4717: FROM okl_k_lines kle,
4718: okc_k_lines_b cle,
4719: okc_line_styles_b lse,
4720: okc_rule_groups_b rgp,
4721: okc_rules_b slh,
4722: okc_rules_b sll,
4723: okl_strm_type_b styt

Line 4752: okc_line_styles_b lse

4748: kle.capitalized_interest,
4749: kle.date_funding_expected
4750: FROM okc_k_lines_b cle,
4751: okl_K_lines kle,
4752: okc_line_styles_b lse
4753: WHERE cle.chr_id = p_khr_id
4754: AND cle.id = kle.id
4755: AND cle.sts_code IN ('PASSED', 'COMPLETE', 'TERMINATED')
4756: AND cle.lse_id = lse.id

Line 4774: okc_line_styles_b lse,

4770: cle.date_terminated,
4771: cle.sts_code
4772: FROM okl_k_lines kle,
4773: okc_k_lines_b cle,
4774: okc_line_styles_b lse,
4775: okc_rule_groups_b rgp,
4776: okc_rules_b slh,
4777: okc_rules_b sll,
4778: okl_strm_type_b sty

Line 4801: okc_line_styles_b lse,

4797: cle.id kleId,
4798: lse.lty_code
4799: FROM okl_k_lines kle,
4800: okc_k_lines_b cle,
4801: okc_line_styles_b lse,
4802: okc_k_items cim,
4803: okl_strm_type_b sty
4804: WHERE cle.chr_id = p_khr_id
4805: AND cle.lse_id = lse.id

Line 4848: okc_line_styles_b lse,

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,
4851: okc_rule_groups_b rgp,
4852: okc_rule_groups_b rgp2,

Line 4887: okc_line_styles_b lse

4883: FROM okc_rules_b rul,
4884: okc_rules_b rul2,
4885: okc_rule_groups_b rgp,
4886: okc_k_lines_b cle,
4887: okc_line_styles_b lse
4888: WHERE cle.chr_id = p_khr_id
4889: AND cle.sts_code IN ('PASSED', 'COMPLETE', 'TERMINATED')
4890: AND cle.lse_id = lse.id
4891: AND lse.lty_code = 'FEE'

Line 5024: okc_line_styles_b lse,

5020: kle1.amount top_amount,
5021: kle.amount link_amount
5022: from okl_k_lines_full_v kle,
5023: okl_k_lines_full_v kle1,
5024: okc_line_styles_b lse,
5025: okc_statuses_b sts
5026: where KLE1.LSE_ID = LSE.ID
5027: and ((lse.lty_code = 'SOLD_SERVICE') OR (lse.lty_code = 'FEE'and kle1.fee_type ='PASSTHROUGH'))
5028: and kle.dnz_chr_id = chrId

Line 6724: okc_line_styles_b lse,

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,
6726: okc_rules_b slh,
6727: okc_rule_groups_b rgp
6728: WHERE stm.khr_id = p_khr_id

Line 6760: okc_line_styles_b lse_so,

6756: DECODE(rul_sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year,
6757: DECODE(rul_sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) months_per_period,
6758: cle_so.END_DATE
6759: FROM okc_k_headers_b chr_so,
6760: okc_line_styles_b lse_so,
6761: okc_k_lines_b cle_so,
6762: okc_rule_groups_b rgp_pay,
6763: okc_rules_b rul_slh,
6764: okc_rules_b rul_sll,

Line 7438: okc_line_styles_b lse_rv,

7434: DECODE(rul_sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) months_per_period,
7435: cle_so.id cle_id,
7436: cle_so.start_date
7437: FROM okc_k_headers_b chr_rv,
7438: okc_line_styles_b lse_rv,
7439: okc_k_lines_b cle_rv,
7440: okc_rules_b rul_rv,
7441: okc_rule_groups_b rgp_rv,
7442: okc_line_styles_b lse_so,

Line 7442: okc_line_styles_b lse_so,

7438: okc_line_styles_b lse_rv,
7439: okc_k_lines_b cle_rv,
7440: okc_rules_b rul_rv,
7441: okc_rule_groups_b rgp_rv,
7442: okc_line_styles_b lse_so,
7443: okc_k_lines_b cle_so,
7444: okc_rules_b rul_so,
7445: okc_rule_groups_b rgp_so,
7446: okc_rule_groups_b rgp_pay,

Line 7544: okc_line_styles_b lse,

7540: TO_NUMBER(sll.rule_information8) stub_amount
7541: FROM okc_k_headers_b chr_so,
7542: okc_k_lines_b cle,
7543: okl_k_lines kle,
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

Line 7576: okc_line_styles_b lse,

7572: From dual
7573: where Exists(
7574: select kle.id
7575: from okl_k_lines_full_v kle,
7576: okc_line_styles_b lse,
7577: okc_statuses_b sts
7578: where KLE.LSE_ID = LSE.ID
7579: and lse.lty_code = 'SUBSIDY'
7580: and kle.dnz_chr_id = p_khr_id

Line 8147: okc_line_styles_b lse,

8143: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) months_per_period,
8144: cle.start_date
8145: FROM okl_k_lines kle,
8146: okc_k_lines_b cle,
8147: okc_line_styles_b lse,
8148: okc_rule_groups_b rgp,
8149: okc_rules_b slh,
8150: okc_rules_b sll,
8151: okl_strm_type_b styt

Line 8172: okc_line_styles_b lse

8168: CURSOR c_asset_cost IS
8169: SELECT cle.id id,
8170: cle.start_date start_date
8171: FROM okc_k_lines_b cle,
8172: okc_line_styles_b lse
8173: WHERE cle.chr_id = p_khr_id
8174: AND cle.sts_code in ( 'BOOKED', 'TERMINATED' )
8175: AND cle.lse_id = lse.id
8176: AND lse.lty_code = 'FREE_FORM1'

Line 8600: okc_line_styles_b lse,

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,
8603: okc_rule_groups_b rgp
8604: WHERE stm.khr_id = p_khr_id

Line 8645: okc_line_styles_b lse,

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,
8647: okc_rules_b slh,
8648: okc_rule_groups_b rgp
8649: WHERE stm.khr_id = p_khr_id

Line 8690: okc_line_styles_b lse,

8686: cle.date_terminated,
8687: cle.sts_code
8688: FROM okl_k_lines kle,
8689: okc_k_lines_b cle,
8690: okc_line_styles_b lse,
8691: okc_rule_groups_b rgp,
8692: okc_rules_b slh,
8693: okc_rules_b sll,
8694: okl_strm_type_b sty

Line 8723: okc_line_styles_b lse

8719: kle.capitalized_interest,
8720: kle.date_funding_expected
8721: FROM okc_k_lines_b cle,
8722: okl_K_lines kle,
8723: okc_line_styles_b lse
8724: WHERE cle.chr_id = p_khr_id
8725: AND cle.id = kle.id
8726: AND cle.sts_code IN ('PASSED', 'COMPLETE', 'TERMINATED')
8727: AND cle.lse_id = lse.id

Line 8745: okc_line_styles_b lse,

8741: cle.date_terminated,
8742: cle.sts_code
8743: FROM okl_k_lines kle,
8744: okc_k_lines_b cle,
8745: okc_line_styles_b lse,
8746: okc_rule_groups_b rgp,
8747: okc_rules_b slh,
8748: okc_rules_b sll,
8749: okl_strm_type_b sty

Line 8772: okc_line_styles_b lse,

8768: lse.lty_code lty_code,
8769: kle.fee_type fee_type
8770: FROM okl_k_lines kle,
8771: okc_k_lines_b cle,
8772: okc_line_styles_b lse,
8773: okc_k_items cim,
8774: okl_strm_type_b sty
8775: WHERE cle.chr_id = p_khr_id
8776: AND cle.lse_id = lse.id

Line 8819: okc_line_styles_b lse

8815: okc_rules_b rul2,
8816: okc_rule_groups_b rgp,
8817: okc_k_lines_b cle,
8818: okl_k_lines kle,
8819: okc_line_styles_b lse
8820: WHERE cle.chr_id = p_khr_id
8821: AND cle.sts_code IN ('PASSED', 'COMPLETE', 'TERMINATED')
8822: AND cle.lse_id = lse.id
8823: AND lse.lty_code = 'FEE'

Line 9942: okc_line_styles_b lse_rv,

9938: DECODE(rul_sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) months_per_period,
9939: cle_so.id cle_id,
9940: cle_so.start_date
9941: FROM okc_k_headers_b chr_rv,
9942: okc_line_styles_b lse_rv,
9943: okc_k_lines_b cle_rv,
9944: okc_rules_b rul_rv,
9945: okc_rule_groups_b rgp_rv,
9946: okc_line_styles_b lse_so,

Line 9946: okc_line_styles_b lse_so,

9942: okc_line_styles_b lse_rv,
9943: okc_k_lines_b cle_rv,
9944: okc_rules_b rul_rv,
9945: okc_rule_groups_b rgp_rv,
9946: okc_line_styles_b lse_so,
9947: okc_k_lines_b cle_so,
9948: okc_rules_b rul_so,
9949: okc_rule_groups_b rgp_so,
9950: okc_rule_groups_b rgp_pay,

Line 10046: okc_line_styles_b lse,

10042: TO_NUMBER(sll.rule_information8) stub_amount
10043: FROM okc_k_headers_b chr_so,
10044: okc_k_lines_b cle,
10045: okl_k_lines kle,
10046: okc_line_styles_b lse,
10047: okc_rules_b sll,
10048: okc_rules_b slh,
10049: okc_rule_groups_b rgp,
10050: okl_strm_type_b stm

Line 10085: okc_line_styles_b lse,

10081: TO_NUMBER(sll.rule_information8) stub_amount
10082: FROM okc_k_headers_b chr_so,
10083: okc_k_lines_b cle,
10084: okl_k_lines kle,
10085: okc_line_styles_b lse,
10086: okc_rules_b sll,
10087: okc_rules_b slh,
10088: okc_rule_groups_b rgp,
10089: okl_strm_type_b stm

Line 10117: okc_line_styles_b lse,

10113: From dual
10114: where Exists(
10115: select kle.id
10116: from okl_k_lines_full_v kle,
10117: okc_line_styles_b lse,
10118: okc_statuses_b sts
10119: where KLE.LSE_ID = LSE.ID
10120: and lse.lty_code = 'SUBSIDY'
10121: and kle.dnz_chr_id = p_khr_id