APPS.INV_MISSING_QTY_ACTIONS_ENGINE dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 595: INSERT INTO mtl_serial_numbers_temp(

591: print_debug('Lot Secondary Qty = ' || l_lot_sec_qty, l_api_name, g_info);
592: END IF;
593:
594: IF p_serial_control_code NOT IN (1,6) THEN
595: INSERT INTO mtl_serial_numbers_temp(
596: transaction_temp_id
597: , fm_serial_number, to_serial_number, serial_prefix
598: , last_update_date, last_updated_by, creation_date, created_by
599: )

Line 615: WHERE serial_number IN (SELECT fm_serial_number FROM mtl_serial_numbers_temp

611: --after splitting the allocation
612: UPDATE mtl_serial_numbers
613: SET group_mark_id = l_serial_txn_temp_id
614: , line_mark_id = l_serial_txn_temp_id
615: WHERE serial_number IN (SELECT fm_serial_number FROM mtl_serial_numbers_temp
616: WHERE transaction_temp_id = l_serial_txn_temp_id)
617: AND inventory_item_id = l_item_id;
618: l_update_count := SQL%ROWCOUNT;
619:

Line 634: INSERT INTO mtl_serial_numbers_temp(

630: EXIT WHEN l_rem_txn_qty <= 0;
631: END LOOP;
632: ELSIF p_serial_control_code NOT IN (1,6) THEN
633: -- If Serial Controlled, create Serial Records
634: INSERT INTO mtl_serial_numbers_temp(
635: transaction_temp_id
636: , fm_serial_number, to_serial_number, serial_prefix
637: , last_update_date, last_updated_by, creation_date, created_by
638: )

Line 653: WHERE serial_number IN (SELECT fm_serial_number FROM mtl_serial_numbers_temp

649: --after splitting the allocation
650: UPDATE mtl_serial_numbers
651: SET group_mark_id = x_new_txn_temp_id
652: , line_mark_id= x_new_txn_temp_id
653: WHERE serial_number IN (SELECT fm_serial_number FROM mtl_serial_numbers_temp
654: WHERE transaction_temp_id = x_new_txn_temp_id)
655: AND inventory_item_id = l_item_id;
656: l_update_count := SQL%ROWCOUNT;
657: