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 11202: FROM okc_k_items cim

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

Line 11375: lv_id1 okc_k_items.object1_id1%TYPE;

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

Line 11376: lv_id2 okc_k_items.object1_id2%TYPE;

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

Line 11377: lv_code okc_k_items.jtot_object1_code%TYPE;

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

Line 11392: FROM okc_k_items cim

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

Line 11398: p_id1 IN okc_k_items.object1_id1%TYPE,

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

Line 11399: p_id2 IN okc_k_items.object1_id2%TYPE

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

Line 11409: p_id1 IN okc_k_items.object1_id1%TYPE,

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

Line 11410: p_id2 IN okc_k_items.object1_id2%TYPE

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

Line 11420: p_id1 IN okc_k_items.object1_id1%TYPE,

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

Line 11421: p_id2 IN okc_k_items.object1_id2%TYPE

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