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_AM_CNTRCT_LN_TRMNT_PVT dependencies on OKC_K_ITEMS

Line 3890: okc_k_items cim,

3886: UNION
3887: SELECT DISTINCT hdrcle.ID cle_id
3888: FROM okc_k_lines_b cle,
3889: okc_k_lines_b hdrcle,
3890: okc_k_items cim,
3891: okl_txl_quote_lines_b tql,
3892: okc_k_headers_b CHR,
3893: okc_line_styles_b lse
3894: WHERE hdrcle.chr_id = p_chr_id

Line 9756: okc_k_items cim

9752: SELECT cim.object1_id1,
9753: cle.cle_id
9754: FROM okc_k_lines_b cle,
9755: okc_line_styles_b lse,
9756: okc_k_items cim
9757: WHERE cle.lse_id = lse.ID
9758: AND lse.lty_code = cp_line_type
9759: AND cim.cle_id = cle.ID
9760: AND cle.ID = cp_fee_serviced_asset_line_id;

Line 9774: okc_k_items item,

9770: IS
9771: SELECT 'X'
9772: FROM okc_k_lines_b linked_asset,
9773: okc_line_styles_b line_styl,
9774: okc_k_items item,
9775: okc_statuses_b sts
9776: WHERE linked_asset.lse_id = line_styl.ID
9777: AND line_styl.lty_code = cp_line_type
9778: AND item.cle_id = linked_asset.ID

Line 9801: okc_k_items cim

9797: SELECT cim.object1_id1,
9798: cle.ID
9799: FROM okc_k_lines_b cle,
9800: okc_line_styles_b lse,
9801: okc_k_items cim
9802: WHERE cle.lse_id = lse.ID
9803: AND lse.lty_code = cp_line_type
9804: AND cim.cle_id = cle.ID
9805: AND cle.cle_id = cp_line_id;

Line 11201: FROM okc_k_items cim

11197: p_cle_id IN okc_k_lines_b.ID%TYPE
11198: )
11199: IS
11200: SELECT cim.cle_id cle_id
11201: FROM okc_k_items cim
11202: WHERE cim.dnz_chr_id = p_chr_id
11203: AND cim.jtot_object1_code = 'OKX_COVASST'
11204: AND cim.object1_id1 IN (
11205: SELECT cle.ID

Line 11374: lv_id1 okc_k_items.object1_id1%TYPE;

11370: lt_old_sls_amt g_cle_amt_tbl;
11371: lt_new_sls_amt g_cle_amt_tbl;
11372: k NUMBER := 0;
11373: lt_msg_tbl g_msg_tbl;
11374: lv_id1 okc_k_items.object1_id1%TYPE;
11375: lv_id2 okc_k_items.object1_id2%TYPE;
11376: lv_code okc_k_items.jtot_object1_code%TYPE;
11377: -- SECHAWLA 28-OCT-03 2846988 : New declarations
11378: l_return_status VARCHAR2 (1) := okl_api.g_ret_sts_success;

Line 11375: lv_id2 okc_k_items.object1_id2%TYPE;

11371: lt_new_sls_amt g_cle_amt_tbl;
11372: k NUMBER := 0;
11373: lt_msg_tbl g_msg_tbl;
11374: lv_id1 okc_k_items.object1_id1%TYPE;
11375: lv_id2 okc_k_items.object1_id2%TYPE;
11376: lv_code okc_k_items.jtot_object1_code%TYPE;
11377: -- SECHAWLA 28-OCT-03 2846988 : New declarations
11378: l_return_status VARCHAR2 (1) := okl_api.g_ret_sts_success;
11379:

Line 11376: lv_code okc_k_items.jtot_object1_code%TYPE;

11372: k NUMBER := 0;
11373: lt_msg_tbl g_msg_tbl;
11374: lv_id1 okc_k_items.object1_id1%TYPE;
11375: lv_id2 okc_k_items.object1_id2%TYPE;
11376: lv_code okc_k_items.jtot_object1_code%TYPE;
11377: -- SECHAWLA 28-OCT-03 2846988 : New declarations
11378: l_return_status VARCHAR2 (1) := okl_api.g_ret_sts_success;
11379:
11380: -- RMUNJULU Bug # 2484327 Added comments, changed parameters to IN

Line 11391: FROM okc_k_items cim

11387: IS
11388: SELECT cim.object1_id1 object1_id1,
11389: cim.object1_id2 object1_id2,
11390: cim.jtot_object1_code jtot_object1_code
11391: FROM okc_k_items cim
11392: WHERE cim.dnz_chr_id = p_dnz_chr_id AND cim.cle_id = p_cle_id;
11393:
11394: -- RMUNJULU Bug # 2484327 Added comments, changed parameters to IN
11395: -- We need to get the name of the service line

Line 11397: p_id1 IN okc_k_items.object1_id1%TYPE,

11393:
11394: -- RMUNJULU Bug # 2484327 Added comments, changed parameters to IN
11395: -- We need to get the name of the service line
11396: CURSOR l_service_line_csr (
11397: p_id1 IN okc_k_items.object1_id1%TYPE,
11398: p_id2 IN okc_k_items.object1_id2%TYPE
11399: )
11400: IS
11401: SELECT siv.NAME NAME

Line 11398: p_id2 IN okc_k_items.object1_id2%TYPE

11394: -- RMUNJULU Bug # 2484327 Added comments, changed parameters to IN
11395: -- We need to get the name of the service line
11396: CURSOR l_service_line_csr (
11397: p_id1 IN okc_k_items.object1_id1%TYPE,
11398: p_id2 IN okc_k_items.object1_id2%TYPE
11399: )
11400: IS
11401: SELECT siv.NAME NAME
11402: FROM okx_system_items_v siv

Line 11408: p_id1 IN okc_k_items.object1_id1%TYPE,

11404:
11405: -- RMUNJULU Bug # 2484327 Added comments, changed parameters to IN
11406: -- We need to get the name of the fee line
11407: CURSOR l_fee_line_csr (
11408: p_id1 IN okc_k_items.object1_id1%TYPE,
11409: p_id2 IN okc_k_items.object1_id2%TYPE
11410: )
11411: IS
11412: SELECT ssv.NAME NAME

Line 11409: p_id2 IN okc_k_items.object1_id2%TYPE

11405: -- RMUNJULU Bug # 2484327 Added comments, changed parameters to IN
11406: -- We need to get the name of the fee line
11407: CURSOR l_fee_line_csr (
11408: p_id1 IN okc_k_items.object1_id1%TYPE,
11409: p_id2 IN okc_k_items.object1_id2%TYPE
11410: )
11411: IS
11412: SELECT ssv.NAME NAME
11413: FROM okl_strmtyp_source_v ssv

Line 11419: p_id1 IN okc_k_items.object1_id1%TYPE,

11415:
11416: -- RMUNJULU Bug # 2484327 Added comments, changed parameters to IN
11417: -- We need to get the name of the UBB line
11418: CURSOR l_usage_line_csr (
11419: p_id1 IN okc_k_items.object1_id1%TYPE,
11420: p_id2 IN okc_k_items.object1_id2%TYPE
11421: )
11422: IS
11423: SELECT siv.NAME NAME

Line 11420: p_id2 IN okc_k_items.object1_id2%TYPE

11416: -- RMUNJULU Bug # 2484327 Added comments, changed parameters to IN
11417: -- We need to get the name of the UBB line
11418: CURSOR l_usage_line_csr (
11419: p_id1 IN okc_k_items.object1_id1%TYPE,
11420: p_id2 IN okc_k_items.object1_id2%TYPE
11421: )
11422: IS
11423: SELECT siv.NAME NAME
11424: FROM okx_system_items_v siv