DBA Data[Home] [Help]

APPS.WIP_ONLINE_MTL_TXN_PROCESSOR dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 335: from mtl_material_transactions_temp

331: --get the flow schedule wip entity id if it is a wol trx
332: if (p_scheduledFlag = 2) then
333: select transaction_source_id
334: into p_wipEntityID
335: from mtl_material_transactions_temp
336: where transaction_temp_id = p_processTempID;
337: end if;
338:
339:

Line 341: delete from mtl_material_transactions_temp

337: end if;
338:
339:
340: --delete the assy mmtt record
341: delete from mtl_material_transactions_temp
342: where transaction_temp_id = p_processTempID;
343:
344: /*Start - Fix for bug #6216695, which is an FP of 6082623:
345: Delete MTLT and MSNT records also*/

Line 601: delete mtl_material_transactions_temp

597: end if;
598: /* End of fix for bug 4253002 */
599:
600: --and delete it
601: delete mtl_material_transactions_temp
602: where transaction_temp_id = l_cmpl_txnTmpID;
603:
604: /* Fix for bug 4253002: Dummy mtlt and msnt records created in putintoMMTT()
605: will also be deleted along with the parent MMTT record. */