APPS.OKL_BLK_AST_UPD_PVT dependencies on OKC_K_ITEMS

Line 170: FROM OKC_K_ITEMS_V

166: AND B.LTY_CODE = 'INST_ITEM';
167:
168: CURSOR c_items(p_inst_itm_id IN NUMBER) is
169: SELECT *
170: FROM OKC_K_ITEMS_V
171: WHERE CLE_ID = p_inst_itm_id
172: AND JTOT_OBJECT1_CODE = 'OKX_IB_ITEM';
173:
174:

Line 248: okc_k_items kitem,

244: CURSOR check_item_csr (p_line_id IN NUMBER) IS -- p_line_id is FREE_FORM1
245: SELECT mtl.serial_number_control_code
246: FROM okc_k_lines_b line,
247: okc_line_styles_b style,
248: okc_k_items kitem,
249: mtl_system_items mtl
250: WHERE line.lse_id = style.id
251: AND style.lty_code = 'ITEM'
252: AND line.id = kitem.cle_id

Line 1746: FROM OKC_K_ITEMS_V

1742: AND B.LTY_CODE = 'INST_ITEM';
1743:
1744: CURSOR c_items(p_inst_itm_id IN NUMBER) is
1745: SELECT *
1746: FROM OKC_K_ITEMS_V
1747: WHERE CLE_ID = p_inst_itm_id
1748: AND JTOT_OBJECT1_CODE = 'OKX_IB_ITEM';
1749:
1750: