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 18: okc_line_styles_b lse,

14: from dual where exists
15: (
16: select 1
17: from okc_k_lines_b kle,
18: okc_line_styles_b lse,
19: okc_statuses_b sts
20: where KLE.LSE_ID = LSE.ID
21: and lse.lty_code = 'SOLD_SERVICE'
22: and kle.chr_id = chrId

Line 783: okc_line_styles_b lse,

779: TO_NUMBER(sll.rule_information8) stub_amount
780: FROM okc_k_headers_b chr_so,
781: okc_k_lines_b cle,
782: okl_k_lines kle,
783: okc_line_styles_b lse,
784: okc_rules_b sll,
785: okc_rules_b slh,
786: okc_rule_groups_b rgp,
787: okl_strm_type_b stm

Line 816: okc_line_styles_b lse

812: cle.start_date fee_start_date
813: FROM okc_k_headers_b chr_so,
814: okc_k_lines_b cle,
815: okl_k_lines kle,
816: okc_line_styles_b lse
817: WHERE chr_so.id = p_khr_id
818: and cle.sts_code in( 'COMPLETE', 'INCOMPLETE')--'ENTERED'
819: AND cle.dnz_chr_id = chr_so.id
820: AND cle.id = kle.id

Line 3570: okc_line_styles_b lse

3566: stm.kle_id,
3567: stm.sty_id
3568: FROM okl_streams stm,
3569: okc_k_lines_b cle,
3570: okc_line_styles_b lse
3571: WHERE stm.khr_id = p_khr_id
3572: AND stm.say_code = 'WORK'
3573: AND NVL(stm.purpose_code, '-99') = p_purpose_code
3574: AND stm.kle_id IS NOT NULL

Line 3990: okc_line_styles_b lse,

3986: tl.name */
3987: --Bug# 9725362
3988: ,sts.ste_code
3989: from okl_k_lines_full_v kle,
3990: okc_line_styles_b lse,
3991: -- okc_k_lines_tl tl,
3992: okc_statuses_b sts
3993: where KLE.LSE_ID = LSE.ID
3994: and lse.lty_code = lnetype

Line 4054: okc_line_styles_b lse,

4050: okc_rules_b rul1,
4051: okc_rules_b rul2,
4052: okc_k_lines_b cle,
4053: okl_k_lines kle,
4054: okc_line_styles_b lse,
4055: okl_strm_type_b sty
4056: WHERE rul1.rgp_id= rgp.id
4057: ANd rgp.rgd_code = 'LALEVL'
4058: AND rul2.rule_information_category = 'LASLL'

Line 4112: okc_line_styles_b lse,

4108: FROM okl_streams stm,
4109: okl_strm_type_b sty,
4110: okl_strm_elements sel,
4111: okc_k_lines_b cle,
4112: okc_line_styles_b lse,
4113: okc_rules_b sll,
4114: okc_rules_b slh,
4115: okc_rule_groups_b rgp
4116: WHERE stm.khr_id = khrId

Line 5254: okc_line_styles_b lse

5250: okc_rules_b rul1,
5251: okc_rules_b rul2,
5252: okc_k_lines_b cle,
5253: okl_k_lines kle,
5254: okc_line_styles_b lse
5255: WHERE
5256: rul2.dnz_chr_id = p_khr_id
5257: AND rul2.rule_information_category = 'LASLL'
5258: AND rul1.rule_information_category = 'LASLH'

Line 5302: okc_line_styles_b lse

5298: NVL(kle.residual_value, 0) residual_value,
5299: cle.start_date
5300: FROM okc_k_lines_b cle,
5301: okl_k_lines kle,
5302: okc_line_styles_b lse
5303: WHERE cle.chr_id = p_khr_id
5304: AND cle.sts_code IN ('PASSED', 'COMPLETE', 'TERMINATED')
5305: AND cle.lse_id = lse.id
5306: AND lse.lty_code = 'FREE_FORM1'

Line 5382: okc_line_styles_b ls

5378: from okl_strm_type_tl tl,
5379: okl_strm_type_v sty,
5380: okc_k_items cim,
5381: okl_k_lines_full_v kle,
5382: okc_line_styles_b ls
5383: where tl.id = sty.id
5384: and tl.language = 'US'
5385: and cim.cle_id = kle.id
5386: and ls.id = kle.lse_id

Line 5898: okc_line_styles_b lse

5894: SELECT cle.id cle_id,
5895: cle.start_date start_date,
5896: NVL(cle.date_terminated, cle.end_date) end_date
5897: FROM okc_k_lines_b cle,
5898: okc_line_styles_b lse
5899: WHERE cle.dnz_chr_id = p_khr_id
5900: AND cle.sts_code IN ('PASSED', 'COMPLETE')
5901: -- Removing 'TERMINATED' Status Lines as Partial Terminated Asset Accruals
5902: -- will be copied over any way.

Line 6225: , okc_line_styles_b lse

6221: , cle.id kle_id
6222: , NULL fee_id
6223: , cle.date_terminated date_terminated
6224: FROM okc_k_lines_b cle
6225: , okc_line_styles_b lse
6226: , okc_statuses_b sts
6227: WHERE cle.dnz_chr_id = cp_chr_id
6228: AND lse.id = cle.lse_id
6229: AND lse.lty_code = 'FREE_FORM1'

Line 6242: , okc_line_styles_b lnk_lse

6238: , lnk_cle.date_terminated date_terminated
6239: FROM okc_k_lines_b lnk_cle
6240: , okl_k_lines fee_kle
6241: , okc_k_lines_b fee_cle
6242: , okc_line_styles_b lnk_lse
6243: , okc_statuses_b sts
6244: WHERE lnk_cle.dnz_chr_id = cp_chr_id
6245: AND fee_cle.dnz_chr_id = cp_chr_id
6246: AND lnk_cle.cle_id = fee_cle.id

Line 6261: , okc_line_styles_b lse1

6257: , NULL fee_id
6258: , cle1.date_terminated date_terminated
6259: FROM okl_streams stm
6260: , okc_k_lines_b cle1
6261: , okc_line_styles_b lse1
6262: , okc_statuses_b sts1
6263: WHERE stm.khr_id = cp_chr_id
6264: AND stm.say_code = 'CURR'
6265: AND stm.kle_id = cle1.id

Line 8041: okc_line_styles_b lse,

8037: okc_rules_b rul1,
8038: okc_rules_b rul2,
8039: okc_k_lines_b cle,
8040: okl_k_lines kle,
8041: okc_line_styles_b lse,
8042: okl_strm_type_b sty
8043: WHERE rul2.dnz_chr_id = p_khr_id
8044: AND rul2.rule_information_category = 'LASLL'
8045: AND rul2.rgp_id = rgp.id

Line 8083: okc_line_styles_b lse,

8079: kle.amount fee_amount,
8080: 'INCOME_AMORT' fee_line_level_type
8081: FROM okc_k_lines_b cle,
8082: okl_k_lines kle,
8083: okc_line_styles_b lse,
8084: okl_strm_type_b sty,
8085: okc_rule_groups_b rgp,
8086: okc_rules_b rul1
8087: WHERE

Line 8124: okc_line_styles_b lse,

8120: okc_rules_b rul1,
8121: okc_rules_b rul2,
8122: okc_k_lines_b cle,
8123: okl_k_lines kle,
8124: okc_line_styles_b lse,
8125: okl_strm_type_b sty
8126: WHERE
8127: rul2.dnz_chr_id = p_khr_id
8128: AND rul2.rule_information_category = 'LASLL'

Line 8189: okc_line_styles_b lse

8185: kle.capital_amount,
8186: kle.capitalized_interest
8187: FROM okc_k_lines_b cle,
8188: okl_k_lines kle,
8189: okc_line_styles_b lse
8190: WHERE cle.dnz_chr_id = p_khr_id
8191: -- 12944979: For Terminated lines, copy_accrual_streams_isg will syncup
8192: AND cle.sts_code IN ('PASSED', 'COMPLETE') --, 'TERMINATED')
8193: AND cle.lse_id = lse.id

Line 8263: okc_line_styles_b lse

8259: nvl(kle.fee_type, 'LINK_FEE_ASSET') fee_type,
8260: lse.lty_code
8261: FROM okc_k_lines_b cle,
8262: okl_k_lines kle,
8263: okc_line_styles_b lse
8264: WHERE cle.dnz_chr_id = p_khr_id
8265: AND cle.sts_code IN ('PASSED', 'COMPLETE', 'TERMINATED')
8266: AND cle.id = kle.id
8267: AND cle.lse_id = lse.id

Line 8341: okc_line_styles_b lse,

8337: From dual
8338: where Exists(
8339: select kle.id
8340: from okl_k_lines_full_v kle,
8341: okc_line_styles_b lse,
8342: okc_statuses_b sts
8343: where KLE.LSE_ID = LSE.ID
8344: and lse.lty_code = 'SUBSIDY'
8345: and kle.dnz_chr_id = p_khr_id

Line 13494: okc_line_styles_b lse

13490: SELECT nvl(kle.fee_type, 'XYZ'),
13491: nvl(lse.lty_code, 'XYZ')
13492: FROM okc_k_lines_b cle,
13493: okl_k_lines kle,
13494: okc_line_styles_b lse
13495: WHERE cle.dnz_chr_id = p_khr_id
13496: AND cle.sts_code IN ('PASSED', 'COMPLETE', 'TERMINATED')
13497: AND cle.lse_id = lse.id
13498: AND (kle.fee_type = 'FINANCED' OR kle.fee_type = 'ROLLOVER' OR lse.lty_code = 'LINK_FEE_ASSET')

Line 13662: okc_line_styles_b lse,

13658:
13659: cursor l_line_csr IS
13660: select kle.id
13661: from okl_k_lines_full_v kle,
13662: okc_line_styles_b lse,
13663: okc_statuses_b sts
13664: where KLE.LSE_ID = LSE.ID
13665: and lse.lty_code in ('FREE_FORM1', 'FEE')
13666: AND nvl(kle.fee_type,'-99') in ( '-99', 'FINANCED', 'ROLLOVER')

Line 14081: okc_line_styles_b lse

14077: okc_rules_b rul1,
14078: okc_rules_b rul2,
14079: okc_k_lines_b cle,
14080: okl_k_lines kle,
14081: okc_line_styles_b lse
14082: WHERE
14083: rul2.dnz_chr_id = p_khr_id
14084: AND rul2.rule_information_category = 'LASLL'
14085: AND rul1.rule_information_category = 'LASLH'

Line 14311: okc_line_styles_b lse,

14307: okc_rules_b rul1,
14308: okc_rules_b rul2,
14309: okc_k_lines_b cle,
14310: okl_k_lines kle,
14311: okc_line_styles_b lse,
14312: okl_strm_type_b sty
14313: WHERE
14314: rul2.dnz_chr_id = p_khr_id
14315: AND rul2.rule_information_category = 'LASLL'