APPS.OKS_BILL_UTIL_PUB dependencies on OKC_K_ITEMS

Line 1587: from okc_k_items_v

1583: l_cimv_rec_in OKC_CONTRACT_ITEM_PUB.cimv_rec_type;
1584: l_cimv_rec_out OKC_CONTRACT_ITEM_PUB.cimv_rec_type;
1585: cursor item_cur is
1586: select id
1587: from okc_k_items_v
1588: where cle_id = p_cle_id;
1589: begin
1590: open item_cur;
1591: fetch item_cur into l_cimv_rec_in.id;

Line 2090: From Okc_K_items Itm, okc_k_lines_b line

2086: WHERE ccr.counter_id = p_counter_id;
2087:
2088: Cursor l_usage_line_csr(p_counter_id Varchar2) Is
2089: Select itm.uom_code, line.cle_id usage_id
2090: From Okc_K_items Itm, okc_k_lines_b line
2091: Where itm.cle_id = line.id
2092: And itm.object1_id1 = p_counter_id
2093: And itm.jtot_object1_code = 'OKX_COUNTER';
2094:

Line 3216: ,OKC_K_ITEMS itm

3212:
3213: Cursor l_line_name_csr (p_line_id Number,p_organization_id Number) IS
3214: Select sys.NAME LineName
3215: From OKX_SYSTEM_ITEMS_V sys
3216: ,OKC_K_ITEMS itm
3217: Where itm.CLE_ID = p_line_id
3218: and sys.ID1 = itm.OBJECT1_ID1
3219: and sys.ID2 = itm.OBJECT1_ID2;
3220:

Line 3234: From OKC_K_ITEMS itm

3230: itm.JTOT_OBJECT1_CODE) CoveredLine
3231: ,itm.JTOT_OBJECT1_CODE
3232: ,itm.object1_id1
3233: ,itm.object1_id2
3234: From OKC_K_ITEMS itm
3235: Where itm.CLE_ID = p_sub_line_id;
3236:
3237: l_line_idx Binary_Integer;
3238: l_sub_line_idx Binary_Integer;

Line 3972: FROM okc_k_items

3968: AND LINES.LSE_ID in (9, 25) ;
3969:
3970: CURSOR l_get_itm_uom_csr(p_cp_id NUMBER) IS
3971: SELECT uom_code
3972: FROM okc_k_items
3973: WHERE cle_id = p_cp_id;
3974:
3975: CURSOR L_GET_BSL_CSR ( P_ID NUMBER ) IS
3976: SELECT 1

Line 4038: ----Get the item uom from okc_k_items

4034:
4035: ---create rec in oks_subline_bill_dtl table.
4036:
4037:
4038: ----Get the item uom from okc_k_items
4039: OPEN L_GET_ITM_UOM_CSR( L_GET_COVERED_LEVELS_REC.ID );
4040: FETCH L_GET_ITM_UOM_CSR INTO L_GET_ITM_UOM_rec ;
4041: IF L_GET_ITM_UOM_CSR%NOTFOUND THEN
4042: CLOSE L_GET_ITM_UOM_CSR;