DBA Data[Home] [Help]

APPS.WIP_ONLINE_MTL_TXN_PROCESSOR dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 350: from mtl_transaction_lots_temp

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;

Line 353: delete mtl_transaction_lots_temp

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:

Line 610: from mtl_transaction_lots_temp

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;

Line 613: delete mtl_transaction_lots_temp

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: