DBA Data[Home] [Help]

APPS.INV_PARENT_MMTT_PVT dependencies on WMS_DISPATCHED_TASKS

Line 56: , wms_dispatched_tasks wdt

52: SELECT mmtt.organization_id
53: , mmtt.transfer_lpn_id
54: , wdt.task_id
55: FROM mtl_material_transactions_temp mmtt
56: , wms_dispatched_tasks wdt
57: WHERE mmtt.transaction_temp_id = p_temp_id
58: AND wdt.transaction_temp_id = mmtt.transaction_temp_id;
59:
60: parent_rec c_get_parent_details%ROWTYPE;

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

Line 216: DELETE wms_dispatched_tasks

212: END IF;
213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
214: END;
215: ELSE
216: DELETE wms_dispatched_tasks
217: WHERE transaction_temp_id = p_parent_temp_id;
218:
219: DELETE mtl_material_transactions_temp
220: WHERE transaction_temp_id = p_parent_temp_id;