APPS.WMS_SHIPPING_LOVS dependencies on WMS_DISPATCHED_TASKS

Line 194: FROM wms_dispatched_tasks wdt

190: AND mmtt.subinventory_code = sub.secondary_inventory_name
191: AND mmtt.organization_id = sub.organization_id
192: AND (mmtt.wms_task_status <> 8 OR mmtt.wms_task_status IS NULL )
193: AND NOT EXISTS ( SELECT 1
194: FROM wms_dispatched_tasks wdt
195: WHERE mmtt.transaction_temp_id=wdt.transaction_temp_id
196: AND ( wdt.status > 3 OR v.emp_id <> wdt.person_id )
197: )
198: ORDER BY 1;

Line 254: FROM wms_dispatched_tasks wdt

250: AND (mmtt.wms_task_status <> 8 OR mmtt.wms_task_status IS NULL )
251: AND mmtt.transaction_action_id = 28
252: AND mmtt.transaction_source_type_id IN (2,8)
253: AND NOT EXISTS ( SELECT 1
254: FROM wms_dispatched_tasks wdt
255: WHERE mmtt.transaction_temp_id=wdt.transaction_temp_id
256: AND ( wdt.status > 3 OR v.emp_id <> wdt.person_id )
257: )
258: ORDER BY 1;