DBA Data[Home] [Help]

APPS.WMS_PICKING_PKG dependencies on WMS_SKIP_TASK_EXCEPTIONS

Line 3419: DELETE FROM wms_skip_task_exceptions

3415: x_grouping_document_number := l_next_transaction_temp_id;
3416: END IF; -- Not a cycle count task
3417:
3418: -- Delete from the skip tasks exceptions table
3419: DELETE FROM wms_skip_task_exceptions
3420: WHERE task_id = task_record.transaction_temp_id
3421: AND task_id IN (SELECT wste.task_id
3422: FROM wms_skip_task_exceptions wste, mtl_parameters mp
3423: WHERE ABS((SYSDATE - wste.creation_date) * 24 * 60) > mp.skip_task_waiting_minutes

Line 3422: FROM wms_skip_task_exceptions wste, mtl_parameters mp

3418: -- Delete from the skip tasks exceptions table
3419: DELETE FROM wms_skip_task_exceptions
3420: WHERE task_id = task_record.transaction_temp_id
3421: AND task_id IN (SELECT wste.task_id
3422: FROM wms_skip_task_exceptions wste, mtl_parameters mp
3423: WHERE ABS((SYSDATE - wste.creation_date) * 24 * 60) > mp.skip_task_waiting_minutes
3424: AND wste.task_id = task_record.transaction_temp_id
3425: AND wste.organization_id = mp.organization_id);
3426: