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 1674: FROM OKL_K_LINES KLE, OKC_K_LINES_B CLE, OKC_LINE_STYLES_B LSE

1670: IS
1671: -- cursor to fetch the abosrbed fee line with purpose as RVI
1672: CURSOR rvi_fee_csr IS
1673: SELECT KLE.ID ID
1674: FROM OKL_K_LINES KLE, OKC_K_LINES_B CLE, OKC_LINE_STYLES_B LSE
1675: WHERE CLE.CHR_ID = p_chr_id
1676: AND CLE.DNZ_CHR_ID = p_chr_id
1677: AND CLE.ID = KLE.ID
1678: AND CLE.LSE_ID = LSE.ID

Line 2118: okc_line_styles_b lse

2114: SELECT 'Y'
2115: FROM dual
2116: WHERE EXISTS (SELECT 'Y'
2117: FROM okc_k_lines_b cle,
2118: okc_line_styles_b lse
2119: WHERE cle.dnz_chr_id = p_chr_id
2120: AND cle.lse_id = lse.id
2121: AND cle.sts_code = 'TERMINATED'
2122: AND lse.lty_code = 'FREE_FORM1');

Line 2131: okc_line_styles_b lse

2127: SELECT 'Y'
2128: FROM dual
2129: WHERE EXISTS (SELECT 'Y'
2130: FROM okc_k_lines_b cle,
2131: okc_line_styles_b lse
2132: WHERE cle.dnz_chr_id = p_chr_id
2133: AND cle.id = p_cle_id
2134: AND cle.lse_id = lse.id
2135: AND cle.sts_code = 'TERMINATED'

Line 2343: okc_line_styles_b lse

2339: CURSOR c_fee_line_csr(p_khr_id OKC_K_HEADERS_B.ID%TYPE)
2340: IS
2341: SELECT cle.id id
2342: FROM okc_k_lines_b cle,
2343: okc_line_styles_b lse
2344: WHERE dnz_chr_id = p_khr_id
2345: AND cle.lse_id = lse.id
2346: AND lse.lty_code = 'FEE';
2347: BEGIN

Line 3089: okc_line_styles_b lse

3085: okc_rules_b rul1,
3086: okc_rules_b rul2,
3087: okc_k_lines_b cle,
3088: okl_k_lines kle,
3089: okc_line_styles_b lse
3090: WHERE rul2.dnz_chr_id = p_chr_id
3091: AND rul2.rule_information_category = 'LASLL'
3092: AND rgp.RGD_CODE = 'LALEVL'
3093: AND rul2.rgp_id = rgp.id

Line 5020: okc_line_styles_b lse,

5016: kle.initial_direct_cost,
5017: tl.item_description,
5018: tl.name
5019: FROM okl_k_lines_full_v kle,
5020: okc_line_styles_b lse,
5021: okc_k_lines_tl tl,
5022: okc_statuses_b sts
5023: WHERE kle.lse_id = lse.id
5024: AND lse.lty_code in ( 'FREE_FORM1', 'FEE', 'SOLD_SERVICE', 'LINK_SERV_ASSET')--bug# 3343133 (ssiruvol)

Line 5623: okc_line_styles_b lse

5619: IS
5620: SELECT kle.id kle_id,
5621: kle.start_date
5622: FROM okc_k_lines_b kle,
5623: okc_line_styles_b lse
5624: WHERE kle.lse_id = lse.id
5625: AND lse.lty_code in ( 'FREE_FORM1', 'FEE', 'SOLD_SERVICE', 'LINK_SERV_ASSET')--bug# 3343133 (ssiruvol)
5626: AND kle.dnz_chr_id = p_chr_id;
5627:

Line 6657: okc_line_styles_b lse_fin,

6653: FROM dual
6654: WHERE EXISTS (SELECT '1'
6655: FROM okl_subsidies_b subb,
6656: okc_k_lines_b cle_fin,
6657: okc_line_styles_b lse_fin,
6658: okc_k_lines_b cle,
6659: okl_k_headers khr,
6660: okl_k_lines kle,
6661: okc_line_styles_b lse

Line 6661: okc_line_styles_b lse

6657: okc_line_styles_b lse_fin,
6658: okc_k_lines_b cle,
6659: okl_k_headers khr,
6660: okl_k_lines kle,
6661: okc_line_styles_b lse
6662: WHERE cle.dnz_chr_id = p_dnz_chr_id
6663: AND cle.dnz_chr_id = khr.id
6664: AND khr.deal_type IN ('LEASEDF','LEASEOP','LEASEST','LOAN')
6665: AND cle.cle_id = cle_fin.id

Line 6853: , OKC_LINE_STYLES_B LSE

6849: SELECT CLE.ID LINE_ID
6850: , TRUNC(CLE.DATE_TERMINATED) TERMINATION_DATE
6851: FROM OKL_K_HEADERS KHR
6852: , OKC_K_LINES_B CLE
6853: , OKC_LINE_STYLES_B LSE
6854: , OKC_STATUSES_B STS
6855: WHERE CLE.DNZ_CHR_ID = KHR.ID
6856: AND LSE.ID = CLE.LSE_ID
6857: AND LSE.LTY_CODE ='FREE_FORM1'

Line 7020: , OKC_LINE_STYLES_B LSE

7016: CURSOR c_tmt_assets (cp_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
7017: SELECT CLE.ID LINE_ID
7018: FROM OKL_K_HEADERS KHR
7019: , OKC_K_LINES_B CLE
7020: , OKC_LINE_STYLES_B LSE
7021: , OKC_STATUSES_B STS
7022: WHERE CLE.DNZ_CHR_ID = KHR.ID
7023: AND LSE.ID = CLE.LSE_ID
7024: AND LSE.LTY_CODE ='FREE_FORM1'

Line 7204: okc_line_styles_b lse,

7200: okl_streams str,
7201: --okl_strm_type_v sty,
7202: OKL_STRM_TMPT_LINES_UV sty,
7203: okl_k_lines_full_v kle,
7204: okc_line_styles_b lse,
7205: okc_statuses_b sts
7206: Where ele.stm_id = str.id
7207: and str.khr_id = chrId
7208: and str.kle_id = kle.id

Line 7860: , OKC_LINE_STYLES_B LNK_LSE

7856: SELECT LNK_CLE.ID LNK_ID
7857: , FEE_CLE.ID FEE_ID
7858: , LNK_CLE.DATE_TERMINATED
7859: FROM OKC_K_LINES_B LNK_CLE
7860: , OKC_LINE_STYLES_B LNK_LSE
7861: , OKL_K_LINES FEE_KLE
7862: , OKC_K_LINES_B FEE_CLE
7863: , OKC_STATUSES_B STS
7864: WHERE LNK_CLE.CLE_ID = FEE_CLE.ID

Line 7883: , OKC_LINE_STYLES_B LSE

7879: SELECT CLE.ID LINE_ID
7880: , CLE.DATE_TERMINATED
7881: FROM OKL_K_HEADERS KHR
7882: , OKC_K_LINES_B CLE
7883: , OKC_LINE_STYLES_B LSE
7884: , OKC_STATUSES_B STS
7885: WHERE CLE.DNZ_CHR_ID = KHR.ID
7886: AND LSE.ID = CLE.LSE_ID
7887: AND LSE.LTY_CODE ='FREE_FORM1'

Line 8621: okc_line_styles_b lse,

8617: okl_stream_interfaces sif,
8618: okl_sif_lines line,
8619: okc_k_lines_b cle,
8620: okl_k_lines kle,
8621: okc_line_styles_b lse,
8622: okl_sif_fees fee
8623: WHERE lev.sir_id = ret.id
8624: AND lev.level_type = 'Payment'
8625: AND ret.transaction_number = sif.transaction_number

Line 8694: okc_line_styles_b lse,

8690: AND str.sgn_code NOT IN ('INTC','LATE_CALC') -- bug 6472228
8691: AND (NVL( str.kle_id, -1) = -1 OR
8692: str.kle_id IN (SELECT kle.id
8693: FROM okl_k_lines_full_v kle,
8694: okc_line_styles_b lse,
8695: okc_statuses_b sts
8696: WHERE KLE.LSE_ID = LSE.ID
8697: AND kle.dnz_chr_id = p_chr_id
8698: AND sts.code = kle.sts_code

Line 9615: okc_line_styles_b lse,

9611: CURSOR l_line_rec_csr(chrid NUMBER)
9612: IS
9613: SELECT cle.id
9614: FROM okc_k_lines_b cle,
9615: okc_line_styles_b lse,
9616: okc_statuses_b sts
9617: WHERE cle.dnz_chr_id = chrid
9618: AND cle.lse_id = lse.id
9619: AND lse.lty_code = 'FREE_FORM1'

Line 9629: okc_line_styles_b lse,

9625: CURSOR l_fee_type_csr ( chrId NUMBER, feeId NUMBER ) IS
9626: SELECT kle.fee_type
9627: FROM okl_k_lines kle,
9628: okc_k_lines_b cle,
9629: okc_line_styles_b lse,
9630: okc_statuses_b sts
9631: WHERE cle.lse_id = lse.id
9632: AND lse.lty_code = 'FEE'
9633: AND cle.dnz_chr_id = chrid

Line 9646: okc_line_styles_b lse,

9642: CURSOR l_fin_type_csr (chrId NUMBER)
9643: IS
9644: SELECT cle.id fin_id
9645: FROM okc_k_lines_b cle,
9646: okc_line_styles_b lse,
9647: okl_k_lines kle,
9648: okc_statuses_b sts
9649: WHERE cle.dnz_chr_id = chrId
9650: AND cle.lse_id = lse.id

Line 9662: okc_line_styles_b lse,

9658: CURSOR l_rollover_csr(chrId NUMBER)
9659: IS
9660: SELECT cle.id fin_id
9661: FROM okc_k_lines_b cle,
9662: okc_line_styles_b lse,
9663: okl_k_lines kle,
9664: okc_statuses_b sts
9665: WHERE cle.dnz_chr_id = chrId
9666: AND cle.lse_id = lse.id

Line 9678: okc_line_styles_b lse

9674: IS
9675: SELECT okc.id kle_id
9676: FROM okc_k_lines_b okc,
9677: okl_k_lines kle ,
9678: okc_line_styles_b lse
9679: WHERE okc.cle_id = cleId
9680: AND okc.lse_id = lse.id
9681: AND okc.id = kle.id
9682: AND lty_code = 'LINK_FEE_ASSET';

Line 9697: okc_line_styles_b lse,

9693: okl_strm_type_b sty,
9694: okl_subsidies_v sub,
9695: okl_k_lines kle,
9696: okc_statuses_b sts,
9697: okc_line_styles_b lse,
9698: okc_k_lines_b cle
9699: WHERE cle.dnz_chr_id = p_dnz_chr_id
9700: AND cle.lse_id = lse.id
9701: AND lse.lty_code = 'SUBSIDY'

Line 9721: okc_line_styles_b lse

9717: FROM okl_k_lines kle,
9718: okc_k_lines_b cle,
9719: okl_subsidies_v sub,
9720: okc_statuses_b sts,
9721: okc_line_styles_b lse
9722: WHERE cle.dnz_chr_id = p_dnz_chr_id
9723: AND cle.lse_id = lse.id
9724: AND lse.lty_code = 'SUBSIDY'
9725: AND sts.code = cle.sts_code

Line 10186: okc_line_styles_b lse,

10182: tl.item_description,
10183: tl.name ,
10184: kle.orig_contract_line_id --sechawla 15-jul-09 PRB ESG Enhancements : added orig_contract_line_id
10185: from okl_k_lines_full_v kle,
10186: okc_line_styles_b lse,
10187: okc_k_lines_tl tl,
10188: okc_statuses_b sts
10189: where KLE.LSE_ID = LSE.ID
10190: and lse.lty_code = lnetype

Line 10212: okc_line_styles_b ls

10208: stl.id styp_id
10209: FROM OKL_STRM_TMPT_LINES_UV stl,
10210: okc_k_items cim,
10211: okl_k_lines_full_v kle,
10212: okc_line_styles_b ls
10213: WHERE cim.cle_id = kle.id
10214: AND ls.id = kle.lse_id
10215: AND ls.lty_code = 'FEE'
10216: AND cim.object1_id1 = stl.primary_sty_id

Line 10445: okc_line_styles_b lse

10441: NVL(kle.date_funding,cle.start_date) date_funding ,
10442: kle.orig_contract_line_id --sechawla 15-jun-09 PRB ESG Enhancement : added orig_contract_line_id
10443: FROM okc_k_lines_b cle,
10444: okl_k_lines kle,
10445: okc_line_styles_b lse
10446: WHERE cle.dnz_chr_id = p_chr_id
10447: AND cle.sts_code NOT IN ('HOLD', 'EXPIRED', 'CANCELLED','ABANDONED')
10448: AND cle.id = kle.id
10449: AND cle.lse_id = lse.id

Line 10460: okc_line_styles_b lse_fin,

10456: SELECT subb.accounting_method_code,
10457: cle.id
10458: FROM okl_subsidies_b subb,
10459: okc_k_lines_b cle_fin,
10460: okc_line_styles_b lse_fin,
10461: okc_k_lines_b cle,
10462: okl_k_lines kle,
10463: okc_line_styles_b lse
10464: WHERE cle.cle_id = p_line_id

Line 10463: okc_line_styles_b lse

10459: okc_k_lines_b cle_fin,
10460: okc_line_styles_b lse_fin,
10461: okc_k_lines_b cle,
10462: okl_k_lines kle,
10463: okc_line_styles_b lse
10464: WHERE cle.cle_id = p_line_id
10465: AND cle.id = kle.id
10466: AND cle.lse_id = lse.id
10467: AND lse.lty_code = 'SUBSIDY'

Line 10481: okc_line_styles_b lse_fin,

10477: FROM dual
10478: WHERE EXISTS (SELECT '1'
10479: FROM okl_subsidies_b subb,
10480: okc_k_lines_b cle_fin,
10481: okc_line_styles_b lse_fin,
10482: okc_k_lines_b cle,
10483: okl_k_lines kle,
10484: okc_line_styles_b lse
10485: WHERE cle.dnz_chr_id = p_dnz_chr_id

Line 10484: okc_line_styles_b lse

10480: okc_k_lines_b cle_fin,
10481: okc_line_styles_b lse_fin,
10482: okc_k_lines_b cle,
10483: okl_k_lines kle,
10484: okc_line_styles_b lse
10485: WHERE cle.dnz_chr_id = p_dnz_chr_id
10486: AND cle.cle_id = cle_fin.id
10487: AND cle.dnz_chr_id = cle_fin.dnz_chr_id
10488: AND cle.id = kle.id

Line 10504: okc_line_styles_b lse,

10500:
10501: SELECT kle.sty_id
10502: FROM okl_k_lines kle,
10503: okc_k_lines_b cle,
10504: okc_line_styles_b lse,
10505: okl_subsidies_v sub
10506:
10507: WHERE cle.dnz_chr_id = p_dnz_chr_id
10508: AND cle.id = p_sub_cle_id

Line 10520: okc_line_styles_b lse,

10516: okl_strm_type_b sty_inc,
10517: okl_strm_type_b sty,
10518: okl_subsidies_v sub,
10519: okl_k_lines kle,
10520: okc_line_styles_b lse,
10521: okc_k_lines_b cle
10522: WHERE cle.dnz_chr_id = p_dnz_chr_id
10523: AND cle.id = p_sub_cle_id
10524: AND cle.lse_id = lse.id

Line 11041: okc_line_styles_b lse,

11037: kle.capital_reduction,
11038: kle.capitalize_down_payment_yn,
11039: kle.orig_contract_line_id --sechawla 15-jul-09 ESG PRB Enhancements : added orig_contract_line_id
11040: FROM okl_k_lines_full_v kle,
11041: okc_line_styles_b lse,
11042: okc_k_lines_tl tl,
11043: okc_statuses_b sts
11044: WHERE kle.lse_id = lse.id
11045: AND lse.lty_code = 'LINK_FEE_ASSET'

Line 11096: okc_line_styles_b lse

11092: , kle.orig_contract_line_id ,--sechawla 15-jul-09 PRB ESG enhancements : added orig_contract_line_id
11093: okc.start_date --11-Sep-09 sechawla 8798556 : added
11094: FROM okc_k_lines_b okc,
11095: okl_k_lines kle ,
11096: okc_line_styles_b lse
11097: ,okc_statuses_b sts
11098: WHERE okc.cle_id = cleId
11099: AND okc.lse_id = lse.id
11100: AND okc.id = kle.id

Line 20155: okc_line_styles_b lse,

20151: SELECT 1
20152: FROM dual
20153: WHERE EXISTS (SELECT 1
20154: FROM okc_k_lines_b cle,
20155: okc_line_styles_b lse,
20156: okl_k_lines kle
20157: WHERE cle.dnz_chr_id = chrId
20158: AND cle.lse_id = lse.id
20159: AND lse.lty_code = 'FEE'

Line 20220: okc_line_styles_b lse_ib,

20216: FROM hz_locations hl,
20217: hz_party_sites hps,
20218: hz_party_site_uses hpsu,
20219: okl_txl_itm_insts iti,
20220: okc_line_styles_b lse_ib,
20221: okc_k_lines_b cle_ib
20222: WHERE cle_ib.dnz_chr_id = chrId
20223: AND cle_ib.lse_id = lse_ib.id
20224: AND lse_ib.lty_code = 'INST_ITEM'

Line 20276: okc_line_styles_b lse,

20272: kle.capitalize_down_payment_yn,
20273: kle.orig_contract_line_id, --sechawla 10-jul-09 PRB ESG enhancements : added
20274: kle.capital_reduction_percent
20275: FROM okl_k_lines_full_v kle,
20276: okc_line_styles_b lse,
20277: okc_k_lines_tl tl,
20278: okc_statuses_b sts
20279: WHERE kle.lse_id = lse.id
20280: AND lse.lty_code = lnetype

Line 20292: okc_line_styles_b lse_fin,

20288: IS
20289: SELECT kle_sub.amount, kle_sub.SUBSIDY_OVERRIDE_AMOUNT
20290: FROM okl_subsidies_b subb,
20291: okc_k_lines_b cle_fin,
20292: okc_line_styles_b lse_fin,
20293: okc_k_lines_b cle_sub,
20294: okl_k_lines kle_sub,
20295: okc_line_styles_b lse_sub
20296: WHERE cle_fin.id = p_cle_id

Line 20295: okc_line_styles_b lse_sub

20291: okc_k_lines_b cle_fin,
20292: okc_line_styles_b lse_fin,
20293: okc_k_lines_b cle_sub,
20294: okl_k_lines kle_sub,
20295: okc_line_styles_b lse_sub
20296: WHERE cle_fin.id = p_cle_id
20297: AND cle_fin.dnz_chr_id = p_chr_id
20298: AND cle_sub.id = kle_sub.id
20299: AND cle_sub.lse_id = lse_sub.id

Line 23646: okc_line_styles_b lse

23642: IS
23643: SELECT cle.id
23644: FROM okc_k_lines_b cle,
23645: okl_k_lines kle,
23646: okc_line_styles_b lse
23647: WHERE cle.dnz_chr_id = p_khr_id
23648: AND cle.lse_id = lse.id
23649: AND cle.sts_code NOT IN ('HOLD', 'EXPIRED', 'CANCELLED')
23650: AND lse.lty_code = 'FEE'

Line 23674: okc_line_styles_b lse

23670: CURSOR c_get_all_lines_csr(p_khr_id okl_k_headers.id%TYPE)
23671: IS
23672: SELECT cle.id line_id
23673: FROM okc_k_lines_b cle,
23674: okc_line_styles_b lse
23675: WHERE cle.dnz_chr_id = p_khr_id
23676: AND cle.lse_id = lse.id
23677: AND cle.sts_code NOT IN ('HOLD', 'EXPIRED', 'CANCELLED')
23678: AND lse.lty_code IN ('FREE_FORM1','FEE','SOLD_SERVICE');

Line 24248: okc_line_styles_b lse_rv,

24244: SELECT kle_rv.id asset_line_id,
24245: kle_rv.oec oec,
24246: cle_so.START_DATE
24247: FROM okc_k_headers_b chr_rv,
24248: okc_line_styles_b lse_rv,
24249: okl_k_lines kle_rv,
24250: okc_k_lines_b cle_rv,
24251: okc_rules_b rul_rv,
24252: okc_rule_groups_b rgp_rv,

Line 24253: okc_line_styles_b lse_so,

24249: okl_k_lines kle_rv,
24250: okc_k_lines_b cle_rv,
24251: okc_rules_b rul_rv,
24252: okc_rule_groups_b rgp_rv,
24253: okc_line_styles_b lse_so,
24254: okc_k_lines_b cle_so,
24255: okc_rules_b rul_so,
24256: okc_rule_groups_b rgp_so
24257: WHERE rgp_so.cle_id = p_kle_id

Line 24371: okc_line_styles_b lse_rv,

24367: kle_rv.oec oec,
24368: kle_rv.residual_percentage residual_percent,
24369: cle_so.start_date
24370: FROM okc_k_headers_b chr_rv,
24371: okc_line_styles_b lse_rv,
24372: okl_k_lines kle_rv,
24373: okc_k_lines_b cle_rv,
24374: okc_rules_b rul_rv,
24375: okc_rule_groups_b rgp_rv,

Line 24376: okc_line_styles_b lse_so,

24372: okl_k_lines kle_rv,
24373: okc_k_lines_b cle_rv,
24374: okc_rules_b rul_rv,
24375: okc_rule_groups_b rgp_rv,
24376: okc_line_styles_b lse_so,
24377: okc_k_lines_b cle_so,
24378: okc_rules_b rul_so,
24379: okc_rule_groups_b rgp_so
24380: WHERE rgp_so.cle_id = p_kle_id

Line 24763: okc_line_styles_b lse_ib,

24759: FROM hz_locations hl,
24760: hz_party_sites hps,
24761: hz_party_site_uses hpsu,
24762: okl_txl_itm_insts iti,
24763: okc_line_styles_b lse_ib,
24764: okc_k_lines_b cle_ib
24765: WHERE cle_ib.dnz_chr_id = chrId
24766: AND cle_ib.lse_id = lse_ib.id
24767: AND lse_ib.lty_code = 'INST_ITEM'

Line 24796: okc_line_styles_b lse,

24792: kle.initial_direct_cost,
24793: tl.item_description,
24794: tl.name
24795: FROM okl_k_lines_full_v kle,
24796: okc_line_styles_b lse,
24797: okc_k_lines_tl tl,
24798: okc_statuses_b sts
24799: WHERE kle.lse_id = lse.id
24800: AND lse.lty_code = lnetype

Line 24831: okc_line_styles_b lse,

24827: kle.initial_direct_cost,
24828: tl.item_description,
24829: tl.name
24830: FROM okl_k_lines_full_v kle,
24831: okc_line_styles_b lse,
24832: okc_k_lines_tl tl,
24833: okc_statuses_b sts
24834: WHERE kle.lse_id = lse.id
24835: AND lse.lty_code = 'SO_PAYMENT'

Line 24982: okc_line_styles_b lse,

24978: SELECT 1
24979: FROM dual
24980: WHERE EXISTS (SELECT 1
24981: FROM okc_k_lines_b cle,
24982: okc_line_styles_b lse,
24983: okl_k_lines kle
24984: WHERE cle.dnz_chr_id = chrId
24985: AND cle.lse_id = lse.id
24986: AND lse.lty_code = 'FEE'