DBA Data[Home] [Help]

APPS.WMS_WAVEPLAN_TASKS_PVT dependencies on WMS_DISPATCHED_TASKS_S

Line 11312: SET task_id = NVL (task_id, wms_dispatched_tasks_s.NEXTVAL),

11308: -- If changing status to Queued
11309: IF p_to_status_id = 2
11310: THEN
11311: UPDATE wms_waveplan_tasks_temp
11312: SET task_id = NVL (task_id, wms_dispatched_tasks_s.NEXTVAL),
11313: status = p_to_status,
11314: status_id = p_to_status_id,
11315: priority =
11316: DECODE (p_clear_priority,

Line 11970: (SELECT wms_dispatched_tasks_s.NEXTVAL, mcce.cycle_count_entry_id,

11966: machine_resource_id, status, dispatched_time,
11967: last_update_date, last_updated_by, creation_date,
11968: created_by, last_update_login, task_type, priority,
11969: move_order_line_id, operation_plan_id, transfer_lpn_id)
11970: (SELECT wms_dispatched_tasks_s.NEXTVAL, mcce.cycle_count_entry_id,
11971: wwtt.organization_id, NVL (wwtt.user_task_type_id, 0),
11972: wwtt.person_id, sysdate, sysdate , /*bug#5965353.replaced effective dates by sysdate */
11973: wwtt.person_resource_id, NULL, 2, -- Queued
11974: NULL, l_update_date, p_user_id, l_update_date, p_user_id,