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_LINE_STYLES_B

Line 14: okc_line_styles_b lse,

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'
18: and kle.chr_id = chrId

Line 774: okc_line_styles_b lse,

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,
778: okl_strm_type_b stm

Line 807: okc_line_styles_b lse

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
811: AND cle.id = kle.id

Line 3660: okc_line_styles_b lse

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
3664: AND stm.kle_id IS NOT NULL

Line 4075: okc_line_styles_b lse,

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
4079: and lse.lty_code = lnetype

Line 4138: okc_line_styles_b lse,

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'
4142: AND rul2.rule_information_category = 'LASLL'

Line 4196: okc_line_styles_b lse,

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
4200: WHERE stm.khr_id = khrId

Line 5332: okc_line_styles_b lse

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'
5336: AND rul1.rule_information_category = 'LASLH'

Line 5380: okc_line_styles_b lse

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
5384: AND lse.lty_code = 'FREE_FORM1'

Line 5460: okc_line_styles_b ls

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
5464: and ls.id = kle.lse_id

Line 6015: okc_line_styles_b lse,

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'
6019: AND rul2.rgp_id = rgp.id

Line 6053: okc_line_styles_b lse,

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
6057: AND rul2.rule_information_category = 'LASLL'

Line 6115: okc_line_styles_b lse

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
6119: AND (lse.lty_code = 'FREE_FORM1' OR

Line 6187: okc_line_styles_b lse

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
6191: AND cle.lse_id = lse.id

Line 6265: okc_line_styles_b lse,

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'
6269: and kle.dnz_chr_id = p_khr_id

Line 11039: okc_line_styles_b lse

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
11043: AND (kle.fee_type = 'FINANCED' OR kle.fee_type = 'ROLLOVER' OR lse.lty_code = 'LINK_FEE_ASSET')

Line 11207: okc_line_styles_b lse,

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')
11211: AND nvl(kle.fee_type,'-99') in ( '-99', 'FINANCED', 'ROLLOVER')

Line 11614: okc_line_styles_b lse

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'
11618: AND rul1.rule_information_category = 'LASLH'

Line 11844: okc_line_styles_b lse,

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
11848: AND rul2.rule_information_category = 'LASLL'