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_SEEDED_FUNCTIONS_PVT dependencies on OKC_K_LINES_B

Line 1087: FROM okc_k_lines_b cle,

1083: l_capred_incl_terminated BOOLEAN := FALSE;
1084: -- Cursor to get the lty_code
1085: CURSOR get_lty_code(p_cle_id IN OKC_K_LINES_V.ID%TYPE) IS
1086: SELECT lse.lty_code
1087: FROM okc_k_lines_b cle,
1088: okc_line_styles_b lse
1089: WHERE cle.id = p_cle_id
1090: AND cle.lse_id = lse.id;
1091: -- Cursor to sum up oec for contract

Line 1139: okc_k_lines_b cle

1135: okc_line_styles_b lse3,
1136: okc_line_styles_b lse2,
1137: okc_line_styles_b lse1,
1138: okc_k_items_v cim,
1139: okc_k_lines_b cle
1140: WHERE cle.dnz_chr_id = p_dnz_chr_id
1141: AND cle.dnz_chr_id = cim.dnz_chr_id
1142: AND cle.id = cim.cle_id
1143: AND cle.lse_id = lse1.id

Line 1156: okc_k_lines_b clex

1152: AND exists (SELECT 1 --cle.id
1153: FROM okc_subclass_top_line stlx,
1154: okc_line_styles_b lse2x,
1155: okc_line_styles_b lse1x,
1156: okc_k_lines_b clex
1157: WHERE clex.cle_id = p_top_cle_id
1158: AND clex.dnz_chr_id = p_dnz_chr_id
1159:
1160: AND clex.lse_id = lse1x.id

Line 1181: OKC_K_LINES_B cleb

1177: --cursor to get expected asset value for contract
1178: cursor l_chr_expcost_trmn_csr(p_chr_id in number) is
1179: SELECT SUM(kle.expected_asset_cost) expected_asset_cost
1180: FROM OKL_K_LINES kle,
1181: OKC_K_LINES_B cleb
1182: WHERE kle.id = cleb.id
1183: AND cleb.dnz_chr_id = p_chr_id
1184: AND cleb.lse_id = 33
1185: AND cleb.sts_code NOT IN ( 'ABANDONED', 'EXPIRED', 'CANCELLED', 'HOLD');

Line 1190: OKC_K_LINES_B cleb

1186:
1187: cursor l_chr_expcost_csr(p_chr_id in number) is
1188: SELECT SUM(kle.expected_asset_cost) expected_asset_cost
1189: FROM OKL_K_LINES kle,
1190: OKC_K_LINES_B cleb
1191: WHERE kle.id = cleb.id
1192: AND cleb.dnz_chr_id = p_chr_id
1193: AND cleb.lse_id = 33
1194: AND cleb.sts_code NOT IN ( 'ABANDONED', 'TERMINATED', 'EXPIRED', 'CANCELLED', 'HOLD');

Line 2290: OKC_K_LINES_B CLEB_COV,

2286: SELECT NVL(SUM(kle_cov.capital_amount),0) CapAmountLines
2287: FROM OKC_LINE_STYLES_B LSEB,
2288: OKC_K_ITEMS CIM,
2289: OKL_K_LINES KLE_COV,
2290: OKC_K_LINES_B CLEB_COV,
2291: OKC_STATUSES_B STSB
2292: WHERE LSEB.ID = CLEB_COV.LSE_ID
2293: AND LSEB.lty_code = 'LINK_FEE_ASSET'
2294: AND CIM.jtot_object1_code = 'OKX_COVASST'

Line 2307: OKC_K_LINES_B CLEB_COV,

2303: SELECT NVL(SUM(kle_cov.capital_amount),0) CapAmountLines
2304: FROM OKC_LINE_STYLES_B LSEB,
2305: OKC_K_ITEMS CIM,
2306: OKL_K_LINES KLE_COV,
2307: OKC_K_LINES_B CLEB_COV,
2308: OKC_STATUSES_B STSB
2309: WHERE LSEB.ID = CLEB_COV.LSE_ID
2310: AND LSEB.lty_code = 'LINK_FEE_ASSET'
2311: AND CIM.jtot_object1_code = 'OKX_COVASST'

Line 3338: FROM okc_k_lines_b cleb,

3334:
3335: CURSOR adv_arr_csr IS
3336: SELECT
3337: rulb2.RULE_INFORMATION10 arrears_yn
3338: FROM okc_k_lines_b cleb,
3339: okc_rule_groups_b rgpb,
3340: okc_rules_b rulb,
3341: okc_rules_b rulb2,
3342: okl_strm_type_b styb

Line 4174: okc_k_lines_b cle,

4170: SELECT SUM(ste.amount)
4171: FROM OKL_STREAMS stm,
4172: OKL_STRM_ELEMENTS ste,
4173: OKL_STRM_TYPE_B sty,
4174: okc_k_lines_b cle,
4175: okl_k_lines kle
4176: WHERE stm.khr_id = p_ctr_id
4177: AND stm.sty_id = sty.id
4178: AND sty.id = p_lease_inc_sty_id

Line 4187: okc_k_lines_b cle,

4183: (SELECT TRUNC(MIN(ste.stream_element_date),'MM')
4184: FROM OKL_STREAMS stm,
4185: OKL_STRM_ELEMENTS ste,
4186: OKL_STRM_TYPE_B sty,
4187: okc_k_lines_b cle,
4188: okl_k_lines kle
4189: WHERE stm.khr_id = p_ctr_id
4190: AND stm.sty_id = sty.id
4191: AND sty.id = l_rent_sty_id

Line 4206: okc_k_lines_b cle,

4202: (SELECT LAST_DAY(MAX(ste.stream_element_date))
4203: FROM OKL_STREAMS stm,
4204: OKL_STRM_ELEMENTS ste,
4205: OKL_STRM_TYPE_B sty,
4206: okc_k_lines_b cle,
4207: okl_k_lines kle
4208: WHERE stm.khr_id = p_ctr_id
4209: AND stm.sty_id = sty.id
4210: AND sty.id = l_rent_sty_id

Line 4795: FROM OKC_K_LINES_B KLE_FA,

4791: -- from _uv
4792: /*
4793: CURSOR l_item_loc_csr (cp_fin_asset_cle_id NUMBER) IS
4794: SELECT DISTINCT LOA.loc_id location_id, LOC.postal_code -- 3682465
4795: FROM OKC_K_LINES_B KLE_FA,
4796: OKC_LINE_STYLES_B LSE_FA,
4797: OKC_K_LINES_B KLE_IL,
4798: OKC_LINE_STYLES_B LSE_IL,
4799: OKC_K_LINES_B KLE_IB,

Line 4797: OKC_K_LINES_B KLE_IL,

4793: CURSOR l_item_loc_csr (cp_fin_asset_cle_id NUMBER) IS
4794: SELECT DISTINCT LOA.loc_id location_id, LOC.postal_code -- 3682465
4795: FROM OKC_K_LINES_B KLE_FA,
4796: OKC_LINE_STYLES_B LSE_FA,
4797: OKC_K_LINES_B KLE_IL,
4798: OKC_LINE_STYLES_B LSE_IL,
4799: OKC_K_LINES_B KLE_IB,
4800: OKC_LINE_STYLES_B LSE_IB,
4801: OKC_K_ITEMS ITE,

Line 4799: OKC_K_LINES_B KLE_IB,

4795: FROM OKC_K_LINES_B KLE_FA,
4796: OKC_LINE_STYLES_B LSE_FA,
4797: OKC_K_LINES_B KLE_IL,
4798: OKC_LINE_STYLES_B LSE_IL,
4799: OKC_K_LINES_B KLE_IB,
4800: OKC_LINE_STYLES_B LSE_IB,
4801: OKC_K_ITEMS ITE,
4802: CSI_ITEM_INSTANCES CII,
4803: HZ_PARTY_SITES PSI,

Line 4829: FROM OKC_K_LINES_B KLE_FA,

4825: AND psu.site_use_type = 'INSTALL_AT'
4826: AND loc.location_id = loa.location_id
4827: UNION
4828: SELECT DISTINCT LOA.loc_id location_id, LOC.postal_code -- 3682465
4829: FROM OKC_K_LINES_B KLE_FA,
4830: OKC_LINE_STYLES_B LSE_FA,
4831: OKC_K_LINES_B KLE_IL,
4832: OKC_LINE_STYLES_B LSE_IL,
4833: OKC_K_LINES_B KLE_IB,

Line 4831: OKC_K_LINES_B KLE_IL,

4827: UNION
4828: SELECT DISTINCT LOA.loc_id location_id, LOC.postal_code -- 3682465
4829: FROM OKC_K_LINES_B KLE_FA,
4830: OKC_LINE_STYLES_B LSE_FA,
4831: OKC_K_LINES_B KLE_IL,
4832: OKC_LINE_STYLES_B LSE_IL,
4833: OKC_K_LINES_B KLE_IB,
4834: OKC_LINE_STYLES_B LSE_IB,
4835: OKC_K_ITEMS ITE,

Line 4833: OKC_K_LINES_B KLE_IB,

4829: FROM OKC_K_LINES_B KLE_FA,
4830: OKC_LINE_STYLES_B LSE_FA,
4831: OKC_K_LINES_B KLE_IL,
4832: OKC_LINE_STYLES_B LSE_IL,
4833: OKC_K_LINES_B KLE_IB,
4834: OKC_LINE_STYLES_B LSE_IB,
4835: OKC_K_ITEMS ITE,
4836: CSI_ITEM_INSTANCES CII,
4837: --HZ_PARTY_SITES PSI,

Line 6377: FROM okc_k_lines_b line

6373: --Cursor to get the parent line id for a contract
6374: CURSOR parent_line_id_csr (p_contract_id NUMBER)
6375: IS
6376: SELECT line.id parent_line_id
6377: FROM okc_k_lines_b line
6378: ,okc_line_styles_v lse
6379: WHERE line.lse_id=lse.id
6380: AND lse.lty_code= 'FREE_FORM1'
6381: AND line.sts_code <> 'ABANDONED'

Line 6629: OKC_K_LINES_B CLE,

6625: */
6626: okl_bpd_tld_ar_lines_v LSM,
6627: -- OKC_K_HEADERS_B CHR, commenting unused table, ankushar Bug# 5499193
6628: /* 16-Aug-2007 ankushar end changes */
6629: OKC_K_LINES_B CLE,
6630: OKC_LINE_STYLES_B LSE
6631: WHERE
6632: LSM.KLE_ID = p_contract_line_id
6633: AND LSM.CUSTOMER_TRX_ID = APS.CUSTOMER_TRX_ID

Line 6689: OKC_K_LINES_B CLE,

6685: */
6686: okl_bpd_tld_ar_lines_v LSM,
6687: -- OKC_K_HEADERS_B CHR, commenting unused table, ankushar Bug# 5499193
6688: /* 16-Aug-2007 ankushar end changes */
6689: OKC_K_LINES_B CLE,
6690: OKC_LINE_STYLES_B LSE
6691: WHERE
6692: LSM.KLE_ID = p_contract_line_id
6693: AND LSM.CUSTOMER_TRX_ID = APS.CUSTOMER_TRX_ID

Line 6898: okc_k_lines_b sub_cle,

6894: CURSOR l_sub_csr(c_contract_id IN NUMBER,c_accounting_method IN VARCHAR2) IS
6895: SELECT NVL(SUM(NVL(sub_kle.subsidy_override_amount, sub_kle.amount)),0)
6896: FROM okl_subsidies_b subb,
6897: okl_k_lines sub_kle,
6898: okc_k_lines_b sub_cle,
6899: okc_line_styles_b sub_lse
6900: WHERE subb.id = sub_kle.subsidy_id
6901: AND subb.accounting_method_code = NVL(UPPER(c_accounting_method),subb.accounting_method_code)
6902: AND sub_kle.id = sub_cle.id

Line 7007: FROM okc_k_lines_b line

7003: --Cursor to get the parent line id for a contract
7004: CURSOR parent_line_id_csr (p_contract_id NUMBER)
7005: IS
7006: SELECT line.id parent_line_id
7007: FROM okc_k_lines_b line
7008: ,okc_line_styles_v lse
7009: WHERE line.lse_id=lse.id
7010: AND lse.lty_code= 'FREE_FORM1'
7011: AND line.sts_code <> 'ABANDONED'

Line 8282: okc_k_lines_b clet,

8278: CURSOR l_okl_percent_stake_csr(p_sty_subclass IN VARCHAR2)
8279: IS
8280: SELECT DISTINCT kleb.percent_stake,clet.id
8281: FROM okl_k_lines kleb,
8282: okc_k_lines_b clet,
8283: okc_k_lines_b cles
8284: WHERE kleb.id = cles.id
8285: AND cles.cle_id = clet.id
8286: AND clet.dnz_chr_id = p_chr_id

Line 8283: okc_k_lines_b cles

8279: IS
8280: SELECT DISTINCT kleb.percent_stake,clet.id
8281: FROM okl_k_lines kleb,
8282: okc_k_lines_b clet,
8283: okc_k_lines_b cles
8284: WHERE kleb.id = cles.id
8285: AND cles.cle_id = clet.id
8286: AND clet.dnz_chr_id = p_chr_id
8287: --AND kleb.sty_id = styb.id

Line 8615: OKC_K_LINES_B CLEB,

8611: SELECT
8612: NVL(SUM(NVL(KLEB.AMOUNT,0)),0)
8613: FROM
8614: OKL_K_LINES KLEB,
8615: OKC_K_LINES_B CLEB,
8616: OKC_LINE_STYLES_B LSEB
8617: WHERE
8618: CLEB.ID = KLEB.ID AND
8619: CLEB.LSE_ID = LSEB.ID AND

Line 8630: OKC_K_LINES_B CLEB,

8626: SELECT
8627: NVL(SUM(NVL(KLEB.AMOUNT_STAKE,0)),0)
8628: FROM
8629: OKL_K_LINES KLEB,
8630: OKC_K_LINES_B CLEB,
8631: OKC_LINE_STYLES_B LSEB
8632: WHERE
8633: CLEB.ID = KLEB.ID AND
8634: CLEB.LSE_ID = LSEB.ID AND

Line 8719: okc_k_lines_b clet,

8715: CURSOR l_okl_percent_stake_csr(p_sty_subclass IN VARCHAR2)
8716: IS
8717: SELECT DISTINCT kleb.percent_stake,clet.id
8718: FROM okl_k_lines kleb,
8719: okc_k_lines_b clet,
8720: okc_k_lines_b cles
8721: WHERE kleb.id = cles.id
8722: AND cles.cle_id = clet.id
8723: AND clet.dnz_chr_id = p_contract_id

Line 8720: okc_k_lines_b cles

8716: IS
8717: SELECT DISTINCT kleb.percent_stake,clet.id
8718: FROM okl_k_lines kleb,
8719: okc_k_lines_b clet,
8720: okc_k_lines_b cles
8721: WHERE kleb.id = cles.id
8722: AND cles.cle_id = clet.id
8723: AND clet.dnz_chr_id = p_contract_id
8724: AND kleb.stream_type_subclass = p_sty_subclass;

Line 8914: OKC_K_LINES_B CLEB,

8910: SELECT
8911: NVL(SUM(NVL(KLEB.initial_direct_cost,0)),0)
8912: FROM
8913: OKL_K_LINES KLEB,
8914: OKC_K_LINES_B CLEB,
8915: OKC_LINE_STYLES_B LSEB
8916: WHERE
8917: KLEB.ID = CLEB.ID AND
8918: CLEB.LSE_ID = LSEB.ID AND

Line 9122: okc_k_lines_b cleb

9118: --cursor to get line_sts
9119: CURSOR l_line_sts_csr (p_cle_id IN NUMBER) IS
9120: SELECT stsb.ste_code
9121: FROM okc_statuses_b stsb,
9122: okc_k_lines_b cleb
9123: WHERE stsb.code = cleb.sts_code
9124: AND cleb.id = p_cle_id;
9125:
9126: l_line_sts_rec l_line_sts_csr%ROWTYPE;

Line 9131: FROM okc_k_lines_b cleb,

9127:
9128: --cursor to get financial asset lines on a contract (without terminated lines)
9129: CURSOR l_cleb_csr (p_chr_id IN NUMBER) IS
9130: SELECT cleb.id
9131: FROM okc_k_lines_b cleb,
9132: okc_statuses_b stsb,
9133: okc_line_styles_b lseb
9134: WHERE cleb.chr_id = p_chr_id
9135: AND cleb.lse_id = lseb.id

Line 9143: FROM okc_k_lines_b cleb,

9139:
9140: --cursor to get financial asset lines on a contract (with terminated lines)
9141: CURSOR l_cleb_termn_csr (p_chr_id IN NUMBER) IS
9142: SELECT cleb.id
9143: FROM okc_k_lines_b cleb,
9144: okc_statuses_b stsb,
9145: okc_line_styles_b lseb
9146: WHERE cleb.chr_id = p_chr_id
9147: AND cleb.lse_id = lseb.id

Line 9156: FROM okc_k_lines_b cleb,

9152: --Bug# 15992711 , Start
9153: -- Considers either new or re-leased assets of a Contract based on p_line_type parameter
9154: CURSOR l_cleb_nr_csr (p_chr_id IN NUMBER, p_line_type VARCHAR2) IS
9155: SELECT cleb.id
9156: FROM okc_k_lines_b cleb,
9157: okc_statuses_b stsb,
9158: okc_line_styles_b lseb,
9159: okl_k_lines kle
9160: WHERE cleb.chr_id = p_chr_id

Line 9171: FROM okc_k_lines_b cleb,

9167:
9168: -- Considers either new or re-leased assets of a Contract based on p_line_type parameter
9169: CURSOR l_cleb_nr_termn_csr (p_chr_id IN NUMBER, p_line_type VARCHAR2) IS
9170: SELECT cleb.id
9171: FROM okc_k_lines_b cleb,
9172: okc_statuses_b stsb,
9173: okc_line_styles_b lseb,
9174: okl_k_lines kle
9175: WHERE cleb.chr_id = p_chr_id

Line 9187: okc_k_lines_b cleb,

9183: -- Considers either new or re-leased assets of a Contract based on p_line_type parameter
9184: CURSOR l_line_nr_sts_csr (p_cle_id IN NUMBER, p_line_type VARCHAR2) IS
9185: SELECT stsb.ste_code
9186: FROM okc_statuses_b stsb,
9187: okc_k_lines_b cleb,
9188: okl_k_lines kle
9189: WHERE stsb.code = cleb.sts_code
9190: AND cleb.id = p_cle_id
9191: AND cleb.id = kle.id

Line 9198: l_cle_id okc_k_lines_b.ID%TYPE;

9194:
9195: l_line_type VARCHAR2(30) := 'X';
9196: --Bug# 15992711 , End
9197:
9198: l_cle_id okc_k_lines_b.ID%TYPE;
9199:
9200:
9201: BEGIN
9202:

Line 10567: okc_k_lines_b kle,

10563: cp_date DATE ) IS -- rmunjulu EDAT
10564: SELECT SUM(ste.amount) amount
10565: FROM okl_streams stm,
10566: okl_strm_type_b sty,
10567: okc_k_lines_b kle,
10568: okc_statuses_b kls,
10569: okc_line_styles_b lse,
10570: okl_strm_elements ste,
10571: okl_k_lines cle

Line 10599: ,okc_k_lines_b kle

10595: cp_date DATE ) IS -- rmunjulu EDAT
10596: SELECT SUM(ste.amount) amount
10597: FROM okl_streams stm
10598: ,okl_strm_type_b sty
10599: ,okc_k_lines_b kle
10600: ,okc_statuses_b kls
10601: ,okc_line_styles_b lse
10602: ,okl_strm_elements ste
10603: ,okl_k_lines cle

Line 10604: ,okc_k_lines_b cles

10600: ,okc_statuses_b kls
10601: ,okc_line_styles_b lse
10602: ,okl_strm_elements ste
10603: ,okl_k_lines cle
10604: ,okc_k_lines_b cles
10605: WHERE stm.khr_id = cp_chr_id
10606: AND stm.active_yn = 'Y'
10607: AND stm.say_code = 'CURR'
10608: AND ste.stm_id = stm.id

Line 10633: ,okc_k_lines_b kle

10629: cp_date DATE ) IS -- rmunjulu EDAT
10630: SELECT SUM(ste.amount) amount
10631: FROM okl_streams stm
10632: ,okl_strm_type_b sty
10633: ,okc_k_lines_b kle
10634: ,okc_statuses_b kls
10635: ,okc_line_styles_b lse
10636: ,okl_strm_elements ste
10637: ,okl_k_lines cle

Line 10638: ,okc_k_lines_b cles

10634: ,okc_statuses_b kls
10635: ,okc_line_styles_b lse
10636: ,okl_strm_elements ste
10637: ,okl_k_lines cle
10638: ,okc_k_lines_b cles
10639: ,okc_k_items cim
10640: WHERE stm.khr_id = cp_chr_id
10641: AND stm.active_yn = 'Y'
10642: AND stm.say_code = 'CURR'

Line 10823: CURSOR c_subsidy_amount(p_cle_id okc_k_lines_b.id%TYPE) IS

10819:
10820: l_amount NUMBER;
10821:
10822: /* case not available
10823: CURSOR c_subsidy_amount(p_cle_id okc_k_lines_b.id%TYPE) IS
10824: select (case
10825: when ROUND(MONTHS_BETWEEN(chr.end_date, cle.start_date)) <= 12 then NVL(kle.oec,0) * .2
10826: else NVL(kle.oec,0) * .1
10827: end) subsidy_amount

Line 10828: from okc_k_lines_b cle,

10824: select (case
10825: when ROUND(MONTHS_BETWEEN(chr.end_date, cle.start_date)) <= 12 then NVL(kle.oec,0) * .2
10826: else NVL(kle.oec,0) * .1
10827: end) subsidy_amount
10828: from okc_k_lines_b cle,
10829: okl_k_lines kle,
10830: okc_k_headers_b chr
10831: where chr.id = cle.dnz_chr_id
10832: and kle.id = cle.id

Line 10836: CURSOR c_subsidy_amount(p_cle_id okc_k_lines_b.id%TYPE) IS

10832: and kle.id = cle.id
10833: and cle.id = p_cle_id -- FREE_FORM1 (FIN)
10834: ;
10835: */
10836: CURSOR c_subsidy_amount(p_cle_id okc_k_lines_b.id%TYPE) IS
10837: SELECT ROUND(MONTHS_BETWEEN(CHR.end_date, cle.start_date)) months,
10838: NVL(kle.oec,0) oec
10839: FROM okc_k_lines_b cle,
10840: okl_k_lines kle,

Line 10839: FROM okc_k_lines_b cle,

10835: */
10836: CURSOR c_subsidy_amount(p_cle_id okc_k_lines_b.id%TYPE) IS
10837: SELECT ROUND(MONTHS_BETWEEN(CHR.end_date, cle.start_date)) months,
10838: NVL(kle.oec,0) oec
10839: FROM okc_k_lines_b cle,
10840: okl_k_lines kle,
10841: okc_k_headers_b CHR
10842: WHERE CHR.id = cle.dnz_chr_id
10843: AND kle.id = cle.id

Line 10899: CURSOR c_subsidy_lines(p_cle_id okc_k_lines_b.id%TYPE) IS

10895: l_amount NUMBER := 0;
10896: l_tot_amount NUMBER := 0;
10897: l_return_status VARCHAR2(1);
10898:
10899: CURSOR c_subsidy_lines(p_cle_id okc_k_lines_b.id%TYPE) IS
10900: SELECT sub.accounting_method_code,
10901: top_cle.date_terminated,
10902: --TO_NUMBER(sgn.value) sty_id
10903: sub_kle.sty_id sty_id, /* Bug 6353756 */

Line 10908: okc_k_lines_b sub_cle,

10904: top_cle.dnz_chr_id chr_id
10905: FROM --okl_sgn_translations sgn,
10906: okl_subsidies_b sub,
10907: okl_k_lines sub_kle,
10908: okc_k_lines_b sub_cle,
10909: okc_k_lines_b top_cle
10910: WHERE --sgn.jtot_object1_code = 'OKL_STRMTYP'
10911: --AND sgn.object1_id1 = TO_CHAR(sub_kle.sty_id) AND
10912: sub.id = sub_kle.subsidy_id

Line 10909: okc_k_lines_b top_cle

10905: FROM --okl_sgn_translations sgn,
10906: okl_subsidies_b sub,
10907: okl_k_lines sub_kle,
10908: okc_k_lines_b sub_cle,
10909: okc_k_lines_b top_cle
10910: WHERE --sgn.jtot_object1_code = 'OKL_STRMTYP'
10911: --AND sgn.object1_id1 = TO_CHAR(sub_kle.sty_id) AND
10912: sub.id = sub_kle.subsidy_id
10913: AND sub_cle.cle_id = top_cle.id

Line 10918: CURSOR c_refund_subsidy(p_cle_id okc_k_lines_b.id%TYPE,

10914: AND sub_kle.id = sub_cle.id
10915: AND sub_cle.cle_id = p_cle_id -- FREE_FORM1
10916: ;
10917:
10918: CURSOR c_refund_subsidy(p_cle_id okc_k_lines_b.id%TYPE,
10919: p_date_terminated okc_k_lines_b.date_terminated%TYPE,
10920: p_sty_id okl_strm_type_b.id%TYPE) IS
10921: SELECT NVL(SUM(selb.amount),0)
10922: FROM

Line 10919: p_date_terminated okc_k_lines_b.date_terminated%TYPE,

10915: AND sub_cle.cle_id = p_cle_id -- FREE_FORM1
10916: ;
10917:
10918: CURSOR c_refund_subsidy(p_cle_id okc_k_lines_b.id%TYPE,
10919: p_date_terminated okc_k_lines_b.date_terminated%TYPE,
10920: p_sty_id okl_strm_type_b.id%TYPE) IS
10921: SELECT NVL(SUM(selb.amount),0)
10922: FROM
10923: okl_streams stmb,

Line 11079: okc_k_lines_b cle,

11075: okl_streams_rep_v str,
11076: okl_strm_type_v sty,
11077: okc_k_headers_b CHR,
11078: okc_statuses_b sts,
11079: okc_k_lines_b cle,
11080: okl_k_lines kle
11081: WHERE sele.stm_id = str.id
11082: AND str.sty_id = sty.id
11083: --AND UPPER(sty.name) = 'PRE-TAX INCOME'

Line 11217: OKC_K_LINES_B CLEB,

11213: SELECT
11214: NVL(SUM(NVL(KLEB.amount,0)),0)
11215: FROM
11216: OKL_K_LINES KLEB,
11217: OKC_K_LINES_B CLEB,
11218: OKC_LINE_STYLES_B LSEB,
11219: okc_statuses_b sts
11220: WHERE
11221: KLEB.ID = CLEB.ID AND

Line 11276: OKC_K_LINES_B CLEB,

11272: SELECT
11273: NVL(SUM(NVL(KLEB.amount,0)),0)
11274: FROM
11275: OKL_K_LINES KLEB,
11276: OKC_K_LINES_B CLEB,
11277: OKC_LINE_STYLES_B LSEB,
11278: okc_statuses_b sts
11279: WHERE
11280: KLEB.ID = CLEB.ID AND

Line 12325: FROM okc_k_lines_b fin_cle,

12321: x_msg_data VARCHAR2(256);
12322:
12323: CURSOR l_finast_csr(p_chr_id IN NUMBER) IS
12324: SELECT fin_cle.id
12325: FROM okc_k_lines_b fin_cle,
12326: okc_line_styles_b lse,
12327: okc_statuses_b stsb
12328: WHERE fin_cle.dnz_chr_id = p_chr_id
12329: AND fin_cle.chr_id = p_chr_id

Line 12337: FROM okc_k_lines_b fin_cle,

12333: AND stsb.ste_code NOT IN ('HOLD','EXPIRED','CANCELLED','TERMINATED');
12334:
12335: CURSOR l_finast_csr_incl_terminated(p_chr_id IN NUMBER) IS
12336: SELECT fin_cle.id
12337: FROM okc_k_lines_b fin_cle,
12338: okc_line_styles_b lse,
12339: okc_statuses_b stsb
12340: WHERE fin_cle.dnz_chr_id = p_chr_id
12341: AND fin_cle.chr_id = p_chr_id

Line 12443: FROM okc_k_lines_b fin_cle,

12439: x_msg_data VARCHAR2(256);
12440:
12441: CURSOR l_finast_csr(p_chr_id IN NUMBER) IS
12442: SELECT fin_cle.id
12443: FROM okc_k_lines_b fin_cle,
12444: okc_line_styles_b lse,
12445: okc_statuses_b stsb
12446: WHERE fin_cle.dnz_chr_id = p_chr_id
12447: AND fin_cle.chr_id = p_chr_id

Line 12455: FROM okc_k_lines_b fin_cle,

12451: AND stsb.ste_code NOT IN ('HOLD','EXPIRED','CANCELLED','TERMINATED');
12452:
12453: CURSOR l_finast_csr_incl_terminated(p_chr_id IN NUMBER) IS
12454: SELECT fin_cle.id
12455: FROM okc_k_lines_b fin_cle,
12456: okc_line_styles_b lse,
12457: okc_statuses_b stsb
12458: WHERE fin_cle.dnz_chr_id = p_chr_id
12459: AND fin_cle.chr_id = p_chr_id

Line 12568: OKC_K_LINES_B CLEB,

12564: --bug# 4899328
12565: --+ NVL(SUM(kle.capitalized_interest),0) CapAmountLines
12566: FROM OKC_LINE_STYLES_B LSEB,
12567: OKL_K_LINES KLE,
12568: OKC_K_LINES_B CLEB,
12569: OKC_STATUSES_B STSB
12570: WHERE LSEB.ID = CLEB.LSE_ID
12571: AND LSEB.lty_code = 'FREE_FORM1'
12572: AND KLE.id = CLEB.ID

Line 12585: OKC_K_LINES_B CLEB,

12581: SELECT
12582: NVL(SUM(NVL(KLEB.amount,0)),0) ROLLOVER_AMOUNT
12583: FROM
12584: OKL_K_LINES KLEB,
12585: OKC_K_LINES_B CLEB,
12586: OKC_LINE_STYLES_B LSEB,
12587: OKC_STATUSES_B STS
12588: WHERE
12589: KLEB.ID = CLEB.ID AND

Line 12881: FROM okc_k_lines_b

12877: --currency code cursor added to derive currency code for the particular line
12878: --which will be used for rounding amount
12879: CURSOR currency_code_csr (p_kle_id NUMBER ) IS
12880: SELECT currency_code
12881: FROM okc_k_lines_b
12882: WHERE id = p_kle_id;
12883: --declaring proration factor , currency code and rounding rule variables
12884: l_proration_factor NUMBER;
12885: l_currency_code okc_k_lines_b.currency_code%TYPE;

Line 12885: l_currency_code okc_k_lines_b.currency_code%TYPE;

12881: FROM okc_k_lines_b
12882: WHERE id = p_kle_id;
12883: --declaring proration factor , currency code and rounding rule variables
12884: l_proration_factor NUMBER;
12885: l_currency_code okc_k_lines_b.currency_code%TYPE;
12886: l_parent_strm_amt NUMBER;
12887: l_parent_strm_rounded_amt NUMBER;
12888: l_parent_strm_rounded_tot_amt NUMBER;
12889: --declaring other local variables

Line 13307: FROM okc_k_lines_b

13303: --currency code cursor added to derive currency code for the particular line
13304: --which will be used for rounding amount
13305: CURSOR currency_code_csr (p_kle_id NUMBER ) IS
13306: SELECT currency_code
13307: FROM okc_k_lines_b
13308: WHERE id = p_kle_id;
13309: --declaring proration factor , currency code and rounding rule variables
13310: l_proration_factor NUMBER;
13311: l_currency_code okc_k_lines_b.currency_code%TYPE;

Line 13311: l_currency_code okc_k_lines_b.currency_code%TYPE;

13307: FROM okc_k_lines_b
13308: WHERE id = p_kle_id;
13309: --declaring proration factor , currency code and rounding rule variables
13310: l_proration_factor NUMBER;
13311: l_currency_code okc_k_lines_b.currency_code%TYPE;
13312: l_parent_strm_amt NUMBER;
13313: l_parent_strm_rounded_amt NUMBER;
13314: l_parent_strm_rounded_tot_amt NUMBER;
13315: --declaring other local variables

Line 13814: okc_k_lines_b cle,

13810:
13811: CURSOR c_fin_fees IS
13812: SELECT cle.id
13813: FROM
13814: okc_k_lines_b cle,
13815: okl_k_lines kle,
13816: okc_k_headers_b chr
13817: WHERE
13818: chr.id = p_contract_id

Line 13862: okc_k_lines_b cle,

13858:
13859: CURSOR c_fin_fees IS
13860: SELECT cle.id
13861: FROM
13862: okc_k_lines_b cle,
13863: okl_k_lines kle,
13864: okc_k_headers_b chr
13865: WHERE
13866: chr.id = p_contract_id

Line 13925: okc_k_lines_b kle,

13921: SELECT nvl(fab.cost,0) current_cost
13922: FROM fa_books fab,
13923: fa_book_controls fbc,
13924: okc_k_items_v itm,
13925: okc_k_lines_b kle,
13926: okc_line_styles_v lse
13927: WHERE fbc.book_class = 'CORPORATE'
13928: AND fab.book_type_code = fbc.book_type_code
13929: AND fab.asset_id = itm.object1_id1

Line 14566: ,p_contract_line_id okc_k_lines_b.id%TYPE DEFAULT OKL_API.G_MISS_NUM) RETURN NUMBER IS

14562: -- sjalasut, Rebook Change Control Enhancement START
14563:
14564: -- function that returns the sum of unbilled RENT for all active assets on the rebook copy of the contract
14565: FUNCTION cont_rbk_unbilled_receivables(p_contract_id okc_k_headers_b.id%TYPE
14566: ,p_contract_line_id okc_k_lines_b.id%TYPE DEFAULT OKL_API.G_MISS_NUM) RETURN NUMBER IS
14567:
14568: -- get all unbilled receivables for all ACTIVE assets
14569: CURSOR cle_rents_csr(cp_contract_id okc_k_headers_b.id%TYPE) IS
14570: SELECT NVL(SUM(sele.amount),0)

Line 14623: ,p_contract_line_id okc_k_lines_b.id%TYPE DEFAULT OKL_API.G_MISS_NUM) RETURN NUMBER IS

14619: END cont_rbk_unbilled_receivables;
14620:
14621: -- function that returns the sum of pre-tax income that was not accrued for all active assets on the rebook copy of the contract
14622: FUNCTION cont_rbk_unearned_income(p_contract_id okc_k_headers_b.id%TYPE
14623: ,p_contract_line_id okc_k_lines_b.id%TYPE DEFAULT OKL_API.G_MISS_NUM) RETURN NUMBER IS
14624:
14625: CURSOR c_pre_tax_csr(cp_contract_id okc_k_headers_b.id%TYPE) IS
14626: SELECT NVL(SUM(sele.amount),0)
14627: FROM okl_strm_elements sele

Line 14631: ,okc_k_lines_b line

14627: FROM okl_strm_elements sele
14628: --,okl_streams str MGAAP 7263041
14629: ,okl_streams_rep_v str
14630: ,okl_strm_type_v sty
14631: ,okc_k_lines_b line
14632: ,okc_line_styles_b style
14633: ,okc_statuses_b sts
14634: WHERE sele.stm_id = str.id
14635: AND str.sty_id = sty.id

Line 14672: ,p_contract_line_id okc_k_lines_b.id%TYPE DEFAULT OKL_API.G_MISS_NUM) RETURN NUMBER IS

14668:
14669: -- returns sum of rent not billed for all terminated assets
14670: -- do not send p_contract_line_id as okl_api.g_miss_num
14671: FUNCTION cont_tmt_unbilled_receivables(p_contract_id okc_k_headers_b.id%TYPE
14672: ,p_contract_line_id okc_k_lines_b.id%TYPE DEFAULT OKL_API.G_MISS_NUM) RETURN NUMBER IS
14673: -- get all unbilled receivables for all TERMINATED assets
14674: CURSOR cle_rents_csr(cp_contract_id okc_k_headers_b.id%TYPE
14675: ,cp_contract_line_id okc_k_lines_b.id%TYPE) IS
14676: SELECT NVL(SUM(sele.amount),0)

Line 14675: ,cp_contract_line_id okc_k_lines_b.id%TYPE) IS

14671: FUNCTION cont_tmt_unbilled_receivables(p_contract_id okc_k_headers_b.id%TYPE
14672: ,p_contract_line_id okc_k_lines_b.id%TYPE DEFAULT OKL_API.G_MISS_NUM) RETURN NUMBER IS
14673: -- get all unbilled receivables for all TERMINATED assets
14674: CURSOR cle_rents_csr(cp_contract_id okc_k_headers_b.id%TYPE
14675: ,cp_contract_line_id okc_k_lines_b.id%TYPE) IS
14676: SELECT NVL(SUM(sele.amount),0)
14677: FROM okl_strm_elements sele
14678: ,okl_streams str
14679: ,okl_strm_type_v sty

Line 14731: ,p_contract_line_id okc_k_lines_b.id%TYPE DEFAULT OKL_API.G_MISS_NUM) RETURN NUMBER IS

14727:
14728: -- returns sum of pre tax income not accrued for all terminated assets
14729: -- do not send p_contract_line_id as okl_api.g_miss_num
14730: FUNCTION cont_tmt_unearned_income(p_contract_id okc_k_headers_b.id%TYPE
14731: ,p_contract_line_id okc_k_lines_b.id%TYPE DEFAULT OKL_API.G_MISS_NUM) RETURN NUMBER IS
14732: CURSOR c_pre_tax_csr(cp_contract_id okc_k_headers_b.id%TYPE ,cp_contract_line_id okc_k_lines_b.id%TYPE) IS
14733: SELECT NVL(SUM(sele.amount),0)
14734: FROM okl_strm_elements sele
14735: --,okl_streams str MGAAP 7263041

Line 14732: CURSOR c_pre_tax_csr(cp_contract_id okc_k_headers_b.id%TYPE ,cp_contract_line_id okc_k_lines_b.id%TYPE) IS

14728: -- returns sum of pre tax income not accrued for all terminated assets
14729: -- do not send p_contract_line_id as okl_api.g_miss_num
14730: FUNCTION cont_tmt_unearned_income(p_contract_id okc_k_headers_b.id%TYPE
14731: ,p_contract_line_id okc_k_lines_b.id%TYPE DEFAULT OKL_API.G_MISS_NUM) RETURN NUMBER IS
14732: CURSOR c_pre_tax_csr(cp_contract_id okc_k_headers_b.id%TYPE ,cp_contract_line_id okc_k_lines_b.id%TYPE) IS
14733: SELECT NVL(SUM(sele.amount),0)
14734: FROM okl_strm_elements sele
14735: --,okl_streams str MGAAP 7263041
14736: ,okl_streams_rep_v str

Line 14738: ,okc_k_lines_b line

14734: FROM okl_strm_elements sele
14735: --,okl_streams str MGAAP 7263041
14736: ,okl_streams_rep_v str
14737: ,okl_strm_type_v sty
14738: ,okc_k_lines_b line
14739: ,okc_line_styles_b style
14740: -- ,okc_statuses_b sts
14741: WHERE sele.stm_id = str.id
14742: AND str.sty_id = sty.id

Line 15611: FROM okc_k_lines_b cle,

15607:
15608: -- Cursor to get the lty_code
15609: CURSOR get_lty_code(p_line_id NUMBER) IS
15610: SELECT lse.lty_code
15611: FROM okc_k_lines_b cle,
15612: okc_line_styles_b lse
15613: WHERE cle.id = p_line_id
15614: AND cle.lse_id = lse.id;
15615:

Line 15645: okc_k_lines_b cle

15641: okc_line_styles_b lse3,
15642: okc_line_styles_b lse2,
15643: okc_line_styles_b lse1,
15644: okc_k_items_v cim,
15645: okc_k_lines_b cle
15646: WHERE cle.dnz_chr_id = p_dnz_chr_id
15647: AND cle.dnz_chr_id = cim.dnz_chr_id
15648: AND cle.id = cim.cle_id
15649: AND cle.lse_id = lse1.id

Line 15661: okc_k_lines_b clex

15657: AND exists (SELECT 1
15658: FROM okc_subclass_top_line stlx,
15659: okc_line_styles_b lse2x,
15660: okc_line_styles_b lse1x,
15661: okc_k_lines_b clex
15662: WHERE clex.cle_id = p_line_id
15663: AND clex.dnz_chr_id = p_dnz_chr_id
15664: AND clex.lse_id = lse1x.id
15665: AND lse1x.lty_code = 'ITEM'

Line 15679: okc_k_lines_b cleb_cov,

15675: SELECT SUM(kle_cov.capital_amount) Cap_fee
15676: FROM okc_line_styles_b lseb,
15677: okc_k_items cim,
15678: okl_k_lines kle_cov,
15679: okc_k_lines_b cleb_cov,
15680: okc_statuses_b stsb
15681: WHERE lseb.id = cleb_cov.lse_id
15682: AND lseb.lty_code = 'LINK_FEE_ASSET'
15683: AND cim.jtot_object1_code = 'OKX_COVASST'

Line 15930: okc_k_lines_b cle

15926: okc_line_styles_b lse3,
15927: okc_line_styles_b lse2,
15928: okc_line_styles_b lse1,
15929: okc_k_items_v cim,
15930: okc_k_lines_b cle
15931: WHERE cle.dnz_chr_id = p_contract_id
15932: AND cle.dnz_chr_id = cim.dnz_chr_id
15933: AND cle.id = cim.cle_id
15934: AND cle.lse_id = lse1.id

Line 15946: okc_k_lines_b clex

15942: AND exists (SELECT 1
15943: FROM okc_subclass_top_line stlx,
15944: okc_line_styles_b lse2x,
15945: okc_line_styles_b lse1x,
15946: okc_k_lines_b clex
15947: WHERE clex.cle_id = p_contract_line_id -- lse_id = 33>
15948: AND clex.dnz_chr_id = p_contract_id
15949: AND clex.lse_id = lse1x.id
15950: AND lse1x.lty_code = 'ITEM' -- G_MODEL_LINE_LTY_CODE

Line 16047: okc_k_lines_b sub_cle,

16043: p_accounting_method IN VARCHAR2) IS
16044: SELECT NVL(SUM(sub_kle.amount),0)
16045: FROM okl_subsidies_b subb,
16046: okl_k_lines sub_kle,
16047: okc_k_lines_b sub_cle,
16048: okc_line_styles_b sub_lse
16049: WHERE subb.id = sub_kle.subsidy_id
16050: AND subb.accounting_method_code = NVL(UPPER(p_accounting_method),subb.accounting_method_code)
16051: AND sub_kle.id = sub_cle.id

Line 16167: okc_k_lines_b sub_cle,

16163: p_accounting_method IN VARCHAR2) IS
16164: SELECT NVL(SUM(sub_kle.subsidy_override_amount),0)
16165: FROM okl_subsidies_b subb,
16166: okl_k_lines sub_kle,
16167: okc_k_lines_b sub_cle,
16168: okc_line_styles_b sub_lse
16169: WHERE subb.id = sub_kle.subsidy_id
16170: AND subb.accounting_method_code = NVL(UPPER(p_accounting_method),subb.accounting_method_code)
16171: AND sub_kle.id = sub_cle.id

Line 16276: OKC_K_LINES_B CLEB_COV,

16272: FROM OKC_LINE_STYLES_B LSEB,
16273: OKC_K_ITEMS CIM,
16274: OKL_K_LINES KLE_COV,
16275: okl_k_lines fee_line,
16276: OKC_K_LINES_B CLEB_COV,
16277: OKC_STATUSES_B STSB
16278: WHERE LSEB.ID = CLEB_COV.LSE_ID
16279: AND LSEB.lty_code = 'LINK_FEE_ASSET'
16280: AND CIM.jtot_object1_code = 'OKX_COVASST'

Line 16298: OKC_K_LINES_B CLEB_COV,

16294: FROM OKC_LINE_STYLES_B LSEB,
16295: OKC_K_ITEMS CIM,
16296: OKL_K_LINES KLE_COV,
16297: okl_k_lines fee_line,
16298: OKC_K_LINES_B CLEB_COV,
16299: OKC_STATUSES_B STSB
16300: WHERE LSEB.ID = CLEB_COV.LSE_ID
16301: AND LSEB.lty_code = 'LINK_FEE_ASSET'
16302: AND CIM.jtot_object1_code = 'OKX_COVASST'

Line 16400: OKC_K_LINES_B CLEB_COV,

16396: FROM OKC_LINE_STYLES_B LSEB,
16397: OKC_K_ITEMS CIM,
16398: OKL_K_LINES KLE_COV,
16399: okl_k_lines fee_line,
16400: OKC_K_LINES_B CLEB_COV,
16401: OKC_STATUSES_B STSB
16402: WHERE LSEB.ID = CLEB_COV.LSE_ID
16403: AND LSEB.lty_code = 'LINK_FEE_ASSET'
16404: AND CIM.jtot_object1_code = 'OKX_COVASST'

Line 16422: OKC_K_LINES_B CLEB_COV,

16418: FROM OKC_LINE_STYLES_B LSEB,
16419: OKC_K_ITEMS CIM,
16420: OKL_K_LINES KLE_COV,
16421: okl_k_lines fee_line,
16422: OKC_K_LINES_B CLEB_COV,
16423: OKC_STATUSES_B STSB
16424: WHERE LSEB.ID = CLEB_COV.LSE_ID
16425: AND LSEB.lty_code = 'LINK_FEE_ASSET'
16426: AND CIM.jtot_object1_code = 'OKX_COVASST'