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 1412: okl_k_lines kle,

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

Line 1452: FROM okl_k_lines_full_v kle,

1448: CURSOR l_terminated_line_csr is
1449: SELECT kle.ID,
1450: sts.STE_CODE,
1451: trunc(nvl(kle.DATE_TERMINATED, sysdate)) date_terminated
1452: FROM okl_k_lines_full_v kle,
1453: okc_statuses_b sts
1454: WHERE kle.id = p_kle_id
1455: and kle.dnz_chr_id = p_khr_id
1456: and sts.code = kle.sts_code

Line 3298: okl_k_lines kle,

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,
3300: okc_rules_b sll,
3301: okc_rules_b slh,
3302: okc_rule_groups_b rgp

Line 3350: okl_k_lines kle,

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,
3352: okc_rules_b sll,
3353: okc_rules_b slh,
3354: okc_rule_groups_b rgp

Line 3465: okl_k_lines kle,

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

Line 3515: okl_k_lines kle,

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

Line 4650: okl_K_lines kle_roll

4646: Where Exists(Select crl.id slh_id
4647: From OKC_RULE_GROUPS_B crg,
4648: OKC_RULES_B crl,
4649: okc_K_lines_b cle_lnk,
4650: okl_K_lines kle_roll
4651: Where crl.rgp_id = crg.id
4652: and crg.RGD_CODE = 'LALEVL'
4653: and crl.RULE_INFORMATION_CATEGORY = 'LASLL'
4654: and crg.dnz_chr_id = chrId

Line 4717: FROM okl_k_lines kle,

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

Line 4751: okl_K_lines kle,

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

Line 4772: FROM okl_k_lines kle,

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

Line 4799: FROM okl_k_lines kle,

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

Line 5022: from okl_k_lines_full_v kle,

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

Line 5023: okl_k_lines_full_v kle1,

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

Line 6274: from okl_k_lines_full_v kle,

6270:
6271: CURSOR c_kle IS
6272: select kle.id,
6273: kle.start_date
6274: from okl_k_lines_full_v kle,
6275: okc_statuses_b sts
6276: where kle.dnz_chr_id = p_khr_id
6277: and kle.id = p_kle_id
6278: and sts.code = kle.sts_code

Line 7543: okl_k_lines kle,

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

Line 7575: from okl_k_lines_full_v kle,

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

Line 8145: FROM okl_k_lines kle,

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

Line 8575: okl_K_lines kle_roll

8571: Where Exists(Select crl.id slh_id
8572: From OKC_RULE_GROUPS_B crg,
8573: OKC_RULES_B crl,
8574: okc_K_lines_b cle_lnk,
8575: okl_K_lines kle_roll
8576: Where crl.rgp_id = crg.id
8577: and crg.RGD_CODE = 'LALEVL'
8578: and crl.RULE_INFORMATION_CATEGORY = 'LASLL'
8579: and crg.dnz_chr_id = chrId

Line 8644: okl_k_lines kle,

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,
8647: okc_rules_b slh,
8648: okc_rule_groups_b rgp

Line 8688: FROM okl_k_lines kle,

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

Line 8722: okl_K_lines kle,

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

Line 8743: FROM okl_k_lines kle,

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

Line 8770: FROM okl_k_lines kle,

8766: cle.start_date,
8767: cle.id kleid,
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

Line 8818: okl_k_lines kle,

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

Line 10045: okl_k_lines kle,

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

Line 10084: okl_k_lines kle,

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

Line 10116: from okl_k_lines_full_v kle,

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