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 1428: okc_line_styles_b lse

1424: SELECT nvl(kle.fee_type, 'XYZ'),
1425: nvl(lse.lty_code, 'XYZ')
1426: FROM okc_k_lines_b cle,
1427: okl_k_lines kle,
1428: okc_line_styles_b lse
1429: WHERE cle.dnz_chr_id = p_khr_id
1430: AND cle.sts_code IN ('PASSED', 'COMPLETE', 'TERMINATED')
1431: AND cle.lse_id = lse.id
1432: AND (kle.fee_type = 'FINANCED' OR kle.fee_type = 'ROLLOVER' OR lse.lty_code = 'LINK_FEE_ASSET')

Line 2323: okc_line_styles_b lse_so,

2319: NVL(rul_sll.rule_information10, 'Y') arrears_yn,
2320: khr_so.term_duration
2321: FROM okc_k_headers_b chr_so,
2322: okl_k_headers khr_so,
2323: okc_line_styles_b lse_so,
2324: okc_k_lines_b cle_so,
2325: okc_rule_groups_b rgp_pay,
2326: okc_rules_b rul_slh,
2327: okc_rules_b rul_sll,

Line 2365: okc_line_styles_b lse

2361: okl_strm_elements sel_amt,
2362: okl_strm_elements sel_rate,
2363: okc_k_headers_b chr_so,
2364: okc_k_lines_b cle,
2365: okc_line_styles_b lse
2366: WHERE stm.khr_id = p_khr_id
2367: AND stm.kle_id = p_kle_id
2368: AND stm.say_code = 'WORK'
2369: AND stm.purpose_code = 'FLOW'

Line 2899: okc_line_styles_b lse,

2895: okl_strm_elements sel_amt,
2896: okc_k_headers_b chr_so,
2897: okc_k_lines_b cle,
2898: okl_k_lines kle,
2899: okc_line_styles_b lse,
2900: okc_rules_b sll,
2901: okc_rules_b slh,
2902: okc_rule_groups_b rgp
2903: WHERE stm.khr_id = p_khr_id

Line 2951: okc_line_styles_b lse,

2947: okl_strm_elements sel_amt,
2948: okc_k_headers_b chr_so,
2949: okc_k_lines_b cle,
2950: okl_k_lines kle,
2951: okc_line_styles_b lse,
2952: okc_rules_b sll,
2953: okc_rules_b slh,
2954: okc_rule_groups_b rgp
2955: WHERE stm.khr_id = p_khr_id

Line 3002: okc_line_styles_b lse,

2998: okl_strm_elements sel_rate,
2999: okl_strm_elements sel_amt,
3000: okc_k_headers_b chr_so,
3001: okc_k_lines_b cle,
3002: okc_line_styles_b lse,
3003: okc_rules_b sll,
3004: okc_rules_b slh,
3005: okc_rule_groups_b rgp
3006: WHERE stm.khr_id = p_khr_id

Line 3038: okc_line_styles_b lse_so,

3034: DECODE(rul_sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year,
3035: DECODE(rul_sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) months_per_period,
3036: cle_so.END_DATE
3037: FROM okc_k_headers_b chr_so,
3038: okc_line_styles_b lse_so,
3039: okc_k_lines_b cle_so,
3040: okc_rule_groups_b rgp_pay,
3041: okc_rules_b rul_slh,
3042: okc_rules_b rul_sll,

Line 3067: okc_line_styles_b lse

3063: cle.start_date
3064: FROM okc_k_headers_b chr_so,
3065: okl_k_lines kle,
3066: okc_k_lines_b cle,
3067: okc_line_styles_b lse
3068: WHERE cle.chr_id = p_khr_id
3069: AND cle.lse_id = lse.id
3070: AND nvl(kle.fee_type, 'XXX') not in ( 'SECDEPOSIT', 'INCOME', 'CAPITALIZED' )
3071: AND lse.lty_code = 'FEE'

Line 3114: okc_line_styles_b lse,

3110: okl_strm_elements sel_amt,
3111: okl_strm_elements sel,
3112: okc_k_headers_b chr_so,
3113: okc_k_lines_b cle,
3114: okc_line_styles_b lse,
3115: okl_k_lines kle,
3116: okc_rules_b sll,
3117: okc_rules_b slh,
3118: okc_rule_groups_b rgp,

Line 3161: okc_line_styles_b lse

3157: okc_rules_b rul2,
3158: okc_rule_groups_b rgp,
3159: okc_k_headers_b chr_so,
3160: okc_k_lines_b cle,
3161: okc_line_styles_b lse
3162: WHERE cle.chr_id = p_khr_id
3163: AND cle.lse_id = lse.id
3164: AND lse.lty_code = 'FEE'
3165: AND cle.id = rgp.cle_id

Line 4277: okc_line_styles_b lse,

4273: FROM okl_streams stm,
4274: okl_strm_type_b sty,
4275: okl_strm_elements sel,
4276: okc_k_lines_b cle,
4277: okc_line_styles_b lse,
4278: okc_rules_b sll,
4279: okc_rules_b slh,
4280: okc_rule_groups_b rgp
4281: WHERE stm.khr_id = p_khr_id

Line 4319: okc_line_styles_b lse,

4315: cle.date_terminated,
4316: cle.sts_code
4317: FROM okl_k_lines kle,
4318: okc_k_lines_b cle,
4319: okc_line_styles_b lse,
4320: okc_rule_groups_b rgp,
4321: okc_rules_b slh,
4322: okc_rules_b sll,
4323: okl_strm_type_b styt

Line 4352: okc_line_styles_b lse

4348: kle.capitalized_interest,
4349: kle.date_funding_expected
4350: FROM okc_k_lines_b cle,
4351: okl_K_lines kle,
4352: okc_line_styles_b lse
4353: WHERE cle.chr_id = p_khr_id
4354: AND cle.id = kle.id
4355: AND cle.sts_code IN ('PASSED', 'COMPLETE', 'TERMINATED')
4356: AND cle.lse_id = lse.id

Line 4374: okc_line_styles_b lse,

4370: cle.date_terminated,
4371: cle.sts_code
4372: FROM okl_k_lines kle,
4373: okc_k_lines_b cle,
4374: okc_line_styles_b lse,
4375: okc_rule_groups_b rgp,
4376: okc_rules_b slh,
4377: okc_rules_b sll,
4378: okl_strm_type_b sty

Line 4401: okc_line_styles_b lse,

4397: cle.id kleId,
4398: lse.lty_code
4399: FROM okl_k_lines kle,
4400: okc_k_lines_b cle,
4401: okc_line_styles_b lse,
4402: okc_k_items cim,
4403: okl_strm_type_b sty
4404: WHERE cle.chr_id = p_khr_id
4405: AND cle.lse_id = lse.id

Line 4448: okc_line_styles_b lse,

4444: FROM okl_streams stm,
4445: okl_strm_type_b sty,
4446: okl_strm_elements sel,
4447: okc_k_lines_b cle,
4448: okc_line_styles_b lse,
4449: okc_rules_b sll,
4450: okc_rules_b slh,
4451: okc_rule_groups_b rgp,
4452: okc_rule_groups_b rgp2,

Line 4487: okc_line_styles_b lse

4483: FROM okc_rules_b rul,
4484: okc_rules_b rul2,
4485: okc_rule_groups_b rgp,
4486: okc_k_lines_b cle,
4487: okc_line_styles_b lse
4488: WHERE cle.chr_id = p_khr_id
4489: AND cle.sts_code IN ('PASSED', 'COMPLETE', 'TERMINATED')
4490: AND cle.lse_id = lse.id
4491: AND lse.lty_code = 'FEE'

Line 4624: okc_line_styles_b lse,

4620: kle1.amount top_amount,
4621: kle.amount link_amount
4622: from okl_k_lines_full_v kle,
4623: okl_k_lines_full_v kle1,
4624: okc_line_styles_b lse,
4625: okc_statuses_b sts
4626: where KLE1.LSE_ID = LSE.ID
4627: and ((lse.lty_code = 'SOLD_SERVICE') OR (lse.lty_code = 'FEE'and kle1.fee_type ='PASSTHROUGH'))
4628: and kle.dnz_chr_id = chrId

Line 6334: okc_line_styles_b lse,

6330: okl_strm_elements sel_rate,
6331: okl_strm_elements sel_amt,
6332: okc_k_headers_b chr_so,
6333: okc_k_lines_b cle,
6334: okc_line_styles_b lse,
6335: okc_rules_b sll,
6336: okc_rules_b slh,
6337: okc_rule_groups_b rgp
6338: WHERE stm.khr_id = p_khr_id

Line 6370: okc_line_styles_b lse_so,

6366: DECODE(rul_sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year,
6367: DECODE(rul_sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) months_per_period,
6368: cle_so.END_DATE
6369: FROM okc_k_headers_b chr_so,
6370: okc_line_styles_b lse_so,
6371: okc_k_lines_b cle_so,
6372: okc_rule_groups_b rgp_pay,
6373: okc_rules_b rul_slh,
6374: okc_rules_b rul_sll,

Line 7048: okc_line_styles_b lse_rv,

7044: DECODE(rul_sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) months_per_period,
7045: cle_so.id cle_id,
7046: cle_so.start_date
7047: FROM okc_k_headers_b chr_rv,
7048: okc_line_styles_b lse_rv,
7049: okc_k_lines_b cle_rv,
7050: okc_rules_b rul_rv,
7051: okc_rule_groups_b rgp_rv,
7052: okc_line_styles_b lse_so,

Line 7052: okc_line_styles_b lse_so,

7048: okc_line_styles_b lse_rv,
7049: okc_k_lines_b cle_rv,
7050: okc_rules_b rul_rv,
7051: okc_rule_groups_b rgp_rv,
7052: okc_line_styles_b lse_so,
7053: okc_k_lines_b cle_so,
7054: okc_rules_b rul_so,
7055: okc_rule_groups_b rgp_so,
7056: okc_rule_groups_b rgp_pay,

Line 7154: okc_line_styles_b lse,

7150: TO_NUMBER(sll.rule_information8) stub_amount
7151: FROM okc_k_headers_b chr_so,
7152: okc_k_lines_b cle,
7153: okl_k_lines kle,
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

Line 7186: okc_line_styles_b lse,

7182: From dual
7183: where Exists(
7184: select kle.id
7185: from okl_k_lines_full_v kle,
7186: okc_line_styles_b lse,
7187: okc_statuses_b sts
7188: where KLE.LSE_ID = LSE.ID
7189: and lse.lty_code = 'SUBSIDY'
7190: and kle.dnz_chr_id = p_khr_id

Line 7757: okc_line_styles_b lse,

7753: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) months_per_period,
7754: cle.start_date
7755: FROM okl_k_lines kle,
7756: okc_k_lines_b cle,
7757: okc_line_styles_b lse,
7758: okc_rule_groups_b rgp,
7759: okc_rules_b slh,
7760: okc_rules_b sll,
7761: okl_strm_type_b styt

Line 7782: okc_line_styles_b lse

7778: CURSOR c_asset_cost IS
7779: SELECT cle.id id,
7780: cle.start_date start_date
7781: FROM okc_k_lines_b cle,
7782: okc_line_styles_b lse
7783: WHERE cle.chr_id = p_khr_id
7784: AND cle.sts_code in ( 'BOOKED', 'TERMINATED' )
7785: AND cle.lse_id = lse.id
7786: AND lse.lty_code = 'FREE_FORM1'

Line 8210: okc_line_styles_b lse,

8206: FROM okl_streams stm,
8207: okl_strm_type_b sty,
8208: okl_strm_elements sel,
8209: okc_k_lines_b cle,
8210: okc_line_styles_b lse,
8211: okc_rules_b sll,
8212: okc_rules_b slh,
8213: okc_rule_groups_b rgp
8214: WHERE stm.khr_id = p_khr_id

Line 8255: okc_line_styles_b lse,

8251: okl_strm_type_b sty,
8252: okl_strm_elements sel,
8253: okc_k_lines_b cle,
8254: okl_k_lines kle,
8255: okc_line_styles_b lse,
8256: okc_rules_b sll,
8257: okc_rules_b slh,
8258: okc_rule_groups_b rgp
8259: WHERE stm.khr_id = p_khr_id

Line 8300: okc_line_styles_b lse,

8296: cle.date_terminated,
8297: cle.sts_code
8298: FROM okl_k_lines kle,
8299: okc_k_lines_b cle,
8300: okc_line_styles_b lse,
8301: okc_rule_groups_b rgp,
8302: okc_rules_b slh,
8303: okc_rules_b sll,
8304: okl_strm_type_b sty

Line 8333: okc_line_styles_b lse

8329: kle.capitalized_interest,
8330: kle.date_funding_expected
8331: FROM okc_k_lines_b cle,
8332: okl_K_lines kle,
8333: okc_line_styles_b lse
8334: WHERE cle.chr_id = p_khr_id
8335: AND cle.id = kle.id
8336: AND cle.sts_code IN ('PASSED', 'COMPLETE', 'TERMINATED')
8337: AND cle.lse_id = lse.id

Line 8355: okc_line_styles_b lse,

8351: cle.date_terminated,
8352: cle.sts_code
8353: FROM okl_k_lines kle,
8354: okc_k_lines_b cle,
8355: okc_line_styles_b lse,
8356: okc_rule_groups_b rgp,
8357: okc_rules_b slh,
8358: okc_rules_b sll,
8359: okl_strm_type_b sty

Line 8382: okc_line_styles_b lse,

8378: lse.lty_code lty_code,
8379: kle.fee_type fee_type
8380: FROM okl_k_lines kle,
8381: okc_k_lines_b cle,
8382: okc_line_styles_b lse,
8383: okc_k_items cim,
8384: okl_strm_type_b sty
8385: WHERE cle.chr_id = p_khr_id
8386: AND cle.lse_id = lse.id

Line 8429: okc_line_styles_b lse

8425: okc_rules_b rul2,
8426: okc_rule_groups_b rgp,
8427: okc_k_lines_b cle,
8428: okl_k_lines kle,
8429: okc_line_styles_b lse
8430: WHERE cle.chr_id = p_khr_id
8431: AND cle.sts_code IN ('PASSED', 'COMPLETE', 'TERMINATED')
8432: AND cle.lse_id = lse.id
8433: AND lse.lty_code = 'FEE'

Line 9557: okc_line_styles_b lse_rv,

9553: DECODE(rul_sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) months_per_period,
9554: cle_so.id cle_id,
9555: cle_so.start_date
9556: FROM okc_k_headers_b chr_rv,
9557: okc_line_styles_b lse_rv,
9558: okc_k_lines_b cle_rv,
9559: okc_rules_b rul_rv,
9560: okc_rule_groups_b rgp_rv,
9561: okc_line_styles_b lse_so,

Line 9561: okc_line_styles_b lse_so,

9557: okc_line_styles_b lse_rv,
9558: okc_k_lines_b cle_rv,
9559: okc_rules_b rul_rv,
9560: okc_rule_groups_b rgp_rv,
9561: okc_line_styles_b lse_so,
9562: okc_k_lines_b cle_so,
9563: okc_rules_b rul_so,
9564: okc_rule_groups_b rgp_so,
9565: okc_rule_groups_b rgp_pay,

Line 9661: okc_line_styles_b lse,

9657: TO_NUMBER(sll.rule_information8) stub_amount
9658: FROM okc_k_headers_b chr_so,
9659: okc_k_lines_b cle,
9660: okl_k_lines kle,
9661: okc_line_styles_b lse,
9662: okc_rules_b sll,
9663: okc_rules_b slh,
9664: okc_rule_groups_b rgp,
9665: okl_strm_type_b stm

Line 9700: okc_line_styles_b lse,

9696: TO_NUMBER(sll.rule_information8) stub_amount
9697: FROM okc_k_headers_b chr_so,
9698: okc_k_lines_b cle,
9699: okl_k_lines kle,
9700: okc_line_styles_b lse,
9701: okc_rules_b sll,
9702: okc_rules_b slh,
9703: okc_rule_groups_b rgp,
9704: okl_strm_type_b stm

Line 9732: okc_line_styles_b lse,

9728: From dual
9729: where Exists(
9730: select kle.id
9731: from okl_k_lines_full_v kle,
9732: okc_line_styles_b lse,
9733: okc_statuses_b sts
9734: where KLE.LSE_ID = LSE.ID
9735: and lse.lty_code = 'SUBSIDY'
9736: and kle.dnz_chr_id = p_khr_id