DBA Data[Home] [Help]

APPS.OKL_BLK_AST_UPD_PVT dependencies on MTL_SYSTEM_ITEMS

Line 249: mtl_system_items mtl

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

Line 282: l_count mtl_system_items.serial_number_control_code%TYPE;

278: l_org_id NUMBER;
279: l_currency_code VARCHAR2(30);
280: l_try_id NUMBER;
281: l_serialized_yn VARCHAR2(3);
282: l_count mtl_system_items.serial_number_control_code%TYPE;
283: l_ser_count NUMBER;
284:
285: l_trxv_rec trxv_rec_type;
286: lm_trxv_rec trxv_rec_type;