APPS.WMS_SHIPPING_PUB dependencies on WMS_DISPATCHED_TASKS

Line 110: DELETE FROM wms_dispatched_tasks wdt

106: -- {{- Delete all pending staging move transactions in MMTT/WDT, for }}
107: -- {{ all the staged LPNs belonging to the given delivery }} */
108: BEGIN
109:
110: DELETE FROM wms_dispatched_tasks wdt
111: WHERE task_type = 7
112: AND organization_id = l_organization_id
113: AND transfer_lpn_id IN
114: (SELECT wlpn.outermost_lpn_id