346: delete mtl_serial_numbers_temp
347: where transaction_temp_id = p_processTempID
348: or transaction_temp_id in (
349: select serial_transaction_temp_id
350: from mtl_transaction_lots_temp
351: where transaction_temp_id = p_processTempID);
352:
353: delete mtl_transaction_lots_temp
354: where transaction_temp_id = p_processTempID;
349: select serial_transaction_temp_id
350: from mtl_transaction_lots_temp
351: where transaction_temp_id = p_processTempID);
352:
353: delete mtl_transaction_lots_temp
354: where transaction_temp_id = p_processTempID;
355: /*End - Fix for bug #6216695, which is an FP of 6082623:
356: Delete MTLT and MSNT records also*/
357:
606: delete mtl_serial_numbers_temp
607: where transaction_temp_id = l_cmpl_txnTmpID
608: or transaction_temp_id in (
609: select serial_transaction_temp_id
610: from mtl_transaction_lots_temp
611: where transaction_temp_id = l_cmpl_txnTmpID);
612:
613: delete mtl_transaction_lots_temp
614: where transaction_temp_id = l_cmpl_txnTmpID;
609: select serial_transaction_temp_id
610: from mtl_transaction_lots_temp
611: where transaction_temp_id = l_cmpl_txnTmpID);
612:
613: delete mtl_transaction_lots_temp
614: where transaction_temp_id = l_cmpl_txnTmpID;
615:
616: /* End - Bug 6013398: Moved below code from procedure wma_completion.process to here*/
617: