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_LA_STREAM_PVT dependencies on OKC_LINE_STYLES_B

Line 1695: FROM OKL_K_LINES KLE, OKC_K_LINES_B CLE, OKC_LINE_STYLES_B LSE

1691: IS
1692: -- cursor to fetch the abosrbed fee line with purpose as RVI
1693: CURSOR rvi_fee_csr IS
1694: SELECT KLE.ID ID
1695: FROM OKL_K_LINES KLE, OKC_K_LINES_B CLE, OKC_LINE_STYLES_B LSE
1696: WHERE CLE.CHR_ID = p_chr_id
1697: AND CLE.DNZ_CHR_ID = p_chr_id
1698: AND CLE.ID = KLE.ID
1699: AND CLE.LSE_ID = LSE.ID

Line 2139: okc_line_styles_b lse

2135: SELECT 'Y'
2136: FROM dual
2137: WHERE EXISTS (SELECT 'Y'
2138: FROM okc_k_lines_b cle,
2139: okc_line_styles_b lse
2140: WHERE cle.dnz_chr_id = p_chr_id
2141: AND cle.lse_id = lse.id
2142: AND cle.sts_code = 'TERMINATED'
2143: AND lse.lty_code = 'FREE_FORM1');

Line 2152: okc_line_styles_b lse

2148: SELECT 'Y'
2149: FROM dual
2150: WHERE EXISTS (SELECT 'Y'
2151: FROM okc_k_lines_b cle,
2152: okc_line_styles_b lse
2153: WHERE cle.dnz_chr_id = p_chr_id
2154: AND cle.id = p_cle_id
2155: AND cle.lse_id = lse.id
2156: AND cle.sts_code = 'TERMINATED'

Line 2364: okc_line_styles_b lse

2360: CURSOR c_fee_line_csr(p_khr_id OKC_K_HEADERS_B.ID%TYPE)
2361: IS
2362: SELECT cle.id id
2363: FROM okc_k_lines_b cle,
2364: okc_line_styles_b lse
2365: WHERE dnz_chr_id = p_khr_id
2366: AND cle.lse_id = lse.id
2367: AND lse.lty_code = 'FEE';
2368: BEGIN

Line 2673: okc_line_styles_b lse

2669: okc_rules_b rul1,
2670: okc_rules_b rul2,
2671: okc_k_lines_b cle,
2672: okl_k_lines kle,
2673: okc_line_styles_b lse
2674: WHERE rul2.dnz_chr_id = p_chr_id
2675: AND rul2.rule_information_category = 'LASLL'
2676: AND rgp.RGD_CODE = 'LALEVL'
2677: AND rul2.rgp_id = rgp.id

Line 3921: okc_line_styles_b lse,

3917: kle.initial_direct_cost,
3918: tl.item_description,
3919: tl.name
3920: FROM okl_k_lines_full_v kle,
3921: okc_line_styles_b lse,
3922: okc_k_lines_tl tl,
3923: okc_statuses_b sts
3924: WHERE kle.lse_id = lse.id
3925: AND lse.lty_code in ( 'FREE_FORM1', 'FEE', 'SOLD_SERVICE', 'LINK_SERV_ASSET')--bug# 3343133 (ssiruvol)

Line 4524: okc_line_styles_b lse

4520: IS
4521: SELECT kle.id kle_id,
4522: kle.start_date
4523: FROM okc_k_lines_b kle,
4524: okc_line_styles_b lse
4525: WHERE kle.lse_id = lse.id
4526: AND lse.lty_code in ( 'FREE_FORM1', 'FEE', 'SOLD_SERVICE', 'LINK_SERV_ASSET')--bug# 3343133 (ssiruvol)
4527: AND kle.dnz_chr_id = p_chr_id;
4528:

Line 5547: okc_line_styles_b lse_fin,

5543: FROM dual
5544: WHERE EXISTS (SELECT '1'
5545: FROM okl_subsidies_b subb,
5546: okc_k_lines_b cle_fin,
5547: okc_line_styles_b lse_fin,
5548: okc_k_lines_b cle,
5549: okl_k_headers khr,
5550: okl_k_lines kle,
5551: okc_line_styles_b lse

Line 5551: okc_line_styles_b lse

5547: okc_line_styles_b lse_fin,
5548: okc_k_lines_b cle,
5549: okl_k_headers khr,
5550: okl_k_lines kle,
5551: okc_line_styles_b lse
5552: WHERE cle.dnz_chr_id = p_dnz_chr_id
5553: AND cle.dnz_chr_id = khr.id
5554: AND khr.deal_type IN ('LEASEDF','LEASEOP','LEASEST','LOAN')
5555: AND cle.cle_id = cle_fin.id

Line 5788: okc_line_styles_b lse,

5784: okl_streams str,
5785: --okl_strm_type_v sty,
5786: OKL_STRM_TMPT_LINES_UV sty,
5787: okl_k_lines_full_v kle,
5788: okc_line_styles_b lse,
5789: okc_statuses_b sts
5790: Where ele.stm_id = str.id
5791: and str.khr_id = chrId
5792: and str.kle_id = kle.id

Line 6423: , OKC_LINE_STYLES_B LNK_LSE

6419: SELECT LNK_CLE.ID LNK_ID
6420: , FEE_CLE.ID FEE_ID
6421: , LNK_CLE.DATE_TERMINATED
6422: FROM OKC_K_LINES_B LNK_CLE
6423: , OKC_LINE_STYLES_B LNK_LSE
6424: , OKL_K_LINES FEE_KLE
6425: , OKC_K_LINES_B FEE_CLE
6426: , OKC_STATUSES_B STS
6427: WHERE LNK_CLE.CLE_ID = FEE_CLE.ID

Line 6446: , OKC_LINE_STYLES_B LSE

6442: SELECT CLE.ID LINE_ID
6443: , CLE.DATE_TERMINATED
6444: FROM OKL_K_HEADERS KHR
6445: , OKC_K_LINES_B CLE
6446: , OKC_LINE_STYLES_B LSE
6447: , OKC_STATUSES_B STS
6448: WHERE CLE.DNZ_CHR_ID = KHR.ID
6449: AND LSE.ID = CLE.LSE_ID
6450: AND LSE.LTY_CODE ='FREE_FORM1'

Line 7127: okc_line_styles_b lse,

7123: okl_stream_interfaces sif,
7124: okl_sif_lines line,
7125: okc_k_lines_b cle,
7126: okl_k_lines kle,
7127: okc_line_styles_b lse,
7128: okl_sif_fees fee
7129: WHERE lev.sir_id = ret.id
7130: AND lev.level_type = 'Payment'
7131: AND ret.transaction_number = sif.transaction_number

Line 7200: okc_line_styles_b lse,

7196: AND str.sgn_code NOT IN ('INTC','LATE_CALC') -- bug 6472228
7197: AND (NVL( str.kle_id, -1) = -1 OR
7198: str.kle_id IN (SELECT kle.id
7199: FROM okl_k_lines_full_v kle,
7200: okc_line_styles_b lse,
7201: okc_statuses_b sts
7202: WHERE KLE.LSE_ID = LSE.ID
7203: AND kle.dnz_chr_id = p_chr_id
7204: AND sts.code = kle.sts_code

Line 8095: okc_line_styles_b lse,

8091: CURSOR l_line_rec_csr(chrid NUMBER)
8092: IS
8093: SELECT cle.id
8094: FROM okc_k_lines_b cle,
8095: okc_line_styles_b lse,
8096: okc_statuses_b sts
8097: WHERE cle.dnz_chr_id = chrid
8098: AND cle.lse_id = lse.id
8099: AND lse.lty_code = 'FREE_FORM1'

Line 8109: okc_line_styles_b lse,

8105: CURSOR l_fee_type_csr ( chrId NUMBER, feeId NUMBER ) IS
8106: SELECT kle.fee_type
8107: FROM okl_k_lines kle,
8108: okc_k_lines_b cle,
8109: okc_line_styles_b lse,
8110: okc_statuses_b sts
8111: WHERE cle.lse_id = lse.id
8112: AND lse.lty_code = 'FEE'
8113: AND cle.dnz_chr_id = chrid

Line 8126: okc_line_styles_b lse,

8122: CURSOR l_fin_type_csr (chrId NUMBER)
8123: IS
8124: SELECT cle.id fin_id
8125: FROM okc_k_lines_b cle,
8126: okc_line_styles_b lse,
8127: okl_k_lines kle,
8128: okc_statuses_b sts
8129: WHERE cle.dnz_chr_id = chrId
8130: AND cle.lse_id = lse.id

Line 8142: okc_line_styles_b lse,

8138: CURSOR l_rollover_csr(chrId NUMBER)
8139: IS
8140: SELECT cle.id fin_id
8141: FROM okc_k_lines_b cle,
8142: okc_line_styles_b lse,
8143: okl_k_lines kle,
8144: okc_statuses_b sts
8145: WHERE cle.dnz_chr_id = chrId
8146: AND cle.lse_id = lse.id

Line 8158: okc_line_styles_b lse

8154: IS
8155: SELECT okc.id kle_id
8156: FROM okc_k_lines_b okc,
8157: okl_k_lines kle ,
8158: okc_line_styles_b lse
8159: WHERE okc.cle_id = cleId
8160: AND okc.lse_id = lse.id
8161: AND okc.id = kle.id
8162: AND lty_code = 'LINK_FEE_ASSET';

Line 8177: okc_line_styles_b lse,

8173: okl_strm_type_b sty,
8174: okl_subsidies_v sub,
8175: okl_k_lines kle,
8176: okc_statuses_b sts,
8177: okc_line_styles_b lse,
8178: okc_k_lines_b cle
8179: WHERE cle.dnz_chr_id = p_dnz_chr_id
8180: AND cle.lse_id = lse.id
8181: AND lse.lty_code = 'SUBSIDY'

Line 8201: okc_line_styles_b lse

8197: FROM okl_k_lines kle,
8198: okc_k_lines_b cle,
8199: okl_subsidies_v sub,
8200: okc_statuses_b sts,
8201: okc_line_styles_b lse
8202: WHERE cle.dnz_chr_id = p_dnz_chr_id
8203: AND cle.lse_id = lse.id
8204: AND lse.lty_code = 'SUBSIDY'
8205: AND sts.code = cle.sts_code

Line 8664: okc_line_styles_b lse,

8660: kle.initial_direct_cost,
8661: tl.item_description,
8662: tl.name
8663: from okl_k_lines_full_v kle,
8664: okc_line_styles_b lse,
8665: okc_k_lines_tl tl,
8666: okc_statuses_b sts
8667: where KLE.LSE_ID = LSE.ID
8668: and lse.lty_code = lnetype

Line 8690: okc_line_styles_b ls

8686: stl.id styp_id
8687: FROM OKL_STRM_TMPT_LINES_UV stl,
8688: okc_k_items cim,
8689: okl_k_lines_full_v kle,
8690: okc_line_styles_b ls
8691: WHERE cim.cle_id = kle.id
8692: AND ls.id = kle.lse_id
8693: AND ls.lty_code = 'FEE'
8694: AND cim.object1_id1 = stl.primary_sty_id

Line 8903: okc_line_styles_b lse

8899: SELECT cle.id,
8900: NVL(kle.date_funding,cle.start_date) date_funding
8901: FROM okc_k_lines_b cle,
8902: okl_k_lines kle,
8903: okc_line_styles_b lse
8904: WHERE cle.dnz_chr_id = p_chr_id
8905: AND cle.sts_code NOT IN ('HOLD', 'EXPIRED', 'CANCELLED','ABANDONED')
8906: AND cle.id = kle.id
8907: AND cle.lse_id = lse.id

Line 8916: okc_line_styles_b lse_fin,

8912: SELECT subb.accounting_method_code,
8913: cle.id
8914: FROM okl_subsidies_b subb,
8915: okc_k_lines_b cle_fin,
8916: okc_line_styles_b lse_fin,
8917: okc_k_lines_b cle,
8918: okl_k_lines kle,
8919: okc_line_styles_b lse
8920: WHERE cle.cle_id = p_line_id

Line 8919: okc_line_styles_b lse

8915: okc_k_lines_b cle_fin,
8916: okc_line_styles_b lse_fin,
8917: okc_k_lines_b cle,
8918: okl_k_lines kle,
8919: okc_line_styles_b lse
8920: WHERE cle.cle_id = p_line_id
8921: AND cle.id = kle.id
8922: AND cle.lse_id = lse.id
8923: AND lse.lty_code = 'SUBSIDY'

Line 8936: okc_line_styles_b lse_fin,

8932: FROM dual
8933: WHERE EXISTS (SELECT '1'
8934: FROM okl_subsidies_b subb,
8935: okc_k_lines_b cle_fin,
8936: okc_line_styles_b lse_fin,
8937: okc_k_lines_b cle,
8938: okl_k_lines kle,
8939: okc_line_styles_b lse
8940: WHERE cle.dnz_chr_id = p_dnz_chr_id

Line 8939: okc_line_styles_b lse

8935: okc_k_lines_b cle_fin,
8936: okc_line_styles_b lse_fin,
8937: okc_k_lines_b cle,
8938: okl_k_lines kle,
8939: okc_line_styles_b lse
8940: WHERE cle.dnz_chr_id = p_dnz_chr_id
8941: AND cle.cle_id = cle_fin.id
8942: AND cle.dnz_chr_id = cle_fin.dnz_chr_id
8943: AND cle.id = kle.id

Line 8959: okc_line_styles_b lse,

8955:
8956: SELECT kle.sty_id
8957: FROM okl_k_lines kle,
8958: okc_k_lines_b cle,
8959: okc_line_styles_b lse,
8960: okl_subsidies_v sub
8961:
8962: WHERE cle.dnz_chr_id = p_dnz_chr_id
8963: AND cle.id = p_sub_cle_id

Line 8975: okc_line_styles_b lse,

8971: okl_strm_type_b sty_inc,
8972: okl_strm_type_b sty,
8973: okl_subsidies_v sub,
8974: okl_k_lines kle,
8975: okc_line_styles_b lse,
8976: okc_k_lines_b cle
8977: WHERE cle.dnz_chr_id = p_dnz_chr_id
8978: AND cle.id = p_sub_cle_id
8979: AND cle.lse_id = lse.id

Line 9455: okc_line_styles_b lse,

9451: kle.date_funding_expected,
9452: kle.capital_reduction,
9453: kle.capitalize_down_payment_yn
9454: FROM okl_k_lines_full_v kle,
9455: okc_line_styles_b lse,
9456: okc_k_lines_tl tl,
9457: okc_statuses_b sts
9458: WHERE kle.lse_id = lse.id
9459: AND lse.lty_code = 'LINK_FEE_ASSET'

Line 9508: okc_line_styles_b lse

9504: , sts.ste_code
9505: -- srsreeni - Bug#5699923 - Added - End
9506: FROM okc_k_lines_b okc,
9507: okl_k_lines kle ,
9508: okc_line_styles_b lse
9509: ,okc_statuses_b sts
9510: WHERE okc.cle_id = cleId
9511: AND okc.lse_id = lse.id
9512: AND okc.id = kle.id

Line 17521: okc_line_styles_b lse,

17517: SELECT 1
17518: FROM dual
17519: WHERE EXISTS (SELECT 1
17520: FROM okc_k_lines_b cle,
17521: okc_line_styles_b lse,
17522: okl_k_lines kle
17523: WHERE cle.dnz_chr_id = chrId
17524: AND cle.lse_id = lse.id
17525: AND lse.lty_code = 'FEE'

Line 17586: okc_line_styles_b lse_ib,

17582: FROM hz_locations hl,
17583: hz_party_sites hps,
17584: hz_party_site_uses hpsu,
17585: okl_txl_itm_insts iti,
17586: okc_line_styles_b lse_ib,
17587: okc_k_lines_b cle_ib
17588: WHERE cle_ib.dnz_chr_id = chrId
17589: AND cle_ib.lse_id = lse_ib.id
17590: AND lse_ib.lty_code = 'INST_ITEM'

Line 17638: okc_line_styles_b lse,

17634: -- Added for Down Payment Enhancement
17635: kle.capital_reduction,
17636: kle.capitalize_down_payment_yn
17637: FROM okl_k_lines_full_v kle,
17638: okc_line_styles_b lse,
17639: okc_k_lines_tl tl,
17640: okc_statuses_b sts
17641: WHERE kle.lse_id = lse.id
17642: AND lse.lty_code = lnetype

Line 17654: okc_line_styles_b lse_fin,

17650: IS
17651: SELECT kle_sub.amount, kle_sub.SUBSIDY_OVERRIDE_AMOUNT
17652: FROM okl_subsidies_b subb,
17653: okc_k_lines_b cle_fin,
17654: okc_line_styles_b lse_fin,
17655: okc_k_lines_b cle_sub,
17656: okl_k_lines kle_sub,
17657: okc_line_styles_b lse_sub
17658: WHERE cle_fin.id = p_cle_id

Line 17657: okc_line_styles_b lse_sub

17653: okc_k_lines_b cle_fin,
17654: okc_line_styles_b lse_fin,
17655: okc_k_lines_b cle_sub,
17656: okl_k_lines kle_sub,
17657: okc_line_styles_b lse_sub
17658: WHERE cle_fin.id = p_cle_id
17659: AND cle_fin.dnz_chr_id = p_chr_id
17660: AND cle_sub.id = kle_sub.id
17661: AND cle_sub.lse_id = lse_sub.id

Line 20810: okc_line_styles_b lse

20806: IS
20807: SELECT cle.id
20808: FROM okc_k_lines_b cle,
20809: okl_k_lines kle,
20810: okc_line_styles_b lse
20811: WHERE cle.dnz_chr_id = p_khr_id
20812: AND cle.lse_id = lse.id
20813: AND cle.sts_code NOT IN ('HOLD', 'EXPIRED', 'CANCELLED')
20814: AND lse.lty_code = 'FEE'

Line 20838: okc_line_styles_b lse

20834: CURSOR c_get_all_lines_csr(p_khr_id okl_k_headers.id%TYPE)
20835: IS
20836: SELECT cle.id line_id
20837: FROM okc_k_lines_b cle,
20838: okc_line_styles_b lse
20839: WHERE cle.dnz_chr_id = p_khr_id
20840: AND cle.lse_id = lse.id
20841: AND cle.sts_code NOT IN ('HOLD', 'EXPIRED', 'CANCELLED')
20842: AND lse.lty_code IN ('FREE_FORM1','FEE','SOLD_SERVICE');

Line 21405: okc_line_styles_b lse_rv,

21401: SELECT kle_rv.id asset_line_id,
21402: kle_rv.oec oec,
21403: cle_so.START_DATE
21404: FROM okc_k_headers_b chr_rv,
21405: okc_line_styles_b lse_rv,
21406: okl_k_lines kle_rv,
21407: okc_k_lines_b cle_rv,
21408: okc_rules_b rul_rv,
21409: okc_rule_groups_b rgp_rv,

Line 21410: okc_line_styles_b lse_so,

21406: okl_k_lines kle_rv,
21407: okc_k_lines_b cle_rv,
21408: okc_rules_b rul_rv,
21409: okc_rule_groups_b rgp_rv,
21410: okc_line_styles_b lse_so,
21411: okc_k_lines_b cle_so,
21412: okc_rules_b rul_so,
21413: okc_rule_groups_b rgp_so
21414: WHERE rgp_so.cle_id = p_kle_id

Line 21528: okc_line_styles_b lse_rv,

21524: kle_rv.oec oec,
21525: kle_rv.residual_percentage residual_percent,
21526: cle_so.start_date
21527: FROM okc_k_headers_b chr_rv,
21528: okc_line_styles_b lse_rv,
21529: okl_k_lines kle_rv,
21530: okc_k_lines_b cle_rv,
21531: okc_rules_b rul_rv,
21532: okc_rule_groups_b rgp_rv,

Line 21533: okc_line_styles_b lse_so,

21529: okl_k_lines kle_rv,
21530: okc_k_lines_b cle_rv,
21531: okc_rules_b rul_rv,
21532: okc_rule_groups_b rgp_rv,
21533: okc_line_styles_b lse_so,
21534: okc_k_lines_b cle_so,
21535: okc_rules_b rul_so,
21536: okc_rule_groups_b rgp_so
21537: WHERE rgp_so.cle_id = p_kle_id

Line 21920: okc_line_styles_b lse_ib,

21916: FROM hz_locations hl,
21917: hz_party_sites hps,
21918: hz_party_site_uses hpsu,
21919: okl_txl_itm_insts iti,
21920: okc_line_styles_b lse_ib,
21921: okc_k_lines_b cle_ib
21922: WHERE cle_ib.dnz_chr_id = chrId
21923: AND cle_ib.lse_id = lse_ib.id
21924: AND lse_ib.lty_code = 'INST_ITEM'

Line 21953: okc_line_styles_b lse,

21949: kle.initial_direct_cost,
21950: tl.item_description,
21951: tl.name
21952: FROM okl_k_lines_full_v kle,
21953: okc_line_styles_b lse,
21954: okc_k_lines_tl tl,
21955: okc_statuses_b sts
21956: WHERE kle.lse_id = lse.id
21957: AND lse.lty_code = lnetype

Line 21988: okc_line_styles_b lse,

21984: kle.initial_direct_cost,
21985: tl.item_description,
21986: tl.name
21987: FROM okl_k_lines_full_v kle,
21988: okc_line_styles_b lse,
21989: okc_k_lines_tl tl,
21990: okc_statuses_b sts
21991: WHERE kle.lse_id = lse.id
21992: AND lse.lty_code = 'SO_PAYMENT'

Line 22139: okc_line_styles_b lse,

22135: SELECT 1
22136: FROM dual
22137: WHERE EXISTS (SELECT 1
22138: FROM okc_k_lines_b cle,
22139: okc_line_styles_b lse,
22140: okl_k_lines kle
22141: WHERE cle.dnz_chr_id = chrId
22142: AND cle.lse_id = lse.id
22143: AND lse.lty_code = 'FEE'