APPS.INV_PARENT_MMTT_PVT dependencies on WMS_DISPATCHED_TASKS_HISTORY

Line 84: FROM wms_dispatched_tasks_history

80: INTO l_dummy
81: FROM dual
82: WHERE EXISTS
83: ( SELECT 'x'
84: FROM wms_dispatched_tasks_history
85: WHERE parent_transaction_id = p_parent_temp_id
86: AND is_parent = 'N'
87: );
88:

Line 163: UPDATE wms_dispatched_tasks_history wdth

159: --
160: -- Update parent_transaction_id in WDTH
161: --
162: BEGIN
163: UPDATE wms_dispatched_tasks_history wdth
164: SET wdth.parent_transaction_id = wdth.transaction_id
165: , wdth.is_parent = 'Y'
166: WHERE wdth.task_id = parent_rec.task_id
167: RETURNING wdth.transaction_id INTO l_parent_txn_id;

Line 193: UPDATE wms_dispatched_tasks_history wdth

189: --
190: -- Update child lines
191: --
192: BEGIN
193: UPDATE wms_dispatched_tasks_history wdth
194: SET wdth.parent_transaction_id = l_parent_txn_id
195: WHERE wdth.parent_transaction_id = p_parent_temp_id;
196:
197: IF l_debug = 1 AND SQL%FOUND