DBA Data[Home] [Help]

APPS.INV_MISSING_QTY_ACTIONS_ENGINE dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 512: INSERT INTO mtl_serial_numbers_temp(

508: print_debug('Lot Secondary Qty = ' || l_lot_sec_qty, l_api_name, g_info);
509: END IF;
510:
511: IF p_serial_control_code NOT IN (1,6) THEN
512: INSERT INTO mtl_serial_numbers_temp(
513: transaction_temp_id
514: , fm_serial_number, to_serial_number, serial_prefix
515: , last_update_date, last_updated_by, creation_date, created_by
516: )

Line 532: WHERE serial_number IN (SELECT fm_serial_number FROM mtl_serial_numbers_temp

528: --after splitting the allocation
529: UPDATE mtl_serial_numbers
530: SET group_mark_id = l_serial_txn_temp_id
531: , line_mark_id = l_serial_txn_temp_id
532: WHERE serial_number IN (SELECT fm_serial_number FROM mtl_serial_numbers_temp
533: WHERE transaction_temp_id = l_serial_txn_temp_id)
534: AND inventory_item_id = l_item_id;
535: l_update_count := SQL%ROWCOUNT;
536:

Line 551: INSERT INTO mtl_serial_numbers_temp(

547: EXIT WHEN l_rem_txn_qty <= 0;
548: END LOOP;
549: ELSIF p_serial_control_code NOT IN (1,6) THEN
550: -- If Serial Controlled, create Serial Records
551: INSERT INTO mtl_serial_numbers_temp(
552: transaction_temp_id
553: , fm_serial_number, to_serial_number, serial_prefix
554: , last_update_date, last_updated_by, creation_date, created_by
555: )

Line 570: WHERE serial_number IN (SELECT fm_serial_number FROM mtl_serial_numbers_temp

566: --after splitting the allocation
567: UPDATE mtl_serial_numbers
568: SET group_mark_id = x_new_txn_temp_id
569: , line_mark_id= x_new_txn_temp_id
570: WHERE serial_number IN (SELECT fm_serial_number FROM mtl_serial_numbers_temp
571: WHERE transaction_temp_id = x_new_txn_temp_id)
572: AND inventory_item_id = l_item_id;
573: l_update_count := SQL%ROWCOUNT;
574: