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

Line 93: OKC_K_LINES_B cle,

89: SELECT '!'
90: FROM dual
91: where exists (SELECT 1
92: FROM OKC_LINE_STYLES_B lse,
93: OKC_K_LINES_B cle,
94: okc_statuses_b sts
95: WHERE lse.id = cle.lse_id
96: AND lse.lty_code = 'USAGE'
97: AND cle.dnz_chr_id = p_chr_id

Line 227: okc_k_lines_b cle,

223:
224: CURSOR non_linked_usage_csr (p_chr_id NUMBER) IS
225: SELECT cle.id usage_line_id
226: FROM okc_line_styles_b lse,
227: okc_k_lines_b cle,
228: okc_statuses_v okcsts
229: WHERE cle.dnz_chr_id = p_chr_id
230: AND cle.lse_id = lse.id
231: AND lse.lse_parent_id is null

Line 237: FROM okc_k_lines_b line,

233: and okcsts.code = cle.sts_code
234: AND okcsts.ste_code NOT IN ('EXPIRED','HOLD','CANCELLED','TERMINATED')
235: AND NOT EXISTS (
236: SELECT 1
237: FROM okc_k_lines_b line,
238: okc_line_styles_b lse,
239: okc_statuses_b sts
240: WHERE line.dnz_chr_id = p_chr_id
241: AND line.cle_id = cle.id

Line 252: okc_k_lines_b cle,okc_statuses_v okcsts

248:
249: CURSOR usage_csr (p_chr_id NUMBER) IS
250: SELECT cle.id usage_line_id
251: FROM okc_line_styles_b lse,
252: okc_k_lines_b cle,okc_statuses_v okcsts
253: WHERE cle.dnz_chr_id = p_chr_id
254: AND cle.lse_id = lse.id
255: AND lse.lse_parent_id is null
256: AND lse.lty_code ='USAGE'

Line 264: FROM okc_k_lines_b line,

260:
261: CURSOR link_asset_csr (p_chr_id NUMBER,
262: p_usage_line_id NUMBER) IS
263: SELECT line.id
264: FROM okc_k_lines_b line,
265: okc_line_styles_b lse,
266: okc_statuses_b okcsts
267: WHERE line.dnz_chr_id = p_chr_id
268: AND line.cle_id = p_usage_line_id

Line 889: From okc_k_lines_b cle,

885: -- Added below for bug 5769216 - Start
886: -- Cursor to get top line id
887: Cursor top_cle_csr (p_chr_id IN NUMBER) is
888: SELECT cle.id
889: From okc_k_lines_b cle,
890: okc_statuses_b sts
891: where cle.dnz_chr_id = cle.chr_id
892: and cle.chr_id = p_chr_id
893: and sts.code = cle.sts_code;

Line 896: l_top_cle_id OKC_K_LINES_B.ID%TYPE;

892: and cle.chr_id = p_chr_id
893: and sts.code = cle.sts_code;
894:
895:
896: l_top_cle_id OKC_K_LINES_B.ID%TYPE;
897: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
898: l_cle_id OKC_K_LINES_B.ID%TYPE;
899: l_cle_start_date OKC_K_LINES_B.START_DATE%TYPE;
900: l_cle_end_date OKC_K_LINES_B.END_DATE%TYPE;

Line 898: l_cle_id OKC_K_LINES_B.ID%TYPE;

894:
895:
896: l_top_cle_id OKC_K_LINES_B.ID%TYPE;
897: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
898: l_cle_id OKC_K_LINES_B.ID%TYPE;
899: l_cle_start_date OKC_K_LINES_B.START_DATE%TYPE;
900: l_cle_end_date OKC_K_LINES_B.END_DATE%TYPE;
901: l_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
902: lx_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;

Line 899: l_cle_start_date OKC_K_LINES_B.START_DATE%TYPE;

895:
896: l_top_cle_id OKC_K_LINES_B.ID%TYPE;
897: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
898: l_cle_id OKC_K_LINES_B.ID%TYPE;
899: l_cle_start_date OKC_K_LINES_B.START_DATE%TYPE;
900: l_cle_end_date OKC_K_LINES_B.END_DATE%TYPE;
901: l_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
902: lx_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
903: l_parent_cle_id OKC_K_LINES_B.orig_system_id1%TYPE;

Line 900: l_cle_end_date OKC_K_LINES_B.END_DATE%TYPE;

896: l_top_cle_id OKC_K_LINES_B.ID%TYPE;
897: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
898: l_cle_id OKC_K_LINES_B.ID%TYPE;
899: l_cle_start_date OKC_K_LINES_B.START_DATE%TYPE;
900: l_cle_end_date OKC_K_LINES_B.END_DATE%TYPE;
901: l_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
902: lx_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
903: l_parent_cle_id OKC_K_LINES_B.orig_system_id1%TYPE;
904:

Line 903: l_parent_cle_id OKC_K_LINES_B.orig_system_id1%TYPE;

899: l_cle_start_date OKC_K_LINES_B.START_DATE%TYPE;
900: l_cle_end_date OKC_K_LINES_B.END_DATE%TYPE;
901: l_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
902: lx_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
903: l_parent_cle_id OKC_K_LINES_B.orig_system_id1%TYPE;
904:
905: --Cursor to check if lease chr has lines to change effectivity
906:
907: Cursor cle_csr(p_cle_id IN NUMBER) is

Line 911: From okc_k_lines_b cle

907: Cursor cle_csr(p_cle_id IN NUMBER) is
908: SELECT cle.id,
909: cle.start_date,
910: cle.end_date
911: From okc_k_lines_b cle
912: connect by prior cle.id = cle.cle_id
913: start with cle.id = p_cle_id
914: and exists (select 1
915: from okc_statuses_b sts

Line 1060: CURSOR c_get_old_k_top_line(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS

1056: lt_klev_tbl_type klev_tbl_type;
1057: ltx_klev_tbl_type klev_tbl_type;
1058: i number := 0;
1059:
1060: CURSOR c_get_old_k_top_line(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
1061: SELECT cle.id top_line
1062: FROM okc_subclass_top_line stl,
1063: okc_line_styles_b lse,
1064: okc_k_lines_b cle

Line 1064: okc_k_lines_b cle

1060: CURSOR c_get_old_k_top_line(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
1061: SELECT cle.id top_line
1062: FROM okc_subclass_top_line stl,
1063: okc_line_styles_b lse,
1064: okc_k_lines_b cle
1065: WHERE cle.dnz_chr_id = p_dnz_chr_id
1066: AND cle.lse_id = lse.id
1067: AND lse.lty_code = G_FIN_LINE_LTY_CODE
1068: AND lse.lse_parent_id is null

Line 1268: FUNCTION get_k_tls_asset(p_dnz_chr_id IN OKC_K_LINES_B.DNZ_CHR_ID%TYPE DEFAULT OKL_API.G_MISS_NUM,

1264: x_msg_data,
1265: '_PVT');
1266: END l_copy_contract;
1267: -----------------------------------------------------------------------------------------------------------------------
1268: FUNCTION get_k_tls_asset(p_dnz_chr_id IN OKC_K_LINES_B.DNZ_CHR_ID%TYPE DEFAULT OKL_API.G_MISS_NUM,
1269: x_top_line_tbl OUT NOCOPY g_top_line_tbl,
1270: x_asset_num_tbl OUT NOCOPY g_asset_num_tbl)
1271: RETURN VARCHAR2 IS
1272: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;

Line 1276: CURSOR c_get_old_k_top_line(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS

1272: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
1273: i NUMBER := 0;
1274: j NUMBER := 0;
1275:
1276: CURSOR c_get_old_k_top_line(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
1277: SELECT cle.id top_line
1278: FROM okc_subclass_top_line stl,
1279: okc_line_styles_b lse,
1280: okc_k_lines_b cle

Line 1280: okc_k_lines_b cle

1276: CURSOR c_get_old_k_top_line(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
1277: SELECT cle.id top_line
1278: FROM okc_subclass_top_line stl,
1279: okc_line_styles_b lse,
1280: okc_k_lines_b cle
1281: WHERE cle.dnz_chr_id = p_dnz_chr_id
1282: AND cle.lse_id = lse.id
1283: AND lse.lty_code = G_FIN_LINE_LTY_CODE
1284: AND lse.lse_parent_id is null

Line 1289: CURSOR c_get_old_k_asset(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS

1285: AND lse.lse_type = G_TLS_TYPE
1286: AND lse.id = stl.lse_Id
1287: AND stl.scs_code = 'LEASE';
1288:
1289: CURSOR c_get_old_k_asset(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
1290: SELECT av.asset_number asset_number
1291: FROM okc_subclass_top_line stl,
1292: okc_line_styles_b lse2,
1293: okc_line_styles_b lse1,

Line 1296: okc_k_lines_b cle

1292: okc_line_styles_b lse2,
1293: okc_line_styles_b lse1,
1294: okx_assets_v av,
1295: okc_k_items cim,
1296: okc_k_lines_b cle
1297: WHERE cle.dnz_chr_id = p_dnz_chr_id
1298: AND cle.id = cim.cle_id
1299: AND cim.dnz_chr_id = cle.dnz_chr_id
1300: AND cim.object1_id1 = av.id1

Line 1425: FUNCTION validate_assets_offlease(p_dnz_chr_id IN OKC_K_LINES_B.DNZ_CHR_ID%TYPE)

1421: -- status of that line as TERMINATED , EXPIRED etc....
1422: -- Parameters : 1.P_dnz_chr_id Old Contract id
1423: -- Version : 1.0
1424: -- End of Commnets
1425: FUNCTION validate_assets_offlease(p_dnz_chr_id IN OKC_K_LINES_B.DNZ_CHR_ID%TYPE)
1426: RETURN VARCHAR2 IS
1427: lt_top_line_tbl g_top_line_tbl;
1428: lt_asset_num_tbl g_asset_num_tbl;
1429: i NUMBER := 0;

Line 2433: okc_k_lines_b cleb,

2429: cleb.orig_system_id1 orig_cle_id,
2430: chrb.id new_chr_id,
2431: cleb.id new_cle_id
2432: From
2433: okc_k_lines_b cleb,
2434: okl_k_lines kle,
2435: okc_k_headers_b chrb
2436: where kle.id = cleb.id
2437: and cleb.dnz_chr_id = chrb.id

Line 2455: okc_k_lines_b cleb_fa

2451: fb.book_type_code
2452: from fa_books fb,
2453: fa_book_controls fbc,
2454: okc_k_items cim,
2455: okc_k_lines_b cleb_fa
2456: where fb.asset_id = cim.object1_id1
2457: and fb.book_type_code = fbc.book_type_code
2458: and fbc.book_class = 'CORPORATE'
2459: and fb.transaction_header_id_out is NULL

Line 2475: from okc_k_lines_b cleb_model,

2471: cursor l_units_csr (p_cle_id in number,
2472: p_chr_id in number) is
2473: select cleb_model.id model_cle_id,
2474: cim_model.number_of_items
2475: from okc_k_lines_b cleb_model,
2476: okc_k_items cim_model
2477: where cim_model.cle_id = cleb_model.id
2478: and cim_model.dnz_chr_id = p_chr_id
2479: and cleb_model.cle_id = p_cle_id

Line 2527: OKC_K_LINES_B USAGE,

2523: select '!' from dual
2524: where exists (
2525: select 1
2526: from okc_k_items UITEM ,
2527: OKC_K_LINES_B USAGE,
2528: OKC_K_LINES_B USUB_LINE,
2529: okc_k_items LINK_ITEM,
2530: okc_k_lines_b top_line,
2531: okl_txl_cntrct_lns tcl

Line 2528: OKC_K_LINES_B USUB_LINE,

2524: where exists (
2525: select 1
2526: from okc_k_items UITEM ,
2527: OKC_K_LINES_B USAGE,
2528: OKC_K_LINES_B USUB_LINE,
2529: okc_k_items LINK_ITEM,
2530: okc_k_lines_b top_line,
2531: okl_txl_cntrct_lns tcl
2532: where UITEM.dnz_chr_id=tcl.khr_id

Line 2530: okc_k_lines_b top_line,

2526: from okc_k_items UITEM ,
2527: OKC_K_LINES_B USAGE,
2528: OKC_K_LINES_B USUB_LINE,
2529: okc_k_items LINK_ITEM,
2530: okc_k_lines_b top_line,
2531: okl_txl_cntrct_lns tcl
2532: where UITEM.dnz_chr_id=tcl.khr_id
2533: and UITEM.JTOT_OBJECT1_CODE = 'OKL_USAGE'
2534: and UITEM.OBJECT1_ID2='#'

Line 3190: FROM okc_k_lines_b cle,

3186:
3187: CURSOR chk_usage_csr(p_chr_id OKC_K_HEADERS_B.ID%TYPE)
3188: IS
3189: SELECT 'Y'
3190: FROM okc_k_lines_b cle,
3191: okc_line_styles_b lse
3192: WHERE cle.chr_id = p_chr_id
3193: AND cle.dnz_chr_id = p_chr_id
3194: AND lse.id = cle.lse_id

Line 4097: FROM okc_k_lines_b cle,

4093: cle.dnz_chr_id,
4094: cle.cle_id,
4095: sts.ste_code,
4096: cle.orig_system_id1
4097: FROM okc_k_lines_b cle,
4098: okl_k_lines kle,
4099: okc_line_styles_b lse,
4100: okc_statuses_b sts
4101: WHERE cle.dnz_chr_id = p_chr_id

Line 4111: FROM okc_k_lines_b cle,

4107:
4108: CURSOR orig_cle_sts_csr(p_cle_id IN NUMBER)
4109: IS
4110: SELECT sts.ste_code
4111: FROM okc_k_lines_b cle,
4112: okc_statuses_b sts
4113: WHERE cle.id = p_cle_id
4114: AND cle.sts_code = sts.code;
4115:

Line 4150: FROM okc_k_lines_b cle,

4146: cle.dnz_chr_id,
4147: cle.cle_id,
4148: --avsingh
4149: cle.orig_system_id1
4150: FROM okc_k_lines_b cle,
4151: okl_k_lines kle
4152: WHERE cle.cle_id = p_cle_id
4153: AND cle.dnz_chr_id = p_chr_id
4154: AND cle.id = kle.id;

Line 4282: l_currency_code OKC_K_LINES_B.CURRENCY_CODE%TYPE;

4278: SELECT currency_code
4279: FROM okc_k_headers_b
4280: WHERE id = p_chr_id;
4281:
4282: l_currency_code OKC_K_LINES_B.CURRENCY_CODE%TYPE;
4283:
4284: l_principal_bal NUMBER;
4285: l_accumulated_int NUMBER;
4286:

Line 5368: FROM okc_k_lines_b cle,

5364: cle.dnz_chr_id,
5365: cle.cle_id,
5366: cle.orig_system_id1,
5367: sts.ste_code
5368: FROM okc_k_lines_b cle,
5369: okl_k_lines kle,
5370: okc_line_styles_b lse,
5371: okc_statuses_b sts
5372: WHERE cle.dnz_chr_id = p_chr_id

Line 5382: FROM okc_k_lines_b cle,

5378:
5379: CURSOR orig_cle_sts_csr(p_cle_id IN NUMBER)
5380: IS
5381: SELECT sts.ste_code
5382: FROM okc_k_lines_b cle,
5383: okc_statuses_b sts
5384: WHERE cle.id = p_cle_id
5385: AND cle.sts_code = sts.code;
5386:

Line 5418: FROM okc_k_lines_b cle,

5414: NVL(kle.capital_amount,0) capital_amount,
5415: cle.chr_id,
5416: cle.dnz_chr_id,
5417: cle.cle_id
5418: FROM okc_k_lines_b cle,
5419: okl_k_lines kle
5420: WHERE cle.cle_id = p_cle_id
5421: AND cle.dnz_chr_id = p_chr_id
5422: AND cle.id = kle.id;

Line 5429: l_currency_code OKC_K_LINES_B.CURRENCY_CODE%TYPE;

5425: SELECT currency_code
5426: FROM okc_k_headers_b
5427: WHERE id = p_chr_id;
5428:
5429: l_currency_code OKC_K_LINES_B.CURRENCY_CODE%TYPE;
5430:
5431: CURSOR check_pymts_csr(p_chr_id IN NUMBER,
5432: p_cle_id IN NUMBER) IS
5433: SELECT 'Y' pymt_exists

Line 6052: FROM okc_k_lines_b cle,

6048: CURSOR fee_serv_csr(p_chr_id IN NUMBER)
6049: IS
6050: SELECT cle.id,
6051: kle.amount
6052: FROM okc_k_lines_b cle,
6053: okc_line_styles_b lse,
6054: okl_k_lines kle
6055: WHERE cle.chr_id = p_chr_id
6056: AND cle.dnz_chr_id = p_chr_id

Line 6065: FROM okc_k_lines_b cle,

6061:
6062: CURSOR subline_csr (p_chr_id IN NUMBER,
6063: p_cle_id IN NUMBER) IS
6064: SELECT SUM(NVL(kle.capital_amount,kle.amount)) sum_amount
6065: FROM okc_k_lines_b cle,
6066: okl_k_lines kle
6067: WHERE cle.cle_id = p_cle_id
6068: AND cle.dnz_chr_id = p_chr_id
6069: AND kle.id = cle.id;

Line 6090: l_currency_code OKC_K_LINES_B.CURRENCY_CODE%TYPE;

6086: SELECT currency_code
6087: FROM okc_k_headers_b
6088: WHERE id = p_chr_id;
6089:
6090: l_currency_code OKC_K_LINES_B.CURRENCY_CODE%TYPE;
6091:
6092: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;
6093: lx_rulv_rec OKL_RULE_PUB.rulv_rec_type;
6094:

Line 6580: FROM okc_k_lines_b cle,

6576: SELECT cle.id,
6577: cle.start_date,
6578: sts.ste_code,
6579: cle.orig_system_id1
6580: FROM okc_k_lines_b cle,
6581: okc_line_styles_b lse,
6582: okc_statuses_b sts
6583: WHERE cle.dnz_chr_id = p_chr_id
6584: AND cle.chr_id = p_chr_id

Line 6594: FROM okc_k_lines_b cle,

6590: IS
6591: SELECT sts.ste_code,
6592: --Bug# 4670760
6593: cle.dnz_chr_id
6594: FROM okc_k_lines_b cle,
6595: okc_statuses_b sts
6596: WHERE cle.id = p_cle_id
6597: AND cle.sts_code = sts.code;
6598:

Line 6608: FROM okc_k_lines_b

6604: chr_id,
6605: cle_id,
6606: lse_id,
6607: start_date
6608: FROM okc_k_lines_b
6609: CONNECT BY PRIOR id = cle_id
6610: START WITH id = p_cle_id;
6611:
6612: CURSOR lse_csr(p_lse_id IN NUMBER) IS

Line 6650: okc_k_lines_b fa_cleb,

6646: txlb.percent_salvage_value,
6647: txlb.id
6648: FROM okl_txl_assets_b txlb,
6649: okl_trx_assets trx,
6650: okc_k_lines_b fa_cleb,
6651: okc_line_styles_b fa_lseb
6652: WHERE txlb.kle_id = fa_cleb.id
6653: AND txlb.tal_type = 'CRL'
6654: AND trx.id = txlb.tas_id

Line 6706: l_currency_code OKC_K_LINES_B.CURRENCY_CODE%TYPE;

6702: SELECT currency_code
6703: FROM okc_k_headers_b
6704: WHERE id = p_chr_id;
6705:
6706: l_currency_code OKC_K_LINES_B.CURRENCY_CODE%TYPE;
6707:
6708: --bug# 4670760
6709: l_orig_chr_id NUMBER;
6710: l_orig_cle_id NUMBER;

Line 7252: FROM okc_k_lines_b cle,

7248: tcl.source_column_2,
7249: tcl.source_value_2,
7250: tcl.source_column_3,
7251: tcl.source_value_3
7252: FROM okc_k_lines_b cle,
7253: okc_line_styles_b lse,
7254: okl_txl_cntrct_lns tcl
7255: WHERE cle.chr_id = p_chr_id
7256: AND cle.dnz_chr_id = p_chr_id

Line 7274: okc_k_lines_b fa_cleb,

7270: p_cle_id IN NUMBER) IS
7271: SELECT txlb.id
7272: FROM okl_txl_assets_b txlb,
7273: okl_trx_assets trx,
7274: okc_k_lines_b fa_cleb,
7275: okc_line_styles_b fa_lseb
7276: WHERE txlb.kle_id = fa_cleb.id
7277: AND txlb.tal_type = 'CRL'
7278: AND trx.id = txlb.tas_id

Line 7299: okc_k_lines_b cleb_ib,

7295: iti.object_id2_new,
7296: iti.jtot_object_code_new
7297: FROM okl_trx_assets trx,
7298: okl_txl_itm_insts iti,
7299: okc_k_lines_b cleb_ib,
7300: okc_line_styles_b lseb_ib,
7301: okc_k_lines_b cleb_inst,
7302: okc_line_styles_b lseb_inst
7303: WHERE trx.id = iti.tas_id

Line 7301: okc_k_lines_b cleb_inst,

7297: FROM okl_trx_assets trx,
7298: okl_txl_itm_insts iti,
7299: okc_k_lines_b cleb_ib,
7300: okc_line_styles_b lseb_ib,
7301: okc_k_lines_b cleb_inst,
7302: okc_line_styles_b lseb_inst
7303: WHERE trx.id = iti.tas_id
7304: AND trx.tsu_code <> 'PROCESSED'
7305: AND trx.tas_type = 'CRL'

Line 7905: FROM okc_k_lines_b cle,

7901: CURSOR taa_lines_csr(p_new_chr_id IN NUMBER,
7902: p_source_trx_id IN NUMBER)
7903: IS
7904: SELECT cle.id
7905: FROM okc_k_lines_b cle,
7906: okc_line_styles_b lse
7907: WHERE cle.chr_id = p_new_chr_id
7908: AND cle.dnz_chr_id = p_new_chr_id
7909: AND lse.lty_code = 'FREE_FORM1'

Line 7920: FROM okc_k_lines_b cle,

7916:
7917: CURSOR taa_fee_serv_csr(p_new_chr_id IN NUMBER)
7918: IS
7919: SELECT cle.id
7920: FROM okc_k_lines_b cle,
7921: okc_line_styles_b lse
7922: WHERE cle.chr_id = p_new_chr_id
7923: AND cle.dnz_chr_id = p_new_chr_id
7924: AND lse.lty_code IN ('FEE','SOLD_SERVICE')

Line 7927: FROM okc_k_lines_b sub_cle

7923: AND cle.dnz_chr_id = p_new_chr_id
7924: AND lse.lty_code IN ('FEE','SOLD_SERVICE')
7925: AND cle.lse_id = lse.id
7926: AND NOT EXISTS (SELECT 1
7927: FROM okc_k_lines_b sub_cle
7928: WHERE sub_cle.cle_id = cle.id);
7929:
7930: CURSOR taa_request_csr(p_source_trx_id IN NUMBER)
7931: IS

Line 7950: from okc_k_lines_b cleb

7946: --Bug# 4631549
7947: --cursor to get all finasset lines
7948: cursor l_finast_csr (p_chr_id in number) is
7949: select cleb.id
7950: from okc_k_lines_b cleb
7951: where cleb.chr_id = p_chr_id
7952: and cleb.dnz_chr_id = p_chr_id
7953: and cleb.lse_id = 33; --financial asset line id
7954:

Line 8416: FROM OKC_K_LINES_B cle,

8412: -- To get the orig system id for Fixed Asset lines of p_chr_id
8413: CURSOR get_orig_fa(p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
8414: SELECT cle.orig_system_id1 orig_cle_fa,
8415: cle.id id
8416: FROM OKC_K_LINES_B cle,
8417: OKC_LINE_STYLES_B lse
8418: WHERE cle.dnz_chr_id = p_chr_id
8419: AND cle.lse_id = lse.id
8420: AND lse.lty_code = 'FIXED_ASSET';

Line 8426: FROM OKC_K_LINES_B cle,

8422: -- To get the orig system id for Install Base lines of p_chr_id
8423: CURSOR get_orig_ib(p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
8424: SELECT cle.orig_system_id1 orig_cle_ib,
8425: cle.id id
8426: FROM OKC_K_LINES_B cle,
8427: OKC_LINE_STYLES_B lse
8428: WHERE cle.dnz_chr_id = p_chr_id
8429: AND cle.lse_id = lse.id
8430: AND lse.lty_code = 'INST_ITEM';

Line 8434: p_orig_cle_id OKC_K_LINES_B.ID%TYPE) IS

8430: AND lse.lty_code = 'INST_ITEM';
8431:
8432: -- To get the item information from original line id and original contract id
8433: CURSOR get_item_info(p_orig_chr_id OKC_K_HEADERS_B.ID%TYPE,
8434: p_orig_cle_id OKC_K_LINES_B.ID%TYPE) IS
8435: SELECT object1_id1,
8436: object1_id2
8437: FROM okc_k_items
8438: WHERE cle_id = p_orig_cle_id

Line 8447: OKC_K_LINES_B cle_orig,

8443: cim.object1_id1 asset_id,
8444: cle_orig.cle_id orig_finasst_id,
8445: asr.id asset_return_id
8446: FROM OKL_ASSET_RETURNS_B asr,
8447: OKC_K_LINES_B cle_orig,
8448: OKC_LINE_STYLES_B lse_orig,
8449: OKC_K_ITEMS cim_orig,
8450: OKC_K_ITEMS cim,
8451: OKC_K_LINES_B cle,

Line 8451: OKC_K_LINES_B cle,

8447: OKC_K_LINES_B cle_orig,
8448: OKC_LINE_STYLES_B lse_orig,
8449: OKC_K_ITEMS cim_orig,
8450: OKC_K_ITEMS cim,
8451: OKC_K_LINES_B cle,
8452: OKC_LINE_STYLES_B lse,
8453: OKC_STATUSES_B sts,
8454: OKL_TXL_ASSETS_B txl
8455: WHERE asr.kle_id = cle_orig.cle_id