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_K_LINES

Line 309: from okl_k_lines

305: lx_return_status VARCHAR2(1);
306:
307: Cursor fee_type_csr IS
308: Select nvl(fee_type, 'XYZ' ) fee_type
309: from okl_k_lines
310: where id = p_kle_id;
311:
312: fee_type_rec fee_type_csr%ROWTYPe;
313:

Line 1427: okl_k_lines kle,

1423: from dual where Exists(
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

Line 1467: FROM okl_k_lines_full_v kle,

1463: CURSOR l_terminated_line_csr is
1464: SELECT kle.ID,
1465: sts.STE_CODE,
1466: trunc(nvl(kle.DATE_TERMINATED, sysdate)) date_terminated
1467: FROM okl_k_lines_full_v kle,
1468: okc_statuses_b sts
1469: WHERE kle.id = p_kle_id
1470: and kle.dnz_chr_id = p_khr_id
1471: and sts.code = kle.sts_code

Line 1524: FROM okl_k_lines kle

1520:
1521: CURSOR get_sub_pre_tax_yield_csr( p_kle_id NUMBER)
1522: IS
1523: SELECT ( sub_pre_tax_yield / 100 ) sub_pre_tax_yield
1524: FROM okl_k_lines kle
1525: WHERE kle.id = p_kle_id;
1526: -- Cursor to fetch the Stream Elements for a given Contract, Line, Stream and Purpose
1527: CURSOR get_strms_csr (
1528: p_khr_id IN NUMBER

Line 2898: okl_k_lines kle,

2894: okl_strm_elements sel_rate,
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

Line 2950: okl_k_lines kle,

2946: okl_strm_elements sel_rate,
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

Line 3065: okl_k_lines kle,

3061: IS
3062: SELECT NVL(kle.amount, 0) amount,
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

Line 3115: okl_k_lines kle,

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,
3119: okc_rule_groups_b rgp2,

Line 4250: okl_K_lines kle_roll

4246: Where Exists(Select crl.id slh_id
4247: From OKC_RULE_GROUPS_B crg,
4248: OKC_RULES_B crl,
4249: okc_K_lines_b cle_lnk,
4250: okl_K_lines kle_roll
4251: Where crl.rgp_id = crg.id
4252: and crg.RGD_CODE = 'LALEVL'
4253: and crl.RULE_INFORMATION_CATEGORY = 'LASLL'
4254: and crg.dnz_chr_id = chrId

Line 4317: FROM okl_k_lines kle,

4313: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) months_per_period,
4314: cle.start_date,
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,

Line 4351: okl_K_lines kle,

4347: kle.capital_amount,
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')

Line 4372: FROM okl_k_lines kle,

4368: DECODE(sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year,
4369: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) months_per_period,
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,

Line 4399: FROM okl_k_lines kle,

4395: SELECT NVL(kle.amount, 0) amount,
4396: cle.start_date,
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

Line 4622: from okl_k_lines_full_v kle,

4618: CURSOR top_svc_csr ( chrId NUMBER, linkId NUMBER ) IS
4619: select to_char(kle1.id) top_svc_id,
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

Line 4623: okl_k_lines_full_v kle1,

4619: select to_char(kle1.id) top_svc_id,
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'))

Line 5884: from okl_k_lines_full_v kle,

5880:
5881: CURSOR c_kle IS
5882: select kle.id,
5883: kle.start_date
5884: from okl_k_lines_full_v kle,
5885: okc_statuses_b sts
5886: where kle.dnz_chr_id = p_khr_id
5887: and kle.id = p_kle_id
5888: and sts.code = kle.sts_code

Line 7153: okl_k_lines kle,

7149: TO_NUMBER(sll.rule_information7) stub_days,
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,

Line 7185: from okl_k_lines_full_v kle,

7181: Select 'Y'
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'

Line 7755: FROM okl_k_lines kle,

7751: DECODE(sll.object1_id1, 'M', 30, 'Q', 90, 'S', 180, 'A', 360) days_per_period,
7752: DECODE(sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year,
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,

Line 8185: okl_K_lines kle_roll

8181: Where Exists(Select crl.id slh_id
8182: From OKC_RULE_GROUPS_B crg,
8183: OKC_RULES_B crl,
8184: okc_K_lines_b cle_lnk,
8185: okl_K_lines kle_roll
8186: Where crl.rgp_id = crg.id
8187: and crg.RGD_CODE = 'LALEVL'
8188: and crl.RULE_INFORMATION_CATEGORY = 'LASLL'
8189: and crg.dnz_chr_id = chrId

Line 8254: okl_k_lines kle,

8250: FROM okl_streams stm,
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

Line 8298: FROM okl_k_lines kle,

8294: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) months_per_period,
8295: cle.start_date,
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,

Line 8332: okl_K_lines kle,

8328: kle.capital_amount,
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')

Line 8353: FROM okl_k_lines kle,

8349: DECODE(sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year,
8350: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) months_per_period,
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,

Line 8380: FROM okl_k_lines kle,

8376: cle.start_date,
8377: cle.id kleid,
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

Line 8428: okl_k_lines kle,

8424: FROM okc_rules_b rul,
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

Line 9660: okl_k_lines kle,

9656: TO_NUMBER(sll.rule_information7) stub_days,
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,

Line 9699: okl_k_lines kle,

9695: TO_NUMBER(sll.rule_information7) stub_days,
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,

Line 9731: from okl_k_lines_full_v kle,

9727: Select 'Y'
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'