DBA Data[Home] [Help]

APPS.WMS_INSERT_WDTH_PVT dependencies on WMS_DISPATCHED_TASKS

Line 75: INSERT INTO wms_dispatched_tasks_history

71: , l_api_name
72: );
73: END IF;
74:
75: INSERT INTO wms_dispatched_tasks_history
76: ( task_id
77: , transaction_id
78: , organization_id
79: , transaction_batch_id

Line 157: FROM wms_dispatched_tasks wdt

153: , mmtt.lpn_id
154: , mmtt.content_lpn_id
155: , mmtt.transaction_temp_id
156: , nvl(wdt.priority,mmtt.task_priority) -- For bug 5401222
157: FROM wms_dispatched_tasks wdt
158: , mtl_material_transactions_temp mmtt
159: WHERE wdt.transaction_temp_id = p_transaction_temp_id
160: AND wdt.transaction_temp_id = mmtt.transaction_temp_id
161: );