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_STREAM_GENERATOR_PVT dependencies on OKL_K_LINES

Line 773: okl_k_lines kle,

769: TO_NUMBER(sll.rule_information7) stub_days,
770: TO_NUMBER(sll.rule_information8) stub_amount
771: FROM okc_k_headers_b chr_so,
772: okc_k_lines_b cle,
773: okl_k_lines kle,
774: okc_line_styles_b lse,
775: okc_rules_b sll,
776: okc_rules_b slh,
777: okc_rule_groups_b rgp,

Line 806: okl_k_lines kle,

802: kle.amount fee_amount,
803: cle.start_date fee_start_date
804: FROM okc_k_headers_b chr_so,
805: okc_k_lines_b cle,
806: okl_k_lines kle,
807: okc_line_styles_b lse
808: WHERE chr_so.id = p_khr_id
809: and cle.sts_code in( 'COMPLETE', 'INCOMPLETE')--'ENTERED'
810: AND cle.dnz_chr_id = chr_so.id

Line 4074: from okl_k_lines_full_v kle,

4070: kle.capital_reduction_percent,
4071: NVL(kle.capitalize_down_payment_yn, 'N') capitalize_down_payment_yn
4072: /* ,tl.item_description,
4073: tl.name */
4074: from okl_k_lines_full_v kle,
4075: okc_line_styles_b lse,
4076: -- okc_k_lines_tl tl,
4077: okc_statuses_b sts
4078: where KLE.LSE_ID = LSE.ID

Line 4137: okl_k_lines kle,

4133: FROM okc_rule_groups_b rgp,
4134: okc_rules_b rul1,
4135: okc_rules_b rul2,
4136: okc_k_lines_b cle,
4137: okl_k_lines kle,
4138: okc_line_styles_b lse,
4139: okl_strm_type_b sty
4140: WHERE rul1.rgp_id= rgp.id
4141: ANd rgp.rgd_code = 'LALEVL'

Line 5331: okl_k_lines kle,

5327: FROM okc_rule_groups_b rgp,
5328: okc_rules_b rul1,
5329: okc_rules_b rul2,
5330: okc_k_lines_b cle,
5331: okl_k_lines kle,
5332: okc_line_styles_b lse
5333: WHERE
5334: rul2.dnz_chr_id = p_khr_id
5335: AND rul2.rule_information_category = 'LASLL'

Line 5379: okl_k_lines kle,

5375: SELECT kle.id,
5376: NVL(kle.residual_value, 0) residual_value,
5377: cle.start_date
5378: FROM okc_k_lines_b cle,
5379: okl_k_lines kle,
5380: okc_line_styles_b lse
5381: WHERE cle.chr_id = p_khr_id
5382: AND cle.sts_code IN ('PASSED', 'COMPLETE', 'TERMINATED')
5383: AND cle.lse_id = lse.id

Line 5459: okl_k_lines_full_v kle,

5455: sty.stream_type_class stream_type_class
5456: from okl_strm_type_tl tl,
5457: okl_strm_type_v sty,
5458: okc_k_items cim,
5459: okl_k_lines_full_v kle,
5460: okc_line_styles_b ls
5461: where tl.id = sty.id
5462: and tl.language = 'US'
5463: and cim.cle_id = kle.id

Line 6014: okl_k_lines kle,

6010: FROM okc_rule_groups_b rgp,
6011: okc_rules_b rul1,
6012: okc_rules_b rul2,
6013: okc_k_lines_b cle,
6014: okl_k_lines kle,
6015: okc_line_styles_b lse,
6016: okl_strm_type_b sty
6017: WHERE rul2.dnz_chr_id = p_khr_id
6018: AND rul2.rule_information_category = 'LASLL'

Line 6052: okl_k_lines kle,

6048: FROM okc_rule_groups_b rgp,
6049: okc_rules_b rul1,
6050: okc_rules_b rul2,
6051: okc_k_lines_b cle,
6052: okl_k_lines kle,
6053: okc_line_styles_b lse,
6054: okl_strm_type_b sty
6055: WHERE
6056: rul2.dnz_chr_id = p_khr_id

Line 6114: okl_k_lines kle,

6110: kle.amount,
6111: kle.capital_amount,
6112: kle.capitalized_interest
6113: FROM okc_k_lines_b cle,
6114: okl_k_lines kle,
6115: okc_line_styles_b lse
6116: WHERE cle.dnz_chr_id = p_khr_id
6117: AND cle.sts_code IN ('PASSED', 'COMPLETE', 'TERMINATED')
6118: AND cle.lse_id = lse.id

Line 6152: okl_K_lines kle_roll

6148: From OKC_RULE_GROUPS_B crg,
6149: OKC_RULES_B crl,
6150: okc_rules_b slh,
6151: okc_K_lines_b cle_lnk,
6152: okl_K_lines kle_roll
6153: Where slh.rgp_id = crg.id
6154: and crg.RGD_CODE = 'LALEVL'
6155: and crl.RULE_INFORMATION_CATEGORY = 'LASLL'
6156: and slh.RULE_INFORMATION_CATEGORY = 'LASLH'

Line 6186: okl_k_lines kle,

6182: SELECT kle.id,
6183: nvl(kle.fee_type, 'LINK_FEE_ASSET') fee_type,
6184: lse.lty_code
6185: FROM okc_k_lines_b cle,
6186: okl_k_lines kle,
6187: okc_line_styles_b lse
6188: WHERE cle.dnz_chr_id = p_khr_id
6189: AND cle.sts_code IN ('PASSED', 'COMPLETE', 'TERMINATED')
6190: AND cle.id = kle.id

Line 6264: from okl_k_lines_full_v kle,

6260: Select 'Y'
6261: From dual
6262: where Exists(
6263: select kle.id
6264: from okl_k_lines_full_v kle,
6265: okc_line_styles_b lse,
6266: okc_statuses_b sts
6267: where KLE.LSE_ID = LSE.ID
6268: and lse.lty_code = 'SUBSIDY'

Line 11038: okl_k_lines kle,

11034: from dual where Exists(
11035: SELECT nvl(kle.fee_type, 'XYZ'),
11036: nvl(lse.lty_code, 'XYZ')
11037: FROM okc_k_lines_b cle,
11038: okl_k_lines kle,
11039: okc_line_styles_b lse
11040: WHERE cle.dnz_chr_id = p_khr_id
11041: AND cle.sts_code IN ('PASSED', 'COMPLETE', 'TERMINATED')
11042: AND cle.lse_id = lse.id

Line 11206: from okl_k_lines_full_v kle,

11202: x_msg_data OUT NOCOPY VARCHAR2) IS
11203:
11204: cursor l_line_csr IS
11205: select kle.id
11206: from okl_k_lines_full_v kle,
11207: okc_line_styles_b lse,
11208: okc_statuses_b sts
11209: where KLE.LSE_ID = LSE.ID
11210: and lse.lty_code in ('FREE_FORM1', 'FEE')

Line 11613: okl_k_lines kle,

11609: FROM okc_rule_groups_b rgp,
11610: okc_rules_b rul1,
11611: okc_rules_b rul2,
11612: okc_k_lines_b cle,
11613: okl_k_lines kle,
11614: okc_line_styles_b lse
11615: WHERE
11616: rul2.dnz_chr_id = p_khr_id
11617: AND rul2.rule_information_category = 'LASLL'

Line 11843: okl_k_lines kle,

11839: FROM okc_rule_groups_b rgp,
11840: okc_rules_b rul1,
11841: okc_rules_b rul2,
11842: okc_k_lines_b cle,
11843: okl_k_lines kle,
11844: okc_line_styles_b lse,
11845: okl_strm_type_b sty
11846: WHERE
11847: rul2.dnz_chr_id = p_khr_id