DBA Data[Home] [Help]

APPS.OKL_BLK_AST_UPD_PVT dependencies on MTL_SYSTEM_ITEMS

Line 281: mtl_system_items mtl

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
285: AND kitem.jtot_object1_code = 'OKX_SYSITEM'

Line 314: l_count mtl_system_items.serial_number_control_code%TYPE;

310: l_org_id NUMBER;
311: l_currency_code VARCHAR2(30);
312: l_try_id NUMBER;
313: l_serialized_yn VARCHAR2(3);
314: l_count mtl_system_items.serial_number_control_code%TYPE;
315: l_ser_count NUMBER;
316:
317: l_trxv_rec trxv_rec_type;
318: lm_trxv_rec trxv_rec_type;