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 891: From okc_k_lines_b cle,

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

Line 898: l_top_cle_id OKC_K_LINES_B.ID%TYPE;

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

Line 900: l_cle_id OKC_K_LINES_B.ID%TYPE;

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

Line 901: l_cle_start_date OKC_K_LINES_B.START_DATE%TYPE;

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

Line 902: l_cle_end_date OKC_K_LINES_B.END_DATE%TYPE;

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

Line 905: l_parent_cle_id OKC_K_LINES_B.orig_system_id1%TYPE;

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

Line 913: From okc_k_lines_b cle

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

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

1070: lt_klev_tbl_type klev_tbl_type;
1071: ltx_klev_tbl_type klev_tbl_type;
1072: i number := 0;
1073:
1074: CURSOR c_get_old_k_top_line(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
1075: SELECT cle.id top_line
1076: FROM okc_subclass_top_line stl,
1077: okc_line_styles_b lse,
1078: okc_k_lines_b cle

Line 1078: okc_k_lines_b cle

1074: CURSOR c_get_old_k_top_line(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
1075: SELECT cle.id top_line
1076: FROM okc_subclass_top_line stl,
1077: okc_line_styles_b lse,
1078: okc_k_lines_b cle
1079: WHERE cle.dnz_chr_id = p_dnz_chr_id
1080: AND cle.lse_id = lse.id
1081: AND lse.lty_code = G_FIN_LINE_LTY_CODE
1082: AND lse.lse_parent_id is null

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

1285: x_msg_data,
1286: '_PVT');
1287: END l_copy_contract;
1288: -----------------------------------------------------------------------------------------------------------------------
1289: FUNCTION get_k_tls_asset(p_dnz_chr_id IN OKC_K_LINES_B.DNZ_CHR_ID%TYPE DEFAULT OKL_API.G_MISS_NUM,
1290: x_top_line_tbl OUT NOCOPY g_top_line_tbl,
1291: x_asset_num_tbl OUT NOCOPY g_asset_num_tbl)
1292: RETURN VARCHAR2 IS
1293: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;

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

1293: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
1294: i NUMBER := 0;
1295: j NUMBER := 0;
1296:
1297: CURSOR c_get_old_k_top_line(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
1298: SELECT cle.id top_line
1299: FROM okc_subclass_top_line stl,
1300: okc_line_styles_b lse,
1301: okc_k_lines_b cle

Line 1301: okc_k_lines_b cle

1297: CURSOR c_get_old_k_top_line(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
1298: SELECT cle.id top_line
1299: FROM okc_subclass_top_line stl,
1300: okc_line_styles_b lse,
1301: okc_k_lines_b cle
1302: WHERE cle.dnz_chr_id = p_dnz_chr_id
1303: AND cle.lse_id = lse.id
1304: AND lse.lty_code = G_FIN_LINE_LTY_CODE
1305: AND lse.lse_parent_id is null

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

1306: AND lse.lse_type = G_TLS_TYPE
1307: AND lse.id = stl.lse_Id
1308: AND stl.scs_code = 'LEASE';
1309:
1310: CURSOR c_get_old_k_asset(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
1311: SELECT av.asset_number asset_number
1312: FROM okc_subclass_top_line stl,
1313: okc_line_styles_b lse2,
1314: okc_line_styles_b lse1,

Line 1317: okc_k_lines_b cle

1313: okc_line_styles_b lse2,
1314: okc_line_styles_b lse1,
1315: okx_assets_v av,
1316: okc_k_items cim,
1317: okc_k_lines_b cle
1318: WHERE cle.dnz_chr_id = p_dnz_chr_id
1319: AND cle.id = cim.cle_id
1320: AND cim.dnz_chr_id = cle.dnz_chr_id
1321: AND cim.object1_id1 = av.id1

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

1442: -- status of that line as TERMINATED , EXPIRED etc....
1443: -- Parameters : 1.P_dnz_chr_id Old Contract id
1444: -- Version : 1.0
1445: -- End of Commnets
1446: FUNCTION validate_assets_offlease(p_dnz_chr_id IN OKC_K_LINES_B.DNZ_CHR_ID%TYPE)
1447: RETURN VARCHAR2 IS
1448: lt_top_line_tbl g_top_line_tbl;
1449: lt_asset_num_tbl g_asset_num_tbl;
1450: i NUMBER := 0;

Line 2457: okc_k_lines_b cleb,

2453: cleb.orig_system_id1 orig_cle_id,
2454: chrb.id new_chr_id,
2455: cleb.id new_cle_id
2456: From
2457: okc_k_lines_b cleb,
2458: okl_k_lines kle,
2459: okc_k_headers_b chrb
2460: where kle.id = cleb.id
2461: and cleb.dnz_chr_id = chrb.id

Line 2479: okc_k_lines_b cleb_fa

2475: fb.book_type_code
2476: from fa_books fb,
2477: fa_book_controls fbc,
2478: okc_k_items cim,
2479: okc_k_lines_b cleb_fa
2480: where fb.asset_id = cim.object1_id1
2481: and fb.book_type_code = fbc.book_type_code
2482: and fbc.book_class = 'CORPORATE'
2483: and fb.transaction_header_id_out is NULL

Line 2499: from okc_k_lines_b cleb_model,

2495: cursor l_units_csr (p_cle_id in number,
2496: p_chr_id in number) is
2497: select cleb_model.id model_cle_id,
2498: cim_model.number_of_items
2499: from okc_k_lines_b cleb_model,
2500: okc_k_items cim_model
2501: where cim_model.cle_id = cleb_model.id
2502: and cim_model.dnz_chr_id = p_chr_id
2503: and cleb_model.cle_id = p_cle_id

Line 2551: OKC_K_LINES_B USAGE,

2547: select '!' from dual
2548: where exists (
2549: select 1
2550: from okc_k_items UITEM ,
2551: OKC_K_LINES_B USAGE,
2552: OKC_K_LINES_B USUB_LINE,
2553: okc_k_items LINK_ITEM,
2554: okc_k_lines_b top_line,
2555: okl_txl_cntrct_lns tcl

Line 2552: OKC_K_LINES_B USUB_LINE,

2548: where exists (
2549: select 1
2550: from okc_k_items UITEM ,
2551: OKC_K_LINES_B USAGE,
2552: OKC_K_LINES_B USUB_LINE,
2553: okc_k_items LINK_ITEM,
2554: okc_k_lines_b top_line,
2555: okl_txl_cntrct_lns tcl
2556: where UITEM.dnz_chr_id=tcl.khr_id

Line 2554: okc_k_lines_b top_line,

2550: from okc_k_items UITEM ,
2551: OKC_K_LINES_B USAGE,
2552: OKC_K_LINES_B USUB_LINE,
2553: okc_k_items LINK_ITEM,
2554: okc_k_lines_b top_line,
2555: okl_txl_cntrct_lns tcl
2556: where UITEM.dnz_chr_id=tcl.khr_id
2557: and UITEM.JTOT_OBJECT1_CODE = 'OKL_USAGE'
2558: and UITEM.OBJECT1_ID2='#'

Line 3244: FROM okc_k_lines_b cle,

3240:
3241: CURSOR chk_usage_csr(p_chr_id OKC_K_HEADERS_B.ID%TYPE)
3242: IS
3243: SELECT 'Y'
3244: FROM okc_k_lines_b cle,
3245: okc_line_styles_b lse
3246: WHERE cle.chr_id = p_chr_id
3247: AND cle.dnz_chr_id = p_chr_id
3248: AND lse.id = cle.lse_id

Line 4157: FROM okc_k_lines_b cle,

4153: cle.dnz_chr_id,
4154: cle.cle_id,
4155: sts.ste_code,
4156: cle.orig_system_id1
4157: FROM okc_k_lines_b cle,
4158: okl_k_lines kle,
4159: okc_line_styles_b lse,
4160: okc_statuses_b sts
4161: WHERE cle.dnz_chr_id = p_chr_id

Line 4171: FROM okc_k_lines_b cle,

4167:
4168: CURSOR orig_cle_sts_csr(p_cle_id IN NUMBER)
4169: IS
4170: SELECT sts.ste_code
4171: FROM okc_k_lines_b cle,
4172: okc_statuses_b sts
4173: WHERE cle.id = p_cle_id
4174: AND cle.sts_code = sts.code;
4175:

Line 4210: FROM okc_k_lines_b cle,

4206: cle.dnz_chr_id,
4207: cle.cle_id,
4208: --avsingh
4209: cle.orig_system_id1
4210: FROM okc_k_lines_b cle,
4211: okl_k_lines kle
4212: WHERE cle.cle_id = p_cle_id
4213: AND cle.dnz_chr_id = p_chr_id
4214: AND cle.id = kle.id;

Line 4342: l_currency_code OKC_K_LINES_B.CURRENCY_CODE%TYPE;

4338: SELECT currency_code
4339: FROM okc_k_headers_b
4340: WHERE id = p_chr_id;
4341:
4342: l_currency_code OKC_K_LINES_B.CURRENCY_CODE%TYPE;
4343:
4344: l_principal_bal NUMBER;
4345: l_accumulated_int NUMBER;
4346:

Line 5677: FROM okc_k_lines_b cle,

5673: cle.dnz_chr_id,
5674: cle.cle_id,
5675: cle.orig_system_id1,
5676: sts.ste_code
5677: FROM okc_k_lines_b cle,
5678: okl_k_lines kle,
5679: okc_line_styles_b lse,
5680: okc_statuses_b sts
5681: WHERE cle.dnz_chr_id = p_chr_id

Line 5691: FROM okc_k_lines_b cle,

5687:
5688: CURSOR orig_cle_sts_csr(p_cle_id IN NUMBER)
5689: IS
5690: SELECT sts.ste_code
5691: FROM okc_k_lines_b cle,
5692: okc_statuses_b sts
5693: WHERE cle.id = p_cle_id
5694: AND cle.sts_code = sts.code;
5695:

Line 5727: FROM okc_k_lines_b cle,

5723: NVL(kle.capital_amount,0) capital_amount,
5724: cle.chr_id,
5725: cle.dnz_chr_id,
5726: cle.cle_id
5727: FROM okc_k_lines_b cle,
5728: okl_k_lines kle
5729: WHERE cle.cle_id = p_cle_id
5730: AND cle.dnz_chr_id = p_chr_id
5731: AND cle.id = kle.id;

Line 5738: l_currency_code OKC_K_LINES_B.CURRENCY_CODE%TYPE;

5734: SELECT currency_code
5735: FROM okc_k_headers_b
5736: WHERE id = p_chr_id;
5737:
5738: l_currency_code OKC_K_LINES_B.CURRENCY_CODE%TYPE;
5739:
5740: CURSOR check_pymts_csr(p_chr_id IN NUMBER,
5741: p_cle_id IN NUMBER) IS
5742: SELECT 'Y' pymt_exists

Line 6361: FROM okc_k_lines_b cle,

6357: CURSOR fee_serv_csr(p_chr_id IN NUMBER)
6358: IS
6359: SELECT cle.id,
6360: kle.amount
6361: FROM okc_k_lines_b cle,
6362: okc_line_styles_b lse,
6363: okl_k_lines kle
6364: WHERE cle.chr_id = p_chr_id
6365: AND cle.dnz_chr_id = p_chr_id

Line 6374: FROM okc_k_lines_b cle,

6370:
6371: CURSOR subline_csr (p_chr_id IN NUMBER,
6372: p_cle_id IN NUMBER) IS
6373: SELECT SUM(NVL(kle.capital_amount,kle.amount)) sum_amount
6374: FROM okc_k_lines_b cle,
6375: okl_k_lines kle
6376: WHERE cle.cle_id = p_cle_id
6377: AND cle.dnz_chr_id = p_chr_id
6378: AND kle.id = cle.id;

Line 6399: l_currency_code OKC_K_LINES_B.CURRENCY_CODE%TYPE;

6395: SELECT currency_code
6396: FROM okc_k_headers_b
6397: WHERE id = p_chr_id;
6398:
6399: l_currency_code OKC_K_LINES_B.CURRENCY_CODE%TYPE;
6400:
6401: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;
6402: lx_rulv_rec OKL_RULE_PUB.rulv_rec_type;
6403:

Line 6889: FROM okc_k_lines_b cle,

6885: SELECT cle.id,
6886: cle.start_date,
6887: sts.ste_code,
6888: cle.orig_system_id1
6889: FROM okc_k_lines_b cle,
6890: okc_line_styles_b lse,
6891: okc_statuses_b sts
6892: WHERE cle.dnz_chr_id = p_chr_id
6893: AND cle.chr_id = p_chr_id

Line 6903: FROM okc_k_lines_b cle,

6899: IS
6900: SELECT sts.ste_code,
6901: --Bug# 4670760
6902: cle.dnz_chr_id
6903: FROM okc_k_lines_b cle,
6904: okc_statuses_b sts
6905: WHERE cle.id = p_cle_id
6906: AND cle.sts_code = sts.code;
6907:

Line 6917: FROM okc_k_lines_b

6913: chr_id,
6914: cle_id,
6915: lse_id,
6916: start_date
6917: FROM okc_k_lines_b
6918: CONNECT BY PRIOR id = cle_id
6919: START WITH id = p_cle_id;
6920:
6921: CURSOR lse_csr(p_lse_id IN NUMBER) IS

Line 6959: okc_k_lines_b fa_cleb,

6955: txlb.percent_salvage_value,
6956: txlb.id
6957: FROM okl_txl_assets_b txlb,
6958: okl_trx_assets trx,
6959: okc_k_lines_b fa_cleb,
6960: okc_line_styles_b fa_lseb
6961: WHERE txlb.kle_id = fa_cleb.id
6962: AND txlb.tal_type = 'CRL'
6963: AND trx.id = txlb.tas_id

Line 7015: l_currency_code OKC_K_LINES_B.CURRENCY_CODE%TYPE;

7011: SELECT currency_code
7012: FROM okc_k_headers_b
7013: WHERE id = p_chr_id;
7014:
7015: l_currency_code OKC_K_LINES_B.CURRENCY_CODE%TYPE;
7016:
7017: --bug# 4670760
7018: l_orig_chr_id NUMBER;
7019: l_orig_cle_id NUMBER;

Line 7572: FROM okc_k_lines_b cle,

7568: tcl.source_column_2,
7569: tcl.source_value_2,
7570: tcl.source_column_3,
7571: tcl.source_value_3
7572: FROM okc_k_lines_b cle,
7573: okc_line_styles_b lse,
7574: okl_txl_cntrct_lns tcl
7575: WHERE cle.chr_id = p_chr_id
7576: AND cle.dnz_chr_id = p_chr_id

Line 7594: okc_k_lines_b fa_cleb,

7590: p_cle_id IN NUMBER) IS
7591: SELECT txlb.id
7592: FROM okl_txl_assets_b txlb,
7593: okl_trx_assets trx,
7594: okc_k_lines_b fa_cleb,
7595: okc_line_styles_b fa_lseb
7596: WHERE txlb.kle_id = fa_cleb.id
7597: AND txlb.tal_type = 'CRL'
7598: AND trx.id = txlb.tas_id

Line 7619: okc_k_lines_b cleb_ib,

7615: iti.object_id2_new,
7616: iti.jtot_object_code_new
7617: FROM okl_trx_assets trx,
7618: okl_txl_itm_insts iti,
7619: okc_k_lines_b cleb_ib,
7620: okc_line_styles_b lseb_ib,
7621: okc_k_lines_b cleb_inst,
7622: okc_line_styles_b lseb_inst
7623: WHERE trx.id = iti.tas_id

Line 7621: okc_k_lines_b cleb_inst,

7617: FROM okl_trx_assets trx,
7618: okl_txl_itm_insts iti,
7619: okc_k_lines_b cleb_ib,
7620: okc_line_styles_b lseb_ib,
7621: okc_k_lines_b cleb_inst,
7622: okc_line_styles_b lseb_inst
7623: WHERE trx.id = iti.tas_id
7624: AND trx.tsu_code <> 'PROCESSED'
7625: AND trx.tas_type = 'CRL'

Line 8229: FROM okc_k_lines_b cle,

8225: CURSOR taa_lines_csr(p_new_chr_id IN NUMBER,
8226: p_source_trx_id IN NUMBER)
8227: IS
8228: SELECT cle.id
8229: FROM okc_k_lines_b cle,
8230: okc_line_styles_b lse
8231: WHERE cle.chr_id = p_new_chr_id
8232: AND cle.dnz_chr_id = p_new_chr_id
8233: AND lse.lty_code = 'FREE_FORM1'

Line 8244: FROM okc_k_lines_b cle,

8240:
8241: CURSOR taa_fee_serv_csr(p_new_chr_id IN NUMBER)
8242: IS
8243: SELECT cle.id
8244: FROM okc_k_lines_b cle,
8245: okc_line_styles_b lse
8246: WHERE cle.chr_id = p_new_chr_id
8247: AND cle.dnz_chr_id = p_new_chr_id
8248: AND lse.lty_code IN ('FEE','SOLD_SERVICE')

Line 8251: FROM okc_k_lines_b sub_cle

8247: AND cle.dnz_chr_id = p_new_chr_id
8248: AND lse.lty_code IN ('FEE','SOLD_SERVICE')
8249: AND cle.lse_id = lse.id
8250: AND NOT EXISTS (SELECT 1
8251: FROM okc_k_lines_b sub_cle
8252: WHERE sub_cle.cle_id = cle.id);
8253:
8254: CURSOR taa_request_csr(p_source_trx_id IN NUMBER)
8255: IS

Line 8274: from okc_k_lines_b cleb

8270: --Bug# 4631549
8271: --cursor to get all finasset lines
8272: cursor l_finast_csr (p_chr_id in number) is
8273: select cleb.id
8274: from okc_k_lines_b cleb
8275: where cleb.chr_id = p_chr_id
8276: and cleb.dnz_chr_id = p_chr_id
8277: and cleb.lse_id = 33; --financial asset line id
8278:

Line 8745: FROM OKC_K_LINES_B cle,

8741: -- To get the orig system id for Fixed Asset lines of p_chr_id
8742: CURSOR get_orig_fa(p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
8743: SELECT cle.orig_system_id1 orig_cle_fa,
8744: cle.id id
8745: FROM OKC_K_LINES_B cle,
8746: OKC_LINE_STYLES_B lse
8747: WHERE cle.dnz_chr_id = p_chr_id
8748: AND cle.lse_id = lse.id
8749: AND lse.lty_code = 'FIXED_ASSET';

Line 8755: FROM OKC_K_LINES_B cle,

8751: -- To get the orig system id for Install Base lines of p_chr_id
8752: CURSOR get_orig_ib(p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
8753: SELECT cle.orig_system_id1 orig_cle_ib,
8754: cle.id id
8755: FROM OKC_K_LINES_B cle,
8756: OKC_LINE_STYLES_B lse
8757: WHERE cle.dnz_chr_id = p_chr_id
8758: AND cle.lse_id = lse.id
8759: AND lse.lty_code = 'INST_ITEM';

Line 8763: p_orig_cle_id OKC_K_LINES_B.ID%TYPE) IS

8759: AND lse.lty_code = 'INST_ITEM';
8760:
8761: -- To get the item information from original line id and original contract id
8762: CURSOR get_item_info(p_orig_chr_id OKC_K_HEADERS_B.ID%TYPE,
8763: p_orig_cle_id OKC_K_LINES_B.ID%TYPE) IS
8764: SELECT object1_id1,
8765: object1_id2
8766: FROM okc_k_items
8767: WHERE cle_id = p_orig_cle_id

Line 8776: OKC_K_LINES_B cle_orig,

8772: cim.object1_id1 asset_id,
8773: cle_orig.cle_id orig_finasst_id,
8774: asr.id asset_return_id
8775: FROM OKL_ASSET_RETURNS_B asr,
8776: OKC_K_LINES_B cle_orig,
8777: OKC_LINE_STYLES_B lse_orig,
8778: OKC_K_ITEMS cim_orig,
8779: OKC_K_ITEMS cim,
8780: OKC_K_LINES_B cle,

Line 8780: OKC_K_LINES_B cle,

8776: OKC_K_LINES_B cle_orig,
8777: OKC_LINE_STYLES_B lse_orig,
8778: OKC_K_ITEMS cim_orig,
8779: OKC_K_ITEMS cim,
8780: OKC_K_LINES_B cle,
8781: OKC_LINE_STYLES_B lse,
8782: OKC_STATUSES_B sts,
8783: OKL_TXL_ASSETS_B txl
8784: WHERE asr.kle_id = cle_orig.cle_id