APPS.OKL_BLK_AST_UPD_PVT dependencies on OKC_K_ITEMS

Line 202: FROM OKC_K_ITEMS_V

198: AND B.LTY_CODE = 'INST_ITEM';
199:
200: CURSOR c_items(p_inst_itm_id IN NUMBER) is
201: SELECT *
202: FROM OKC_K_ITEMS_V
203: WHERE CLE_ID = p_inst_itm_id
204: AND JTOT_OBJECT1_CODE = 'OKX_IB_ITEM';
205:
206:

Line 280: okc_k_items kitem,

276: CURSOR check_item_csr (p_line_id IN NUMBER) IS -- p_line_id is FREE_FORM1
277: SELECT mtl.serial_number_control_code
278: FROM okc_k_lines_b line,
279: okc_line_styles_b style,
280: okc_k_items kitem,
281: mtl_system_items mtl
282: WHERE line.lse_id = style.id
283: AND style.lty_code = 'ITEM'
284: AND line.id = kitem.cle_id

Line 1778: FROM OKC_K_ITEMS_V

1774: AND B.LTY_CODE = 'INST_ITEM';
1775:
1776: CURSOR c_items(p_inst_itm_id IN NUMBER) is
1777: SELECT *
1778: FROM OKC_K_ITEMS_V
1779: WHERE CLE_ID = p_inst_itm_id
1780: AND JTOT_OBJECT1_CODE = 'OKX_IB_ITEM';
1781:
1782: