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 OKC_K_LINES_B

Line 13: from okc_k_lines_b kle,

9: select 'T' flag
10: from dual where exists
11: (
12: select 1
13: from okc_k_lines_b kle,
14: okc_line_styles_b lse,
15: okc_statuses_b sts
16: where KLE.LSE_ID = LSE.ID
17: and lse.lty_code = 'SOLD_SERVICE'

Line 772: okc_k_lines_b cle,

768: FND_NUMBER.canonical_to_number(sll.rule_information6) amount,
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,

Line 805: okc_k_lines_b cle,

801: to_char(cle.id) kleId,
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'

Line 3659: okc_k_lines_b cle,

3655: SELECT COUNT(stm.id),
3656: stm.kle_id,
3657: stm.sty_id
3658: FROM okl_streams stm,
3659: okc_k_lines_b cle,
3660: okc_line_styles_b lse
3661: WHERE stm.khr_id = p_khr_id
3662: AND stm.say_code = 'WORK'
3663: AND NVL(stm.purpose_code, '-99') = p_purpose_code

Line 4136: okc_k_lines_b cle,

4132: DECODE(rul2.rule_information10, 'Y', 'ARREARS', 'ADVANCE') advance_arrears
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

Line 4195: okc_k_lines_b cle,

4191: DECODE(sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year
4192: FROM okl_streams stm,
4193: okl_strm_type_b sty,
4194: okl_strm_elements sel,
4195: okc_k_lines_b cle,
4196: okc_line_styles_b lse,
4197: okc_rules_b sll,
4198: okc_rules_b slh,
4199: okc_rule_groups_b rgp

Line 5330: okc_k_lines_b cle,

5326: kle.fee_type fee_type
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

Line 5378: FROM okc_k_lines_b cle,

5374: CURSOR c_fin_assets IS
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')

Line 6013: okc_k_lines_b cle,

6009: TO_NUMBER(rul2.rule_information8) stub_amount
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

Line 6051: okc_k_lines_b cle,

6047: kle.fee_type fee_type
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

Line 6113: FROM okc_k_lines_b cle,

6109: lse.lty_code,
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')

Line 6151: okc_K_lines_b cle_lnk,

6147: Select nvl(slh.object1_id1, -1) styId
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'

Line 6185: FROM okc_k_lines_b cle,

6181: CURSOR c_financed_fees IS
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')

Line 11037: FROM okc_k_lines_b cle,

11033: Select 'Y' What
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')

Line 11612: okc_k_lines_b cle,

11608: kle.fee_type fee_type
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

Line 11842: okc_k_lines_b cle,

11838: kle.fee_type fee_type
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