DBA Data[Home] [Help]

APPS.WSM_SERIAL_SUPPORT_GRP dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 334: /*SELECT mtl_material_transactions_s.nextval

330: end if;
331:
332: -- get a txn header id..
333: -- No will be passed...
334: /*SELECT mtl_material_transactions_s.nextval
335: into p_mtl_txn_hdr_id
336: from dual;
337: */
338:

Line 341: SELECT mtl_material_transactions_s.nextval

337: */
338:
339: /* Have to be passed....
340: if p_move_txn_type = wip_constants.RET_TXN then
341: SELECT mtl_material_transactions_s.nextval
342: into p_compl_txn_id
343: from dual;
344: end if;
345: */

Line 392: select mtl_material_transactions_s.nextval

388:
389: for l_mmt_rec in c_mmt_txn loop
390:
391: l_stmt_num := 60;
392: select mtl_material_transactions_s.nextval
393: into l_temp_id
394: from dual;
395:
396: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN

Line 565: select mtl_material_transactions_s.nextval

561:
562: l_lot_controlled := 1;
563: if l_lot_txn_rec.serial_transaction_id is not null then
564: l_stmt_num := 100;
565: select mtl_material_transactions_s.nextval
566: into l_serial_txn_id
567: from dual;
568: else
569: l_stmt_num := 110;