DBA Data[Home] [Help]

APPS.WMS_PICKING_PKG dependencies on WMS_SKIP_TASK_EXCEPTIONS

Line 3847: DELETE FROM wms_skip_task_exceptions

3843: x_grouping_document_number := l_next_transaction_temp_id;
3844: END IF; -- Not a cycle count task
3845:
3846: -- Delete from the skip tasks exceptions table
3847: DELETE FROM wms_skip_task_exceptions
3848: WHERE task_id = task_record.transaction_temp_id
3849: AND task_id IN (SELECT wste.task_id
3850: FROM wms_skip_task_exceptions wste, mtl_parameters mp
3851: WHERE ABS((SYSDATE - wste.creation_date) * 24 * 60) > mp.skip_task_waiting_minutes

Line 3850: FROM wms_skip_task_exceptions wste, mtl_parameters mp

3846: -- Delete from the skip tasks exceptions table
3847: DELETE FROM wms_skip_task_exceptions
3848: WHERE task_id = task_record.transaction_temp_id
3849: AND task_id IN (SELECT wste.task_id
3850: FROM wms_skip_task_exceptions wste, mtl_parameters mp
3851: WHERE ABS((SYSDATE - wste.creation_date) * 24 * 60) > mp.skip_task_waiting_minutes
3852: AND wste.task_id = task_record.transaction_temp_id
3853: AND wste.organization_id = mp.organization_id);
3854: